Inventory Module - Error while updating physical count variance register

Howdy, Guys.

 

Recently, we upgraded MAS90 from 4.40.0.4 to 4.40.0.8.

 

There were little problems - nothing major - until today.

 

Halfway through the year, we like to cycle count our serialized inventory.  To do this, we copy the live data into a 'test' company, enter the correct count, and then check the variance register just to make sure everything is on track.

 

Today, I tried to do this, and I received an error, "Record '085622H' is missing from M:\MAS90\MAS_TST\IM_ItemWarehouse.M4T.'

 

Since I was using a test company and not concerned about corrupting my live data, I took this to mean that the record was corrupted (silly me), so I did a quick key & sort file rebuild on IM.  This did not work.

 

The next thing I tried was entering an inventory record with part number 085622H.  This WORKED, but then it came up with the next record that "wasn't there" - another part number.  I was able to enter several part numbers, but each time, it just jumped to a new part number that it apparently could no longer find.  I did about 20 of these, just wondering how far the list went.

 

These are not familiar numbers.

 

What's worse:  I narrowed the scope of the inventory freeze / post to a specific warehouse and some specific product lines, and the part numbers that it's erroring on are NOT part of those product lines.

 

Any ideas?  Anyone seen this?  I can post more information if you need it.  The error isn't going anywhere.

 

~RosieD

  • Have you searched the knowledgebase for the program name and line number associated with the error?

  • Yep.  Didn't find anything in the database, relating to this error, specifically.

     

    Program: CI_TierCostCalc.pvc, Line 791.

     

    Error #11:  Record not found or Duplicate key on write.

     

    (The error is that the part number isn't there, so the Physical Count Variance Register refuses to post.  Again, I didn't FREEZE that part number, nor did I try to enter a new quantity for it.) 

     

    I think the error popping may not really be indicative of what's actually going on.

     

     

  • Got a solution.  Had issues finding it though... had to get some help.  I thought I would post here in case anyone else had the same issues.

     

    ~~

     

    110-540886 - Error 11 CI_TierCostCalc.pvc 761

    Entry Type: Informational

    Product:
    Sage MAS 90 ERP
    Sage MAS 200 ERP

    Application: Inventory Management 

    Version Reported: 4.40 

    Subject:

    Error 11 CI_TierCostCalc.pvc 804 when trying to update the Physical Count Variance Register. file referenced is IM_ItemWarehouse

    Possible Resolution:

    Note: Use caution when working with reinitializing data files. Always make a backup first. If necessary, seek the assistance of a qualified Sage business partner, computer or network technician, Sage Customer Support analyst .

    On 4.40.0.8 and above:

    1. Navigate to the ....MAS90\Utility folder. 
    2. Copy the "IM_ClearCommitDataEntry_utl" file.
    3. Navigate to the ....MAS90\IM folder....
    4. Paste the "IM_ClearCommitDataEntry_utl" file.
    5. In MAS 90 or 200, Go to File / Run.
    6. Type in Syzcon.
    7. Type run "IM_ClearCommitDataEntry_utl" and hit Enter.
    8. Click Yes to "Warning: This utility Should not be run while registers have not been updated.  Do you want to Proceed?"
    9. Click Ok to the next window.
    10. Run the Physical Count Variance Register.

     

    ~~

     

    After this, the posting should go through.