My order materials cost is incorrect!
If you find that your material cost for an order seems incorrect, please follow the steps below to troubleshoot the problem:
1. Check that your Order has a Shipped Date
The material cost calculations now only occur when an order has been marked as Shipped.
When the Order is marked with a Shipped Date, it is this date that is used to pinpoint the cost of manufacture which is then assigned as a cost to your order line item. While the order is unshipped, the material cost will always be zero as it is up to this point included in your raw material inventory totals.
2. Check your manufacture history
If an order item does not yet have a manufacture history, then it will have a material cost of zero until the adjustment history is added. Adding in the missing backdated manufactures will automatically recalculate all adjustments and thus all order material costs relating to it. You can review your manufacture history for each project by clicking on the Adjustments tab on your projects page.
3. Ensure the relevant manufactures are dated before the shipped date for the order
As the weighted average cost calculation uses your adjustment history to determine the cost of the manufactured goods sold, dates are extremely important: if your order has a shipped date before your manufacture, then the manufacture cost will not be included into the calculation.
4. Review your Manual Project Adjustments
Any positive manual inventory adjustments you have added to the project will have increase your stock on hand at that point in time, but as no cost will be associated with the adjustment your real costs will be "diluted" by these adjustments.
If you wish to use our material costing / COGS features, it is recommended that you:
a) avoid adding positive inventory adjustments and instead create manufactures to account for the stock increase so that they are fully costed in the system.
5. Review your Starting Quantity Adjustments
As you may be moving to CB from a different system it is possible to set a unit price for any project stock you begin with: these adjustments are fully costed into your rolling averages. If you bring a large quantity of stock into Craftybase without a cost attributed (i.e. zero) then this will dilute and affect your cost calculations going forward.
It is recommended that you review all Starting Adjustments and either:
a) add an accurate unit cost for any stock brought forward into the system or
b) if you are tracking back to the date of manufacture, set your starting quantity as 0.00 and add a manufacture to account for the creation of all products.
For detailed troubleshooting advice on how to rectify uncosted (zero costed) orders, please see the article here: Why is my order cost zero?