Cancelled GRPO's

[Former Member]

Hi there all!

I'm currently doing a report that counts every transaction made as per user. My question is, is there a way for me to query all cancelled GRPO's? TIA!

[Former Member]

Hi,

You may compare the GRPO with AP Invoice to find out how many GRPO those are not copied to AP Invoices.

How did those GRPO "cancelled" anyway?

Thanks,

Gordon

[daroy_alvin]

Hi Djhay,

You can cancel open GRPO's through Goods Return, or APCM Item Type for Closed GRPO's.

Thanks & Regards,

Alvin

[Former Member]

Hi there Sir Alvin!

I'll give it a go and see if I can query using your suggestion. Thanks for replying!

[kothandaraman_nagarajan]

Hi,

Try this query:

SELECT t0.docentry,T0.[DocNum], T0.[CardCode], T0.[CardName], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity] FROM OPDN T0  INNER JOIN PDN1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.[CANCELED] = 'y'

Thanks.

[Former Member]

Hey there Sir Nagarajan K!

I've done something similar. I get default values that shows N only. Btw, Thanks for replying!

[kothandaraman_nagarajan]

Please provide more details for your requirement.