on 06-18-2010 9:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You may try this for delivery window:
SELECT $[DLN1.packQty.number\]/$[DLN1.U_Num_bob.number\]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.