<div dir="ltr"><div>Well this is front ended with processing that asks for a client number range and a date range -- so hard to determine those things until the records are selected for the criteria provided....someone could ask just to print one specific client or a range of clients and about any date range you can imagine, so the last suggestion of a 1 or 0 wouldn't really work - because for a date range of two months ago, they very well could have been owed and not a credit balance</div>
<div> </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jul 12, 2013 at 10:42 AM, Richard D. Williams <span dir="ltr"><<a href="mailto:richard@appgrp.net" target="_blank">richard@appgrp.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On 7/12/2013 9:04 AM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
> Still having issues with this<br>
><br>
> This processing is subtotaled and has @wbrk1 where it does the calculating<br>
> The premise is the 'top' part of the report prints line detail from the<br>
> payment file - then @wrbk1 calculates the totals, if they owe us or we owe<br>
> them<br>
> I have tried putting different logic in place including a running variable<br>
> on 'balance' and if it's negative not to print etc<br>
> >From what I can see the 'print' command only works on 'records' and not<br>
> once processing is finishing and it's spitting out the report?<br>
><br>
> I can post the code if that would help - just trying to figure out can I<br>
> even prevent printing once it gets to @wbrk1 ? Or do I need to 'kill' the<br>
> print BEFORE it gets there?<br>
><br>
> thanks<br>
> Scott<br>
> PDM<br>
><br>
><br>
><br>
><br>
> On Tue, Jul 9, 2013 at 11:52 AM, Nancy Palmquist <<a href="mailto:nlp@vss3.com">nlp@vss3.com</a>> wrote:<br>
><br>
>> Scott,<br>
>><br>
>> getenv("PFPRINTER") is one way to find out what is loaded into that<br>
>> variable.<br>
>><br>
>> However, if it is not set and the default is running, you can get the<br>
>> current printer from @pr (Current printer name) or @pt (current printer<br>
>> type)<br>
>><br>
>> My gotcha's:<br>
>><br>
>> Be sure you never name printers the same as tables. Filepro is clever<br>
>> enough to print to any printer that has a given table assigned. So if<br>
>> you have a number of printers with a table called "laser" you can direct<br>
>> output to "laser" and it will turn up on one of those printers in the<br>
>> queue. A neat trick but annoying if the printer you want is next to you<br>
>> and it never prints.<br>
>><br>
>> If you change the printer name in processing, also set the printer type.<br>
>><br>
>> I know FilePro will assume but I find it always a better rule to be<br>
>> clear as to what you want. Saves much troubleshooting.<br>
>><br>
>> Nancy<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> On 7/9/2013 10:01 AM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
>>> I have some processing that prints our statements each month and it's<br>
>>> worked fine with no problem for years.<br>
>>><br>
>>> The PFPRINTER is set through a menu the user passes through, so they have<br>
>>> the option to printer to 3-4 different printers....no problem there<br>
>>><br>
>>> Now we've gotten more and more clients with a <credit balance> so I want<br>
>> to<br>
>>> be able to set PFPRINTER to 'null' if there is <credit balance><br>
>>><br>
>>> So, is there a way to set a variable to whatever PFPRINTER is set to when<br>
>>> the user executes the processing.....then put a GOSUB if it's a <credit><br>
>>> that will set PRPRINTER=null<br>
>>> If it's NOT <credit balance> then I want to obviously reset PFPRINTER to<br>
>>> whatever it was when user executed the command....<br>
>>><br>
>>> I haven't been able to figure out how to get the 'value' of PFPRINTER<br>
>>> pulled into processing to be able to 'manipulate' it?<br>
>>><br>
>>> Thanks<br>
>>> Scott<br>
>>> PDM<br>
>>> -------------- next part --------------<br>
>>> An HTML attachment was scrubbed...<br>
>>> URL:<br>
>> <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20130709/67e18e99/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20130709/67e18e99/attachment.html</a><br>
>>> _______________________________________________<br>
>>> Filepro-list mailing list<br>
>>> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
>>> Subscribe/Unsubscribe/Subscription Changes<br>
>>> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
>>><br>
>> --<br>
>> Nancy Palmquist MOS & filePro Training Available<br>
>> Virtual Software Systems Web Based Training and Consulting<br>
>> PHONE: <a href="tel:%28412%29%20835-9417" value="+14128359417">(412) 835-9417</a> Web site: <a href="http://www.vss3.com" target="_blank">http://www.vss3.com</a><br>
>><br>
>> _______________________________________________<br>
>> Filepro-list mailing list<br>
>> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
>> Subscribe/Unsubscribe/Subscription Changes<br>
>> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
>><br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
</div></div>> URL: <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20130712/ab257741/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20130712/ab257741/attachment.html</a><br>
<div class="im">> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
><br>
><br>
</div>Scott,<br>
<br>
Why don't you place variables in your sub-total/total area and just not<br>
fill them in if the balance is negative.<br>
That would simply stop the printing of the total area.<br>
<br>
I think you may want to not print your detail if the balance is negative.<br>
You can do that in your selection process before the records are<br>
selected for that client/customer.<br>
That would require you to calc the bal due on each record. Too much time.<br>
<br>
The best way is you use a process only on a blank record somewhere using<br>
*clerk.<br>
From this record you can lookup into your customer/client file and get<br>
each client/customer and calc. the balance due.<br>
If it is negative, do a getnext and check the next client/customer.<br>
But if it is positive, execute a system command to print for that one<br>
client/customer.<br>
<br>
This assumes you have an index already in your detail file by<br>
client/customer.<br>
I often have a single character field that indicates which ones are<br>
paid/unpaid (1 or 0 respectively) and build an index on that field with<br>
the client/customer number.<br>
<br>
Just some thoughts,<br>
<br>
Richard D. Williams<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br></div>