Saltar al contenido principal

Delivery Draft Creation

Respondida

Comentarios

3 comentarios

  • Jas Singh

    Hi Rami, 

    Please check the link below . Scan already provided a solution for this. Check section 2.5.1 

    https://wiki.produmex.name/doku.php?id=implementation:scan:customizationcomplete

    For example, with the following logic, all goods receipt PO documents (doc. type = 20) will be created as drafts, while the other documents are created as real documents:

    MS SQL

    Download

    SELECT CASE T0.[U_BXPDocTy] 
    WHEN 20 THEN 1 
    ELSE 0 END as 'BXDOCTYP' 
    FROM [dbo].[@BXPLMSMOBTHD] T0 WHERE T0.[Code] = [%3]

    HANA

    Download

    SELECT
    case
    T0."U_BXPDocTy" when 20 then 1
    else 0
    end as "BXDOCTYP"
    FROM "@BXPLMSMOBTHD" T0 WHERE T0."Code" = [%3]
  • Rami Keyrouz

    Hi Jas,

    Thank you for your prompt reply!

    This one worked perfectely.

    Regards,

  • Miguel Oscar Lozano

    Thanks Jas for helping other users. That's what I though.

Iniciar sesión para dejar un comentario.