NAV2013 - Cost based Sales Prices

ALopez2710

Is there no standard functionality in NAV 2013 to calculate sales prices based on cost? Most of our sales prices are based on either cost markup or cost margins, instead of having to calculate this and enter it in the sales price tables, can we just base it on cost?

I know this can be done through modifications, but every ERP system I have worked has this as std. functionality. If this feature does not exist as std. functionality, does anybody know of a good add-on that will handle this? Thanks much.

tinoruijs

Probably you want to calculate cost with markup because you need to calculate multiple items and perhaps resources?
What kind of business are you or the customer running?
Maybe the assembly module can help you?

daniellee

ALopez2710 wrote:

Is there no standard functionality in NAV 2013 to calculate sales prices based on cost? Most of our sales prices are based on either cost markup or cost margins, instead of having to calculate this and enter it in the sales price tables, can we just base it on cost?

I know this can be done through modifications, but every ERP system I have worked has this as std. functionality. If this feature does not exist as std. functionality, does anybody know of a good add-on that will handle this? Thanks much.

Hi,

You may test the standard function with the steps as follow:

1. Create a new item with Cost Method= Standard, Standard Cost=100, Price/Profit Calculation= Price=Cost+Profit and Profit % =20. You may find the field Unit Price is become 125 automatically!

2. Create a sales order for this new item

You may use this function under Standard Cost, it would not work well with other cost method!

Rob_Hansen

An inventory valuation decision (costing method) should not be made to facilitate sales pricing...there are obviously big implications for costing and financials that need to be understood.

Is the need this simple? That each item should be priced based on the last cost (or manual update of the cost on the item card)? If so you could look at some logic to implement that any time item costs are updated (in the various places that can happen).

We built some extensive functionality for this on sales quotes/orders, where the item cost would come in and users could then specify markup factors (specific to that customer/order) to calculate and set the price. This was not a complex customization, so you could look at going down that path. Obviously you need to deal with things like currency differences (we also added source currency code and source currency cost to the item table, along with exchange rate management specifically for costing that would be used with markup factors to drive pricing). Then things like default markup setup by customer/item group (or however you do that). As you get into the details the scope can expand, but it's not rocket science...just takes some time.