Use the stock fix utility in Sage 50cloud Pastel
Description
Cause
Resolution

 

Ask all users to log out of the company. Back up your company data and rebuild these files before you run the stock fix.

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

See Process a backup in Sage 50cloud Pastel and Rebuilding a file.

Step 1: Run the stock fix utility and generate the error report

  1. Press the Windows key + E to open File Explorer.

  2. Go to your Local C: drive.

  3. Open the folder for your version:

    • Partner: Pastel19 (or Pastel18, and so on)
    • Xpress: Xpress19 (or your version equivalent)
  4. Double-click FixStkVxx.exe, where xx matches your version number.

  5. Select the company you want to fix.

  6. Select Fix Quantity.

  7. When Sage 50cloud Pastel offers to create the error report, select OK.

  8. Select No when the report finishes.

Step 2: Review the error report

  1. Go to your company folder.
  2. Open stkfix.exe.
  3. Address each type of issue in the report:
    • Missing items: Create the missing inventory items
    • Blank groups: Edit the affected items and assign a new group
    • Quantities not balancing: The stock fix handles these in step 3

Step 3: Re-run the stock fix to apply the corrections

  1. Repeat Step 1 to open the stock fix utility again.
  2. Select the same company.
  3. Select Fix Quantity.
  4. Select Yes to fix the data.
  5. Select OK to finish.

Check your inventory

  • Run the Inventory Activity and Inventory History Item Sequence reports
  • Confirm the values now match
  • Run the Count Inventory to confirm quantities update correctly

If problems continue

Contact Sage Support. Have the following ready:

  • Your customer number
  • A description of the inventory issue

 

Steps to duplicate
Related Solutions