on 11-05-2008 5:49 AM
Hi all,
Is there any way to list out all deliveries which are closed manually, (I mean not linked with A/R Invoices).
There are many deliveries which are closed, there might be 2 reasons (1) A/R Invoice raised for the delivery
(2) Delivery closed manually and raised A/R Invoice directly, with out linking to the delivery.
Now I want to list out all deliveries which is closed manually
Thanks in advance.
Try this one:
Select * from ODLN T0 Inner Join DLN1 T1 ON T1.DocEntry = T0.DocEntry
Where T0.DocStatus = 'C' and T1.TrgetType <= 0
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sree,
Please check the delivery table for the following.
1. if the Delivery has closed having target entry field in not null then it is not closed manually.
2. if the delivery has closed does not having target entry field then it is closed manually.
Write a query based on this field and see the report.
Regards
Chidambaram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.