cancel
Showing results for 
Search instead for 
Did you mean: 

DELIVERIES

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thankyou chidambaram,

I knewed it..................but going wrong in Query. Can you give me Detailed Query for this.