Skip to Content
0

SQL query to show users that manually closed Delivery

Aug 31, 2017 at 01:29 PM

40

avatar image
Former Member

Which field in ODLN table indicates the user that manually closed Delivery.

Will usersign2 reflect that user?

Sql Query to show all "manually" closed queries with user names would be very helpful.

Thank You.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Aug 31, 2017 at 05:36 PM
0

Hi Sasa,

Please try below query for an example purpose & change according to requirements....

SELECT T0.DocStatus,T0.InvntSttus,T0.DocManClsd,* FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.DocStatus ='C' and T0.InvntSttus = 'O' and T0.DocManClsd ='Y' and T1.TrgetEntry IS NULL

Rgds,

Kamlesh Naware

Share
10 |10000 characters needed characters left characters exceeded