Incosistency Error while posting to G/L in Nav. 3.10A

Sbhat

Hi Folks,

I have three of my clients reporting similar a problem which is when they try to Invoice a Sales order or Purchase order in Navision version 3.10A, they get a error message which says 'Incosistency will be be caused in G/L entry table and cannot complete the transaction'.

Is anyone aware of this issue and does anyone have a workaround to this problem. I have contacted Microsoft about this problem and its been weeks they havent got back to me on this.

Any help is highly appreciated.

Thanks
Best regards
Suresh
NY.

eromein

workaround?

I think you should just fix this.

Due to developments (likely) posting a order will course you balance to be "off balance". This means, if you would make a workaround, the G/L will not be correct anymore.

Just check all development that generate g/l entries. and make sure ebery posting is balanced!

Savatage

We get that also...it can be a pain. We were told that it might be a tax issue. so in the payables setup there is a check box that says "allow tax difference". this didn't work 100% of the times either. So we noticed that due to the fact the some of the items when to the 4th decimal digit (ex. 50.4132) it caused a problem when posting and would give that message.

so the quick fix for us - might not wotk for you..is

change all the prices to 2 decimal digits (50.4132->50.41)

..it shouldn't be the way but we have to post & pay bills - we didn't have all week to ponder all the causes and our NSA really had no exact solution.

lakshmivalluru

Hi everyone,

This inconsistency error can be because of difference in rounding as well as missing a posting to an account.One way to find out is goto codeunit 12, initglentry function.there u will find the glentry.amount := amount;
write a message statement message('amount %1',glentry.amount);save the codeunit.
now try posting the sales order/ purchase order which is giving the error.
note down the amounts displayed..u will get the difference...so the difference may be in decimals whcih is rounding error and if the difference is more than 1 then it might be a missing account.

try it...worth giving a go....

Savatage

Document ID: 31468
Date Created: 6/18/2003
Product: Navision
Versions: 3.10A, 3.10B, 3.6, 3.7
Modules: Purchases and Payables, Sales & Receivables, Sales Tax

Issue

Several reports of inconsistency errors on Sales and Purchase Invoice posting have occurred when dealing with Sales Taxes in 3.60.

In all of the cases, the problem is with a penny rounding issue related to taxes. The lingering rounding issue would result in the G/L Entry posting not balancing to zero by a penny. Therefore, an inconsistency error is generated.

Potential Causes

In the majority of reported cases, the issue involved a Sales Order with Sales Tax included. The Sales Order Lines include several positive line and then a separate negative line is entered for some type of discount. A separate negative line is being used instead of a Line Discount. The system can run into rounding problems because the system was not designed to handle a rounding process that deals with negative and positives lines.

A second issue has occurred in Canada where a mix of Expense/Capitalize and non-Expense/Capitalize tax lines exist on the Purchase Order. The same steps apply to purchase transactions as provided below for sales transactions involving sales tax.

Workaround

The following workaround in 3.60 can be used until Development comes up with a more permanent fix.

To resolve this issue, use the following steps:

1. Go into S&R Setup and check the box for Allow Tax Difference.

2. Go into G/L, Setup, G/L Setup on the Application Tab and enter any small decimal (.01, .05 or .10) for the Max. Tax Difference Amount.

3. Go back to the SO and select F9 statistics and go to the Invoicing Tab.

4. Manually change a line that may be at a half-cent. This is normally the problem line.

5. You should now be able to release the Order and post the Invoice.

Any time you are dealing with a mix of negative and positive lines on a Sales Order, there is a possibility that you will need to follow the above steps to deal with the rounding issues that have not been completely resolved