Skip to Content
avatar image
Former Member

Inventory Opening and Closing Stock

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 16, 2010 at 05:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2010 at 05:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2010 at 01:03 PM

    Hi,

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

    Regards

    Jambulingam.P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2010 at 12:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded