Customized Sales Reports Displays Duplicate Sales Amount When Address Filter is used or when an Address field is displayed on the Results

If users customize a summary sales report that includes Address Book:City, State, etc. as filter to display all sales to customers located in a specific city, state, etc. and the total amount for a customer is different from the detailed report (i.e. overstated), perform the following:

1. Navigate to Lists > Relationships > Customers
2. Click View next to the customer record
3. Click Address Tab. The number of times the specific City, State, etc. appears on the Address is number of times the balances are multiplied.

That being the case, users must mark at least one address as a default billing or shipping address.

In customizing reports, add the filter Address Book : Default Billing or Default Shipping (Customer/Job > Address Book > Default Billing or Default Shipping, Filter : equal to True).

User may also opt to replace the Address Book filter with the Sales Transaction's Billing or Shipping Address (Sales > Address > Billing Address  or Shipping Address City, State, etc.) .