Sage 100

Customer on Sage 100c Advanced 2016, PU2. An item appears on the Valuation and Trial Balance reports but does not appear in Item Maintenance/Inquiry. (Not sure why it is in a DO NOT USE whse...) Any ideas on cause/correction(s)?? TIA.

It shows there because there must be a record in the IM_ItemCost table with that qty. but in IM_ItemWarehouse the value is zero. if this is the only item having the problem I would ask the client which is correct (5120 on hand or zero on hand). and use DFDM to correct whichever one is wrong. Or if they say zero on hand, you could add the qty to the IM_ItemWarehouse table and that would allow the client to do an inventory adjustment.

Thanks @DavidOverholt but she is going to want to know why. Any ideas on what could have caused this??

I'm assuming you've rebuilt sort files on all those modules. Are you able to go back on the valuation report and figure out where it comes from - ie the activity line is populated?

Interesting that when looking at the warehouse record in DFDM, it has zero on hand but a value of -4610.06.

And here is the detail transaction report from day one, showing zero on hand SHOULD be correct - with a negative value.

Is there ever a situation where a client would want the qty to be zero and yet still have a valuation? (<-Serious question) You would think after all the years of complaints they could program in some sort of warning message stating the cost input will cause a leftover value, at the very least giving the client a heads up.

Even more interesting, I went to save this as IM_DetailTransactionXXXX (item code) and it said it already existed. We had printed a detail transaction report for this same item last March and there were NO warehouse 003 transactions.

Customer says zero is correct so I'm going to follow @DavidOverholt's suggestion and correct the IM_ItemCost table through DFDM. She recalled an error last month with this item where a transaction updated with a warehouse 3 record, not a 003 so we corrected it through DFDM. Oh the tangled web we weave - when trying to fix things through the back door.....

Sorry I did not get back to you in time to give you some possible ""why"" this could happen. But looks like you found that out.

You may also want to look at or correct IM_PeriodPostingHistory.