UPDATE June 25th, 2015 – I have decided to stop this two year journey. For more on why, click here.
I have decided to embark on what will likely be a two year journey to explore the out of the box reports in Acumatica.
Each week I will post a review of one of the existing reports in Acumatica. This will be a long and sometimes tedious process, but I expect to learn a lot from it.
Which Reports
- Finance -> General Ledger -> Reports -> Balance -> Trial Balance Summary (GL632000)
- Finance -> General Ledger -> Reports -> Balance -> Trial Balance Detailed (GL632500)
- Finance -> General Ledger -> Reports -> Balance -> Transactions for Period (GL633000)
- Finance -> General Ledger -> Reports -> Balance -> Transactions for Account (GL633500)
- Finance -> General Ledger -> Reports -> Audit -> GL Budget Edit (GL612001)
- Finance -> General Ledger -> Reports -> Audit -> GL Edit Summary (GL611500)
- Finance -> General Ledger -> Reports -> Audit -> GL Edit Detailed (GL610500)
- Finance -> General Ledger -> Reports -> Audit -> GL Edit Account Distribution (GL611000)
- Finance -> General Ledger -> Reports -> Audit -> GL Register (GL620500)
- Finance -> General Ledger -> Reports -> Audit -> GL Register Detailed (GL621000)
- Finance -> General Ledger -> Reports -> Audit -> GL Recurring Transactions (GL641500)
- Finance -> General Ledger -> Reports -> Audit -> GL Recurring Transactions Detailed (GL640500)
- Finance -> General Ledger -> Reports -> Audit -> Open GL Documents (GL656000)
- Finance -> General Ledger -> Reports -> Audit -> GL Reversing Batches (GL690010)
- Finance -> Cash Management -> Reports -> Balance -> Cash Account Summary (CA633000)
- Finance -> Cash Management -> Reports -> Balance -> Cash Account Details (CA633500)
- Finance -> Cash Management -> Reports -> Balance -> Reconciliation Statement (CA627000)
- Finance -> Cash Management -> Reports -> Audit -> CA Edit (CA612000)
- Finance -> Cash Management -> Reports -> Audit -> CA Edit Detailed (CA612500)
- Finance -> Cash Management -> Reports -> Audit -> CA Register (CA625000)
- Finance -> Cash Management -> Reports -> Audit -> CA Register Detailed (CA624500)
- Finance -> Cash Management -> Reports -> Audit -> Reconciliation Register (CA623500)
- Finance -> Cash Management -> Reports -> Audit -> Reconciliation Register Details (CA624000)
- Finance -> Cash Management -> Reports -> Audit -> CA Batch Register (CA620500)
- Finance -> Cash Management -> Reports -> Audit -> CA Batch Register Detailed (CA621000)
- Finance -> Cash Management -> Reports -> Audit -> Undeposited Payments (CA657000)
- Finance -> Cash Management -> Reports -> Audit -> Unreleased CA Documents (CA656000)
- Finance -> Accounts Payable -> Reports -> Balance -> AP Balance by GL Account (AP632000)
- Finance -> Accounts Payable -> Reports -> Balance -> AP Balance by Vendor (AP632500)
- Finance -> Accounts Payable -> Reports -> Balance -> AP Balance by Vendor MC (AP633000)
- Finance -> Accounts Payable -> Reports -> Balance -> AP Aged Past Due (AP631000)
- Finance -> Accounts Payable -> Reports -> Balance -> AP Aged Past Due MC (AP631100)
- Finance -> Accounts Payable -> Reports -> Balance -> AP Aged Outstanding (AP631500)
- Finance -> Accounts Payable -> Reports -> Balance -> AP Aged Outstanding MC (AP631600)
- Finance -> Accounts Payable -> Reports -> Balance -> AP Aged Period Sensitive (AP630500)
- Finance -> Accounts Payable -> Reports -> Payment Processing -> Cash Requirements (AP612000)
- Finance -> Accounts Payable -> Reports -> Payment Processing -> Bills Pending Approval (AP611000)
- Finance -> Accounts Payable -> Reports -> Payment Processing -> Bills Pending Payment (AP611500)
- Finance -> Accounts Payable -> Reports -> Payment Processing -> Payments Pending Processing (AP651000)
- Finance -> Accounts Payable -> Reports -> Payment Processing -> Checks Pending Printing (AP612500)
- Finance -> Accounts Payable -> Reports -> Audit -> Vendor Summary (AP655000)
- Finance -> Accounts Payable -> Reports -> Audit -> Vendor Details (AP655500)
- Finance -> Accounts Payable -> Reports -> Audit -> Vendor History Summary (AP652100)
- Finance -> Accounts Payable -> Reports -> Audit -> Vendor History (AP652000)
- Finance -> Accounts Payable -> Reports -> Audit -> AP Edit (AP610700)
- Finance -> Accounts Payable -> Reports -> Audit -> AP Edit Detailed (AP610500)
- Finance -> Accounts Payable -> Reports -> Audit -> AP Register (AP621500)
- Finance -> Accounts Payable -> Reports -> Audit -> AP Register Detailed (AP622000)
- Finance -> Accounts Payable -> Reports -> Audit -> AP Payment Register (AP622500)
- Finance -> Accounts Payable -> Reports -> Audit -> AP Batch Register Detailed (AP621000)
- Finance -> Accounts Payable -> Reports -> Audit -> AP Batch Register (AP620500)
- Finance -> Accounts Payable -> Reports -> Audit -> Open AP Documents (AP656000)
- Finance -> Accounts Payable -> Reports -> Audit -> 1099 Year Details (AP654500)
- Finance -> Accounts Payable -> Reports -> Audit -> 1099 Year Summary (AP654000)
- Finance -> Accounts Receivable -> Reports -> Balance -> AR Balance by GL Account (AR632000)
- Finance -> Accounts Receivable -> Reports -> Balance -> AR Balance by Customer (AR632500)
- Finance -> Accounts Receivable -> Reports -> Balance -> AR Balance by Customer MC (AR633000)
- Finance -> Accounts Receivable -> Reports -> Balance -> AR Aged Past Due (AR631000)
- Finance -> Accounts Receivable -> Reports -> Balance -> AR Aged Past Due MC (AR631100)
- Finance -> Accounts Receivable -> Reports -> Balance -> AR Aged Outstanding (AR631500)
- Finance -> Accounts Receivable -> Reports -> Balance -> AR Aged Outstanding MC (AR631600)
- Finance -> Accounts Receivable -> Reports -> Balance -> AR Aged Period Sensitive (AR630500)
- Finance -> Accounts Receivable -> Reports -> Audit -> Customer Summary (AR650500)
- Finance -> Accounts Receivable -> Reports -> Audit -> Customer Details (AR651000)
- Finance -> Accounts Receivable -> Reports -> Audit -> Customer History Summary (AR652100)
- Finance -> Accounts Receivable -> Reports -> Audit -> Customer History (AR652000)
- Finance -> Accounts Receivable -> Reports -> Audit -> AR Edit (AR611000)
- Finance -> Accounts Receivable -> Reports -> Audit -> AR Edit Detailed (AR610500)
- Finance -> Accounts Receivable -> Reports -> Audit -> AR Register (AR621500)
- Finance -> Accounts Receivable -> Reports -> Audit -> AR Register Detailed (AR622000)
- Finance -> Accounts Receivable -> Reports -> Audit -> AR Batch Register (AR620500)
- Finance -> Accounts Receivable -> Reports -> Audit -> AR Batch Register Detailed (AR621000)
- Finance -> Accounts Receivable -> Reports -> Audit -> Open AR Documents (AR656000)
- Distribution -> Inventory -> Reports -> Balances -> Inventory Balance (IN615000)
- Distribution -> Inventory -> Reports -> Balances -> Historical Inventory Balance (IN616000)
- Distribution -> Inventory -> Reports -> Balances -> Inventory Valuation (IN615500)
- Distribution -> Inventory -> Reports -> Balances -> Historical Inventory Valuation (IN617000)
- Distribution -> Inventory -> Reports -> Balances -> Goods In Transit (IN616500)
- Distribution -> Inventory -> Reports -> Audit -> Standard Cost Change Preview (IN617500)
- Distribution -> Inventory -> Reports -> Audit -> Open Inventory Documents (IN656000)
- Distribution -> Inventory -> Reports -> Audit -> Inventory Register (IN614000)
- Distribution -> Inventory -> Reports -> Audit -> Inventory Account Distribution (IN611500)
- Distribution -> Inventory -> Reports -> Audit -> Inventory Edit Summary (IN610500)
- Distribution -> Inventory -> Reports -> Audit -> Inventory Edit Details (IN611000)
- Distribution -> Sales Orders -> Reports -> Audit -> Sales Order Summary (SO610500)
- Distribution -> Sales Orders -> Reports -> Audit -> Sales Order Details By Customer (SO611000)
- Distribution -> Sales Orders -> Reports -> Audit -> Sales Order Details By Inventory Item (SO611500)
- Distribution -> Sales Orders -> Reports -> Audit -> Shipment Summary (SO620500)
- Distribution -> Sales Orders -> Reports -> Audit -> Shipment Details By Customer (SO621000)
- Distribution -> Sales Orders -> Reports -> Audit -> Shipment Details By Inventory Item (SO621500)
- Distribution -> Sales Orders -> Reports -> Audit -> Order Register (SO612000)
- Distribution -> Sales Orders -> Reports -> Audit -> Shipment Register (SO612500)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Order Summary (PO610500)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Order Details By Vendor (PO611000)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Order Details By Inventory Item (PO611500)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Order Details By Account (PO612000)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Receipt Summary (PO620500)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Receipt Details By Vendor (PO621000)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Receipt Billing Details (PO632000)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Receipt Billing Summary (PO631500)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Receipt Accrual Details (PO631000)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Receipt Accrual Summary (PO630500)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Receipt History (PO643000)
- Distribution -> Purchase Orders -> Reports -> Audit -> Purchase Receipt Allocated and Backordered (PO622000)
The Plan
As you can see, there are 104 reports on the list. If I review one per week, then it will take me exactly two years.
Now, I might find at some point that I can review more than one report per week. If that happens then of course it won’t take me a full two years. But, for now I’m setting the expectation at two years.
I’ll start my first post next Thursday. As I go through each report in the list above, I’ll come back to this post and turn the report name into a link to the review for that report.
This should be fun. Let’s get to work!
Which Modules
Acumatica 5.0 was just released and I installed it in my environment so I can now go through the out of the box reports in Acumatica 5.0.
If you look at the way Acumatica is structured, there are different module categories and, within those categories, different modules. Each module is organized further into tabs and folders.
I will be reviewing the reports in the 7 highlighted modules below:
- Organization –> Communication
- Organization –> Customer Management
- Organization –> Projects
- Organization –> Time & Expenses
- Organization –> Organization Structure
- Organization –> Dashboard Templates
- Organization –> Company Dashboards
- Finance –> General Ledger
- Finance –> Cash Management
- Finance –> Accounts Payable
- Finance –> Accounts Receivable
- Finance –> Fixed Assets
- Finance –> Deferred Revenue
- Finance –> Taxes
- Finance –> Currency Management
- Distribution –> Inventory
- Distribution –> Sales Orders
- Distribution –> Purchase Orders
- Distribution –> Purchase Requisitions
- Configuration –> Common Settings
- Configuration –> User Security
- Configuration –> Row-Level Security
- Configuration –> Document Management
- Configuration –> Email
- System –> Management
- System –> Integration
- System –> Automation
- System –> Customization
How I Came Up With the List
I decided to review everything in the Reports tab under each module with the exception of the following folders: Financial Statements, Forms, Hidden, and Physical Count.
Since I’m lazy and I didn’t want to type out the names of each report, I decided to come up with a query that would give me their names.
Here is the SQL query that I came up with: