KevinCourtney
Active Member
Hello there,
I’ve created a custom table containing a field based on the alias ACR (Amount – Currency)
In the F03B11 Customer Ledger, it has a field based on the same ACR alias that holds the amount that represents the foreign currency.
My UBE reads through the F03B11 and inserts records into my table. In debug I can see the F03B11.ACR has a value of 72205 (no decimals) and moves this value into my worktable’s.ACR in the insert.
When I go to UTB I see the F03B11.ACR has the 72205 with no decimals but my worktable has its ACR = 722.05.
In UTB, properties of both ACRs says their display decimals is 2.
In creating custom tables, how do I tell JDE that a foreign currency amount field should have its values to be based on a certain Currency Code in the file?
Have any of you come across this and/or have any ideas?
Thanks in advance,
I’ve created a custom table containing a field based on the alias ACR (Amount – Currency)
In the F03B11 Customer Ledger, it has a field based on the same ACR alias that holds the amount that represents the foreign currency.
My UBE reads through the F03B11 and inserts records into my table. In debug I can see the F03B11.ACR has a value of 72205 (no decimals) and moves this value into my worktable’s.ACR in the insert.
When I go to UTB I see the F03B11.ACR has the 72205 with no decimals but my worktable has its ACR = 722.05.
In UTB, properties of both ACRs says their display decimals is 2.
In creating custom tables, how do I tell JDE that a foreign currency amount field should have its values to be based on a certain Currency Code in the file?
Have any of you come across this and/or have any ideas?
Thanks in advance,