Allocating Sales, COGS and Inv. from a Central Warehouse to a Production Plant

Posted on: June 5, 2008 | By: SuperUser Account | QAD Distribution

While this is a Distribution blog, I encountered an interesting accounting sitiation this week. A client has 4 maquila sites in Mexico, all production plants, that ship their finished product to a warehouse in Texas. All sales orders are then shipped out of the warehouse.

The Operations VP’s want to get a sense for inventory turns at the plants, though. We need to trace the finished good inventory in the warehouse, in conjunction with the standard cost of shipped product (COGS), back to the originating plant.

By using the Network Code in the ptp_det record of the warehouse, we can find the plant that the part likely came from, as every part is built in one and only one plant. By finding the origination of the parts that were shipped and invoiced in a similar manner, we can deduce not only plant inventory turns, but begin to arrive at a plant Income Statement. Very powerful visibility for these Ops VP’s.



Is Your Accounting Software Hurting Your Business?
Is Your Accounting Software Hurting Your Business?

Free Download:

Is Your Accounting Software Hurting Your Business?

Download the guide ›

Top 10 Inventory & Operations Decisions Distributors Are Making Blind
Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Free Download:

Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Download the guide ›

2020 Nucleus Research Report on ERP Technology

Free Download:

2020 Nucleus Research Report on ERP Technology

Download the guide ›