Error

Navi_Learner

Last week When we tried to post the invoice, it pops up the error message saying the transaction cannot be completed because it will cause inconsistencies in the G/L Entry Table. Parts of the program mark tables as inconsistent during very comprehensive task, such as posting. This prevents data from being updated incorrectly. How to solve this problem? Thanks in advance!

ara3n

In codeunit 12 there is a function called
FinishCodeunit

after the line GLEntry.INSERT; put a new line

Something like message(GLEntry."G/L Account NO." + ' ' + format(GLEntry."Amount"));


write down all the messages when you try to post. Add them up and see why they don't add up to zero.

Most of the time it's a taxing issue. If it is. change the tax amount by one cent or something. If it is not. Write down the Message and maybe we can help. Also it's helpfull to tell what version you are working with.

Navi_Learner

Our version is 4.0. Actually the error happens when we post the returned orders

Savatage

http://www.mibuso.com/forum/viewtopic.php?t=7283
http://www.mibuso.com/forum/viewtopic.php?t=7374

I'm sure there are few more posts about inconsistency

Navi_Learner

I can't open code unit 12 as I don't have the access right. What shall I do?

themave

Navi Learner wrote:

I can't open code unit 12 as I don't have the access right. What shall I do?

you should have your solution center fix this problem, you pay a outrageous annual fee to Microsoft, why should you be forced to fix a program error?

Navi_Learner

I checked the amount and there's no decimal issue. Actually We once reverce the posting to this customer. Is it the reason?

Navi_Learner

We do the invoice and credit all the time, but why this time it happens when we post the credit ? If I can't open the code unit, what shall I do? Please help!

Navi_Learner

I read the reference by Harry, but it doesn't work. It's very urgent and can anyone help me?

Marije_Brummel

This is not realy a problem that can be solved via this board without extra information.

What I would need to solve this problem is access to the database with the debugger to analyse.

You realy should contact your NSC for this.

One last thing you can try is to make a copy of the database, take a posting that does work and compare the data in the tables to each other to see if you can find a difference.

Good luck!

Savatage

We had a wierd one of these the other day.

Usually the problem line is obvious. Show all the fields & look for one that has multiple decimal places.

F9 the statistics and look at that! see if anything looks strange.

The weird one we had wouldn't post even though it also had no extra decimal places. I'm trying to remember but I think we "Opened" Un-released the order and tried to post it & it posted.

Navi_Learner

But the invoice is posted successfully. What we are doing is to post the credit memo. What shall I do?

themave

try deleting the credit memo, and starting a new one.

Savatage

Navi Learner wrote:

But the invoice is posted successfully.

Who's post are you referring to?? Did you try to un-relase the order & see if the credit posts?

Are you wiping out the invoice using "Copy Document" Or it's just a small credit against the invoice as if one of the items arrived damaged?

Navi_Learner

One customer ordered one item and then returned it later on. Why the new version 4.0 has this problem? Right now we try all the way and still can't solve this problem. Thanks, Harry!