Sage 100

v4.5 advanced. Customer has a couple hundred inventory items with no quantity, no unit cost yet a small dollar value.. usually $.01 or $.02. The total affect on inventory is minimal but they want to clean up the valuation report. What is the most efficient method to get rid of these values? See the attached example.

Run the negative tier report first. Then run the Remove Zero Quantity Tiers utility. If that doesn't fix it, run the IM CommitCheckClear_utl and IM_ClearCommitDataEntry_utl to fix stranded tiers, then run the IM Balance Quantity and Cost Utility.

Just curious @DougHiggs does the customer process Period End for Inventory regularly and also are they using more than two decimals in some modules?

@MoiraGoggin .. All of these items are average cost valuation.. no tiers.

Not sure on regular period ends... Definitely more than 2 decimals.

That's helpful info., run the IM Balance Quantity and Cost for Average Cost Items utility then.

Where is that utility located?

I know you can get to with pre processing a migration.

You have to add them...let me look it up...

mas90\utility....copy the programs to IM folder, then use File Run SYZCON

Got it. Thanks @MoiraGoggin !

Let me know if it works @DougHiggs

Will try it tonight and let you know.

You can also run the utility from File / Run / *UTL

@DougHiggs if you have decimal quantities, it could be that the quantity approximates zero but actually is not exactly zero. Sage 500 has this issue. I don't know that it happens in 100 as well but just a consideration.

Thanks @KennyDaniel and @ShawnSlavin

and thanks @MoiraGoggin

The Balance Inventory Quantity and Cost utility program I ran last night didn't work. I was hoping for an efficient way to get rid of these balances but it looks like it will need to be done manually. Manually modified the IM_PeriodpostingHistory table for a couple of records then re-printed the Inventory Valuation by Period report. Balances fixed. Only 734 more to go. Should be done sometime Monday assuming 5 hours of sleep each night.

@DougHiggs anytime I have to manually delete large number of records, I export the whole file to Access or Excel, remove the necessary records, then import the remaining back in - after first making a backup, of course.