Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Customer Sales History By Period

Posted By Justin K over 6 years ago

Just wondering what might throw the amounts in these period 'buckets' out of sync with amounts in transaction data? I've read that it could be due to performing period end close in AR 'incorrectly', but couldn't find specific examples of what might be considered an 'incorrect' P/E close. Can someone fill me in on this? Thanks!

0 TomTarget over 6 years ago in reply to Justin K

Had me curious so I just verified in the ABC demo data. Invoice dated 6/5/2020. Updated the journal to 5/31/2020.

Tab 5 History in customer maintenance/inquiry reports the invoice in May 2020.

Mismatched dates theory confirmed.

On a similar topic, I verified recently that the A/R sales tax report runs on the invoice date, not the g/l posting date (so just the opposite of above). Really would be nice to have some sort of functionality to flag mismatched dates to catch these kinds of mistakes.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Customer Sales History By Period

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING