Charge Account in Purchase Order

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
vangala.jpreddy
Posts: 21
Joined: Tue Oct 30, 2007 8:06 am
Location: India

Charge Account in Purchase Order

Post by vangala.jpreddy »

Dear Gurus,

Please clarify me to the below query.

In purchase order from where charge will be defaulted (Charge account will come from where).

Thanks in advance.

Jayaprakash.
arun1203
Posts: 79
Joined: Mon Jun 11, 2007 10:36 am
Location: Kuwait
Contact:

Post by arun1203 »

Hi Jayaprakash [:)],

The charge account is defaulted from the setups you make while defining your respective Inventory Organization ,Purchasing Options and Financial Options.

What ever the accounts you enter in the above mentioned setups gets defaulted in PO and INV accordingly.

<font color="red"><b>Best Regards,
Arun Reddy.
E-Mail:arunapps@gmail.com</b></font id="red">
vangala.jpreddy
Posts: 21
Joined: Tue Oct 30, 2007 8:06 am
Location: India

Post by vangala.jpreddy »

Thanks Mr.Arun for your quick reply.


Jayaprakash
ashishd
Posts: 7
Joined: Fri Apr 25, 2008 1:08 am
Location: India

Post by ashishd »

Hi Jayaprakash

Charge account defaulting rules depend on
a) Type of Item
b) Destination Type
c) Destination Sub-inventory.

There are 3 kinds of Items used in Purchasing.

Expense Items - Referred to as Item A
Inventory Expense Items - Referred to as Item B
Inventory Asset Items - Referred to Item C


1) Expense Items - Referred to as Item A.
These items normally have the following attributes...

INVENTORY_ASSET_FLAG = N
PURCHASING_ITEM_FLAG = Y
INVENTORY_ITEM_FLAG = N

2) Inventory Expense Items - Referred to as Item B
These items normally have the following attributes...

INVENTORY_ASSET_FLAG = N
PURCHASING_ITEM_FLAG = Y
INVENTORY_ITEM_FLAG = Y


c) Inventory Asset Items - Referred to Item C
These items have the following attributes...

INVENTORY_ASSET_FLAG = Y
PURCHASING_ITEM_FLAG = Y
INVENTORY_ITEM_FLAG = Y
COSTING_ENABLED_FLAG = Y


2. DESTINATION TYPE :
The Destination type determines the final destination of the
items.
This can be of two types
a) EXPENSE
b) INVENTORY -



3. DESTINATION Subinventory:
When an Item is being received into Inventory , a sub-inventory
needs to be specified. A subinventory can be
a) ASSET subinventory
b) EXPENSE sub-inventory


The sql below will help in identifying what type of a
subinventory , the item is being delivered INTO.


select
substr(EXPENSE_ACCOUNT,1,6) Exp_act ,
substr(ENCUMBRANCE_ACCOUNT,1,7) Enc_act ,
ASSET_INVENTORY,
substr(SECONDARY_INVENTORY_NAME,1,15) S_name,
substr(DESCRIPTION,1,15) descrip,
substr(SOURCE_ORGANIZATION_ID,1,8) s_o_id
from
MTL_SECONDARY_INVENTORIES
where
SECONDARY_INVENTORY_NAME = '&destination_subinventory';

pass the value of DESTINATION_SUBINVENTORY
from PO_DISTRIBUTIONS_ALL.DESTINATION_SUBINVENTORY

if the value of ASSET_INVENTORY = 1 then this is an ASSET subinventory.
if the value of ASSET_INVENTORY = 2 then this is NOT an ASSET subinventory.




3.Keeping in view of the types of Items and the destination mentioned above
These are the destination types that can be possible against each type of item

Item A can have ONLY one destination- EXPENSE

Item B can have the destination of
a) EXPENSE
b) INVENTORY -- ASSET subinventory
c) INVENTORY -- EXPENSE subinventory

Item C can have the destination of
a) EXPENSE
b) INVENTORY -- ASSET subinventory
c) INVENTORY -- EXPENSE subinventory



Defaulting Rules for
1) Item A --- Defaults from the Expense a/c defined against the ITEM in the Receiving Organization.( Organization Items)

=======================================================================================
2) Item B--- EXPENSE -Defaults from the Expense a/c defined against the ITEM in the
in the Receiving Organization.( Organization Items)

2) Item B ---INVENTORY--- ASSET Subinventory .... charge account comes from
a) EXPENSE a/c of the ASSET SUBINVENTORY in the RECEIVING Organization.
(This is ONLY if the PO Distribution , contains the Subinventory Information)

b) If the PO distribution DOES NOT have a SUBINVENTORY information
Expense a/c defined in the Organizational Parameters of the Receiving Organization.

3) Item B ---INVENTORY--- EXPENSE subinventory -- comes from
a) EXPENSE a/c of the EXPENSE SUBINVENTORY in the RECEIVING Organization.
(This is ONLY if the PO Distribution , contains the Subinventory Information)

b) If the PO distribution DOES NOT have a SUBINVENTORY information
Expense a/c defined in the Organizational Parameters of the Receiving Organization.

=========================================================================================
4) Item C --- EXPENSE -Defaults from the Expense a/c defined against the ITEM in the
in the Receiving Organization.( Organization Items)

5) Item C ---INVENTORY---ASSEST Subinventory .... charge account comes from

a) Material a/c defined against the ASSET SUBINVENTORY /of the RECEIVING Organization.
(This is ONLY if the PO Distribution , contains the Subinventory Information)

b) Material a/c defined in the Organizational Parameters of the Receiving Organization.

6) Item C ---INVENTORY --EXPENSE Subinventory -- comes from
a) Expense a/c defined against the EXPENSE Subinventory in Receiving Organization.
(This is ONLY if the PO Distribution , contains the Subinventory Information)

b) If the PO distirbution DOES NOT have a SUBINVENTORY information
Material a/c defined in the Organizational Parameters of the Receiving Organization.

ThanksAnd Regards
AshishD
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

From Inventory organization to Item and then from item to PO. thanks
vangala.jpreddy
Posts: 21
Joined: Tue Oct 30, 2007 8:06 am
Location: India

Post by vangala.jpreddy »

Thanks ashishd and admin.

Jayaprakash.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest