Check IM_ItemCost to ensure the TierType column is correct.  When blank (or wrong), the transaction would post, but the inventory would not be consumed as it should have been (due to the bad key field value).

Hi Kevin,

Not sure how to get into this, can you clarify?

Use Excel to query the table I mentioned.  If you don't know how... you'll going to want to get Sage support or your Sage Partner involved.  Things only get more complicated after diagnosing the problem.

Thanks, will bring Sage in on this.

Export the IM_ItemCosting file and see what it shows for that item and serial number.  run the transaction detail report for that item for the date range involved and see what comes up. When an item is first serialized the qty committed field has a value of 1.  If that field is cleared then when posting happens that costing tier is not relieved.  This happened on older versions when rebuilding the inventory sort files.

Unfortunately I have no idea how to get into the 'IM_ItemCosting file'. 

I did run the inventory detail transaction report and it does show a cost for receipt and the same cost for the issue.  I'm just going to have to pay SWK for the correction, but I do appreciate your assistance.

Use Excel and Get Data and pull the file.  This can happen when you enter an invoice which puts a value in the Qty Committed field and the field is cleared before posting.  What version of Sage 100 are you on?

Assuming you run Standard or Advanced, all you need for a query is Excel on the machine you use as a Sage 100 workstation.

Sage 100 Advanced 2017 (Version 5.40.1.0)

I found this when I went to the Cost Detail tab in Item Maintenance.  I see the SN is entered twice, one is available and one is not.  I checked my receipts registers and I only received that SN once.

Thank you, I will try this