Formatted search problem

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi paolo,

how are you?

i want to write the result of a division in an user field...

[Former Member · Accepted solution]

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

[Former Member]

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.

[Former Member]

You may try this for delivery window:

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

[Former Member]

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