How to do Physical Inventory Journal on LS Retail (Store)

lee_d_clar

Hi,

Our store had recently made an physical count (every end of the quarter).

I want to ask how am I going to do on store the Inventory Reconciliation? Is it on Head Office database (HO) or on the Store Back-office (BO) database? Haven't done this before....

Can you provide me the steps on how am I going to reconcile the inventory on hand on both HO and BO database.

Thanks,

MS Dynamics NAV 5.0 & LS Retail NAV

rajatkalia

Dear,

Store Inventory has to be reconciled in Store DB only. The entries posted in Store DB will come to HO DB through ICT (provided ICT setup has been done in Store DB on the Distribution Location card). On the other hand, if you do Inventory adjustment in HO DB directly for Store location then there will be a mismatch between the Inventory in HO DB and Store DB.

In order to reconcile the inventory, worksheets can be created in Inventory Mask Setup in InStore Management module. These worksheeets can be used to calculate the inventory and physical inventory can be specified. the worksheet is then accepted and posted.

The following things should be kept in mind:
1. ICT setup has been done in Store DB on the Distribution Location card
2. Item Journal Dest. Unit cost should be ticked in HO DB in HO DL card. this will ensure that cost is taken from HO DB as HO has teh correct cost.
3. In case positive adjustment is required for certain Items that do not have cost at all, then they should be posted seperately at Store by temporarily removing the tick from Item Journal Dest. Unit cost field in HO DB before posting and putting the tick again after the entries are processed at HO.

Hope this helps.


Regards,
Rajat.





Regards,
Rajat.