Which action generates the COGS
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Which action generates the COGS
in Oracle OM / AR Which action generates the cost of goods sold account for transactions
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
Hi
When the Ship Confirm is complete for the Sales Order COGS Entry will get generated in Inventory Module
Dr COGS A/c (From the Item)
Cr Inventory A/c (From Sub inventory).
For the above entry to create there is No need the Invoice entry should have been generated in AR. There can be time gap between COGS Entry and Invoicing Entry. It depends on Customer requirement how they want the set up.
You can run the WF background Process after this and Autoinvoice process to create Invoicing entry
Dr Receivables A/c (Picked up as per Autoaccounting set up)
Cr Revenue A/c (From the Item)
Hope this helps
Regards
Sivakumar
When the Ship Confirm is complete for the Sales Order COGS Entry will get generated in Inventory Module
Dr COGS A/c (From the Item)
Cr Inventory A/c (From Sub inventory).
For the above entry to create there is No need the Invoice entry should have been generated in AR. There can be time gap between COGS Entry and Invoicing Entry. It depends on Customer requirement how they want the set up.
You can run the WF background Process after this and Autoinvoice process to create Invoicing entry
Dr Receivables A/c (Picked up as per Autoaccounting set up)
Cr Revenue A/c (From the Item)
Hope this helps
Regards
Sivakumar
-
- Posts: 35
- Joined: Wed Apr 04, 2007 4:15 am
- Location: Pakistan
Inventory Interface generates the cost of goods sold account for transactions when passing the transactions to Oracle Inventory. Receivables Interface generates a receivable account, a revenue account, a tax account, a freight account, and others, but not the cost of goods sold account. Ship confirm and pick release do not generate any accounts.
Hi Zeenat Khan,
Yes of course there are no Accounting entries in Order Management, but Siva has clearly specified that it is in Inventory Module and for receivables also, he has given the details that after running workflow background , invoice gets created and when auto invoice is run we get the accounting entries and transactions in AR.
Regards
Yes of course there are no Accounting entries in Order Management, but Siva has clearly specified that it is in Inventory Module and for receivables also, he has given the details that after running workflow background , invoice gets created and when auto invoice is run we get the accounting entries and transactions in AR.
Regards
-
- Posts: 35
- Joined: Wed Apr 04, 2007 4:15 am
- Location: Pakistan
Respected Anu_Uma
Those points are stated as in OSBORNE ORDER FULFILLMENT SAMPLE TEST and for reference I am pasting below some of action by default generated in OM
Action
Enter
Description
The customer order has been entered into Oracle Order Entry
Possible Results
Entered, Partial, Booked
Action
Demand Interface
Description
Creates a demand for the items in the customer order
Possible Results
Interfaced, Partial, Not Applicable
Action
Manufacturing Release
Description
Creates configuration in Oracle Bills of Materials and work order in Oracle Work in Process for ATO customer orders
Possible Results
Release, Configuration Created, Work Order Opened, Work Order Partially Completed, Work Order Completed, Not Applicable
Action
Purchase Release
Description
Creates purchase requisition lines in the Purchasing open interface for drop shipment customer orders
Possible Results
Interfaced, Partial, Confirmed, Not Applicable
Action
Pick Release
Description
Creates picking lines from customer orders for picking
Possible Results
Released, Partial, Not Applicable
Action
Backorder Release
Description
Creates picking lines from backordered customer orders
Possible Results
Released
Action
Ship Confirm
Description
Confirms shipments for customer orders
Possible Results
Confirmed, Partial, Backordered-Complete, Backordered-Partial, Not Applicable
Action
Inventory Interface
Description
Creates material transactions in Inventory open interface to update items? on-hand quantities and generate cost of hoods sold account
Possible Results
Interfaced, Partial, Interface Error, Not Applicable
Action
RMA Interface
Description
Creates material transactions in Inventory open interface to update items? on-hand quantities based on RMA orders
Possible Results
Interfaced, Partially Accepted, Completely Accepted, Not Applicable
Action
Receivables Interface
Description
Creates invoice lines in Receivables open interface to generate invoices for billing
Possible Results
Interfaced to Receivables, Partial, Not Applicable
Action
Complete Line
Description
Closes the customer order line, indicating process completion of the order line
Possible Results
Closed
Action
Complete Order
Description
Closes the customer order, indicating process completion of the order
Possible Results
Closed
Action
Cancel Line
Description
Cancels the customer order line
Possible Results
Cancelled, Partial
Action
Cancel Order
Description
Cancels the customer order
Possible Results
Cancelled
Those points are stated as in OSBORNE ORDER FULFILLMENT SAMPLE TEST and for reference I am pasting below some of action by default generated in OM
Action
Enter
Description
The customer order has been entered into Oracle Order Entry
Possible Results
Entered, Partial, Booked
Action
Demand Interface
Description
Creates a demand for the items in the customer order
Possible Results
Interfaced, Partial, Not Applicable
Action
Manufacturing Release
Description
Creates configuration in Oracle Bills of Materials and work order in Oracle Work in Process for ATO customer orders
Possible Results
Release, Configuration Created, Work Order Opened, Work Order Partially Completed, Work Order Completed, Not Applicable
Action
Purchase Release
Description
Creates purchase requisition lines in the Purchasing open interface for drop shipment customer orders
Possible Results
Interfaced, Partial, Confirmed, Not Applicable
Action
Pick Release
Description
Creates picking lines from customer orders for picking
Possible Results
Released, Partial, Not Applicable
Action
Backorder Release
Description
Creates picking lines from backordered customer orders
Possible Results
Released
Action
Ship Confirm
Description
Confirms shipments for customer orders
Possible Results
Confirmed, Partial, Backordered-Complete, Backordered-Partial, Not Applicable
Action
Inventory Interface
Description
Creates material transactions in Inventory open interface to update items? on-hand quantities and generate cost of hoods sold account
Possible Results
Interfaced, Partial, Interface Error, Not Applicable
Action
RMA Interface
Description
Creates material transactions in Inventory open interface to update items? on-hand quantities based on RMA orders
Possible Results
Interfaced, Partially Accepted, Completely Accepted, Not Applicable
Action
Receivables Interface
Description
Creates invoice lines in Receivables open interface to generate invoices for billing
Possible Results
Interfaced to Receivables, Partial, Not Applicable
Action
Complete Line
Description
Closes the customer order line, indicating process completion of the order line
Possible Results
Closed
Action
Complete Order
Description
Closes the customer order, indicating process completion of the order
Possible Results
Closed
Action
Cancel Line
Description
Cancels the customer order line
Possible Results
Cancelled, Partial
Action
Cancel Order
Description
Cancels the customer order
Possible Results
Cancelled
Who is online
Users browsing this forum: No registered users and 4 guests