mibuso.com

Microsoft Business Solutions online community
It is currently Fri May 24, 2013 8:39 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Journal Line Dimension Disapearing
PostPosted: Mon Jul 12, 2010 6:41 pm 
Offline

Joined: Wed Jan 22, 2003 6:33 pm
Posts: 34
Location: Iceland - USA
Country: United States (us)
Hi guys,

I have a freaky situation going on here at one of my clients. Basically all the Journal Line Dimension are sporadically disappearing. The Dimensions on the Journal lines are still there, but there are no more Journal Line Dimension corresponding to it.

I activated the change log for the Journal Line Dimension and it wielded no results, the Journal Line Dimensions were still disappearing without logging anything about it.

That to me means that the being deleted without using the OnDelete() Trigger, the global one that is.
I have searched the system, using the Navision Toolkit for any lines that delete from this table without calling the trigger and there are a few, but all of them refer to a temp variable.

Can any of you think of another way to try and figure out what is going on?

_________________
Elmar F. Vidisson
Certified Navision Attain Developer


Top
 Profile E-mail  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Mon Jul 12, 2010 7:04 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6979
Location: L.I., New York
Country: United States (us)
are they using dataports to fill in journal lines and it's not validating the dimension field properly?

we can guess all day :roll:

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Mon Jul 12, 2010 7:05 pm 
Offline

Joined: Fri Oct 27, 2006 12:23 am
Posts: 36
Location: Calgary
Country: Canada (ca)
Which version is this on. I had this happening on 3.6 or 3.7 a while ago and was told this was a bug in the product. We ended up writing a utility to validate the journal dimension and had it run in the background before the posting.

Raj


Top
 Profile  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Mon Jul 12, 2010 7:13 pm 
Offline

Joined: Wed Jan 22, 2003 6:33 pm
Posts: 34
Location: Iceland - USA
Country: United States (us)
They are not using any dataports. The Journals get created correctly with the Journal Line Dimension filled in correctly, but then when they go to post, they have disapeared. sometimes it days between the creation of the journal and the actual posting.

There has to be a code that cleares these out somewhere in the system, I just don't know how to look for it.

_________________
Elmar F. Vidisson
Certified Navision Attain Developer


Top
 Profile E-mail  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Mon Jul 12, 2010 7:13 pm 
Offline

Joined: Wed Jan 22, 2003 6:33 pm
Posts: 34
Location: Iceland - USA
Country: United States (us)
This is on version 5.0

_________________
Elmar F. Vidisson
Certified Navision Attain Developer


Top
 Profile E-mail  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Tue Jul 13, 2010 6:34 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12265
Location: Brno
Country: Czech Republic (cz)
Try to enable client monitor and look there for deletion in this table. It will help you to find the correct spot in code...

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Tue Jul 13, 2010 11:37 am 
Offline

Joined: Mon Nov 27, 2006 11:47 am
Posts: 226
Location: Catalunya
Country: Spain (es)
elmarfv wrote:
I have searched the system, using the Navision Toolkit for any lines that delete from this table without calling the trigger and there are a few, but all of them refer to a temp variable.


Even if the variable contains the word "temp" on its name, have you checked that the Temporary property is set to Yes in all of them?

Salut!
Laura Nicolàs

_________________
Laura Nicolàs
Author of the book Implementing Dynamics NAV 2013
Visit my blog (english) : http://JoinNAV.wordpress.com/
Visit my blog (spanish) : http://TodoSobreNAV.blogspot.com/


Top
 Profile E-mail WWW  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Tue Jul 13, 2010 11:39 am 
Offline

Joined: Mon Nov 27, 2006 11:47 am
Posts: 226
Location: Catalunya
Country: Spain (es)
Also try to search for any DELETEALL and check if the proper filters are set before deleting.

Salut!
Laura Nicolàs

_________________
Laura Nicolàs
Author of the book Implementing Dynamics NAV 2013
Visit my blog (english) : http://JoinNAV.wordpress.com/
Visit my blog (spanish) : http://TodoSobreNAV.blogspot.com/


Top
 Profile E-mail WWW  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Thu Jun 07, 2012 8:04 am 
Offline

Joined: Wed May 06, 2009 1:23 pm
Posts: 17
Hi Experts!!!!

I know this post is pretty old, but unfortunately I am facing a similar issues in NAV 2009 R2. The dimension in the Journal Line Dimension table are vanishing. And the same does not replicate in the Test DB. I believe this is happening in a multi-user enviornment.

At the time of input of the entry in the General Journal, the user also generates the Test Report to verify if all the dimension are selected correctly, and the test report does not show any warnings, but when the user tries to post the journal, the dimension just disappears from Journal Line Dimension table, but they are available in the Shortcut dimension in the General Journal Table. And this is happening very unpredicatably.

Please provide some insight or any help,

Thanks in advance.


Top
 Profile E-mail  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Thu Jun 07, 2012 11:08 am 
Offline

Joined: Fri May 18, 2012 3:04 pm
Posts: 148
Location: Armenia, Quindio
Country: Colombia (co)
The answer is the same as posted before. There must be code somewhere that is deleting the journal line dimensions. This can be either a variable named as temp but does not have the Temporary property set to Yes, or some variable somewhere which is not properly filtered.
Example: Back in version 2.5 the US Payroll functionality had a function to accrue payroll costs incurred in the month but not paid until the next. In this process there were multiple GenJournalLine variables and there was one, lets say GenJournalLine4, which was only referenced once with this line:
Code: Select all
GenJournalLine4.DELETEALL;

There was nothing else so needless to say when the accrual process was run all the Gen. Journal Line records were deleted which included recurring journals of which my client had several hundred. Now this was in the standard product but in your case if it does not occur in standard then finding it should be easy - look at all the customizations and look for a variable that is deleting Journal Line Dimensions and is either
1) Variable that is meant to be temporary but is not
2) Not properly filtered before deleting.

_________________
Gerry Kistler
KCP Consultores


Top
 Profile E-mail  
 
 Post subject: Re: Journal Line Dimension Disapearing
PostPosted: Mon Aug 06, 2012 4:02 pm 
Offline

Joined: Wed May 06, 2009 1:23 pm
Posts: 17
Hi Gerry,

We have checked all the posibilities of the customization and have not found any code or variable which are not set to temp and deleting the dimension.

We have found that when the users are assigned the "Super" Roles, the dimension do not vanish or disappear, but even if we assign "Super (Data)" role to the same user, the dimension vanishes or disappears.

There is something related to the roles, however we have still not been able to figure out the reason for the same. We have also tried to create a new roles with all objects access to the users except for System 0, still the dimension disappears. But as soon as System 0 is added to the role, the dimension do not disappear.

Any insight might help!!!

Thanks


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

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 18 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: