BUG: Foreign Currency PO, PV With FA Split

peterbruce

peterbruce

Legendary Poster
JDEList,

Has anyone heard of a bug, probably involving P12102 (Revise Unposted Entries), for a foreign currency purchase order that has been receipted and a voucher created with a notional loss on exchange between the order date and the voucher gl date and then split to create two assets.

We have the above situation where the asset creation resulted in a document being out of balance. This would not have been noticed, except that the account involved had to be re-posted (R099102), which caused the company to be out of balance.

What happened was that when the voucher was created two expense distribution lines were created (F0911), the original with the purchase order domestic and foreign currency amounts and a second line for the extra expense due to the change in the exchange rate between the order date and the voucher gl date. This second line does not have a foreign amount. When using P12102 to create two assets, the amounts on the two lines were added together and the total divided by two and the original line 1 amounts were changed to the amounts calculated. A new line was created for the second asset exactly the same as the first line after the change. The 2nd line for the notional exchange loss was left unchanged. All lines are marked as posted.

To demonstrate:

PO Foreign Amount 9,000
PO Domestic Amount 10,000

PV Line 1 Foreign Amount 9,000
PV Line 1 Domestic Amount 10,000
PV Line 2 Foreign Amount 0
PV Line 2 Domestic Amount 200

Total Domestic 10,200
Total Foreign 9,000

After Asset split:

PV Line 1 Foreign Amount 4,500
PV Line 1 Domestic Amount 5,100
PV Line 1 Asset Number 1
PV Line 2 Foreign Amount 0
PV Line 2 Domestic Amount 200
PV Line 2 Asset Number blank
PV Line 3 Foreign Amount 4,500
PV Line 3 Domestic Amount 5,100
PV Line 3 Asset Number 2

Total Domestic 10,400
Total Foreign 9,000

The voucher is out of balance by 200.
 
Back
Top