Inventory Opening and Closing Stock

[Former Member]

Hello Experts,

How can i get the inventory opening stock and inventory closing stock in SAP business One so as to reflect the same in the Profit and Loss Statement and Balance sheet..

Divya Chaudhary

[Former Member]

Hey

First create a P&L template

2)add child level as assign name "Opening Stock" LEVEL=4

2)add child level as assign name "Stock Detail" LEVEL=8

2)add child level as assign name "stock value" LEVEL=12

now double click on "stock value" and assign GL which u made in Chart of account as Assest e.g hardware,software

*note at level 12 only we can assign GL so it necessary to move hirearchy upto level=12

and then update yr template

Thanks

King Kevin

[Former Member]

Hi,

Use Inventory Audit Repot .Inventory Audit Report shows Opening & Closing Balances of Item

Regards

Jambulingam.P

[Former Member]

hi divya

first i just wanted to confirm whether u have entered the opening stock of items and gl if not the please do it though admin-system initialization-opening stock

otherwise if u done it and wana include it in trial balance then please check the option "opening balance for period" in trial balance window

Regards,

Manish

[former_member1269712]

Hi Divya,

You can see in Inventory Audit report Enter your date in selection parameter and tick on "Display OB for Items/Accounts with no Transactions" check box. System will show you op balances of your entered from date.

You can see only values in PL & BS.

Thanks

Sachin