STOCK OPENING BALANCE

[Former Member]

Hi everybody ,

I have to enter the Stock opening balance , here i have managed the item by its item group .

and also created the gl account for each group which i have mapped with the respective item gr. acct.

Now i have to enter the stock ,please anyone suggest me how to enter the individual item opening stock.

thanx

Ashish

[Former Member · Accepted solution]

Hi Ashish,

You first need to create one Initial Upload account for the purpose of balance uploading only in euity or expense drawer.

Now go to Initial Stock upload window --

To use this function, from the SAP Business One Main Menu choose Inventory --> Inventory Transactions --> Initial Quantities.

After opening the window, give the item code range for upload -

---

after this give the Initial Upload account in Open Inventory Account cell and the quantity and rate for the items.

Hope this will help you.

Regards,

Abhishek

[Former Member]

Hi Ashish,

you can also use DTW for the same. You can use the "Oinventorygenentry" template for the purpose. Make sure the the lines document is filled correctly with the unit price and the quantity along the account code. All the best. Hope this information is useful for you.

Regards,

Joseph Antony

[Former Member]

Joseph,

Can you explain it bit further?

Entering Line document doe not contain any column for account info

When I query database; to see an entry for which I created a manual enttry,

I see some system generated code in CardCode field and -2 in transaction type column in OINM table for the opening balance I created manually