Friday, July 30, 2010

Cost of Goods Sold Account

What is Cost of Good Account:

The Cost of Goods Sold Account is used to determine the profit realized from selling a product. For each item in an inventory organization Oracle Applications has the ability to record the type and amount of costs to maintain the item. To view the associated cost for an item use the Item Costs Details form.
- Generate Cost of Goods Sold Account
- OM: Generate Cost of Goods Sold Account Both processes are used to derive account for cost of good sold (COGS). The workflow process will kick in when an item is shipped or returned.
- Generate Cost of Goods Sold Account the old process of 10.7 Oracle Shipping owns this process,
- OM: Generate Cost of Goods Sold Account is new and default process for 11i, Order Management owns this process.

• Inventory COGS Account Generator
– Item Type = INVFLXWF
– Display Name = ‘Inventory Cost of Goods Sold Account’
– Run by the concurrent program ‘Create Intercompany AP Invoices’, short name INCIAP

• OM COGS Account Generator
– Item Type = OECOGS
– Display Name = ‘OM : Generate Cost of Goods Sold Account’
– Run by the concurrent program ‘Interface Trip Stop’, short name WSHINTERFACE

Seeded Account Generators:

11i10 provides the ability to register custom processes for the following account generators:


  • OM: Generate Cost of Goods Sold Account (OECOGS) – generates the cost of goods sold
    account when invoices imported into AR.
  • PO Account Generator (POWFPOAG) – used by Purchasing to derive the charge, budget,variance, and accrual accounting distributions for each PO line – MUST be customized ifusing Oracle Projects.
  • PO Requisition Account Generator (POWFRQAG) – used by Purchasing to derive thecharge, budget, variance, and accrual accounting distributions for each requisition line –MUST be customized if using Oracle Projects.
  • Inventory Cost of Goods Sold Account (INVFLXWF) – called while processingIntercompany Transactions.
  • Generate Cost of Goods Sold Account (SHPFLXWF) – Pre-11i Cost of Goods Sold AccountGenerator – see Metalink note 260697.1
  • AR: Substitute Balancing Segment (ARSBALSG) – updates the balancing segment duringvarious accounting activities against transactions and receipts.
  • PSB Account Generator for OLD Integration (PSBLDMAG) – Public Sector Budgeting –
    used to derive accounts for positions with POETA charging instructions that are then
    used to import salary distribution information from LD.
  • ITR Account Generator (ITRWKFAG) – Account Generator for self-service ITR. This
    workflow will build creation and receiving accounts for ITR service lines.
  • IAC account Generator (IGIIACWF) – used in Public Sector Assets.
  • MHCA Account Generator (IGIAMAWF) – used in Public Sector Assets.
  • IGC Charge Account Generator (IGCACGNC) – Public Sector Contracts, this workflow is
    used to generate charge account for contract commitment.
  • IGC Budget Account Generator (IGCACGNB) – Public Sector Contracts, this workflow is
    used to generate charge account for contract commitment.
  • Project Budget Account Generation (PABDACWF) – used by Projects to generate
    accounting combinations for all budget items in an integrated project budget.
  • FA Account Generator (FAFLEXWF) – used by Assets to generate the accountingcombinations for each asset transaction.
  • Project Supplier Invoice Account Generation (PAAPINVW) – used by Payables to derivethe invoice distribution accounting combination if the distribution is Project related –MUST be customized.
  • Project Web Employees Account Generator (PAAPWEBX)– used by iExpenses to deriveaccounting combinations for expense report lines that reference a project – MUST becustomized.