Hello AMARJEET SINGH,

You can try generating the Customer Aged Detail Report.

1. (Reports -> Customers & Sales -> Customer...)

2. Switch the Report Type to "Detail"

3. Select the last day of your fiscal year for the report

4. Include invoices paid in the last 365 days.

The report has a column for Currency Code so you can export the report to Excel and sort the report by currency code.

Thank you for the reply. is this the only way to do sales summary? i want to do yearly sale summary without adding any payment details.

thank you.

Hi there, thanks for the follow-up question!

The Sage 50 team confirms that at the moment, the Customer Aged Detail Report is the only built-in Sage 50 report that includes the currency code directly in the output. Other sales-related reports don’t display the currency code, even when foreign currency customers or transactions are involved.

If you need a yearly sales summary that shows both USD and CAD, one option is to:

• Export your preferred sales report to Excel and

• Add or reference the customer’s currency code manually, or

• Export the Aged Detail Report and summarize the data in Excel to create the format you need.

Since Sage 50’s standard sales reports don’t include the currency field, customizing the exported data is currently the most flexible workaround.

If you’d like to share the layout you’re trying to achieve, the community may also have tips or alternative workflows.

Hi there, thanks for the follow-up question!

The Sage 50 team confirms that at the moment, the Customer Aged Detail Report is the only built-in Sage 50 report that includes the currency code directly in the output. Other sales-related reports don’t display the currency code, even when foreign currency customers or transactions are involved.

If you need a yearly sales summary that shows both USD and CAD, one option is to:

• Export your preferred sales report to Excel and

• Add or reference the customer’s currency code manually, or

• Export the Aged Detail Report and summarize the data in Excel to create the format you need.

Since Sage 50’s standard sales reports don’t include the currency field, customizing the exported data is currently the most flexible workaround.

If you’d like to share the layout you’re trying to achieve, the community may also have tips or alternative workflows.