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 Click TransactionSearch Title: Enter TitleClick Criteria tabClick Standard subtabFilter:
   1. Select Account Type
      1. Account Type: Select any of Select Accounts PayableClick Set
      Select Status
      1. Status: Select none ofSelect Bill:Paid in FullClick Set
      Select Posting
      1. Posting: Select YesClick Set
   Click Results tabClick Columns subtabField:
   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 SumFormula: Enter case when ({today})-{duedate} between 1 and 30 then {amountremaining} endSummary Label: Enter 1-30
      Select Formula (Currency)
      1. Summary Type: Select SumFormula: Enter case when ({today})-{duedate} between 31 and 60 then {amountremaining} endSummary Label: Enter 31-60
      Select Formula (Currency)
      1. Summary Type: Select SumFormula: Enter case when ({today})-{duedate} between 61 and 90 then {amountremaining} endSummary Label: Enter 61-90
      Select Formula (Currency)
      1. Summary Type: Select SumFormula: Enter case when ({today})-{duedate} > 90 then {amountremaining} endSummary Label: Enter Over 91
      Select Formula (Currency)
      1. Summary Type: Select SumFormula: 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)   Summary Label: Enter Total Outstanding
   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>)AP Aging report $800 (As the in-transit payment is still not impacting the GL <BillAmount – PaymentAmount posting>)If payment in-transit is confirmed or declined the Saved Search and the AP Aging report will match again.