Material adjustment troubleshooting
Why is my material adjustment showing a material cost of zero?
All material adjustments need to be costed in order for your inventory valuations and COGS to be correct.
To find all zero costed material adjustments, please see this article: How do I find my uncosted material adjustments?
In order to troubleshoot you'll need to find out which type of adjustment this is: you'll find this under the Reason column.
These are the easiest to repair as they usually indicate that there is a data entry issue with the expense that this material is linked to. For the example below, the 14 Oct 16 purchase adjustment has a unit price of $0.00, which is affecting the following manufacture on the 30 Nov 16.
To fix, click on the edit icon on the right hand side of the row and then locate the material line item entry in the expense and fix any issues with the unit price.
A manufacture adjustment with a zero unit cost can be a result of two situations:
1. Error with a previous purchase price. In the example below, the expense before the manufacture has a unit price of 0.00. This has resulted in the manufacture on the 30 Nov to also have a unit price of 0.00 as it is using up the zero valued stock added on 14 Oct.
2. Material out of stock: In the example below, the manufacture on the 30 November uses up all stock purchased on the 29 Mar. As there is now no stock available, the Manufacture on the 1 Dec cannot have a unit cost calculated and is thus 0.00. To fix, the missing material stock needs to be added in as either a Purchase or part of the starting adjustment so that the 1 Dec has enough stock to have a cost calculated.
How do I find my uncosted material adjustments?
Uncosted material adjustments are those that have a calculated material cost of zero. To find your uncosted material adjustments:
1. Navigate to your Material Adjustments page ( How do I find my Material Adjustments page?)
2. On the left hand side search filter bar, open the filter called Costed and select "No".
3. Click the Filter button. The page will refresh to show all adjustments with a material cost of zero.
To troubleshoot why your adjustment has a zero material cost see this article: Why is my material adjustment costed as zero?
Why does my materials beginning inventory for all time show an amount?
If your material beginning inventory shows an all time amount, it is usually due a starting inventory adjustment that is linked to one of your materials. This most likely was set when you first created your materials. As starting adjustments don't have a date associated to them (i.e. they are the stock you had on hand when "records began") they are always assumed to be the starting amount and value no matter how far back in the date range you go.
If you want to have these adjustments appear only within a specific date range, what you'll need to do is find and set these starting adjustments to zero and then create a material expense instead, to account for the increase in stock with the correct date range.
To locate the starting adjustments you need to change, if you haven't yet added any manufactures or other manual adjustments, you may be able to look at your materials list page for materials where the value in the Purchased column is not the same as the In Stock one. This indicates that you have an inventory adjustment for this material.