FAQ #: 104
My sales figures from G/L are not balancing with totals on my Sales Analysis Reports.

There are several things to consider when trying to balance information from these two areas.

(1) Special Charges need to be reviewed to see which G/L accounts they are updating and whether they have a product code or not. If they do not have a product code, then they will not go to S/A, but will still go to G/L. Often Special Charges are directed to different G/L accounts other than the normal sales accounts.

(2) G/L must be reviewed using the J/E Activity tab, a Detailed Trial Balance, or Account Activity Report to determin if there are entries being made to the sales account(s) from sources other than Order Processing. They can often include things such as price adjustments entered through Cash Posting, etc. Realize these are updating G/L, but not S/A.