Hi guys i built a query to mimic the fifo report in SAP b1, but i have wrong results for some items, can someone say what is wrong with the query below:
select distinct
t0."ItemCode"
,t0."itemName"
,t0."InDate" as "Admission Date"
,t0."MnfDate" as "MF Date"
,t0."DistNumber"
,t1."OpenQty"
,t1."Price"
from OSRN t0
left join OIVL t1 on t1."ItemCode" = t0."ItemCode"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.