Sage 100

Does anyone have an idea on what this error is. 2016 v - trying to print out the inv physical var report register and getting this error. The item is not in the physical count and is also discontinued. Of course can't find anything on KB. Thanks !

Is it a valid item or can you remove it from the CI_Item and applicable tables so the system no longer sees it?

Well it is or was an item. I guess I could do that and see if that works.

This seems close, so maybe worth a shot: Error: ""11 CI_TierCostCalc.pvc 804"" Products Sage 100 Description Error 11 CI_TierCostCalc.pvc 804, File: IM_ItemCost, occurs when updating the Physical Count Variance Register. Disclaimer Backup Warning Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst. Resolution On affected customer data set, run the physical count Variance Register to print or preview. On 4.40.0.8 and above: Resolution 1: In Windows Explorer, browse to the ....\MAS90\Utility folder Copy the IM_ClearCommitDataEntry_utl file. In Windows Explorer, browse to the....MAS90\IM folder Paste the IM_ClearCommitDataEntry_utl file. In Sage 100 ERP, on the toolbar click File, Run Type in Syzcon Click Ok Type run ""IM_ClearCommitDataEntry_utl"" (including quotes) and press ENTER Click Yes to ""Warning: This utility Should not be run while registers have not been updated. Do you want to Proceed?"" Click Ok to the next window. Run the Physical Count Variance Register.(Open Inventory Management, Physical Count, Physical Count Variance Register) Resolution 2: In Windows Explorer, browse to the....MAS90\MAS_xxx\IMxxx folder (xxx=Company Code) Rename the IM_DataEntryCostCalcCommit.M4T file to .old Manually Reinitialize the ""IM_DataEntryCostCalcCommit.M4T"" file. Open Library Master, Utilities, Reinitialize Data Files. Review the warning message, and click OK. Click Manual button. In the file name field, type IM_DataEntryCostCalcCommit.M4T and press ENTER. Click Proceed. On 4.40.0.7 and below: In Windows Explorer, browse to the....MAS90\MAS_xxx\IMxxx folder (xxx=Company Code) Rename the ""IM_DataEntryCostCalcCommit.M4T"" file to .old Manually Reinitialize the ""IM_DataEntryCostCalcCommit.M4T"" file. Open Library Master, Utilities, Reinitialize Data Files. Review the warning message, and click OK. Click Manual button. In the file name field, type IM_DataEntryCostCalcCommit.M4T and press ENTER. Click Proceed Related resources How to erase or manually recreate data files using the Reinitialize Data Files utility Entitlement Open ID:21473Last modified:8-5-2016

...or possibly this one: Tier Type is randomly missing from IM_ItemCost file Products Sage 100 Description Tier Type is randomly missing from IM_ItemCost file Disclaimer Backup Warning Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst. Resolution Sage has been unable to recreate this issue in customer or demo data. If you are having this issue frequently or can provide the steps to duplicate this issue, please open a case so we can troubleshoot further. This may require upload of your MAS90 folder and all contents to Sage secure site. To fix the issue: Identify the item and tier in the IM_ItemCost table that is having an issue. Expand Library Master, Utilities, Data File Displaly and Maintenance Select the IM_ItemCost table in the ........\MAS90\MAS_XXX\IMXXX folder. Edit the field containting the TierType to add the appropriate value. Related resources Cost tiers are not visible in the Inventory Transaction Entry distribution window Category Batches, entries, posting Entitlement Open Defect ID 105303 Steps to duplicate - DevTrack only We have been unable to recreate this issue on customer or demo data. Tier type is randomly missing after updating transactions. Happens on all tier types. Will prevent negative tier adjustment from seeing the tier because the tier type is missing. ID:70886Last modified:8-5-2016

Thank you @BrettZimmerman the first one did it. Where did you find that? @NancyHanson Thanks for your help and suggestion also.

Sage Kb

Wow I did the kb many different was and got nothing that made sense! Thanks again