Material adjustment troubleshooting

In this article we'll cover:

Why is my material adjustment showing a material cost of zero?

All material adjustments must be costed for correct inventory valuations and COGS.

To find all zero-costed material adjustments, please take a look at this article: How do I find my uncosted material adjustments?

To troubleshoot, you'll need to find out which type of adjustment this is; you'll find this under the Reason column.

Purchase Adjustments

These are the easiest to repair as they usually indicate a data entry issue with the purchase that this material is linked to. For the example below, the purchase adjustment has a unit price of $0.00, which affects the following manufacture.

To fix, click on the edit icon on the right-hand side of the row, locate the material line item entry in the purchase, and fix any issues with the unit price.

Manufacture Adjustments

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 purchase before the manufacture has a unit price of 0.00. This has resulted in the manufacture also having a unit price of 0.00 as it is using the zero-valued stock. 

  2. Material out of stock: In the example below, a previous manufacture used up all stock purchased. As there is now no stock available, the most recent Manufacture cannot have a unit cost calculated and is thus 0.00. To fix this, the missing material stock must be added as either a Purchase or part of the starting adjustment so that the most recent manufacture has enough stock to calculate the cost.

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 the filter bar under Costed status and tick the 'Not Costed' box.

  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 with 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 these adjustments to appear only within a specific date range, you'll need to find and set these starting adjustments to zero and then create a material purchase 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. 


For example, if your "Blue Ribbon" has a stock on hand of 30 but a Purchase of 20, this would mean that you most probably have a starting inventory adjustment of 10.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.