You’re offline. This is a read only version of the page.
7
We have hundreds of items in NAV, each item has a "Unit cost" calculated as FIFO. Additional to Items having a Unit cost, there's "Special prices" under the Vendor tab too, as items may have multiple vendors at multiple price breaks. This price break information is brought in when generating a Purchase order. Great.
When running "Calculate std cost" on a Production BOM (or it's linked item card), the Unit cost individually pulls in item Unit costs. I now have a Unit cost on a Production BOM which is populated from every Item's FIFO unit cost. If we've already calculated the sales price for this Production BOM, it doesn't matter as much. If we're trying to estimate new pricing for a customer with price breaks, it's a problem.
Unfortunately, from what I understand, as the costing method is FIFO, the Item is subject to fluctuating based on how many items we've ordered in the past. The Calculate std cost function isn't looking into the Special prices tab and matching price breaks based on the quantity. Appreciate that there's potentially multiple Vendors under Special prices.
Currently, we're having to pull the information out manually into excel and calculate price breaks for customers. I've seen there's a field to calculate % discount based on volume, but we're currently doing it by component.
Question 1: Is there another function for calculating the unit cost of a Production BOM that DOES honor price breaks? And would select the cheapest vendor at that price break, pulling information from the Special prices tab?
Question 2: Is there another way to do this without pulling it out into excel every time?
Any help would be much appreciated!
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
