i searched the forum but was unsuccessful. If you know of an existing topic, please direct me to it! thanks. we are using NAV 3.7b code with 5.0 executables in SQL. Our costing method is Average.
a customer wants to buy an item from us. they do not want to see freight on the invoice; they want the cost of the freight included in the cost of the item. so, we increase the sale price to include a freight factor, but how do we increase the unit cost to reflect proper margin (boosted price with same cost = higher margin)?
in my readings regarding cost posting and in my system experiments, it is fruitless to manually alter the cost on the sales line, as the posting routine will retrieve the cost from the item table anyhow and overwrite it. what are some other companies doing with this requirement?
item 123 unit price = 1.00 unit cost = 0.50
assume freight is 0.10 per unit with no markup, so i make the following change to the sales line
item 123 unit price = 1.10 unit cost = 0.60
unfortunately, it posts with unit cost = 0.50.
kind of fell into this...