Sage 100

Odd situation. A statement printed for a customer and the AR Trial Balance for the same customer do not agree. As you can see in the first attachment, the statement balance at the bottom of 5527.10 agrees with the TB (second attachment) but the running total of the statement shows 2622.27. This is due to all of the clearing transactions. I have no idea why they are all appearing, from as far back as 12/2014. These invoices are zero but when looking at the actual 'invoice', there is no invoice transaction (third attachment). They use AP/AR clearing but I can't figure this one out. They've never used statements but want to start if we can figure out WTH is happening here. Anyone??

Okay, so the invoices are missing from the AR_TransactionHistory file. What's the best way to clean this up? Is there a utility to purge transaction history as of a certain date?? @Sage100UrgentSupportNeeded

Are you willing to purge across the board? The Period End processing SHOULD delete AR_TransactionHistory files based on how many days history of paid invoices you have setup in AR options - but maybe there is a field missing on these records that is preventing that from happening.

Well, maybe if they RAN period end processing!!! They are in 2015.

ahhhhhhhhhhh

Copied to backup company and ran period end - statement is now correct! Yay!!

rebuild AR sprts