cancel
Showing results for 
Search instead for 
Did you mean: 

Is the FIFO value stored in the database? Where?

Former Member
0 Kudos

Hi,

We are working on an implementation project of B1 with an integration to SAP ERP. We need to find the stock value somewhere in the database. Does this exist if you are running FIFO? Is running a stock report the only way to find the stock value when running FIFO, nothing is stored in the DB?

Your help is much appreciated.

Br

Anders Petersson

Accepted Solutions (0)

Answers (2)

Answers (2)

jbrotto
Active Contributor
0 Kudos

A more challenging way but works basically all the back to 2004 versio is using the journal entry table OJNL or OJRL(can't remeber the name right now) with the respective sub tables and selct only the inventory needed to do your FIFO calculations. Messy but garenteed to stay the same the structure

former_member206488
Active Contributor
0 Kudos

Hi,

Which version of busines one you are using?

Thanks,

Neetu

Former Member
0 Kudos

We are running 8.81 PL08

former_member206488
Active Contributor
0 Kudos

Hi,

Check OIVQ and OIVE tables

OIVQ: Open entry FIFO layer.

OIVE: Open exit FIFO Layer

Thanks,

Neetu