By using this website, you agree to our Terms of Use (click here)
In the history of all all accounting for the past probably 100 years +, (of which I have experienced 30) we usually have a ledger for accounts receivable and accounts payable. Can anyone provide guidance as to writing a report in the standard international format:
Date / Doc Ref / Description / Debit / Credit / Balance
with Credit amounts reflected in brackets as in minus 1000 would be (1000.00)
and that when running a report for either Customer or Supplier (Vendor); that multiple customers or supplier accounts could be selected (or a range), and that a specific start date and end date could be specified unlike the Acumatica standard "out-of the box" (non confirming to +- 100 years of an accounting standard report layout). The current reports seem to only allow One Customer at a time, and also for only one selected accounting period at a time. Yes this has its place, but can the user not decided on the date range of the transactions they would like to see and the report auto adjusts an Opening Balance for the selected user's Start Date.
Any assistance as to how to write / modify reports like this would be highly appreciated.
You can use the ADDITIONAL SORT AND FILTERS tab on a report to specify a range of Customers or list the Customers individually. You could also use this tab to do Date filters.
Is your Balance column a running total that displays on every document line?
You might find which report is closest to what you want, then remove the groupings that total by Customer.
The Opening Balance part would be tricky because by applying filters, the report wouldn't be aware of the transactions that are not included on the report.
Online Members
