Solution:

Customer Sales Analysis Report Displays “N/A” values in subtotal and total amounts.

There are two reasons why  “N/A” values are displayed on the Customer Sales Analysis Report:

Multicurrency Company

If the company is using multicurrency and the invoice Ext and Margin amounts are in different currencies, “N/A” will display in the subtotals and total amounts.

ARTRAN.Currid or ARYTRN.Currid is not populated with USD

Important
The following should only be done by a Sage Certified Consultant or Business Partner. Create a full and verified backup before proceeding. This should first be attempted in a test installation and the results should be fully verified before implementing in a live system.

If the company is not using multicurrency, the issue is caused by records where either the ARTRAN.Currid or ARYTRN.Currid field is blank. This field should always be populated with “USD.” If records have been identify where ARTRAN.Currid or ARYTRN.Currid is blank, these records will need to be fixed and populated with “USD”

© Copyright Sage Software