Options

Transfer Opening Stock into Navision 4.0

upasanisandipupasanisandip Member Posts: 405
Hi all,

How to transfer Opening Stock from existing Legacy System along with Serial Number , Lot Number & value to Navision 4.0 .

Thanks,
Sandip.

Comments

  • Options
    ssinglassingla Member Posts: 2,973
    There are different ways to do so :

    option 1 : Specify inventory adjustement account (General Posting setup) same as inventory account (inventory setup)and after posting the item journal which is narrated below change inventory adjustment account to its original account. Upload the inventory balance at the time of uploading G/L balances in inventory accounts as per the opening stock statement.

    Option 2 : Open a new G/L account "Opening Bal Adj.". Specify this account as inventory adjustment account for all combinations in the general posting setup and after posting the item journal which is narrated below change inventory adjustment account to its original account. At the time of uploading the G/L Balances upload the total inventory balance in "Opening Bal Adj" account. This account will become zero after the complete opening for G/L and inventory is uploaded.

    Option 2 is better as this ensure that the balance in the inventory account matches with the "Inventory account" defined in the inventory posting setup.

    Upload of inventory: Upload the opening balance item wise in the item journal line either thru manual punching or import thru excel converted csv files. Attach the lot/serial number manually in the item journal line.

    I have never used csv files to update values in the temp table (item tracking lines) and always do it manually. May be somebody in the forum can suggest something on that. Otherwise you have to assign lot/serial number manually.
    CA Sandeep Singla
    http://ssdynamics.co.in
Sign In or Register to comment.