cancel
Showing results for 
Search instead for 
Did you mean: 
kasey1
Level 1

Aging AP with PO#

I need to find a way to create a AP Aging Report that lists:

 

Vendor Name - Date Bill Entered - Due Date - Age - PO# or job 

Vendor IDAmount DueDateDate DueAgeJob ID or PO#
Man D Tec$1,195.024/9/205/9/202921118
Man D Tec$598.014/9/205/9/202921397
Twin City Metalfab$75.604/9/205/9/202921397

Working in QB DT 2020 Premier Manufacturing.

 

Thank you!

1 Comment 1
RaymondJayO
Moderator

Aging AP with PO#

I appreciate you for providing the six columns you want to display on the A/P Aging Detail report, @kasey1. We can customize it to get the specific information you need. I'd be delighted to walk you through the steps. 

  1. Go to Reports from the top menu. 
  2. Select Vendors & Payables and click A/P Aging Detail
  3. Set the Report Date Range in the Display tab. 
  4. In the Columns drop-down list, check the Name, Amount, Date, Due Date, Aging, and P.O. # options.
  5. Click OK

 

The screenshot below shows you the last three steps. 

CustomizeAPAgingDetailReport.PNG

 

Once done, the result will match the six columns you've preferred to display on the report. Here's what it looks like: 

AfterCustomizingAPAgingDetailReport.PNG

 

After customizing the report, I recommend memorizing it to help you quickly access it in the future. 

 

I also want to make sure I've got you covered. If the Age column you're referring to is the A/P aging, you can continue using the customization steps above. However, if it refers to the ages of your vendors, the said column is currently available. With this, I'd suggest exporting it to Excel so you can manually add the Age section to the report. 

 

Lastly, you can run and customize other vendor reports to help you keep track of your expenses and accounts payable. Just go back to the Vendors & Payables or Custom Reports menu and choose the report you want. For more details, visit this article: Customizing Vendor Reports.

 

I'm just a comment away if you need anything else. Enjoy the rest of your day, @kasey1

Need to get in touch?

Contact us