In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Accounting Journals that show specific debits/credits
I'm not a controller but I work with one 🙂
We're doing an implementation of Acumatica currently. In our old system we have journals for the various modules (AP, AR, Sales, Inventory) and they show a summary for the day of the impact to the general ledger.
For example this would be our "Sales Journal" for the day. It only relates to sales though.
Our controller is struggling with Acumatica in trying to see this information. He says he uses this to find discrepancy and errors in the day. If he finds something out of balance he can dial into the specific area. The reports also have a detail tab attached to them that he has them print out with the summary and he uses that to dial in as well.
I'm trying to come up with the "modern" way this is done. Our implementation team basically said no one else does it this way that they've seen and don't "eagle eye" on a daily basis like he does.
I did find @Tim Rodman's Things that Should Never Happen Dashboard and used that to see the if there is a mismatch between AP and GL. We would have to create one for each "module" but the details are lost for that.
I think this could be accomplished through a custom report or custom generic inquiry.
If you are starting from the GL you would need to link back to the original AR Transactions and then filter the lines that originated from a Sales Order.
You could throw the results of the generic inquiry on a widget on a dashboard.
It would be an interesting project.
Feel free to reach out to me if you need help.
As Patrick mentioned, you can easily create a solution in the form of a Generic Inquiry or dashboard that satisfies the user requirement.
I created a quick Generic Inquiry that shows the postings for a period - see attached. Included in a Pivot Table that summaries by day.
Couple of assumptions that can be considered easily:
- Ledgers (did not break out by ledger - Actual versus, statistical, reporting),
- Companies/Branches(did not breakdown by company/branch)