Skip to Content
avatar image
Former Member

Formatted search problem

Hi,

can i write in a user field the result of a division in DLN1 table in real time by this operation

SELECT $[RDR1.packQty]/$[RDR1.U_Num_bob]

is there a workaround

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 23, 2010 at 12:32 PM

    Hi Lorenzo,

    which is the document where you have to write the result of the query?

    why have you make and link the query?

    Paolo

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Lorenzo, all fine thanks.

      Why you have to use the field from RDR1? The same fields are in the DLN1 table.

      You have a user field in the detail of the delivery document? Yes?

      You have to insert the value packQty/U_Num_bob in the delivery? Yes?

      To do this you can use the query write by Badu in his post

      SELECT $[DLN1.packQty.NUMBER] / $[DLN1.U_Num_bob.NUMBER]

      and link it in your user field.

      Paolo

  • avatar image
    Former Member
    Jun 18, 2010 at 04:58 PM

    Hi,

    No. You may only get the current form value. If your delivery is copied from Sales Order, you don't need RDR1 in place because all data should be copied already to current DLN1.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 25, 2010 at 04:53 PM

    You may try this for delivery window:

    SELECT $[DLN1.packQty.number\]/$[DLN1.U_Num_bob.number\]

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 26, 2010 at 08:19 AM

    Hi Lorenzo Pelati,

    Its very simple.

    Try this,

    SELECT $[$38.packQty.NUMBER] / $[$38.U_Num_bob.NUMBER]
    
    SELECT $[DLN1.packQty.NUMBER] / $[DLN1.U_Num_bob.NUMBER]
    

    Regards,

    Madhan.

    Add comment
    10|10000 characters needed characters exceeded