on 05-17-2011 12:13 PM
Hi Experts.
Hope you are all doing well.
Here all I need to know that if we can find out whether GRPO closed automatically or manually.
Regards,
Ravi
Hi Ravi,
If target entry is blank on GRPO and document is closed means it is closed manually.
IF target document is created from GRPO and GRPO status is closed i.e. cliosed automatically.
run below query to get list of GRPO's closes manually:
select T0.DocNum from OPDN T0 Inner JOIn PDN1 T1 on T0.DocEntry=T1.DocEntry
Where ISNULL(T1.TrgetEntry,'')='' and T0.DocStatus='C'
Thanks,
Neetu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.