Skip to main content
R
Robbie Telfer
July 12, 2023
Question

Sales by Customer Summary Report not correct

  • July 12, 2023
  • 1 reply
  • 0 views

Hello

 

When running the Sales by Customer Summary report, the amounts do not match the P&L revenue totals. This seems to be because the report is including journals such as exchange gain/loss journals the system automatically produces when receiving foreign currency transactions. These should not be included in this report as they are not 'sale' transactions.

 

How can I get a sales report by customer that would match the actual P&L revenue figure for the month?

 

To me this seems a defect in this report that needs fixing. It doesn't work the same way the Sales by Customer Summary report did in Desktop (surprise surprise), which always matched the P&L revenue figure.

1 reply

G
GeorgiaC
July 12, 2023

Hi Robbie, thanks for posting on the Community. 

 

Does the journal show when drilling into the Sales by Customer Summary report by clicking the total amount beside the customer, and do you have any sales tax or No VAT (sales) codes included on the journals? 

Terms & ConditionsAccessibility statement