We setup one warehouse and bin to handle all our inventory, we’ll call it Warehouse A. We set GL control codes for the Part Class and Product Groups to control costs and sales. We also did the GL Controal setup in Company Config… We’ve now added a second warehouse that has two bins, we’ll call it Warehouse B. Many of our parts are in both warehouses. We have an inventory GL account 1410 for the cost of inventory in Warehouse A. With the addition of Warehouse B, our accounting department want to add GL account 1420.
Since the hierarchy starts with the Part, Part Class, Product Group, Warehouse and Company, what is now the best way to get the inventory transactions in Warehouse B to pull from GL Account 1420?
I tried removing the part class GL Control from the part and adding a GL Control to Warehouse B, but it’s still pulling from GL Account 1410. I’m not sure what I’m doing wrong…
The material had a class assigned which had a GL Control. I removed the class from the part and added a control on Warehouse B. The control type is Division. I created a control code and assigned 1420 as the account. When I ship items using Warehouse B and run the WIP report, it still shows 1410 as the account. Is there a setup step I’m missing?
I’d say to not waste your time. What I outlined would change the account for part, regardless of the warehouse.
I experimented (in E10) to see if a Division type GLC assigned to the warehouse would work, but no luck.
It is going to have to be a GLC type that has the “Inventory” context, (like the “Inventory COS and WIP” GLC type).
Then find a business object (sure I’m using that term wrong), that can have an “Inventory COS and WIP” type setup for it.
We have the multi-site module, so we could make a GLC to set the GL Acct for Inventory, different for each site. But we’d still be stuck using the same GL Acct for every warehouse in that site.
