Sage 100

2017 premium. FIFO inventory valuation. The Inventory Valuation by Period doesn't agree to the Inventory Valuation report. The inventory valuation report has three item codes that are the source of the difference. Each of the items has one extra tier that doesn't appear to have been used by an SO invoice. Is there a way to determine what cost tier was used by an invoice? I am trying to determine if there was an updating issue or where / how this could happen. For example, one item shows two tier each with 24, so 48 total. They are certain there should only be 24, so one of the tiers didn't get consumed. Any ideas on how to track this down would be greatly appreciated.

In a test backup company, have you tried running the *UTL Balance Inventory Quantity and Cost utility? it may point you in the right direction and repair the problem?

@MadelineStefanou No I haven't but I will. Thanks for the idea!