Skip to Content

Approval required query Delivery note based on condtions Approval procedure required

I need a Query for DC Approval ,that is based on where docentry is null and udf header level tag should be YES and some UDO value based it should come

Select distinct 'True' from ODLN t0 inner join DLN1 t1 on t0.DocEntry=t1.docentry where t0.DocStatus='O' and t0.[U_Demo]='Yes' group by t0.series having sum(t1.Quantity)>(SELECT T0.[U_EndRange] FROM [dbo].[@AIT_MAT] T0 WHERE T0.[Code] =992)

i have my query here plz correct it

it is not working

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 09, 2017 at 11:01 AM

    Hi,

    As Nagarjan said, approvals will not work on row level. Instead through SPTN you route such documents only through special logins. Set a flag to identify these documents and with the hep of this flag you can send this document for approval as a second check.

    Regards

    Pradnya

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 11:40 AM

    Hi,

    1. No formatted search part in above query.

    2. You can get docentry only from current form not from UDO.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sir,

      This is not in part of FMS,

      I need a query changes for approval template purpose

      it is not working ,plz correct it

      my condition is for 'If my Delivery without baseentry, and one header level UDF value equals 'YES' it should be went for approval '

      plz give me query for above condition

      Regards

      Smiley

  • Feb 09, 2017 at 08:56 AM

    Hi,

    Approval procedure will work on header level not on row level.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sir

      Plz suggest for below condition

      my condition is for 'If my Delivery without baseentry, and one header level UDF value equals 'YES' it should be went for approval '

      without out base entry is not possible just for udf value it should work

      plz give me query for above condition

      Regards

      Smiley

  • avatar image
    Former Member
    Feb 09, 2017 at 10:24 AM

    Hello,

    Can you explain a little more your required result please.

    Thanks

    Engr. Taseeb Saeed

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member REDDY K

      Hello,

      Please write a query as per your requirement if it does not met then return 'True'. Give this query in on

      Approval Templates -- Terms -- When the Following Applies -- Give query

      sample query as follows

      IF $[OPOR.UDFName] <> 1
      SELECT 'TRUE'
      

      Now if UDF is not equal to 1 it will prompt for approval else it will not.

      Regards,

      Engr. Taseeb Saeed