Skip to Content
avatar image
Former Member

SQL query to show users that manually closed Delivery

Aug 31, 2017 at 01:29 PM | 42 Views | Last edit Aug 31, 2017 at 01:30 PM 2 rev.

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.

SAP Business One
SAP Business One SDK
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    kamlesh Naware
    Aug 31, 2017 at 05:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded