Author Topic: Runtime error on stock take commands after doing April upgrade  (Read 5736 times)

0 Members and 1 Guest are viewing this topic.

toddynyoni

  • Newbie
  • *
  • Posts: 20
If I restore my backup on the April upgrade and try to run create snapshot or stock take adjustments, I get the following error; Runtime error '-2147217900 (80040e14).....The INSERT INTO statement contains the following unknown field name:StockTake_QuantityOrig'. Make sure you have typed the name correctly, and try the operation again. All the other filters and procedures are ok. When I restore my backup on the February upgrade everything works fine. Please assist, the April upgrade is great news.

Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 517
    • 4POS Point of Sale Solutions
Re: Runtime error on stock take commands after doing April upgrade
« Reply #1 on: May 01, 2011, 08:36:36 AM »
When you reload a backup, you MUST run the upgrade - 4POSDBConvert again. What you have done, is upgrade your 4POS software & THEN reloaded a backup before the upgrade!

When an upgrade is done, 4POS will create all new fields required to match the new upgrade. You simply can't then go & copy an old database back & expect it to work!

Please use your 4POS system wisely!