cogs account generator workflow customization 1234621403189560 2
TRANSCRIPT
![Page 1: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/1.jpg)
COGS Account Generator Workflow Customization
Oracle Applications Technical Consultant
![Page 2: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/2.jpg)
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
![Page 3: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/3.jpg)
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.
![Page 4: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/4.jpg)
COGS Workflow
• Before Modification
• After Modification
![Page 5: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/5.jpg)
Point the Chart of Accounts to the New Process
• OM: Setup > Financials > Flexfields > Key > Accounts
![Page 6: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/6.jpg)
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
![Page 7: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/7.jpg)
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
![Page 8: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/8.jpg)
Ensure New Account Generator Points to the Correct Chart of Accounts (3)
• GL: Setup > Financials > Books
![Page 9: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/9.jpg)
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
![Page 10: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/10.jpg)
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
![Page 11: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/11.jpg)
Process Steps for COGS Account Generator
A.2. Pick Release (1)
• Navigasi : Order Management > Shipping > Transactions
![Page 12: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/12.jpg)
Process Steps for COGS Account Generator
A.2. Pick Release (2)
• Navigasi : Order Management > Shipping > Transactions
![Page 13: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/13.jpg)
Process Steps for COGS Account Generator
A.2. Pick Release (3)
• Navigasi : Order Management > Shipping > Transactions
![Page 14: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/14.jpg)
Process Steps for COGS Account Generator
A.3. Transact Move Order
• Navigasi : Inventory > Move Order > Transact Move Orders
![Page 15: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/15.jpg)
Process Steps for COGS Account Generator
A.4. Ship Confirm (1)
• Navigasi : Order Management > Shipping > Transactions
![Page 16: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/16.jpg)
Process Steps for COGS Account Generator
A.4. Ship Confirm (2)
• Navigasi : Order Management > Shipping > Transactions
![Page 17: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/17.jpg)
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
![Page 18: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/18.jpg)
Process Steps for COGS Account Generator
A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (1)
• Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order
![Page 19: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/19.jpg)
Process Steps for COGS Account Generator
A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (2)
• Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order
![Page 20: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/20.jpg)
Process Steps for COGS Account Generator
A.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (3)
• Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order
![Page 21: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/21.jpg)
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
![Page 22: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/22.jpg)
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
![Page 23: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/23.jpg)
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
![Page 24: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/24.jpg)
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
![Page 25: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/25.jpg)
Process Steps for COGS Account Generator
B.2. Pick Release (1)
• Navigasi : Order Management > Shipping > Transactions
![Page 26: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/26.jpg)
Process Steps for COGS Account Generator
B.2. Pick Release (2)
• Navigasi : Order Management > Shipping > Transactions
![Page 27: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/27.jpg)
Process Steps for COGS Account Generator
B.2. Pick Release (3)
• Navigasi : Order Management > Shipping > Transactions
![Page 28: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/28.jpg)
Process Steps for COGS Account Generator
B.3. Transact Move Order
• Navigasi : Inventory > Move Order > Transact Move Orders
![Page 29: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/29.jpg)
Process Steps for COGS Account Generator
B.4. Ship Confirm (1)
• Navigasi : Order Management > Shipping > Transactions
![Page 30: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/30.jpg)
Process Steps for COGS Account Generator
B.4. Ship Confirm (2)
• Navigasi : Order Management > Shipping > Transactions
![Page 31: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/31.jpg)
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
![Page 32: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/32.jpg)
Process Steps for COGS Account Generator
B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (1)
• Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order
![Page 33: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/33.jpg)
Process Steps for COGS Account Generator
B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (2)
• Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order
![Page 34: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/34.jpg)
Process Steps for COGS Account Generator
B.6. Cek Jurnal yang terbentuk untuk Transaksi tersebut (3)
• Navigasi : Inventory > Transactions > Material Transactions ; Query Sales Order
![Page 35: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/35.jpg)
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
![Page 36: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/36.jpg)
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
![Page 37: Cogs Account Generator Workflow Customization 1234621403189560 2](https://reader033.vdocuments.us/reader033/viewer/2022061203/547e475ab4af9f74108b45f8/html5/thumbnails/37.jpg)
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