FMS

[Former Member]

I want to write a FMS to get Freight amount in the purchase document.

Total Before Discount = 1000

Freight 2% = 20

Its not possible to get Total Before Discount amount in to Freight form. Please help to write FMS

[Former Member · Accepted solution]

Hi Poonkodi,

Please go through this thread:

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks for your reply.

My requirement is the additional expenses in the freight (form) should be automatically calculated based on the total before discount.

Example:

Total before Discount = 1000

Based on this Freight form which has 2 additional expenses namely,

1. Packing & Forwarding 2% = 20

2. Freight 5% = 50

The above calculation has to be done in the freight form automatically. I am trying to do this with FMS but i am not able to get total before discount or columsum of row total in to freight form. Looking forward for the help.

[Former Member · Accepted solution]

It is a known fact that FMS can refer to Fields only within same Form.

But your requirement is to refer 'Total Before Discount' in Marketing Document Form from Additional Expenses Form.

This is not possible through FMS.

[former_member583013 · Accepted solution]

None of the values from the Main Form are available or accessaible on the Freight window, therefore a FMS cannot be created for calculating the Freight value as a percentage

[Former Member · Accepted solution]

Hi All,

Thanks for your reply.