COGS Account Generator Workflow Customization

50 %
50 %
Information about COGS Account Generator Workflow Customization
Technology

Published on February 14, 2009

Author: ediyanto83

Source: slideshare.net

COGS Account Generator Workflow Customization Edi Yanto [email_address] Oracle Applications Technical Consultant

Overview (1) The COGS Account Generator is a Workflow Process that derives the Cost of Goods Sold account for a transaction interfaced to Inventory from Order Management/Shipping Workflow item type ‘OM: Generate Cost of Goods Sold Account’. The ‘Generate Default Account’ is a seeded process which builds the COGS Account This function will return the CCID assigned to an item as it exists in the shipping warehouse. The intent of this function is to retrieve the CCID from the Cost of Goods Sold assigned to the item on the sales order line within the shipping inventory organization

The COGS Account Generator is a Workflow Process that derives the Cost of Goods Sold account for a transaction interfaced to Inventory from Order Management/Shipping

Workflow item type ‘OM: Generate Cost of Goods Sold Account’.

The ‘Generate Default Account’ is a seeded process which builds the COGS Account

This function will return the CCID assigned to an item as it exists in the shipping warehouse. The intent of this function is to retrieve the CCID from the Cost of Goods Sold assigned to the item on the sales order line within the shipping inventory organization

Overview (2) In order to generate the COGS account from the Cost of Sales account assigned to the item type of the item and Cost of Goods Sold account assigned to the order type/OM Transaction Type of the order, the seeded COGS workflow needs to be modified to change the default node from Get CCID for a line function to the new function that modified from Get CCID from the item and selling operating unit function.

In order to generate the COGS account from the Cost of Sales account assigned to the item type of the item and Cost of Goods Sold account assigned to the order type/OM Transaction Type of the order, the seeded COGS workflow needs to be modified to change the default node from Get CCID for a line function to the new function that modified from Get CCID from the item and selling operating unit function.

COGS Workflow Before Modification After Modification

Before Modification

After Modification

Point the Chart of Accounts to the New Process OM: Setup > Financials > Flexfields > Key > Accounts

OM: Setup > Financials > Flexfields > Key > Accounts

Ensure New Account Generator Points to the Correct Chart of Accounts (1) Inv: Setup > Organization > Organizations Get the value of the Set of Books for the inventory organization for which you wish to interface the transactions

Inv: Setup > Organization > Organizations

Get the value of the Set of Books for the inventory organization for which you wish to interface the transactions

Ensure New Account Generator Points to the Correct Chart of Accounts (2) Inv: Setup > Organization > Organizations Determine the Set of Books for the Order Management responsibility for which the order is assigned

Inv: Setup > Organization > Organizations

Determine the Set of Books for the Order Management responsibility for which the order is assigned

Ensure New Account Generator Points to the Correct Chart of Accounts (3) GL: Setup > Financials > Books

GL: Setup > Financials > Books

Ensure New Account Generator Points to the Correct Chart of Accounts (4) Find the workflow process this chart of accounts uses when building the COGS account from the Account Generator Processes form GL: Setup > Financials > Flexfields > Key > Accounts

Find the workflow process this chart of accounts uses when building the COGS account from the Account Generator Processes form

GL: Setup > Financials > Flexfields > Key > Accounts

Process Steps for COGS Account Generator A.1. Entry Transaksi [Non Konsinyasi] Navigasi : Order Management > Orders, Returns > Sales Orders or Quick Sales Orders After SO is Save than do Book Order

A.1. Entry Transaksi [Non Konsinyasi]

Navigasi : Order Management > Orders, Returns > Sales Orders or Quick Sales Orders

After SO is Save than do Book Order

Process Steps for COGS Account Generator A.2. Pick Release (1) Navigasi : Order Management > Shipping > Transactions

A.2. Pick Release (1)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator A.2. Pick Release (2) Navigasi : Order Management > Shipping > Transactions

A.2. Pick Release (2)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator A.2. Pick Release (3) Navigasi : Order Management > Shipping > Transactions

A.2. Pick Release (3)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator A.3. Transact Move Order Navigasi : Inventory > Move Order > Transact Move Orders

A.3. Transact Move Order

Navigasi : Inventory > Move Order > Transact Move Orders

Process Steps for COGS Account Generator A.4. Ship Confirm (1) Navigasi : Order Management > Shipping > Transactions

A.4. Ship Confirm (1)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator A.4. Ship Confirm (2) Navigasi : Order Management > Shipping > Transactions

A.4. Ship Confirm (2)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator A.5. Run Concurrent Program Workflow Background Process Navigasi : (M) View > Requests > Submit a New Request > Workflow Background Process

A.5. Run Concurrent Program Workflow Background Process

Navigasi : (M) View > Requests > Submit a New Request > Workflow Background Process

Process Steps for COGS Account Generator A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (1) Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (1)

Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

Process Steps for COGS Account Generator A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (2) Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (2)

Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

Process Steps for COGS Account Generator A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (3) Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (3)

Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

Process Steps for COGS Account Generator A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (4) Journal: HPP Penjualan Rutin 211.420001.101.000.211.00 25,276.00 - Persediaan Barang 211.110901.000.000.211.00 - 25,276.00 Get Account for HPP Penjualan Rutin 211 .420001 .101 .000 .211 .00 1 2 3 4 5 6 1, 3 – 6 from Organization Item Type 2 from Transaction Type OM

A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (4)

Journal:

HPP Penjualan Rutin 211.420001.101.000.211.00 25,276.00 -

Persediaan Barang 211.110901.000.000.211.00 - 25,276.00

Get Account for HPP Penjualan Rutin

211 .420001 .101 .000 .211 .00

1 2 3 4 5 6

