Customer transactions/movement report

Newton

Member
I am new user of JDE. I need a detailed report for all the movements in the customers accounts (invoices, receipts, credit etc with a date range).
I need this report to reconcile the AR ledger with the General ledger which is not matching. (I think some some entries are directly posted to GL). Please help! Thanx.
 
Newton,

First thing you should do is not allow GL transactions to hit the open AR account(s) by making sure the posting edit code is "M". If you are a newbie, I suggest you have a better understanding of how AR and GL works especially the posting process, "As of" process, and the AAIs. You can run a GL transaction report on the AR account(s). All "AE" entries come from the AR. Any other entries will cause the GL to be out of synch with the AR. Also, there may be unposted AR entries not seen in the GL.
 
Back
Top