Free Oracle Magazine Profit:The Executive's Guide to Oracle Applications

Enter your e-mail address to receive notifications when there are new posts

Profit Magazine: The Executive's Guide to Oracle Applications

Procure to Pay (P2P) - Accounting Entries

Posted on March 21st, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In response of my last post ,yet another reader asked for “Asset ,Purchasing & Inventory Purchasing and there corresponding accounting entry within P2P cycle. Therefore this post highlights some of key accounting entry in each steps with respect to th

As you know “procure to pay” Business Flow start Purchasing requisition till paying to vendors and most important, in all the case the purchase is made for basic element called Items.

As you know there are three types of items:

  • Inventory Expense Item
  • Inventory Asset Item
  • Expense item

Definition of above Items used in Purchasing can be best understood as:

ITEMS

Asset flag means means it is an asset and the items value will show in your inventory valuation.

1Inventory Item

inventory item

2Expense Item

These are one which is used for consumable items purchase for your organization. More importantly , for creating an expense item you have to perform following setup doing in the Master Item form.Go to same path in oracle inventory

Oracle Inventory -> Items -> Master Items

When master items form open Go to Inventory Menu you need to tick followings

  1. Inventory item
  2. Stock able
  3. Transactble
  4. Resolvable

And you can also setup in Costing and purchasing menu account code as per your requirement.

expenseitem

3Asset Item

As discussed above , the following attributes need to be enabled for such an item.

  • Inventory item
  • Stock able
  • transact able
  • Costing flag
  • Inventory asset value

For entering on purchase orders
It should have purchased and purchasable flags enabled and you have to make sure you are assigning this item to the Purchasing org which you have defined at

Oracle Purchasing > Setup > Organizations >
Financial Options > ‘Supplier-Purchasing’ alternate region ‘Inventory Organization’ field.

The accounting can be best described for such kind of items is;

asset Item

Is there any effect on Step 5 in all three cases, that mean do matching have different accounting entry?

The answer is no; as per my understanding purpose of setting the PO to a 2way, 3 way or 4 way match is to ensure that the corresponding hold is generated on the invoice.

The holds are basically designed for control purposes, they do not have any accounting effects.

Additional Reading

Posted in Oracle Payable | Email This Post Email This Post | Print This Post Print This Post

2 Responses
  1. Milind Deodhar Says:

    Dear Sanjit,

    Good these entries flow will help to beginner. But always in my case I have excellent accounting knowledge but at the time of interview Oracle accounting entries explaintion get trouble for me.
    Thks for entries to start fresh studies bcoz I’m not in touch with Apps.

    Thks

  2. Bill Lam Says:

    I think there maybe some big mistakes about the inventory assets item. If the inventory_item_flag is Y and COSTING FLAG enabled for inventory assets item, how could u make step 4 to debit the Asset clearing a/c happen when doing the receiving transaction for po

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.