Create AP Aging Report using Saved Search

• Netsuite offers AP Aging Report. However, you might not be able to expose the field that you wish to expose. You can create a saved search to reflect the A/P Aging Summary Report.

  1. Navigate to Reports > Saved Searches > All Saved Searches > New 
  2. Click Transaction
  3. Search Title: Enter Title
  4. Click Criteria tab
  5. Click Standard subtab
  6. Filter:
     1. Select Account Type
        1. Account Type: Select any of 
        2. Select Accounts Payable
        3. Click Set
     2. Select Status
        1. Status: Select none of
        2. Select Bill:Paid in Full
        3. Click Set
     3. Select Posting
        1. Posting: Select Yes
        2. Click Set
  7. Click Results tab
  8. Click Columns subtab
  9. Field:
     Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.
     1. Select Formula (Currency)
        1. Summary Type: Select Sum
        2. Formula: Enter case when ({today})-{duedate} between 1 and 30 then {amountremaining} end
        3. Summary Label: Enter 1-30
     2. Select Formula (Currency)
        1. Summary Type: Select Sum
        2. Formula: Enter case when ({today})-{duedate} between 31 and 60 then {amountremaining} end
        3. Summary Label: Enter 31-60
     3. Select Formula (Currency)
        1. Summary Type: Select Sum
        2. Formula: Enter case when ({today})-{duedate} between 61 and 90 then {amountremaining} end
        3. Summary Label: Enter 61-90
     4. Select Formula (Currency)
        1. Summary Type: Select Sum
        2. Formula: Enter case when ({today})-{duedate} > 90 then {amountremaining} end
        3. Summary Label: Enter Over 91
     5. Select Formula (Currency)
        1. Summary Type: Select Sum
        2. Formula: Enter NVL (case when trunc({today})-{duedate} between 1 and 30 then {amountremaining} end, 0) + NVL (case when trunc({today})-{duedate} between 31 and 60 then {amountremaining} end, 0) + NVL (case when trunc({today})-{duedate} between 61 and 90 then {amountremaining} end, 0) + NVL (case when trunc({today})-{duedate} >90 then {amountremaining} end, 0)   
        3. Summary Label: Enter Total Outstanding
  10. Click Save & Run

   

  Note: The difference between Saved Search and A/P Aging report, the amount remaining is not the same on the Saved Search as the open balance on A/P Aging, as one considers posting and no-posting related payments and the other one only takes in consideration the posting ones.

   

  For example: A Bill with total amount of $1,000 with an in-transit payment of $500 and an accepted in-transit payment of $200 will reflect the following:

  1. Saved Search $300 (as the remaining amount to be paid for this bill are $300, cause the in-transit and the accepted in-transit. <BillAmount - PaymentAmount posting - PaymentAmount no-posting>)
  2. AP Aging report $800 (As the in-transit payment is still not impacting the GL <BillAmount - PaymentAmount posting>)
  3. If payment in-transit is confirmed or declined the Saved Search and the AP Aging report will match again.
  
  
  

The CFO’s Secret Weapon: The Concentrus Advantage ROI Roadmap™

We have built the ROI roadmap, calculator, and benchmarks CFOs need to manage ERP like a capital investment—because that’s what it is.

Schedule a free strategy call with our ERP experts today!

References

Gartner. (2023). Enterprise Resource Planning (ERP) Insights. Retrieved from Gartner: https://www.gartner.com/en/information-technology/topics/enterprise-resource-planning

About Us

Concentrus is a leading provider of innovative cloud-based enterprise resource planning (ERP) solutions, including NetSuite. Our team of NetSuite experts offers a range of services, including NetSuite price analysis, NetSuite training, and NetSuite integration services.  

Our goal is to help businesses of all sizes maximize their investment in NetSuite by providing expert NetSuite cost optimization and implementation strategies. With years of experience as a NetSuite partner, our NetSuite administrators and NetSuite consultants are well equipped to help businesses of all sizes with their NetSuite consulting needs.  

Whether you're looking for a NetSuite consultant to help with your NetSuite implementation or you need ongoing NetSuite support, Concentrus is here to help. 

Read About Our Implementation Methodology

Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos