Skip to Content
0
Oct 24, 2011 at 02:15 PM

Custom field - Local Net Value Billing

342 Views

Hello,

Could you please help me to understand how calculate correctly, in a query, the net value of billing in the system currency?

I've created the custom field Local-Net Value = VBRP-NETWR * VBRK-KURRF.

But, when i executed the query i had the following situations:

- The correct value when the exchange rate is from EUR to another currency.

- The value incorrectly when the exchange rate is from another currency to EUR, (the exchange rate, VBRK-KURRF, is expressed as a dividend).

Thank you in advance.

Best regards.

Antonio