Inventory opening balance warehouse with advance warehouse

engsiong75

Hi

I have a problem that I need to solve. I am using Advance Warehouse management for the first time and I found that i cannot import the opening balance into the location with Advance Warehouse management. I cannot use Whse. Item Journal because it does not update the Item ledger.

I have 2 solutions but there are both a little tedious:
1) Create a zero value Purchase Order Debit inventory, credit the G/L Account for Inventory. Then create the warehouse receipt, post it and then import the warehouse put-away.
2) Create an item journal to a dummy location. Then transfer all the stocks from one location to the advance warehouse management location by a transfer order. Create all the Items in the dummy location to be transferred to the advance warehouse management. Post the shipment then create the warehouse receipt. Post the warehouse receipt and then import the warehouse put-away.

There has to be a better plan.

Thank you,

Tan Eng Siong

ErictP

Why can't you use the Whse. Item Journals?

After you posted the Whse. Item Journal Lines you go to the Item Journal and run the function "Calculate Whse. Adjustment".
Post the calculated lines and then Item Ledger Entries are created.

engsiong75

Thanks. It fixed the problem.