We are using Navision since 5 years but till now no solution has been reached regarding automatic selling price calculation. Please help.
Our firm produces Steel Welded Mesh for Construction Industry and we make Mesh of different sizes and weights. Each item weight is calculated using the wire sizes & length. E.g 10 bars of wire 6mm + 8 bars of wire 12mm.
Alle Tech designed a weight calculation module & incorporated it in navision which works satisfactorily to some extent but has limitations.
our main concern is how to calculate the selling price of each item using the weight determined by the weight calculation mudule & is shown in the weight field of the item card. The formula to calculate the selling price is as follows:
Selling price = Weight * Rate per Kg
Now each client has different rate per kg and one client may have various rates per kg depending on project size.
We would like to input the Rate per kg while creating the sale quote, the sales order and in the customer card. In which field can we input the rates and how do we modify the program to incorporate all this computaion.
Any urgent attention will oblige.