Monday, December 1, 2014

Cannot Approve PO Error: Line # 1 Shipment # 1 Distribution # 1Distribution is missing foreign currency rate



Cannot Approve PO Error: Line # 1 Shipment # 1 Distribution # 1Distribution is missing foreign currency rate

SYMPTOMS
When attempting to Approve Purchase Order the following error occurs:
ERROR
Error: Line # 1 Shipment # 1 Distribution # 1Distribution is missing foreign currency rate.

STEPS
The issue can be reproduced at will with the following steps:
1- Create PO with base currency
2- Enter PO line, shipment and distribution and save
4- Change PO currency,  Error message :
        APP-PO-14338: Purchase order lines not automatically converted to this
       Currency
       You are trying to change the currency of a purchase order header after creating purchase
       Order lines for this header. Oracle Purchasing does not automatically convert
       Price on the purchase order lines after you change the currency.
       In the Tools menu, select Convert Currency if you want to convert all
       Purchase order line amount to the new currency. If the purchase order
       Contains amount-based line types, you will need to manually update the
       Price information on all purchase order lines to reflect your changes in
        The currency.
   
    5- Click on approve, error message appears:
         Error:    Line # 1 Shipment # 1 Distribution # 1 Distribution is missing foreign currency rate.
   
CAUSE
Currency rate at distribution level is not automatically updated after changing the currency at the header level.
SOLUTION
To implement the solution , execute the following:
1.Make the change of currency at PO header level. Do not save.
2.From the Tools menu in Purchase Order entry form, select convert currency to convert all
   Purchase Order distributions to the new currency.
3. Save. This will ensure currency will be changed at PO distribution level.

No comments: