the transaction cannot be completed because it will cause inconsistencies in the g/l entry table NAV

pruebasEx
pruebasEx Member Posts: 51
edited 2017-08-24 in NAV/Navision Classic Client
Hi,

In NAV 5.0 SP1 I get this error message when I try to POST an Sales Invoice



the transaction cannot be completed because it will cause inconsistencies in the g/l entry table NAV 5.0 SP1
msh145my0ub0.png

It only happens when I try to post an Invoice with a G/L Account (only found problem with one G/L Entry 7000000001).

When I try to post next time works ok, and posts the invoice with no errors.


I saw some threads talking about same problem, but not NAV 5.0 SP1...

I applied this fix to see a list of GL lines Inconsistency


You can see results here
td99m96edu38.png

Best Answer

Answers

  • AntHillMob
    AntHillMob Member Posts: 79
    I'll translate NAV's worst error message for you :smiley:

    The document you are trying to post is trying to post out of balance entries to the G/L. NAV will prevent this as an incorrect posting. You will need to look at the accounts that will get updated be the post and see what accounts are getting updated and try and work out why this will cause an out of balance posting.
  • pruebasEx
    pruebasEx Member Posts: 51
    edited 2017-08-24
    AntHillMob wrote: »
    I'll translate NAV's worst error message for you :smiley:
    :neutral:

    The document you are trying to post is trying to post out of balance entries to the G/L. NAV will prevent this as an incorrect posting. You will need to look at the accounts that will get updated be the post and see what accounts are getting updated and try and work out why this will cause an out of balance posting.

    And why the second time I try to post, there's no error?
  • AntHillMob
    AntHillMob Member Posts: 79
    Are you sure nothing was refreshed between postings?
    Looking at the entries you have shown there is no balancing account for the payment.
  • pruebasEx
    pruebasEx Member Posts: 51
    David_Singleton wrote: »
    Very often this error happens when calculating Sales TAX, VAT GST etc. Often because of incorrect rounding, or sometimes because the last line is incorrectly rounded which is why it works the second time. Go into SQL and take a look at the actual decimal amounts un-rounded and see if there is a miss match.

    finally, it was some strange behaivour when calculing VAT from different countries.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    pruebasEx wrote: »

    finally, it was some strange behaivour when calculing VAT from different countries.

    B)

    David Singleton
  • Ephraim_07
    Ephraim_07 Member Posts: 9
    Check that the VAT posting group field on the journal line has been filled. If it has been filled on the GL account card it will auto pull to the Line and try and post VAT with rounding.

Categories