INCONSISTENCIES IN G/L ENTRY TABLE ERROR:

One of our client is using Navision 4 sp1. At the time of posting the Sales invoice the following error occurs:

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 manager if you need assistance.

Parts of the program mark tables as inconsistent during very comprehensive tasks, such as posting. This prevents data from being updated incorrectly.

Note: if i remove the structure and post the invoice, the sales invoice gets posted.

Please tell me how to rectify this error.

Hi,

I guess you need to debug your code. The CONSISTENT function check the Balance Amount and Balance ACY.

Regards,

-TR-

If you are adding any structure plz check the same & select the correct one again. It can be one possiblity of this error

vikash