Reconcile Sales Ledger with General Ledger

Hi all,
I am trying to reconcile the sales ledger against the GL but as they move at different speed I am having a torrid time pinning down at what point these should balance. I’d better explain a bit more.
Basically we receive interfaces throughout the day, which are batch processed into the GL at night. We have a report A/R to GL integrity by offset (R03B7001A) but this has not revealed the difference.
Can anyone suggest what date I could use to reconcile these?
Many thanks
Sean

Sean,
The sales ledger (F42199) contains activity based on
activity rules. The sales history file
(F42119)contains closed sales order lines if the
processing options on your sales update program move
the processed lines from your active file(F4211). You
may never be able to match the sales ledger as you may
be saving several instances of the same sales order
and line for each change. Look at your activity rules
to see the frequency of the change being saved by
document type.
You will have better luck using the sales history
file. Look at your sales update processing options to
determine how the GL and AR dates are being populated.
This will provide you with a starting point.
--- seangallivan <[email protected]>
wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=44681


__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/



World, OW B733X and Xe

Try to reconcile after all your interfaces have gone through and the R09801 has run. Then take your balances from the F03B11 and compare to total on F0911. You could use the F0902 as an alternative to same time. In the control accounts you are recnociling too, check that there are no manual postings. All control accounts should be set to automatic posting only.

have fun

Vici