How Does The Account Generator Default The Accounts In Oracle Purchasing? (Doc ID 1067139.1)

21 篇文章 0 订阅
13 篇文章 0 订阅

摘自:Document 1067139.1 (oracle.com)

In this Document

Goal
Solution
Account Build Timing and Logistics
References

APPLIES TO:

Oracle Purchasing - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.

GOAL

How does the Account Generator default the accounts in the Purchase Order Distribution?

SOLUTION

The default Account Generator processes in Oracle Purchasing build a charge, budget, accrual, and variance account for each purchase order, release, and requisition distribution based on the distribution's Expense, Inventory, or Shop Floor destination type. Oracle Purchasing always builds these accounts using the Account Generator; you cannot disable this feature.

If you utilize the centralized procurement functionality, the Account Generator will also create two new accounts to record accounting transactions between the procuring organization and the destination organization: the destination charge account and the destination variance account. These accounts will be created and used only when the destination organization is in a different operating unit than the Procuring organization, and there is a transaction flow defined between the two organizations. (Note that if the two operating units are in different sets of books, there must be a transaction flow defined.) For example: In the centralized procurement scenario a user may create a purchase order in one operating unit, but require shipment to a different operating unit. In this case, there will be an accounting transaction (created at the time of receipt of goods) to record the transfer of ownership between the two organizations (operating units). If these accounts are not required they will be not be built.

For Inventory charge account construction, the Account Generator further distinguishes between asset and expense purchases based on the item and subinventory that you provide for the distribution. If you select an expense item, the Account Generator disregards the subinventory and builds an expense charge account. If you select an asset item, the Account Generator evaluates the subinventory to decide whether to build an expense or asset charge account.

Additional Information: You classify a subinventory as expense or asset by selecting the Asset Subinventory check box in the Oracle Inventory Subinventories window. You classify an item as expense or asset by selecting the Inventory Asset Value check box in the Costing section of the Master Item window. (This window is accessible through Inventory or Purchasing.)

When the Account Generator locates a source account based on the distribution destination type, it copies complete code combinations (full Accounting Flexfields) from designated fields to destination Accounting Flexfields. The default Oracle Purchasing processes do not build individual flexfield segments.

For example, to populate the Accrual account for distributions with an Expense destination type, the Account Generator locates the Expense AP Accrual Account that you specify in the Purchasing Options window as part of your application setup, and copies it into the Accrual Account Flexfield in your document.

An exception is when the account generator is unable to derive a charge account in the first two steps. Then an account is retrieved from the HR employee record and individual segments are replaced based on the item category. This is a typical scenario when using one-time items in Oracle Purchasing.

The following matrix describes the source fields that the Account Generator references to build the charge, budget, accrual, and variance account based on the distribution destination type.

The horizontal axis lists the windows you use to specify the source accounts that the Account Generator references in Oracle Purchasing. The vertical axis lists the possible destination types for each account type the Account Generator constructs. In addition, the Additional Conditions are applied as part of the vertical access. The body of the matrix lists the fields you use to enter the reference accounts.

When more than one option is indicated for a particular account/destination type combination, the Account Generator attempts to locate the primary source account identified in the matrix (Seq) with a as long as any Additional Conditions listed are met. This means that there may be several source accounts with a 1, since there may be multiple Additional Conditions. The first additional condition met will be the source attempted. If this reference account is unavailable or not appropriate for the distribution information you provide, the Account Generator tries the source indicated as 2 and so on until it either successfully locates a reference account, or fails. When an account has been located, or the Account Generator has failed to find an account, the matrix may indicate that an Override condition may apply. These entries are indicated by an O instead of a numeric value. In the case of an Override, a built account may be superceeded.

Default Charge Account Sources

Destination TypesAdditional Consider- ationsSeqWIP Accounting ClassesSub- inventoriesOrganizat- ion ParametersItems (INV or PO)Purchasing OptionsOther
All Destination TypesCross OU case and One-Time Item or a Shop Floor enabled Item1Cost of Sales Account for Transaction Flow default org
All Destination TypesCross OU case and Expense item1Expense
All Destination TypesCross OU case and Expense item2Expense
All Destination TypesCross OU case and Asset item1Material
All Destination TypesPO auto-created from requisition1Copied from requisition
ExpenseNot a PO autocreated from req and not prevented by PA override profile1Preferences
ExpenseProject related2Customized Project rules
ExpenseProject Related and not prevented by PA override profileOUser entered
ExpenseNot a PO autocreated from a req. Not Project.1Preferences
ExpenseNon-Project2Expense
ExpenseNon-Project3Employee Profile for Assignment in Purchasing OU's SOB
ExpenseNon-Project Account not built before HR Employee Profile step3OItem Category Segment substitutions
ExpenseNon-ProjectOUser entered
InventoryExpense item1Expense
InventoryExpense item2Expense
InventoryExpense item3Expense
InventoryAsset item1Material
InventoryAsset item2Material
Shop Floor1Enterprise Asset Mgmt (EAM) rules
Shop Floor2aMaterial
Shop Floor2bMat. Overhead
Shop Floor2cResource
Shop Floor2dOutside Processing
Shop Floor2eOverhead

Default Accrual Account Sources

