Skip to Content
author's profile photo Former Member
Former Member

Stock Statement

Hi all,

I'm facing a problem in generating a report called as stock statement, the details of the problem and report are as stated below.

This report is called as "Stock Statement", the aim of the report being one should be able to understand clearly that for a item what is the opening balance, its receipts, its issues, its closing balance and the value of the closing balance. Now this can be achieved as follows.

For Receipts the transaction involved are:

1. Goods Receipts PO.

2. Goods Receipts.

3. Receipt from Production.

4. Inventory transfer.

For Issues the transaction involved are:

1.Goods Issue.

2.Issue to Production.

3.Goods Return.

4.Inventory transfer.

For Closing Balance the transaction involved are:

Closing Balance = Opening Balance + Receipts - Issues

For Opening Balance the transaction involved are:

It is the closing balance of the previous consecutive date.

However we have to trap the stock increase and decrease carried out by the Opening balance and stock posting transaction found under inventory > inventory transaction > Initial quantities, inventory tracking and stock posting.

Since above transaction doesnu2019t have any history other than Journal entry, we needed a way wherein we could trap the quantities from this transaction.

Thus your help in finding out the link between the journal entry and the stock posting transaction.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on May 30, 2008 at 09:44 AM

    Hi Aditya,

    First you can check if Reports-> stock management-> stock audit report can meet your requirement. The report contains the details of all the inventory transactions.

    If you want to generate a report via SQL. You can base it on OINM table which keep records of all the inventory transactions.

    You can track the transactions you want by transtype field.

    transtype = '20' - 'Good Receipts PO'

    transtype = '59' 'Good Receipts'

    transtype = '21' 'Good returns'

    transtype = '60' 'Good issue'

    transtype = '162' 'Inventory valuations'

    transtype = '67' 'Inventory Transfer'

    transtype = '60' Issue for Production

    transtype = '59' Receipt for Production

    transtype = '-2' Initial Quantity

    transtype = '58' stock posting

    Hope it is helpful!

    Regards,

    Ivy Zhang

    SAP Business One Forums Team

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.