How to use the stock fix utility?
Description

The Stock fix Utility is a tool which is used to correct inventory quantity levels where the quantity in Sage 50cloud Pastel Accounting is incorrect.

The Stock fix Utility would be used in the following circumstances:

  • The Inventory Activity and Inventory History Item Sequence reports do not correspond
  • The Count Inventory process does not update the quantities
Cause
Resolution
[BCB:1:Backup warning:ECB]
To view a step by step video on How to run a Stock Fix click the video below

Refer to How do I process a backup Sage 50cloud Pastel Accounting? if needed.

Before you run the Stock fix Utility you would need to rebuild the following files that are located under the company folder:

  • ACCPRD.dat
  • ACCPRDQ.dat
  • ACCSTKLK.dat
  • ACCSTKST.dat

Please refer to article How do I rebuild a Btrieve file using the Rebuild Utility for further assistance.

Running the Stock fix Utility

  • Open the Pastel installation folder e.g. Pastel19 and double click on the file FixStkV19.exe
  • The ‘Fix Inventory Quantity’ screen will display:

  • Double click on the company that you want to fix and click on Fix Quantity

  • The below message will display:

  • Click on OK
  • The Stock Fix will process the files to check for error and create an Error Report
  • Once the process is done, the message below will display

  • Click on No
  • Navigate to your company folder and look for the file StkFix.txt
    • If there are any errors regarding missing items, you will need to recreate the items in your company before you run the Stock Fix
    • If there are any errors regarding blank group, you need to open the company, go to Edit inventory, select the item with issue, select the store as mentioned on the error report, take note of the inventory group, change the inventory group to something else, save changes, change the inventory group back to what it was and save changes. 
      Run the stock fix again to see if the error is cleared.
    • If there are errors regarding items not balancing run the Stock Fix
  • After the StkFix.txt has been checked and any errors received rectified re-run the Stock Fix Utility
  • When the message asking ‘Do you want to continue to fix the data’ displays click on Yes
  • The message below will display once the Stock Fix is complete

  • Click on OK
  • Open your company in Sage 50cloud Pastel Accounting
  • Check the inventory quantities to ensure they are correct.

If you still have issue please contact our Support Team on [email protected] for further assistance. 

 

Steps to duplicate
Related Solutions