Tuesday 23 April 2013

How to modify an account logic in existing Subledger Accounting Definition

Question: Can I use the Oracle Standard SLA method ( Standard Accrual ) but at the same time modify an account logic for some specific item. Like account change for tax based on ship to country for AR Invoice?

Ans. Yes this is possible. SLA method is attached to the ledger and hence once it is setup, it can not be modified. It would be a huge effort to rework on the ledger setup and not worth its while for few account logic changes. Instead, all that we need to do are the following:

      a) Create a new accounting derivation rule with condition like ship to country value for deriving the tax account.
      b) Create a new Journal Line Definition (JLD) by copying the existing JLD.
      c) Change the Rule Name for Invoice Tax Journal Line Type to the new accounting derivation rule you just created in a) above.
     d)  Go to the standard Application Accounting Definition (AAD) for receivables, copy it and create a new application accounting definition.
    e)   In the event class for Invoice, change the Journal Line definition name to the one that you created in b) above.

    f) Go to the Subledger Accounting Method and look for Receivables in the Application Accounting Definition Assignment. End date the AAD for receivables and create a new line for receivables. Note that you are not copying the SLA standard accrual to another one, instead you are modifying on the existing one itself. This will enable you to use the same ledger.


    g) and that's it. As simple as that.