3735639 - Currency and Document Currency Search Filters in Manage Billing Documents Application Behave Differently

When using the app Manage Billing Documents to find a billing document worth a defined amount in a specific currency (e.g. JPY/ Japanese Yen), depending on the currency filter selected, different search results are observed. 

SAP S/4HANA Cloud Public Edition

1. Open the app Manage Billing Documents.
2. Identify a billing document with a known Net Value in JPY (for example, 100 JPY).
3. Adapt Filters and add Document Currency and Net Value.
4. Set Document Currency = JPY and Net Value to the known display amount (for example, 100). 

Observe that the expected document(s) appear.

1. Now replace Document Currency with Currency while keeping Net Value the same.

Observe that the results show amounts inflated by a factor of 100 (for example, 10,000), differing from the expected document(s).

This is the expected system behavior.

In the backend the amount fields, such as Net Value, in the app are bound to the transaction currency (Document Currency). The field Currency represents the company code currency and is not assigned to those amount fields for filtering, leading to mismatched interpretation.

For zero-decimal currencies like JPY, values are stored internally with two decimals. Using Currency with Net Value causes a factor-of-100 discrepancy, whereas Document Currency applies the correct display-to-internal conversion.

When searching for a document worth a specified amount in Manage Billing Documents use Document Currency together with amount fields (e.g. Net Value) to ensure you get the desired result.

manage billing documents, document currency, currency filter, net value, jpy, zero-decimal currency, factor 100, rounding, search results, billing documents, filter mismatch, transaction currency, company code currency, s/4hana cloud, sales billing , KBA , SD-BIL-IV , Processing Billing Documents , Problem