Phreesoft Support Forum

hi dave when i do a Customer Receipts and put a discount in then save. Then on the statement report the discount doesn't show and shows the customer balance as outstanding by the discount amount . am i doing something wrong plz advice

I have a problem with the statement report, it's on the bug list. I'll post a new version to the download store as soon as I can get to it.

Dave

hi dave any new on when statements will be fixed ..

Try this. The .php file goes in /modules/phreebooks/classes/ and the .xml file in /modules/phreebooks/language/en_us/reports/

Delete your current version and import the new one. Let me know if you have any problems.

Dave

Hi Dave,

a really useful report. Have imported it into R3, made some layout tweaks and is fine except for one thing I cannot work out how to change.

The due date of each invoice in the report is calculated from the Terms set up for that customer, not the Terms defined in the invoice. So if you override the customers terms for a particular invoice this does not show in the report.
I tried changing in the data table to but now nothing appears in the due date column. I expect this is due to the database set up, but this is where I am stuck as I do not fully understand this part of the form builder.
Any pointers would be gratefully appreciated.

Hi Dave I did update the two files .php & xml and now I get this error in the statement

Trace information for debug purposes. Phreedom release 3.0, generated 2011-03-16 23:40:12.


GET Vars = Array ( [module] => phreeform [page] => popup_gen [rID] => 52 [todo] => open )
POST Vars = Array ( [todo] => exp_pdf [title] => Statement [delivery_method] => I [from_name] => Otto Willum Nielsen [from_email] => on@ctcash.eu [to_name] => [to_email] => [cc_name] => [cc_email] => [message_subject] => Statement From CTcash Limited [message_body] => Attached is your Statement from CTcash Limited

To view the attachment, you must have pdf reader software installed on your computer. [rID] => 52 [datedefault] => a [date_from] => [date_to] => [defcritsel0] => EQUAL [fromvalue0] => 15013 [tovalue0] => [defcritsel1] => EQUAL [fromvalue1] => )

The failing sql was: select from journal_main join contacts on journal_main.bill_acct_id = contacts.id where = '15013' and = '' group by

mySQL returned: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from journal_main join contacts on journal_main.bill_acct_id = contacts.id where' at line 1

Edit the statement and in the criteria tab set the fieldname as follows:
Date Fieldname: Post Date
Sorting First field: Bill Primary Name
Sorting Second Field: Invoice Number
Criteria First Field: Customer ID
Criteria Second Field: Journal ID

Then on properties tab:
Set Printed Flag: Record ID
Form Page Break Field: Bill Record ID
Download Filename Source - Source Field: Bill Record ID

Save and try again.

Dave

Hi Dave,

was that fix for my problem or China's ?

For china. On the terms, the statement builder class (which is used to generate the data) doesn't calculate a different due date. It would need to be modified to do this. Need to know php coding though.

Dave

Hi Dave sorry it did not work, I did exactly what you wrote.

Trace information for debug purposes. Phreedom release 3.0, generated 2011-03-24 20:10:54.


GET Vars = Array ( [module] => phreeform [page] => popup_gen [rID] => 52 [todo] => open )
POST Vars = Array ( [todo] => exp_pdf [title] => Statement [delivery_method] => I [from_name] => Otto Willum Nielsen [from_email] => on@ctcash.eu [to_name] => [to_email] => [cc_name] => [cc_email] => [message_subject] => Statement From CTcash Limited [message_body] => Attached is your Statement from CTcash Limited

To view the attachment, you must have pdf reader software installed on your computer. [rID] => 52 [datedefault] => c [date_from] => [date_to] => [defcritsel0] => ALL [fromvalue0] => [tovalue0] => [defcritsel1] => EQUAL [fromvalue1] => )

The failing sql was: select id, id from journal_main join contacts on journal_main.bill_acct_id = contacts.id where post_date >= '2011-03-24' and post_date < '2011-03-25' and journal_id = '' group by id

mySQL returned: 1052 Column 'id' in field list is ambiguous

Hi Dave, any idea when there is a fix for this problem ?

hi dave same problem like china ..but some observation when when u open report and in date and customer id u leave it the same then nothing happens but when u choose range in any fields i.e date or customer id then u get the error like chinas . but in properties when u edit the statement report i dont see
Form Page Break Field: Bill Record ID
Download Filename Source - Source Field: Bill Record ID
so it doesnt seem to b working

This post is being consolidated with post http://www.phreesoft.com/forum/viewtopic.php?f=15&t=1551. Please post all issues related to the Statement form on that topic.

Dave