How to import opening balance

Madhavi_Pandey

Hi Experts,

What is the best way to import the opening balances for inventory with lot
Number and expiry date and how??

nilesh20

Hello,

You can use Item Journals for that.

Andwian

When you use a WHITE location:
1. Use the WHSE. Journal Line table
2. Enter the Item Tracking into the Whse. Tracking Line table

When using another location:
1. Use the Item Journal Line table
2. Enter the Item Tracking in Reservation Entry table

Do not know which field to filled up?
1. Create 2 or 3 lines in the Item Journal form manually
2. Open the respective table
3. Study the pattern
4. With that pattern, we could know which field to fill in the Excel Template
5. Create the Excel Template (use the Export to Excel function in Data Migration in NAV 5)
6. Import the Excel into NAV using Data Migration | Import from Excel.
7. Good luck!

crisnicolas

Andwian wrote:

When you use a WHITE location:

You mean when using a location thats uses Directed Put-away and Pick, right? Because a WHITE location doesn't mean anything to me...

Andwian

crisnicolas wrote:

Andwian wrote:

When you use a WHITE location:

You mean when using a location thats uses Directed Put-away and Pick, right? Because a WHITE location doesn't mean anything to me...

Yes, you are right!