mibuso.com

Microsoft Business Solutions online community
It is currently Sat May 25, 2013 12:02 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: [Solved] How to void a check after payment journal line is deleted
PostPosted: Mon Jul 16, 2012 5:38 pm 
Offline

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

One user reported that the check status is shown as printed in check ledger entries window, but the payment journal line doesnt exist any more.

May I know how could the payment journal line got deleted when check is printed but not posted? In addition, in this case, how could the user void the check? I tested to void the check from check ledger entries window, but the system will not allow me to void the check if the status is not posted.

Thank you so much for your advice in advance.

Li


Top
 Profile E-mail  
 
 Post subject: Re: How to void a check after payment journal line is delete
PostPosted: Mon Jul 16, 2012 5:52 pm 
Offline

Joined: Mon Jun 08, 2009 2:24 pm
Posts: 154
Location: Connecticut
Country: United States (us)
Are you certain there isn't a filter applied, or perhaps the user is looking in a different batch?

When you try to delete a line from the Payment Journal after the check is printed, you get an error saying "Check Printed must be No ....." The only way you'd be able to see the behavior you described is if the payment journal was modified to allow the deletion, which doesn't seem like a very good idea.

Adam


Top
 Profile E-mail  
 
 Post subject: Re: How to void a check after payment journal line is delete
PostPosted: Mon Jul 16, 2012 6:17 pm 
Offline

Joined: Thu Dec 01, 2011 1:30 am
Posts: 56
Country: United States (us)
Hi Adam

Thanks a lot for your prompt reply.

I just double checked all the batches, click the show all button, but did not find any filter applied.

This issue happens in the production company. I checked the testing environment that we prepared for our testing purposes, and found a similar situation when a check status is shown as printed, and is not assigned a bank ledger entry number, but doesnt exist in any batch.

Li


Top
 Profile E-mail  
 
 Post subject: Re: How to void a check after payment journal line is delete
PostPosted: Mon Jul 16, 2012 7:12 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 4858
Location: Los Angeles, CA
Country: United States (us)
Did the check the Status and make sure it's not already set to VOID?

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


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to void a check after payment journal line is delete
PostPosted: Mon Jul 16, 2012 7:36 pm 
Offline

Joined: Thu Dec 01, 2011 1:30 am
Posts: 56
Country: United States (us)
Hi Alex

Yes, I did check the status of the check and it shown as "Printed". And no entry exists in Bank Account Ledger entries window.

I am also quite confused how could that happen.

Since there is no way to delete a payment journal line when the check is printed and posted, I tested to delete the journal batch, but was not allowed to process either.

Li


Top
 Profile E-mail  
 
 Post subject: Re: How to void a check after payment journal line is delete
PostPosted: Mon Jul 16, 2012 8:34 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)
So in the "Check Ledger Entries" You have "Entry Status" showing "Printed".

And the check is not in any batch?

If you view the TABLE (81) Gen. Journal Line can you find the check line that way?

If the "Check Printed" field = YES then you can't delete the line.


Attachments:
delete entry.JPG
delete entry.JPG [ 11.9 KiB | Viewed 414 times ]

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org
Top
 Profile E-mail WWW  
 
 Post subject: Re: How to void a check after payment journal line is delete
PostPosted: Mon Jul 16, 2012 8:47 pm 
Offline

Joined: Thu Dec 01, 2011 1:30 am
Posts: 56
Country: United States (us)
Thanks a lot for your information.
I just double checked the general journal lines, and could not find the lines for the "Printed" checks.

Although when testing, I got the same error when trying to delete a journal line with check status as printed, I believe there is some way to delete journal lines.


Top
 Profile E-mail  
 
 Post subject: Re: How to void a check after payment journal line is delete
PostPosted: Mon Jul 16, 2012 10:42 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)
Perhaps a developers license right from the table. But who would do that and not say anything? :-k

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


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to void a check after payment journal line is delete
PostPosted: Tue Jul 17, 2012 12:35 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 4858
Location: Los Angeles, CA
Country: United States (us)
kelseykong wrote:
Thanks a lot for your information.
I just double checked the general journal lines, and could not find the lines for the "Printed" checks.

Although when testing, I got the same error when trying to delete a journal line with check status as printed, I believe there is some way to delete journal lines.



Looks like the entry was deleted either by a developer or a process only report deleted the record without validation.

Nonetheless, you will need to get your partner on this.

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


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

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 8 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: