Sage 100

Customer on Sage 100 2016 called and wanted to know how their inventory could be showing 0 qty, and yet also display a value. - Recalculated inventory - Ran remove tiers - Ran *UTL and did the cost adjust I'm a little baffled as to how the system shows a value for a line with zero quantity

I've run into it on an older version with BOM production entries, and also seen it caused by valuation change on items.

I forget the reason why this happens. To fix it, they have to upward adjust qty 1 at zero and then downward adjust qty 1 at zero.

I'm thinking i may need to take another stab at running this utility Item Code has a negative or incorrect Average Cost and is a tiered valued item **Inventory Reports have an Item Code with zero QOH, but has an Extended Total Inventory Value** Stranded values in the IM_DataEntryCostCalcCommit.M4T table or the CostCalcQtyCommitted or CostCalcCostCommitted fields in the IM_ItemCost.M4T or IM_ItemWarehouse.M4T tables **Resolution** Make a copy of the live Company Code into a test company (i.e. Company Code TST) In the TEST company, run the IM_CommitCheckClear_utl and IM_ClearCommitDataEntry_utl utilities to clear stranded values in the IM_ItemWarehouse, IM_ItemCost and IM_DataEntryCostCalcCommit files. - File, Run, Syzcon, Run ""IM_CommitCheckClear_utl - File, Run, Syzcon, Run ""IM_ClearCommitDataEntry_utl In the TEST company, run the IM/Period End/Inventory Negative Tier Adjustment. After updating, there may be items that don't have off-setting tiers. Adjustments may need to be made through Inventory Adjustments may need to be processed to create off-setting tiers. NOTE: Clear ALL negative tiers before running the utility. This should be standard practice for customers using tiered valuation methods. Open Inventory Management, Utilities, Remove Zero Quantity Costing Tiers Run the IM Balance Quantity and Cost utility Open Inventory Management, Utilities, IM Recalculate Item History utility and Proceed. Compare costs between the Inventory Valuation, Trial Balance and Stock Status reports and the total Quantity On Hand on the Stock Status report vs. the Trial Balance report. Verify and review specific items in Item Maintenance as well as the reports by grand total and by Item Code. Once the results have been reviewed and verified, create a copy or backup the current live Company Code and repeat these steps in the live Company Code.

Had this last week, not sure why it happens but only way to fix is DFDM.

Yes... the utility is certainly a fix for the problem. Do they have any third party add on products (Multi-Bin, JobOps, etc); I typically see this with clients that have add on products. It was a real PITA back in v4.50; it has gotten better, but still continually happens.

How many decimal places? It seems when I review these items, its a rounding issue.

Seems to happen in both IM_ItemCost and IM_ItemWarehouse for at least FIFO, Lot, and Average Cost items. Our approach is to import an IM Receipt for quantity of 1 with a reasonable last unit cost. Post the transaction. Then import an IM Adjustment for a quantity of -1 (again Tiers if needed) and then post. Correct the offsetting journal entries, if needed. This clears up the problem and then do it all over again when it happens. Haven't really established a pattern for why it's happening.

If the negative tier didn't fix it, we use @KarenOLane's solution. +1 @ $0; -1 @ $0

The customer did the correction noted in Karen's document (Thanks!) and it worked. I'm not exactly sure what happened or why there isn't an automated tool to fix it -- or even why it happens in the first place.

One would think the zero tier purge would work, but that utility only removes tiers that have a zero qty AND a zero cost...... A change to that logic would be welcomed...

And it is amazing how much buzz this topic has gotten on SC over the years. Maybe this could be a quick win for Diane Coffman. I will send her a note.....

I've seen this several times recently. Sage claims it happens if you do a Physical Count without first getting rid of all the Negative Tiers. I've argued this never used to happen but they sent me procedures on how to do a proper physical count. Steps include getting rid of all negative tiers first, removing zero quantity cost tiers, freeze items, count and update. In the past, I would do a physical count to remove negative tiers. Now the article states to enter adjusting entries to clear negative tiers. When this changed I don't know. I do know our clients with this issue did a physical count and then the issue showed up. Here is my own method to fix the 0 qty tiers with a cost. Use at your own risk. Print Inventory Negative Tier Report that will show all 0 quantity items with a Tier Value. Use DFDM to open the IM_ItemCost file. Find and delete all of the wrong records. This will fix the Inventory Valuation Report. Go to File, Run and enter *utl to get the utilities menu. Run Balance Inventory and Cost utility. This will fix the IM_ItemWarehouse file and recalculate the total cost in the warehouse by item.

Feedback from Diane... _I'll run this by the developer that works a lot on Inventory and get his thoughts. ......_ She also notes that: _Sage wants to start sending me to user groups/user conferences that partners put on where I can do demos of the product and get customer/partner feedback. 90Minds is top on my list and next year, if you guys will let me attend, I want to actually participate instead of being a fly on the wall. If you know any partners that do an annual conference, either let them know I'm available or give me their info and I'll reach out to them._

_**Sage wants to start sending me to user groups/user conferences that partners put on where I can do demos of the product and get customer/partner feedback.**_ Heard this the past two MOTM. Prediction for MOTM 2017 when inquiring of Sage = _**Crickets Chirping**_