Hi Folks, I have a dilemma, A/R sub ledger was closed for month of June, then some invoices for June were brought in after the A/R close and got posted in July with June 30th date. Now GL and A/R subledger are mismatched or not aligned. my questions are these: 1. Would the AR sub-ledger being close cause transactions to synch to the next open period (July) 2. Is the sub-ledger driven by the invoice date 6/30 versus the posting date (and thus this causes the disconnect). If all of the above is true – which would logically make sense to me – we have done a saved search of invoices dated 6/30/2021 that were posted in July – I would want to utilize this search as support to accrue in the missing A/R and revenue for the June period.   There’s an option B to open A/R and get these posted into the correct period not via a JE but we’re not certain that that wouldn’t impact some of the consolidated invoicing that had already been sent to customers. Any help appreciated @KevinJ of Kansas

I would opt for re-opening the period, booking your AR and re-consolicating the invoices. Painful one-and-done vs dragging the issue into the next period, using journals for AR accruals (???$%^&^%) which you are the one to control and any consolidation/reval issues that may arise.

thanks @Karina thats was my suggestion

The sub-ledger is driven by the invoice date unless you change your preference in Home | Set Preferences | Analytics | Report by Period = All Reports If you do this, the GL and subledger (aged receivables) will automatically align. With that said, assuming the dates on the invoices are correct I would still go with Karina's suggestion.

@Jon Kears thanks setting the preference is for user specific so all the users have to have the same preference. That's why I asked them to reopen the period and close it properly

true - the trick is you only show the auditors users with that box ticked 😉

great I can add this to my suiteworld 2019 presentation for audit preparation - can showcase in 2021 suiteworld LOL

You can define that preference on the role