Mutli-Currency Receipts for landed cost invoices

We are implementing Landed Cost Management Module (LCM) at one of our client in Kingdom of Saudi Arabia. Now Landed Cost Management is recently released and still pre-mature although it is very useful and effective addition to Oracle EBS but it lacks one of the basic requirements.

I don’t know why Oracle Development didn’t catered this first hand. I am sure around the world whenever anything is Imported landed cost invoice is always different than PO currency.

PO is always raised in Foreign currency and Landed cost (Freight, Insurance, Duty, and local transport) in local currency.

In our case PO is raised in USD, EURO, JPY and landed cost invoices are always in SAR and while matching the landed cost invoices to the item receipt, it does not shows that receipt.

Now as per Oracle this is the intended functionality. PO currency and Invoice Currency Should be same.
This is a enhancement request and under development review.

Well we all know client doesn’t cares about Oracle Enhancement request and Developement review. This is a logical requirement and a basic one also.

Here on this project we are going with customization and recommend the same till oracle releases and standard functionality.

(Be advised this should be tested thoroughly before migrating it to your live environment)

  • Customize ‘Find Receipts for Matching’ Payables form ($AU_TOP/forms/US/ APXRMTCH.fmb) using following steps :
    • Comment out or remove following code fromOTHR_CHRG_MATCH_EVENT.CONSTRUCT_WHERE_CLAUSE program unit==
      — and this clause by default
      app_query.append (‘OTHR_CHRG_MATCH’,
      ‘CURRENCY_CODE = :INVOICE.INV_CURR_CODE’);
      ==
    • Replace ‘poh.currency_code = :invoice.inv_curr_code’ with ‘((:match_qf.match_type = ‘ITEM’ AND poh.currency_code = :invoice.inv_curr_code) OR (:match_qf.match_type <> ‘ITEM’))’ in PO_NUMBER record group
    • Replace ‘RTXN.currency_code = :invoice.inv_curr_code’ with ‘((:match_qf.match_type = ‘ITEM’ AND RTXN.currency_code = :invoice.inv_curr_code) OR (:match_qf.match_type <> ‘ITEM’))’ in RECEIPT_NUMBER record group (at 4 places)
  • Save the changes and Compile the form to generate APXRMTCH.fmx.
  • Go to $AP_TOP/forms/US and take a backup of APXRMTCH.fmx (i.e copy APXRMTCH.fmx to APXRMTCH.fmx.bak)
  • Copy APXRMTCH.fmx (from step b) to $AP_TOP/forms/US

Wollaaa!!

Do share your feedback.

Advertisements

5 thoughts on “Mutli-Currency Receipts for landed cost invoices

  1. Hi Attiq,

    Thanks for your helpful note, I tried to use same idea of commenting the currency where condition through personalization in Payables and it worked and matched the invoice with the different currency, but unfortunately landed cost couldn’t calculate the invoice charge with the different currency. Any advice regarding this issue ?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s