Hi Vincent:

If you have set up Sage to use multi-currency then only US sales will show in US currency. If you wanted all customers to reflect in US currency then your home currency must be US rather than CAD.

In the Customer Sales Summary Report, the Revenue, COGS and Profit column are always shown/calculated in CAD. I want to see all those 3 colums in USD if the customer is US and in CAD if the customer is CA.

Vincent:

A custom report would have to be developed to come up with what you are requiring for the Customer Sales Summary Report.

How to create a custom report without the Sage Intelligence Reporting, since SAGE remove it for the Canadian in the version 2022?

XLGL (Logicim.ca) writes custom reports for Sage 50. If the data is in the program they can pull it to a report. https://www.logicimtech.com/

Hi Vincent:

We also have an associate who can customize reports. See our website https://agateconsulting.ca. Send us the format of the report and we will quote it for you.