How do I Update the Freight1 (LC) field with a FMS

[vickibm10]

In SAP B1 9.1 PL 12 on the Sales Order, I am trying to update the Freight1(LC) field based on a query that should display the results of the Quantity * U_FrtUnit. This is my query - Select (Quantity*U_FrtUnit) AS 'Freight' From RDR1 Where ItemCode = $[$38.1.0]

It is set to refresh when the U_FrtUnit is updated and display saved User Defined Value.

However, it is not calculating properly. If I click on the Magnifying glass to select the result, it displays several rows and one of the rows normally has the correct answer.

Any assistance will be greatly appreciated. Thank you.

[former_member185682 · Accepted solution]

Hi Vicki,

If your field U_FrtUnit is at the line level, try this query in your fms.

SELECT $[$38.11.NUMBER] * $[$38.U_FrtUnit.NUMBER]

Hope it helps.

Kind Regards,

Diego Lother

[narayanis]

Hi,

Diego is right. You have to follow the itemcode syntax to reflect the freight calculation.

Regards

Pradnya