Skip to main content
Question

Multi currency customer statement coming out black although customer has open items in foreign currency

  • October 8, 2026
  • 5 replies
  • 17 views

Forum|alt.badge.img

Good day

 

I am running the customer statement on demand for a customer denoted in a foreign currency and they have open items. However on printing the Multicurrency statement is comes out blank and the customer’s currency set in master data does not appear on statement.

Where could I be getting it wrong?

5 replies

Eric Ratté
Jr Varsity I
Forum|alt.badge.img+2
  • Jr Varsity I
  • October 8, 2026

Hi,

Please verify:

1- Compare the date of the statement and the one from the document. Anything document after the date of the statement will not be considered most of the time.

2- The status of the document should be open or Closed - meaning it has been released and affected the customer balance.

3- The type of statement. There is one (Balance Brought Forward) that lists all documents no matter what their status and has a brought forward amount for past periods and another type (Open Item) that acts like a credit card, which lists all open documents no matter the date. I usually select the later because customer always want to know details about outstanding documents.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • October 8, 2026

Hi,

Please verify:

1- Compare the date of the statement and the one from the document. Anything document after the date of the statement will not be considered most of the time.

2- The status of the document should be open or Closed - meaning it has been released and affected the customer balance.

3- The type of statement. There is one (Balance Brought Forward) that lists all documents no matter what their status and has a brought forward amount for past periods and another type (Open Item) that acts like a credit card, which lists all open documents no matter the date. I usually select the later because customer always want to know details about outstanding documents.

There are open documents, the fundamental difference I am seeing is that the customer had a payment done in base currency USD of the company, then matched to forex invoices now the statement comes out blank.


Eric Ratté
Jr Varsity I
Forum|alt.badge.img+2
  • Jr Varsity I
  • October 8, 2026

1. Try to recalculate customer balances for this customer and regenerate the statement.

  1. Switch the type of statement to Open Item and/or not MC statement.

The goal is to know if the problem is for all types of statements, just MC or not, after balcances have been calculated.

Then, knowing which reports has to be changed, a case at Acumatica can be created.

Also, has the statement report been modified? 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • October 8, 2026

1. Try to recalculate customer balances for this customer and regenerate the statement.

  1. Switch the type of statement to Open Item and/or not MC statement.

The goal is to know if the problem is for all types of statements, just MC or not, after balcances have been calculated.

Then, knowing which reports has to be changed, a case at Acumatica can be created.

Also, has the statement report been modified? 

1. Try to recalculate customer balances for this customer and regenerate the statement.

  1. Switch the type of statement to Open Item and/or not MC statement.

The goal is to know if the problem is for all types of statements, just MC or not, after balcances have been calculated.

Then, knowing which reports has to be changed, a case at Acumatica can be created.

Also, has the statement report been modified? 

The statement is the standard template no changes, then after recalculation done no changes seen.


Eric Ratté
Jr Varsity I
Forum|alt.badge.img+2
  • Jr Varsity I
  • October 8, 2026

I do not have any other idea than to create a support case at Acumatica...