mibuso.com

Microsoft Business Solutions online community
It is currently Fri Oct 31, 2014 4:39 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: INCONSISTENCY IN G/L ENTRY TABLE
PostPosted: Thu Mar 22, 2012 8:07 am 
Offline

Joined: Sat Dec 19, 2009 12:41 pm
Posts: 391
Country: India (in)
hi experts

I am getting following message ,The transaction can not be completed because it will inconsistencies in the g/l entry table during jobwork cancellation .


Top
 Profile E-mail  
 
 Post subject: Re: INCONSISTENCY IN G/L ENTRY TABLE
PostPosted: Thu Mar 22, 2012 8:16 am 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 9:13 am
Posts: 7705
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]

The total amount of the G/L Entry should always be 0.
If you are writing entries to it and the total is not 0 and you want to COMMIT it, you will get this error.
In general it means there is some bug in the customized code. (a record is not written, or a record too many is written. A bug in the calculation of the amount,rounding errors,...).
If there is no customized code in any point, it probably is a bug in the base.

The only way to find out is to use the debugger and following every write to the G/L Entry table (you can start to debug every time codeunit 12 is entered (this is the one that writes to the G/L Entry.

BTW: another way to help you debugging: if you are on SQL, you can try this trick: just before the COMMIT that generates the error. Do a FINDFIRST on the G/L Entry to force NAV to write all records it has in the buffer to the table. Then add "IF NOT CONFIRM('Continue?',FALSE) THEN ERROR('STOP'); The CONFIRM waits for a confirmation before doing the COMMIT. Opening another session you can see what this session has written in G/L Entry. DON'T DO THIS IN PRODUCTION BECAUSE YOU ARE BLOCKING EVERYONE!

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: INCONSISTENCY IN G/L ENTRY TABLE
PostPosted: Thu Mar 22, 2012 8:41 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Aug 14, 2001 6:01 am
Posts: 5349
Location: Prague
Country: Czech Republic (cz)
kriki wrote:
...
The only way to find out is to use the debugger and following every write to the G/L Entry table (you can start to debug every time codeunit 12 is entered (this is the one that writes to the G/L Entry.

BTW: another way to help you debugging: if you are on SQL, you can try this trick: just before the COMMIT that generates the error. Do a FINDFIRST on the G/L Entry to force NAV to write all records it has in the buffer to the table. Then add "IF NOT CONFIRM('Continue?',FALSE) THEN ERROR('STOP'); The CONFIRM waits for a confirmation before doing the COMMIT. Opening another session you can see what this session has written in G/L Entry. DON'T DO THIS IN PRODUCTION BECAUSE YOU ARE BLOCKING EVERYONE!


or a MUCH better way would be to search mibuso for Rashed's trick to solve this.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: INCONSISTENCY IN G/L ENTRY TABLE
PostPosted: Thu Mar 22, 2012 8:48 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Aug 14, 2001 6:01 am
Posts: 5349
Location: Prague
Country: Czech Republic (cz)
viewtopic.php?f=5&t=22748

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: Exabot [Bot] and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: