mibuso.com

Microsoft Business Solutions online community
It is currently Thu Nov 27, 2014 3:40 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: [Solved] Increment Receipt No.?
PostPosted: Tue Mar 20, 2012 7:50 pm 
Offline

Joined: Fri Sep 30, 2011 6:04 pm
Posts: 359
Country: Canada (ca)
I think I have been looking at this ReceiptNo. problem all wrong.

This is what I want to do basically. Maybe you guyz can suggest me a way of doing it.

In my report, I have created a field call ReceiptNo. When you run the report for the first time, ReceiptNo. is 1. Only if the report is printed, then the ReceiptNo. is incremented. The next time user runs the report, the ReceiptNo. should be 2 and so on. If it is printed, then ReceiptNo. should increment again and so on.

Therefore, the ReceiptNo. only incremements if a report is printed.

What is the easiest way to implement this in my report?


Last edited by nverma on Sun Mar 25, 2012 6:06 pm, edited 1 time in total.

Top
 Profile E-mail  
 
 Post subject: Re: Increment Receipt No.?
PostPosted: Tue Mar 20, 2012 7:54 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 8:01 pm
Posts: 7069
Location: L.I., New York
Country: United States (us)
So this is different from your other post?
viewtopic.php?f=23&t=52362

If the variable is on the report it will always start as zero.
I thought you wanted to save the value somewhere?

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


Top
 Profile E-mail WWW  
 
 Post subject: Re: Increment Receipt No.?
PostPosted: Tue Mar 20, 2012 7:57 pm 
Offline

Joined: Fri Sep 30, 2011 6:04 pm
Posts: 359
Country: Canada (ca)
It is the same topic. But I am trying to find another way of doing it since I am struggling to implement the No. Series to increment the ReceiptNo.

No. Series method was suggested by my manager. But he is out of town, and this report needs to be finished asap.

I was thinking maybe there is another way of doing this. Any ideas?

I dont really need to save anything. I just need to only incrememnt receiptno. if the report was printed.


Top
 Profile E-mail  
 
 Post subject: Re: Increment Receipt No.?
PostPosted: Tue Mar 20, 2012 8:22 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 8:01 pm
Posts: 7069
Location: L.I., New York
Country: United States (us)
If you don't save the value of the number of times the report was printed then how do you expect it to know?

Then you want it count number of times printed, but in the next sentance you don't care if it resets?

How can we help when it appears your not even sure what's supposed to happen.
Is this report Like an Invoice or some report linked to some table?
Then see "No. Printed" (field 47) in the Sales Invoice Header table (Table #112).

if it's just the aging report then you have to ask yourself why is that so important.

If you don't explain what you are trying to achive then you can't get a complete answer.

Surprise your senior with the Report Logging table from the other post. Then all you have to do is create a report based on the Report log table that you can filter on ANY report # and find our how many times it's been run and who's been running it. Extending the functionality 10fold over a simple count.

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


Top
 Profile E-mail WWW  
 
 Post subject: Re: Increment Receipt No.?
PostPosted: Tue Mar 20, 2012 8:41 pm 
Offline

Joined: Fri Sep 30, 2011 6:04 pm
Posts: 359
Country: Canada (ca)
I guess, we can try to keep track of number of times a report has been printed. This is the only report that I need to keep track of.

Is there any other table or report that sorta mimics this behavior, so it will be easier to implement caz I am not sure where to even begin developing this.


Top
 Profile E-mail  
 
 Post subject: Re: Increment Receipt No.?
PostPosted: Tue Mar 20, 2012 8:42 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 8:01 pm
Posts: 7069
Location: L.I., New York
Country: United States (us)
Savatage wrote:
Then see "No. Printed" (field 47) in the Sales Invoice Header table (Table #112).

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


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

All times are UTC + 1 hour


Who is online

Users browsing this forum: Google [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: