Skip to main content

Oracle Purchasing Expense Charge Account Rules

Expense Charge Account Rules

When determining the default charge account, the account generator may reference the charge account defined on the employee record. Expense Charge Account Rules enable you to override one or multiple segments of that default account based on the item category. This ability to override does not interfere with the action of the account generator, but replaces those segments you configure after the account generator has created a charge account.
Setup Steps
  1. Log in to Oracle Applications and choose the Procure to Pay Administrator responsibility.
  2. Navigate to Purchasing Setup > Financials > Accounting > Expense Account Rules.
  3. Define the rules (for each item category) in the window. Duplicate rules for the same category or account segment are not permitted.
  4. Save your work.
Profile Options
  • Set POR: Apply Expense Account Rules to Favorite Charge Accounts to Yes

Comments

  1. UnknownFebruary 7, 2017 at 3:39 AM

    How we can change Charge account while making PO Receipt?

    ReplyDelete
  2. Sreekanth Reddy PothulaFebruary 7, 2017 at 3:25 PM

    Hi Kaushik,

    Nice Question. I don't think we can change charge account on PO during Receipt Creation from both iProcurement Desktop Receiving and Standard Receiving from Purchasing Super User.

    As per standard functionality when the charge account on distribution of the PO is changed it will go for require reapproval even though the revision number will not changed.

    The alternatives are either buyer can change during the PO approval or after PO approval and before Receipt creation or the requester can change if it is returned by buyer for a change if the requester is having access to change the default account (Depends on Client's requirement).

    Thanks,
    Sree

    ReplyDelete
  3. UnknownMarch 14, 2017 at 3:58 PM

    HI Sreekanth,

    Firstly, thanks for the article. i followed the steps as mentioned by you.

    my requirement is for an expense destination, non-inventory PO.

    So Default expense account on employee record is: XX-XXXXX-211017-XXX.

    i defined a category 'Miscellaneous.Miscellaneous' in the expense account rules HTML form with 3rd segment value - 411010.

    Now when i create a PO, the charge account on the distributions is not defaulted.

    Then i create 3 more records for category Miscellaneous.Miscellaneous' in the expense account rules HTML form with 1st, 2nd, 3rd and 4th segment values respectively as XX, XXXXX, 411010 and XXXX.

    Now when i create the PO, the charge account on the distributions is defaulted as XX-XXXXX-411040-XXXX.

    So my questions are:

    1. when i defined only one record in expense rules form for only one segment that i want to be overridden, why is the charge account not defaulting in the distributions window? i see that requester field is not defaulting either in the shipments/distributions form. is it an expected functionality?

    2. when defined a record for the same category per segment, the account was defaulted. why did this happen? is this expected? normally i would imagine that we only need to define categories in expense rules form for the segment that we want to change and not the whole CCID.

    3. Is there a way i can change this behaviour? requirement is to change the 3rd segment of our default PO charge account (which is on the buyer record) with the segment depending on the category used in the PO.

    any help will be highly appreciated.

    Thanks,
    A

    ReplyDelete
    Replies
    1. Sreekanth Reddy PothulaMarch 25, 2017 at 4:25 PM

      Hi Anshalu,

      Thanks for your feedback, sorry for delay in my response.

      Can you please confirm the below -

      1) Are you creating the PO directly without referring any Requisition or auto creating the PO from Requisition Created in iProcurement/Core Purchasing?

      If you are creating the PO based on Requisition, please check whether the requester is having Expense Account defined in HR and also check the iProcurement preferences for the same user.

      If you are directly creating PO without referring requisition, you won't see the requester field defaulted on PO and verify the Buyer's Employee record.

      The standard functionality should work in your case.
      I suggest you to try creating requisition from iProcurement with the buyer's login and check the charge account default login on requisition distribution and share the results.

      Thanks,
      Sree



      Delete
    2. Sreekanth Reddy PothulaMarch 25, 2017 at 4:28 PM

      Below is the standard functionality -

      Based on the Account Generator workflow logic, the expense account rules are called
      - If the item is not having an expense account entered on the item in the item master (Not applicable for non-inventory item)

      - Partial replacement will occur from the expense account rule - if a complete account is found first - ex. from the requester, inventory organization parameters, etc..

      - If a complete account combination is not found - then expense account rules would have to exist for all the segments

      Expense account rules are designed to overlay already located segments - if a full account is found - or
      if all segments are defined in the expense account rules then it would build a complete combination using those rules.

      Delete

Post a Comment

Popular posts from this blog

How To Enable / Disable Forms Personalization Option

Forms Personalization gives great flexibility to execute custom business logic without performing so much of technical work. To start forms personalization navigate to Help -> Diagnostics -> Custom Code -> Personalize But many time when we click on personalize it give below error  " Function is not available for this respnosibility. Change responsibilities or contact your System Administrator " To Enable access to forms personalization function we need to set below profile option.  -  Utilities:Diagnostics -> Yes / No It determines the diagnostics option is enabled for a user / responsibility or site, depending on the level profile option is set. Navigate to System Administrator -> Profile -> System Query for your user / responsibility for which you want to provide access. Set the value to 'Yes' , If you want allow access to forms personalization Since we change the profile option please change the respons...
Post a Comment
Read more

Query to find Operating Unit, Business Group and Legal Entity Information

SELECT   DISTINCT   hrl . country ,                  hroutl_bg . name              bg ,                  hroutl_bg . organization_id ,                  lep . legal_entity_id ,                  lep . name                    legal_entity ,                  hroutl_ou . name              ou_name ,               ...
Post a Comment
Read more

Oracle Purchasing – Receipt Accounting

Oracle Purchasing – Receipt Accounting (Accrue On Receipt and Accrue at Period End) Inventory Accruals: Inventory and Purchasing provides visibility and control of accrued liabilities for inventory items. Purchasing automatically records the accrued liability for the inventory items at the time of receipt. This transaction is automatically recorded in the general ledger at the time of receipt. The inventory expense is recorded at delivery if Standard Delivery is used and at receipt if Direct Delivery used. Expense Accruals: Purchasing optionally accrues un-invoiced receipts of non-inventory items when a period is closed. Purchasing automatically creates a balanced journal entry for each receipt un-invoiced at period end which can be reversed at the beginning of the next period. Navigation: India Local Purchasing > Oracle Purchasing > Setup > Organizations > Purchasing Options Difference between 'Accrue On Receipt' and 'Accrue at Per...
Post a Comment
Read more