I’m hoping someone can point me in the right direction; I’m guessing there’s probably even some stuff in the standard help that covers this but I’m striking out.
If I run one of the stock AP or AR reports (I’ll use “AP Balance by GL Account” as my example), they all have a date or period parameter. What I’m being asked for is to run these reports as of a specific date, like running the AP Balance as of the previous month end, so that we can then tie to the appropriate GL accounts.
The issue with As-Of reporting in every ERP I’ve ever worked with is that, for subledger reports like AR and AP, the transactions are always changing. GL is easy to run “as of”, because you never close or delete a GL transaction (worst case, you create a new transaction in the same period to reverse it). It’s very possible on an AP subledger report that I may come in on February 3 and need to post an bill with a posting date of January 31. I may also, on the same day, pay and close a January 10 bill. I can’t capture an AP balance overnight on 1/31 because it won’t reflect that bill I posted on 2/3, but if I run the report on 2/4 it (from what I’ve seen) winds up not including that January 10 bill that I paid on 2/3.
Our finance team is low key having kittens because they can easily produce a 1/31 balance of the GL accounts, they can’t create a subledger report that matches. If a stock report can’t do as-of, I may have to result to some Excel magic to pull out the bills that were active during a period, and back out payments made in future periods.
