Home › Forums › Developers › General developer's discussion ›

1.7 Alpha Query on Reporting|Debtors screen

Submitted by Guest on Thu, 20/06/2013 - 16:28
in

Some queries on the Reporting|Debtors screen [my next one to document ;-]

In the screen shot below:

  1. Is there any reason that the Exclude Credit label and checkbox are in the opposite order to the normal "label on the left, box on the left" order?  The Balances selection in the line above is also swapped from the normal order of label, field.
     
  2. What do the Overdue From & To select?  I think that its days since last payment, but I can put letters in (eg from a to z) and it does not bitch. 
     
  3. I looked at the customerAccountBalance.jrxml - it would appear that the application is running the selection and pushing the data to the report via the data source interface. Hence it would appear that the report cannot show what any of the screen parameters are - or are there items in the data source that contain these?  ie is it possible to enhance the Debtors Report so that one can tell what it is reporting?

Regards, Tim G

‹ 1.7 Alpha - CSH query - Patient Image template type ?? 1.7 Alpha Reporting|Debtors|Period End|Confirm - no F1 ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: 1.7 Alpha Query on Reporting|Debtors screen

Submitted by tanderson on Sat, 22/06/2013 - 01:07.

1. No idea why it was laid out this way. I've fixed it in revision 5186

2. Overdue From and To may be used to specify the range of dates that a balance is overdue, relative to the Statement Date.

By default, a balance is overdue if its unpaid or part paid, and its startTime < the overdue date.

The overdue date is calculated as:

   overdue date = statement date - customer's account type payment terms

If the customer doesn't have an account type, then the overdue date is the statement date.

Overdue From and Overdue To are used to determine a range of overdue dates relative to the statement date and the customer's account type.  They are both optional. If you enter bad data, they are treated as zero.

3. There would need to a code change to passed them as parameters to the report.

-Tim 

Re: 1.7 Alpha Query on Reporting|Debtors screen

Submitted by tgething (not verified) on Sat, 22/06/2013 - 04:49.

1. Thanks - I have left note in the CSH page to say it will need a new picture when 5186 is available

2. Have put this in the CSH page

3. Have warned that you don't get the selection parameters on the report.

Regards, Tim G

Syndicate content