Has anyone figured out a way to get an edit list for auto posting financial documents? For audit and review purposes, it would be great to be able to have the ability review edit list before posting like AR and AP Invoice Batches, GL postings and Fixed Asset Postings.
Examples include:
Apply Credit Memo
Apply Debit Memo/Prepayment
Write Off and Adjustments
Bank Funds Transfer
Void AP Payments
Thanks,
Cyle
Hi Cyle,
Have you considered just sending those transactions to the Review Journal? You can do that in GL Transaction Types. This will let you post it and review/confirm/cancel it in the RJ so could act like an edit list.
If that doesn’t work, you will have to create the report and or show the information via customization on each screen but that might get involved. The general ledger data will be in either the TranGLC table or the GLJrnDtl table. These tables will have to be tied to the corresponding transactional tables in each instance.
The data is also available in the GL Distribution report and/or GL Account summary report but that is after you post. It is period based and the transactions you are referring are single transactions so you will have to find your transaction in the report.
Ross
Hi Ross,
Thanks for the feedback. I will have to spend sometime right after month end looking into the GL Transaction Types to send it to the review Journal. This sounds like a viable solution. Hopefully, Epicor will expand the edit list to all postings and remove the auto posting of these entries.
I digress, but if the inventory receipt doesn’t auto post and relies on a WIP capture process, one would think these entries wouldn’t auto post.
Anyways, I will look into the GL Transaction Types and the G/L Distribution reports and let you know if I have any questions.
I greatly appreciate the help.
Cyle
