Dynamics 365 Business Central

Vivian,

Thank you for the information - right now we operate in NAV and we had a program written to calculated unit price off the the last direct. Sales Price Worksheet will not work with us due to the amount of items we buy every month. Based on the standard functionality i understand it cannot be done but can a program be written to modify this to work?

I hope you've found something useful here. If it helps you get more insight into the issue, it's appreciated to accept the answer then. Should you have more questions, feel free to leave a message. Have a nice day!

Vivian

Hi Rob Zelehoski,

Based on the standard functionality of Microsoft Dynamics 365 Business Central (and Dynamics NAV), the answer is no, you can't configure...

The "Price/Profit Calculation" field on the Item Card is hardcoded to use the Unit Cost field (which represents your inventory value/average cost) for its "Price=Cost+Profit" calculation. It doesn't look at the "Last Direct Cost" field.

However, since this is a very common requirement for distributors who want to price based on the most recent vendor invoice rather than average inventory value, here is the best way: Instead of relying on the automatic calculation on the card, you can use the Sales Price Worksheet (or "Price Worksheet" in newer versions) combined with Excel to update your prices in bulk.

1. Export Your Data:
   • Go to your Item List.
   • Click on the "Share" icon (top right) and select Open in Excel.
   • Make sure your Excel file includes columns for No., Last Direct Cost, and Unit Price.
2. Calculate in Excel:
   • In Excel, create a new column for your "New Price."
   • Use a formula to calculate this based on the Last Direct Cost column (e.g., =Last Direct Cost * 1.30 for a 30% margin).
3. Update via Price Worksheet:
   • In Business Central, search for Sales Price Worksheet (or just "Price Worksheet" if you are on the new pricing experience).
   • You can copy/paste your calculated columns from Excel directly into this worksheet, or use the "Edit in Excel" feature on the worksheet itself to paste your new prices in.
   • Once the lines are in the worksheet, click Implement Price Change on the ribbon.3 This will push your calculated prices back to the actual Item Cards.

It distinguishes between Unit Cost (the accounting value of your inventory, often an average) and Last Direct Cost (the literal last price you paid on an invoice). The system defaults to Unit Cost to ensure your profit margins are based on the actual value of the stock you are selling, not just what you paid most recently.