Query linked help

[former_member224367]

Dear All,

Need your help, how to build query to pull out open Purchase order, GRN and AP Invoice if user using AP reserved invoice.

Sample transaction as below:-

1. PO -> AP Reserved Invoice -> Payment

2. After received invoice , user proceed GRN copy from AP Reserved invoice.

Currently i'm able to pull out transaction based on PO -> GRN -> AP Invoice

Please help

Thanks,

Saufil

[RahF]

Hi Saufil

Can you please be more specific on what you want?

When you copy a PO to AP Reserve Invoice, the PO's are closed

Do need the query to display the PO's that haven't been copied to GRPO?

Thanks and Regards

Rahul