Hi has anyone ran into this problem?
"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 prevent data from being updated incorrectly."
am getting this error during posting, using nav ver 3.7
Thanks!
0
Comments
Mike
we have this happen on a regular basis on Sales credit memos, when the sales tax for a jurisdiction calulated exactly to three digits and the last digit is exactly a half penny. it causes this problem,
so for example, you have an item that sells for $100 and a tax rate of 8.735% the tax calculates to 8.735
the line in the sales order rounds it correctly to $108.74, but the program is trying to post the tax at the full three digits, thus the inconsistency.
the official fix we received from Microsoft, was to hit F9 statistics on the order we have the error on, go to the invoicing tab, and you will see the tax posting detail lines, manually change the 8.735 to 8.74, and all will be good to go.
Try opening the sales order and go to the last line, and add one more line, a blank comment. The tax rounding (<$0.0049) will apply to it and become zero, and null out the error.
For any queries you can also visit my blog site: http://msnavarena.blogspot.com/
Yeah it's a horrible error isn't it. Very inconsistent. I have one customer that on some orders they hit F9 and then the tax field, sometimes they have to add a blank line at the end, and in worst case they sometimes need to Partially invoice :shock:
Well its time for sure for them to upgrade.
:shock:
Ok that is not acceptable. I have not seen this issue unresolvable since 3.10 did you have a full upgrade to 4.00?
I know your signature changed, so I guess you did an upgrade, but was it a full upgrade?
You have every right to stamp your feet and start yelling
It just doesn't come up often for most people, because everything has to be just right for it to occur, the tax rates have to be out to at least four digits, the sales document has to be a certain dollar amount
Now we only get it on a sales credit, for our Fresno store which has a tax rate of 8.375% and it only happens when an invoice is for an an odd $100 increment, such as 100, 300, 500 ect. Now we just so happen to sell auto parts with a core charge of $300 for a lot of items, so every time a $300 core from a taxable customer get returned to our Fresno store, I get an email from a user saying they can't post the credit memo because of some inconsistancy error message.
just had one this morning.
Now I could pay our solution center to program a change, around $500, but I refuse out of some misguided notion that I shouldn't have to pay (beyond the 16% annual maintenace I already pay) to fix a know problem