mibuso.com

Microsoft Business Solutions online community
It is currently Wed Sep 03, 2014 6:44 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: [Solved] General Journal Lines disappeared
PostPosted: Fri Aug 03, 2012 9:57 pm 
Offline

Joined: Thu Dec 01, 2011 1:30 am
Posts: 67
Country: United States (us)
Dear Experts

Our client is using NAV 2009 R2.
Users reported that general journal lines get deleted before posting.

*************************
The user did provided us with a test report.
We checked Change log and did not find any deletion of general journal lines that are the same as the one.
We checked G/L entries and confirmed the journal lines are not posted.
*************************

Based on the above investigation, I think the journal lines get deleted by the system.
May I know whether any of you have experienced the same issue?
Is there any limitations on how many days NAV will keep general journal lines?
Any suggestions on how to fix the issue?

Thank you.

Li


Top
 Profile E-mail  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Fri Aug 03, 2012 10:04 pm 
Offline

Joined: Sat Feb 18, 2012 2:42 am
Posts: 54
Location: Portland, OR
Country: United States (us)
Hi, G/L lines don't normally disappear and there is no time/day limit on them either. I would look into any filters that are set (intentionally or accidently). I would verify the batches, too. They can be entering info in different batch names. Start with the obvious stuff first. If they get error messages, that would help us, too. Good luck!


Top
 Profile E-mail  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Fri Aug 03, 2012 10:06 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 7061
Location: L.I., New York
Country: United States (us)
Did you check if they exist in the General Journal Line Table?

Perhaps they have a filter on that's preventing them from seeing the lines?

Nav doesn't delete lines after a certain amount of time.

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


Top
 Profile E-mail WWW  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Fri Aug 03, 2012 10:08 pm 
Offline

Joined: Thu Dec 01, 2011 1:30 am
Posts: 67
Country: United States (us)
I have checked general journal lines and did not find the journal lines shown on the test report.

The thing is the journal lines are not shown in change log either.

That is why I assume it is deleted by the system.


Top
 Profile E-mail  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Fri Aug 03, 2012 10:27 pm 
Offline

Joined: Sat Feb 18, 2012 2:42 am
Posts: 54
Location: Portland, OR
Country: United States (us)
I agree with Savatage. Take a look at the Gen. Journal Line table (ID 81) and see if the lines are present there.


Top
 Profile E-mail  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Fri Aug 03, 2012 10:32 pm 
Offline

Joined: Thu Dec 01, 2011 1:30 am
Posts: 67
Country: United States (us)
Thank you for your comments.
I did check gen. journal line table (81)and confirmed the journal lines shown on the test report is not there..


Top
 Profile E-mail  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Fri Aug 03, 2012 11:22 pm 
Offline

Joined: Mon Mar 12, 2007 3:07 pm
Posts: 360
Location: Hamburg
Country: Germany (de)
Check customised functions for deletes of journal lines. Start with reports, codeunits,...

Maybe there is a modification where someone wanted to use a temporary variable but forgot to set the temporary property. Or someone forgot a filter in a function where journal lines are deleted.

kelseykong wrote:
Our client is using NAV 2009 R2.
Users reported that general journal lines get deleted before posting.
...
Is there any limitations on how many days NAV will keep general journal lines?
Any suggestions on how to fix the issue?

Are you the NAV partner?? :shock:

_________________
Frank Dickschat
FD Consulting


Top
 Profile E-mail WWW  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Mon Aug 06, 2012 6:52 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 5012
Location: Los Angeles, CA
Country: United States (us)
No, what you described is not standard NAV. I would get with your partner and tell them to look into this. My bet is that it's a bug they created.

NAV will not record the change log if the record was deleted using code unless specifically told to do so.

The person that made the modification probably forgot to use filters when he/she used DELETE or DELETEALL.

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Wed Aug 08, 2012 3:23 pm 
Offline

Joined: Thu Dec 01, 2011 1:30 am
Posts: 67
Country: United States (us)
Thank you Alex.
We have confirmed the issue is caused by a customization.
Li


Top
 Profile E-mail  
 
 Post subject: Re: General Journal Lines disappeared
PostPosted: Wed Aug 08, 2012 7:22 pm 
Offline

Joined: Sat Feb 18, 2012 2:42 am
Posts: 54
Location: Portland, OR
Country: United States (us)
Hi Li, thanks for the update


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

All times are UTC + 1 hour [ DST ]


Who is online

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