Error while posting a purchase order

poppins

Hi everyone,

While trying to post a purchase order, I got the following error message:

The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. 
Check where and how the CONSISTENT function is used in the transaction to find the reason for the error.

Contact your system administrator.

Tables can be marked as inconsistent during comprehensive tasks, such as posting. 
This prevents data from being updated incorrectly.

What can possibly cause that?

rafal

Error was discussed here many times, I think you should search mibuso again.

Probably you are getting this error because the total of the Debit amounts is not equal to the total of the Credit amounts anymore in the G/L Entries, which is caused by your changes in the code, or rounding differences..

poppins

rafal wrote:

Error was discussed here many times, I think you should search mibuso again.

Probably you are getting this error because the total of the Debit amounts is not equal to the total of the Credit amounts anymore in the G/L Entries, which is caused by your changes in the code, or rounding differences..

From what i understood, it's a rounding issue...but how to solve it??

rafal

You have a standard database without custom modifications? What version of NAV, which build ?

Luc_VanDyck

TIP: Use this code to see which amounts will be posted, so it might become easier to pinpoint the problem: How to see why you are getting CONSISTENCY Error