The Open PO and Inventor Report is requested by Eric Lindstad. It lists the open PO and inventory from warehouse 044 and 055 with stock transaction type 17. Users can filter on Created Date, Lot Number, Batch Status, Product ID & Name, Warehouse, and Param ID.
The data is refreshed once daily at 10pm Central Time.
The report is connected to BPW_Datamarts and the labvantage database. The tables used from Labvantage include: s_batch and V_BI_SampleTestResult. The tables used from M3 include V_DimItem and StockTransactionDetailed. The following filters are applied to the data:
Warehouse = 044 or 055
Stock Transaction type = 17
Transaction date > 1/1/2021
Transaction qty >= 0