Hide all Cancel Document in Report when Using OINM table

[former_member665247]

Dear Mr/Mrs,

I want to create a report Inventory Posting Detail and I used OINM table to create that report. But in OINM table not have CANCELED field and I can't hide Cancel Document in this report.

Example: I create Inventory Transfer Document from Warehouse A to Warehouse B But It's wrong transaction and I cancel this document. So in Report I want to hide this transaction by using OINM table.

Any one have idea in this report. Please help me, I'm newbie in SAP B1

Thanks for your help,

Best Regards,

[markus_schaefer242]

Hi,
please try like that (

OWTR = Stock-Tranfer = Transtype 67...)

select T0.BASE_REF, T1.DocNum

from OWTR T0

LEFT JOIN OWTR T1 on T0.BASE_REF = T1.DocNum and T0.Transtype = '67'

where T1.CANCELED = 'N'

hope that helps.

greetings
Markus

[former_member665247]

Hi,

I know that solution but I used OINM for my report Inventory Posting.

This is my query:

Select * FROM OITM T0 with(nolock) INNER JOIN OINM T1 with(nolock) ON T0.ItemCode = T1.ItemCode INNER JOIN OWHS T2 with(nolock) ON T1.Warehouse = T2.WhsCode left JOIN OLCT T3 with(nolock) ON T1.Location = T3.Code

I don't use OWTR or OPOR, OPDN, OINV, ... Because in OINM have inQty and outQty of all transaction in SAP B1 but OINM don't have CANCELED field.

If you have any idea. Please help me.

Thanks for your help,

Greetings

Huy Vu