Error while creating validation routine

FishermanFisherman Member Posts: 456
Question for the gurus.

I've written a routine to automate a couple of things off of the Item card. We plan to use Inventory Value Zero for one of our areas of business where we carry materials at zero cost on our books, and only have to account for quantities and lots.

In order to ensure that AP and AR ledgers are also controlled, I've added some code to the OnValidate() trigger for Inventory Value Zero on a test database on my machine, that no one else is using, that attempts to create/delete sales and purchase line discounts for the current item when the user check/unchecks the box. I say attempts because, if they haven't filled in enough information, I have it set to error out.

Every so often, though, after checking/unchecking the box to test the code, I get the following message...

Microsoft Business Solutions-Navision
Another user has changed the definition of the Field table after the activity was started.

Start again.

OK

I find it doubtful - since no one else is using my database. Any explanations?

Comments

  • WaldoWaldo Member Posts: 3,412
    <edit>

    Sorry ... didn't read the error message very well ... my post was rubbish :oops:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • FishermanFisherman Member Posts: 456
    not much - we're actually still running SP2.

    Since Microsoft sees fit to release full version replacements and call them "Service Packs", I've not felt like replacing everything again.
  • WaldoWaldo Member Posts: 3,412
    Fisherman wrote:
    not much - we're actually still running SP2.

    Since Microsoft sees fit to release full version replacements and call them "Service Packs", I've not felt like replacing everything again.

    Microsoft gives you with the "full release" the option of:
    - Start with full updated database
    - upgrading the runtime
    - only updated objects you can export
    All by giving just an fdb file with all objects and an up-to-date version list \:D/

    So, in your case ... just export all objects with filter on Version list: *4.00.03*. Then you have your "service pack".

    Also, just try to update (only runtime) your test environment and see if it helps... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • dbdb Member Posts: 82
    Our Client suffering from this too.
    It's look's like Change log is cause of problems.
    Scenario:
    1. Change log is ON.
    2. Modify OBJ
    3. Modifying obj record, navision cause errors
    4. Switch OFF change log -> OK
    5. Change log to ON -> OK too.
Sign In or Register to comment.