cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Audit Report Query SBO 8.8 PL 18

Former Member
0 Kudos

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,

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

OINM has been replaced by OILM and OIVL in SBO 8.8, please have a look at the below thread it migh help you

[]

Regards,

Rakesh N