1, 3 – 6 from Organization Item Type

2 from Transaction Type OM

Process Steps for COGS Account Generator A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (5) 1, 3 – 6 from Organization Item Type Navigasi : Inventory > Items > Organization Items ; Query Item 0B0020

A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (5)

1, 3 – 6 from Organization Item Type

Navigasi : Inventory > Items > Organization Items ; Query Item 0B0020

Process Steps for COGS Account Generator A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (6) 2 from Transaction Type OM Navigasi : Order Management > Setup > Transaction Type > Define Query Regular JKT1 tab Finance

A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (6)

2 from Transaction Type OM

Navigasi : Order Management > Setup > Transaction Type > Define

Query Regular JKT1 tab Finance

Process Steps for COGS Account Generator B.1. Entry Transaksi [Konsinyasi] Navigasi : Order Management > Orders, Returns > Sales Orders or Quick Sales Orders After SO is Save than do Book Order

B.1. Entry Transaksi [Konsinyasi]

Navigasi : Order Management > Orders, Returns > Sales Orders or Quick Sales Orders

After SO is Save than do Book Order

Process Steps for COGS Account Generator B.2. Pick Release (1) Navigasi : Order Management > Shipping > Transactions

B.2. Pick Release (1)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator B.2. Pick Release (2) Navigasi : Order Management > Shipping > Transactions

B.2. Pick Release (2)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator B.2. Pick Release (3) Navigasi : Order Management > Shipping > Transactions

B.2. Pick Release (3)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator B.3. Transact Move Order Navigasi : Inventory > Move Order > Transact Move Orders

B.3. Transact Move Order

Navigasi : Inventory > Move Order > Transact Move Orders

Process Steps for COGS Account Generator B.4. Ship Confirm (1) Navigasi : Order Management > Shipping > Transactions

B.4. Ship Confirm (1)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator B.4. Ship Confirm (2) Navigasi : Order Management > Shipping > Transactions

B.4. Ship Confirm (2)

Navigasi : Order Management > Shipping > Transactions

Process Steps for COGS Account Generator B.5. Run Concurrent Program Workflow Background Process Navigasi : (M) View > Requests > Submit a New Request > Workflow Background Process

B.5. Run Concurrent Program Workflow Background Process

Navigasi : (M) View > Requests > Submit a New Request > Workflow Background Process

Process Steps for COGS Account Generator B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (1) Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (1)

Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

Process Steps for COGS Account Generator B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (2) Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (2)

Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

Process Steps for COGS Account Generator B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (3) Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (3)

Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order

Process Steps for COGS Account Generator B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (4) Journal: Persediaan Konsinyasi 211.110904.000.000.211.00 126,380.00 - Persediaan Barang 211.110901.000.000.211.00 - 126,380.00 Get Account for Persediaan Konsinyasi 211 .110904 .000 .000 .211 .00 1 2 3 4 5 6 1, 4 - 6 from Organization Item Type 2 and 3 from Transaction Type OM

B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (4)

Journal:

Persediaan Konsinyasi 211.110904.000.000.211.00 126,380.00 -

Persediaan Barang 211.110901.000.000.211.00 - 126,380.00

Get Account for Persediaan Konsinyasi

211 .110904 .000 .000 .211 .00

1 2 3 4 5 6

1, 4 - 6 from Organization Item Type

2 and 3 from Transaction Type OM

Process Steps for COGS Account Generator B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (5) 1, 4 – 6 from Organization Item Type Navigasi : Inventory > Items > Organization Items ; Query Item 0B0020

B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (5)

1, 4 – 6 from Organization Item Type

Navigasi : Inventory > Items > Organization Items ; Query Item 0B0020

Process Steps for COGS Account Generator B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (6) 2 and 3 from Transaction Type OM Navigasi : Order Management > Setup > Transaction Type > Define Query Regular JKT1 tab Finance

B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (6)

2 and 3 from Transaction Type OM

Navigasi : Order Management > Setup > Transaction Type > Define

Query Regular JKT1 tab Finance

Add a comment

Related presentations

Related pages

COGS Account Generator Workflow Customization | Edi Yanto ...

You are commenting using your WordPress.com account. ( Log Out / Change ). You are commenting using your Twitter account. (
Read more

COGS Account Generator Workflow Customization - Technology

Inventory COGS Account Generator John Peters JRPJR, Inc. john.peters@jrpjr.com.
Read more

Using the Account Generator in Oracle Order Entry ...

Using the Account Generator in Oracle Order Entry ... Each Account Generator workflow is called an ... Customizing the Account Generator. Customization ...
Read more

Account Generator workflow 'OECOGS' customization does not ...

Account Generator workflow 'OECOGS' customization does not ... Hello Tech gurus, I have customized Account Generator workflow ... Deriving COGS Account ...
Read more

Apps - Oracle Account Generator Workflow Example

Oracle Account Generator Workflow Example ... I have a problem related to po requisition workflow customization. i am describing my requirement ...
Read more

Account Generator - Oracle E-Business Suite Flexfields Guide

Benefits of the Account Generator using Oracle Workflow. ... Account Generator process to create an account. ... require customization before they ...
Read more

Cogs Account Generator Workflow Customization ...

COGS Account Generator Workflow Customization Edi Yanto edi.y4nto@gmail.com Oracle ... Share Cogs Account Generator Workflow Customization ...
Read more

FA Account Generator Workflow Customization - Toolbox for ...

... , I need to do customization of FA Account Generator Workflow Customization ... In R12 Oracle is replacing the account generator workflow ...
Read more

Account generator for COGS | Oracle Community

Account generator for COGS. ... to be done is can the account generator be modified in such ... on workflow and not aware on Account Generator, ...
Read more