Sage 100 How to Run the IM_CommitCheckClear_utl and IM_ClearCommitDataEntry_utl Utilities in Versions 4.40 and Higher

Values may become stranded in the CostCalcQtyCommitted or CostCalcCostCommitted fields in the IM_ItemCost.M4T and IM_ItemWarehouse.M4T tables or in the IM_DataEntryCostCalcCommit.M4T table during Transaction Register updates or previews. These values may contribute to discrepancies with Quantity On Hand totals and costing issues. Using these utilities will remove the stranded values and create a comma separated file (.csv) of the committed records removed.

Utilities are included in versions 4.40.0.8 and 4.50.2.0 and higher to remove these values. For versions 4.40.0.7 or 4.50.1.0 or lower, contact Customer Support to receive the utilities.

Backup Warning

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. 

Database Warning

These steps require knowledge of database engines and application databases (DBs) used by your Sage product (including Microsoft/Transact SQL, Pervasive SQL, or MySQL, etc.). Customer Support is not responsible for assisting with these steps and cannot be responsible for errors resulting from changes to the database engine or DBs. Before making changes, backup all system and application DBs required for a full restore.

These utilities will remove all values in the CostCalcQtyCommitted or CostCalcCostCommitted fields in the IM_ItemCost.M4T and IM_ItemWarehouse.M4T tables and in the IM_DataEntryCostCalcCommit.M4T table.

The utilities can only be used when there are no inventory-related transactions waiting to be updated.

This includes, but is not limited to:

Sales Order Invoices

Purchase Order Receipt/Return of Goods

Return Merchandise Authorization Receipts

Bill of Materials Production Entry

Inventory Management Transactions/Physical Count

To run the IM_CommitCheckClear utility:

1. Copy the IM_CommitCheckClear_utl and IM_ClearCommitDataEntry_UTL program files from the..\MAS90\Utility folder to the ..\MAS90\IM program file.

2. Open File, Run and type syzcon. Click OK.

3. At the command prompt, type: run “IM_CommitCheckClear_utl” and OK.

4. The program will prompt with the following warning: “Warning: This utility should not be run while registers have not been updated. Do you want to proceed?

5. Click Yes to Continue. Click No to quit the program.

6. If any issues are found, the message “IM Commit Check Clear Utility Check completed. Do you want to clear them?” will display.

7. Click Yes and the message “The IM Commit Check Clear Utility for Company xxx has been successfully completed. Results can be viewed in.. HOME/TEXTOUT/IMCommitCheckClear001.csv

8. If no issues are found, the message “The IM Commit Check Clear Utility for Company xxx found no issues to review” will display.

9. You can then review the report in Excel. The reports are saved by adding a sequence number to the end so comparisons can be made to isolate the cause of the issues.

10. The program will also add an entry to the Activity Log.

To run the IM_ClearCommitDataEntry utility:

1. Open File, Run and type syzcon. Click OK.

2. At the command prompt, type: run “IM_ClearCommitDataEntry_utl” and OK.

3. The program will prompt with the following warning: “Warning: This utility should not be run while registers have not been updated. Do you want to proceed?

4. Click Yes to Continue. Click No to quit the program.

5. If any issues are found, the message “IM Commit Check Clear Utility Check completed. Do you want to clear them?” will display.

6. Click Yes and the message “The IM Clear Commit Data Entry Utility for Company xxx has been successfully completed. Results can be viewed in..
HOME/TEXTOUT/IMCommitCheckClear001.csv

7. If no issues are found, the message “The IM Clear Commit Data Entry Utility for Company xxx found no issues to review” will display.

8. You can then review the report in Excel. The reports are saved by adding a sequence number to the end so comparisons can be made to isolate the cause of the issues.

9. The program will also add an entry to the Activity Log.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.