on 07-16-2010 5:55 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use Inventory Audit Repot .Inventory Audit Report shows Opening & Closing Balances of Item
Regards
Jambulingam.P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
97 | |
8 | |
8 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.