Sage 100

Hi Guys, I have a simple one. I have a customer on 4.5 that wanted a date range on her statement printing. The customers they have pay from a statement. I saw that the previous reseller coded a sub-report and just included the invoice date etc. The issue is that when you run the report with a date range of say 03-01-2014 - 3-31-2014 the TOTALS on the main page do not reflect the range. Anybody done this before?

Can you do a conditional suppression on the sections inside the report to exclude invoices with dates outside the range?

It depends on how the out of range transactions have been eliminated. If either by conditional suppression or by Group Selection (Record Selection is always superseded by MAS) then the totals will still be off for Open Item customers because the group sum will include suppressed amounts and even those eliminated by the Group Selection. However, you could use the Group Selection criteria for your date range condition and change the formula @TotalsOfInvoices to use just the #RunningBalance instead of the Sum({@TransactionAmount},{@CustomerNumber}). That worked for me.

This issue sound familiar. Search the KB as I am pretty sure the totals issue has been addressed. Also, contact @ThereseLogeais as I believe she has written a Crystal report to do what you are asking.

This was discussed recently: https://90minds-com.socialcast.com/messages/19168269

...but with each iteration my solution gets simpler. ;-)

@Dan Burleson yes it does. BTW your solution worked I looked at that other link and yeah I don't have the time to decipher. Good info however. Thanks ALL.

I stand corrected. It has a sub report. I have attached the file. I am not quite sure what the previous reseller was attempting to accomplish.

He was summing the open invoices out of AR_OpenInvoice. You can use a Shared Variable to total the invoice balances in the subreport and pass that to a formula on the main report's page footer. Don't forget to zero the Shared Variable there also.

@Dan Burleson, that worked ok. It is now printing correct with the exception that if the customer has a balance in the 30 60 90 120 columns it will print zeros and all the customer information. Is this possibly because the shared variable total is in the header on the main report?