Sage 100

Standard, version 4.40.0.8 Customer inventory valuation report has about 40 items with quantity on hand of 0, yet a valuation amount. Valuation method is FIFO. The amounts are generally quite immaterial (range from $.01 to $5.00), but the outside accountants want them cleaned up. I know how to fix these by manipulating the data. Does anyone know what causes this, and how to prevent it from occurring ion the future?

Are these over-distributions? Have you tried removing zero qty costing tiers?

Good idea but unfortunately, removing zero quantity costs tiers doesn't help. There are no quantities (negative or positive) and there are no unit costs... just extended values. I wish this was somehow caused by over-distributions / negative cost tiers so I would at least know what was causing this.

So you did run the negative tire report??

Ran the negative tier report and none of the items in question are on it. I am cleaning up the valuation at 12/31/13. Tiers could have gone negative anytime in 2014 which shouldn't have affected 2013. They do a lot of product substitutions and clear the negative tier report every month as part of the month end closing.

If you run the trial balance report do they still show values?

Wonder about decimal precision. How many decimal places display? When you DFDM the tier record, how many decimals display there?

I have cured the patient but not sure what caused the disease. Modified IM_PeriodPostingHistory.M4T and all is well. @JohnLeonard Trial balance shows the same data as Inv Valuation by Period at 12-31-13. @JeffSchwenk Precision is 3 on cost field.

If somehow the DFDM showed 4 decimals, the quantity would be zero on the valuation but it might still show an amount on the valuation report.

This is the cost calc commit issue

Check the IM_ItemCost and the IM_Itemwarehouse fields 'costcalccommit"". this issue is in the 440 release PU2 - PU10. affecting average cost and tier items

What should I check for?

These fields are not releasing data and should only show data when physically in an update. Once you answer Yes or No to the update prompt the fields should clear. KB ID:20968 , Here is just one article related to this bug.... https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=20968&sliceId=1&cmd=displayKC&dialogID=91930&docType=kc&isLoadPublishedVer=&stateId=91931&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

Thanks @JoanSerr I will check it out.

I'm guessing this holds true for negative tier adjustments as well. Just had a customer with over-distributed tiers and positive tiers NOT offsetting properly. Thanks for the reminder @JoanSerr !

Yup Yup. Anytime.