Is there a provision in Sage 50 to add a column in supplier aged report.
I need to run report with Total due, Current, 15-30 days, 31-45 days, 46-60 days.
Is there a provision in Sage 50 to add a column in supplier aged report.
I need to run report with Total due, Current, 15-30 days, 31-45 days, 46-60 days.
Setup, Settings, Payables, Options.
Change the Aging Periods to what you need. eg. 15, 30, 45
Hi Richard in regards to this question, is there any way to add another level so there are 4 Periods?
Hi Richard in regards to this question, is there any way to add another level so there are 4 Periods?
By using the 30/60/90 or 10/20/30 or 15/30/45 day concepts, the Vendor Aged report shows four columns plus a total while the Vendor Aged Overdue report shows five columns plus the Total and Total Overdue columns.
There is no way to add any more than that unless you move to custom reporting outside of Sage 50.
For example, you could create an Excel template using either the Aged or Overdue Aged report that does the columns you want and then you could export the Vendor Aged Detail report to Excel, then format, copy and paste the raw data into the template. It will then calculate the proper agings for you.
Thanks for your feedback.
*Community Hub is the new name for Sage City