on 02-10-2011 8:44 AM
Hello all SAP Consultant,
i need help..
i need to create report for inventory audit report, before current update it's ok,
but after upgrading to version 8.8 PL 18 the trans value is different.
i try to get from OINM table, but some values is not there or different...
btw i'm using FIFO valuation method
Best Regards,
Dear iwan.t,
Try this one for inventory audit report as per SAP Standard.
Its tested on SAP Business one 8.8
SELECT T0.[TransSeq], T1.[ItemCode], T1.[ItemName], T0.[CreateDate], T2.[WhsCode], T0.[InQty], T0.[OutQty], T0.[CalcPrice], T0.[TransValue], T0.[InvntAct],
T0.[Currency], T0.[Rate], T0.[UserSign], T0.[TransType], T0.[CreatedBy], T0.[BASE_REF], T0.[DocLineNum], T1.[InvntryUom], T1.[EvalSystem], T0.[DocDate] FROM [dbo].[OINM] T0
INNER JOIN [dbo].[OITM] T1 ON T1.[ItemCode] = T0.[ItemCode] INNER JOIN [dbo].[OWHS] T2 ON T2.[WhsCode] = T0.[Warehouse] WHERE (T0.[TransValue] <> 0 OR
T0.[InQty] <> 0 OR T0.[OutQty] <> 0 OR T0.[TransType] = 0 ) ORDER BY T1.[ItemCode],T0.[TransSeq]
Edited by: itskumaramit on Feb 10, 2011 10:47 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.