Sage 100

Have a client with a FIFO item that shows a negative tier and 0 on hand. Any ideas how to gracefully get rid of this without DFDM D-1600-I is still appearing on the Inventory Negative Tier Report. I was wondering if you had another solution to remove this item from the Inventory Negative Tier Report? Item On Hand Cost Tier Tier Qty D-1600-I 0 OVERDIST 34- They've already run the negative tier adjustment report.

How about. Imzbl1 or is it 4.4

In cases such as this I just go in and do an inventory adjustment.

IMZBL1 will not work because the issue is that there are two tiers, one positive and one negative and for some reason the negative adjustment feature in period end will not apply one to the other. Hence the need to manually do it with an adjustment.

Thanks I'm working on this now. I essentially provided this advice however it's one of those situations where a failing business is on their third CFO in two years and the present CFO doesn't understand why everything is messed up, why it doesn't look like MAS 500, why we could have ever let this customer do all these things. Essentially I've seen this movie -- it's called ""oh can you tell us when our support contract is up"" which is followed by a never ending stream of support emails and calls for mundane things to ""use up their time"" --- which is followed by the notification from Sage that the client is moving VARS for unspecified reasons.

I'm also receiving some type of error about ""tiers must exist for negative quanities: Client is on 4.05 so I really would prefer not to brute force DFDM or I'll get an earful on conversion --- although I secretly wonder if someone previously worked some DFDM magic.

And did I mention we provided the outgoing CFO with a proposal to fix the Inventory issues 9 months ago. Apparently they brought in ""TJ"" who ""Sat at the computer for a few days and made adjustments"".

Did they run just the report or the negative tier adjustment? is there a positive tier to offset to zero out the negative?

You are going to have to pull the Item Costing File for that item with Excel to see what is going on with that item.