Destination TypesAdditional Consider- ationsSeqWIP Accounting ClassesSub- inventoriesOrganiz- ation ParametersItems (INV or PO)Purchasing OptionsOther
All Destination TypesCross OU case (No additional sources are used)1Expense AP Accrual Account for PO OU
All Destination TypesOPM is installed. Not Project related.1OPM API
ExpenseProject related1Customized Project rules
ExpenseOPM is not installed. Not Project related.1Expense AP Accrual Account
Inventory, Shop FloorOPM is not installed. One-time item.1Expense AP Accrual Account for PO OU
Inventory, Shop FloorOPM is not installed. Not one-time item.1Inventory AP Accrual for Ship-to org

Default Budget Account Sources

Destination TypesAdditional Consider- ationsSeqWIP Accounting ClassesSub- inventoriesOrganiz- ation ParametersItems (INV or PO)Purchasing OptionsOther
Expense or InventoryPO auto-created from requisition1Copied from requisition
Expense1Charge Account
ExpenseOUser entered
Inventory1Encumbrance
Inventory2Encumbrance
Inventory3Encumbrance for ship-to org
Shop FloorNo encumbrance is done for Shop Floor1n/an/an/an/an/an/a

Default Variance Account Sources

Destination TypesAdditional Consider- ationsSeqWIP Accounting ClassesSub- inventoriesOrganization ParametersItems (INV or PO)Purchasing OptionsOther
All Destination TypesCross OU case (No additional sources are used)1Charge Account
All Destination TypesPO auto-created from requisition1Copied from requisition
ExpenseProject-related1Customized Project rules
ExpenseProject-related2Customized Project rules
ExpenseNon-Project1Charge Account
Inventory1Invoice Price Variance for Ship-to org(org parameters)
Shop FloorOne-time Item1Charge Account
Shop Floor1Invoice Price Variance for Ship-to org (org  parameters)

Default Destination Charge Account Sources

Destination TypesAdditional Consider- ationsSeqWIP Accounting ClassesSub- inventoriesOrganizat- ion ParametersItems (INV or PO)Purchasing OptionsOther
All Destination TypesPO auto-created from requisition1Copied from requisition charge account
ExpenseProject related2Customized Project rules
ExpenseProject Related and not prevented by PA override profileOUser entered
ExpenseNot a PO autocreated from a req. Not Project.1Preferences
ExpenseNon-Project2Expense
ExpenseNon-Project3Employee profile for deliver-to-person's HR assignment in destination OU SOB
ExpenseNon-Project Account not built before HR Employee Profile step3OItem Category Segment substitutions
ExpenseNon-ProjectOUser entered
InventoryExpense item2Expense
InventoryExpense item3Expense
InventoryExpense item4Expense
InventoryAsset item2Material
InventoryAsset item3Material
Shop Floor2Enterprise Asset Mgmt (EAM) rules
Shop Floor3aMaterial
Shop Floor3bMat. Overhead
Shop Floor3cResource
Shop Floor3dOutside Processing
Shop Floor3eOverhead

Default Destination Variance Account Sources

Destination TypesAdditional Consider- ationsSeqWIP Accounting ClassesSub- inventoriesOrganization ParametersItems (INV or PO)Purchasing OptionsOther
ExpensePO auto-created from requisition1Copied from requisition Variance Account
ExpenseProject related1Customized Project rules
ExpenseProject related2Destination Charge Account
ExpenseNon-Project1Destination Charge Account
Inventory1Inventory Price Variance for Ship-to org
Shop FloorOne-time Item1Destination Charge Account
Shop Floor1Inventory Price Variance for Ship-to org

Suggestion: Minimize your setup by specifying source accounts at the appropriate level of detail for your business. For example, you can specify the charge account source for Inventory (expense) destination types at the subinventory, item, or organization level. If an organization level account is sufficient for your business needs, it is not necessary to specify item or subinventory accounts.

For Shop Floor destination types, the Account Generator first applies the Oracle Enterprise Asset Management (EAM) rules. If no account is found, it then constructs the charge account based on the resource cost element associated with the Outside Processing job or schedule. In this case, the Account Generator selects one of the five possible source accounts; it does not step through a hierarchy of choices as it does for other destination types. Finally, the Account Generator does not construct a budget account for Shop Floor distributions, even if you are using encumbrance. Oracle Purchasing never encumbers outside processing purchases.

Attention: If the Account Generator is unable to build a charge account you can either manually specify a charge account in your document or you can design a custom Account Generator function to build Expense destination charge accounts based on your own business rules.

While you cannot edit the accrual, budget, or variance accounts that the Account Generator constructs, you can override or specify the charge account for uncommitted Expense distributions. In this case, you can either edit the charge account that the Account Generator constructs for you, or you can specify a default charge account in the Defaults region of your document. When you specify a default charge account, it always overrides any expense charge account that the Account Generator tries to provide.

Account Build Timing and Logistics

For Expense and Inventory destinations in the Requisitions, Purchase Orders, and Releases windows, the Account Generator constructs the account when you navigate into the distribution Charge Account field, or when an explicit or implicit commit anywhere in the window provides enough information for Oracle Purchasing to create a distribution. For Shop Floor destinations, the code is constructed when you enter all required data in the Outside Processing region and either return to the document distributions region or commit.


Question: What are the standard features that cannot be used in encumbered environment?

PR/PO created with shop floor destination cannot be reserved.
Note: From R12.1.3 onwards, this feature is available for PR/PO created with shop floor destination with EAM enabled ship to organization can be reserved

Additional Resources:
Note 2319562.1 - How Are the Purchasing Accounts Derived on the Requisitions and Purchase Orders?

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值