Sales Analysis Discrepancies

If a Sales Analysis is not printing as expected or there are discrepancies around one report giving a different value than another then check the following:

GL Codes

Are there any GL codes that start with "T", "S", "N", "B", "P"?

When invoice lines are recorded with eg. "/T-1000" this will be read by the sales analysis as a Trade-in. 

Similar problems are possible with the other letters.

Solution – for "/T" GL codes

1. Swap the GL codes to a different code - "_T" or use "1000-T"; or
2. Adjust the Sales Analysis to exclude the reserved letter, provided the Company does not, nor will ever use Trade-ins. In Before Open Tables find this section.  Add the section in BLUE:

(invidx.location=VAL(nzf_location) OR nzf_location="999") AND INVIDX.POSTED=1 AND (invln.code <> "/N " OR invln.extend <>0) AND ;

(infflags.rpttradein OR (not infflags.rpttradein AND Left(invln.Code, 3) <> "/T " AND invln.tiproc = 0 ))

 If the source of the problem is another letter in the GL please contact Support to find the fix.

Freight

If an invoice has had freight added to the bottom of the invoice and then that freight needs to be credited, the freight cannot be credited from the freight field,  it must appear as a line in the invoice.  This means that the sales analysis will include the Freight Credit, but not the initial freight charged.

Solution

Contact Support, if the discrepancy is significant a fix may need to be applied in the tables to exclude this freight credit.