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

value of fifo-batch

Hi all,

Can anyone tell me exactly where the value of a fifo-element is stored?

Or alternatively how I can re-value fifo-inventory (on an item basis not overall financial value)?

That's sbo 6.5!

Thanks for your time,


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 27, 2005 at 12:07 AM

    Hi Jacques,

    As I understand you are looking for the current open quantity for particular FIFO batch.

    The open, so the quantity which remains on the stock, for each lot is stored in OINM table, filed OpenQty. Please consider that this filed, for each particular batch, is always updated after goods issue.

    I hope that it helped,


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi All,

      Just some hint, if you are not aware of already:

      For MSSQL you can use SQL Server Profiler to trace the statements that occur in a particular transaction in SAP Business One (it may be a large number 😉).

      Thus you could identify all tables touched...



      PS: In addition, documentation developers are working on an improved DB documentation. Unfortunately, it is not yet clear, when it will be available...

      Nevertheless Profiler will always remain useful to give you some more insight into internal processes.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2005 at 02:30 PM

    Hello Jacques,

    Do you mean which property sets this value?

    If this is the case, then check object ItemGroups and then the InventorySystem property. There you will find the enumeration BoInventorySystem.

    If you are asking for the Database table, check table OITM field OnHand (Actual Quantity in Stock)

    I hope this helps,


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Felipe,

      I'm not looking for the quantity of a batch but for its itemvalue. In a fifo value system, each batch gets its very own value assigned. I would like to know how to retrieve that (so I'm looking for a sub-devision of the onHand value).

      Thank you for your time,


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.