elax:
Thanks for you info. I imagine that the fix will show up in the FA before too long.
It seems to be that the best way to fix the problem would not be in a fix in the filter but a fix when the data is entered into the database.
ed10
1 05/03/2013 08:19:21 pm
Re: print only statements with non-zero balance? (9 replies, posted in Accounts Receivable)
2 05/03/2013 07:37:09 pm
Re: print only statements with non-zero balance? (9 replies, posted in Accounts Receivable)
Does the fix fix the old data from previous invoices/payments or just fix the invoices/payments from now on?
3 05/03/2013 02:57:48 pm
Re: print only statements with non-zero balance? (9 replies, posted in Accounts Receivable)
Version 2.3.15 Build 20.02.2013 on Ubuntu 12.04lts
4 05/03/2013 01:50:02 pm
Re: print only statements with non-zero balance? (9 replies, posted in Accounts Receivable)
Hi Joe:
I did Print Statements using Show Also Allocated: No.
One of the statements I got had body:
----------------------------------------------------------------------------------
Trans Type # Date DueDate Charges Credits Allocated Outstanding
Outstanding Transactions
Sales Invoice 124 01/15/2013 01/15/2013 210.40 210.40 -0.00
Current 1-30 Days 31-60 Days Over 60 Days Total Balance
0.00 0.00 0.00 0.00 0.00
----------------------------------------------------------------------------------
To me this is a zero balance, customer owes us nothing. I don't know why it is being printed.
This is what I don't want printed. I must not be understanding something about how the statements are being selected for printing. How do I avoid printing such statements?
Thanks for you quick replies,
ed10
5 05/03/2013 12:20:00 am
Topic: print only statements with non-zero balance? (9 replies, posted in Accounts Receivable)
How do I print only statements of customers which have a non-zero balance?
We have relativity few customers (1% of several thousand) which have a balance at the end of the month and they need to be sent a statement. Is there an easy way to do this?
Thanks,
ed10
6 03/15/2013 12:34:11 pm
Re: direct invoice reference (2 replies, posted in Accounts Receivable)
Janusz:
ok, thanks for the answer. I will work around what I was trying to do.
ed10
7 03/12/2013 03:50:01 pm
Topic: direct invoice reference (2 replies, posted in Accounts Receivable)
When entering a direct invoice, the sales order created get assigned the reference 'auto'. Is there any way that could be changed so it uses the next_reference number from the sys_types table? It is sort of a mess having all the 'auto' references mixed in with the references generated with an invoice created from a sales order. 'auto' makes too many duplicate references.
Thanks,
ed10
8 02/25/2013 02:50:27 pm
Re: "charge to" field (20 replies, posted in Setup)
Joe:
Thanks, you are always a big help.
ed10
9 02/24/2013 02:21:10 pm
Re: "charge to" field (20 replies, posted in Setup)
Joe:
I entered a customer in the 2.3 demo: anewtestcustomer. I left the branch billing adress empty and when I print a sales order for that customer the charge to address is empty. I seems that the branch billing address is always used?
joe wrote:
I am sorry. I gave you a wrong directive. If the branch has its own billing address it is used here in 'charge to'. otherwise it is not used at all. It should still have its own mailing address for the delivery fields.
When the delivery and/or invoice is sent the customers address is used in 'charge to'.
/Joe
ed10
10 02/23/2013 10:56:58 pm
Re: "charge to" field (20 replies, posted in Setup)
Janusz:
In the line below, where does the formData['br_name'] get set? I can't find it. I am having the same problem as Eric except sometimes I need to charge the branch so have to do a bit more changing.
ericta wrote:
'name' => @$this->formData['br_name'] ? $this->formData['br_name'] : @$this->formData['DebtorName'],
Thanks,
ed10
11 02/09/2013 01:42:15 pm
Re: selection bug-I think (4 replies, posted in Report Bugs here)
Joe:
Yes that was it. The value was set to be 30. I am certain that I didn't set it so don't know why it was 30. I didn't even know the var was in config.php.
Been another learning experience 
Thank you so much,
ed10
12 02/08/2013 11:22:28 pm
Re: selection bug-I think (4 replies, posted in Report Bugs here)
Hi Joe:
Yes I have edited doctext.inc as you suggested to me in another thread. The reason that the line 239 got shoved down is because when I make a change on the core files, I remark the original line and add my line so I can go back and see what did or didn't work. I made 8 changes go that added 16 lines, may have gotten a extra blank line, didn't count closely. Almost all changes were simply changes in text, one was a footer.
I am using Version 2.3.14 Build 20.01.2013.
I tried to test the weird search on your demo, but it is not set up for searching so was not possible to test. I have FA running on 3 different boxes and the three are generally not the same. One is our live server that is used for our real accounting, one on my managers box for her testing new changes and my box for development of things we want to change. All boxes are Ubuntu 12.04LTS using Firefox 18.0.2.
I promise you that the search is acting as I described on all three boxes. My manager found it to be acting in this manner when we were testing the emailing of statements.
I seems to have something to do with session/cookies. I just did a small test. I went to reports/print statements and printed a statement for a customer. Then I looked at the cookies both before and after the print. there were four cookies set after the print:
select[108][0] this one had content 83551 (the debtor_no)
select[108][2]
select[108][3]
select[108][5]
the rest had content 0. If that means anything to you.
I think typed in a new exact match customer, click on his name then checked the cookies. No change at all, exactly the same. Seems that there should be some change.
Next I logged off FA and back on, went to reports, print statement and the customer showing was the customer I printed the statement in the beginning of my test. Cookies still exactly the same. I expected the cookies to be removed but were not. Is that the way it is supposed to be? The cookies are session cookies. The session cookie id was the same also.
I don't know what else I can do to test this.
Thanks for you working on this,
ed10
13 02/08/2013 01:29:57 pm
Re: body of an email from reports (6 replies, posted in Wish List)
Janusz:
That is great, thanks.
What I did in the mean time was put this in pdf_report.inc:
switch ($this->formData['doctype'])
{
case ST_SALESQUOTE:
$msg = _("Attached you will find ") . " " . $subject ."\n\n";
$msg .="Please contact us with any questions or when you are ready to place this order." . "\n\n";
$msg .="Thank you for the opportunity to offer this quote to you and we look forward to working with you." . "\n\n";
$msg .= _("Sincerely,") . "\n\n";
break;
...
ed10
14 02/07/2013 09:57:02 pm
Topic: selection bug-I think (4 replies, posted in Report Bugs here)
This is sort of a mix of things.
itronics wrote:
Regarding the weird exact selection effect, I can't remember why it was leaved as it is. I'm sure there was some (more or less) important reason for implementing such behaviour, but simply I can't remember what it was. Anyway, I agree this is annoying., and maybe this is good candidiate for improvement.
Janusz
The above is from: https://frontaccounting.com/punbb/viewtopic.php?id=3558
When I go to: /frontaccount/reporting/reports_main.php?Class=0 then select Print Statements (we are still testing our emailing). Then go to Customer to filter the customers, hit space and type in an exact match for a customer it still comes back with No Customer Filter (expected since the code was not changed --discussion in above thread). When I click on the filter again, I then can see and select the exact match customer, print the statement. No problems to print the statement. But then when I try to email the statement, I get:
======================================
Undefined variable: id in file: /var/www/frontaccount/reporting/includes/doctext.inc at line 256
/var/www/frontaccount/reporting/includes/pdf_report.inc:438: include('/var/www/frontaccount/reporting/includes/doctext.inc')
/var/www/frontaccount/reporting/includes/pdf_report.inc:948: (FrontReport Object)->Header2()
/var/www/frontaccount/reporting/rep108.php:121: (FrontReport Object)->NewPage()
/var/www/frontaccount/reporting/rep108.php:29: print_statements()
/var/www/frontaccount/reporting/prn_redirect.php:71: require('/var/www/frontaccount/reporting/rep108.php')
/var/www/frontaccount/reporting/includes/reports_classes.inc:53: include('/var/www/frontaccount/reporting/prn_redirect.php')
/var/www/frontaccount/reporting/reports_main.php:465: (BoxReports Object)->getDisplay()
You have no email contact defined for this type of document
/var/www/frontaccount/includes/ui/ui_msgs.inc:14: trigger_error('You have no email contact defined for this type of document','256')
/var/www/frontaccount/reporting/includes/pdf_report.inc:983: display_error('You have no email contact defined for this type of document')
/var/www/frontaccount/reporting/rep108.php:168: (FrontReport Object)->End('1','Statement as of 02/07/2013')
/var/www/frontaccount/reporting/rep108.php:29: print_statements()
/var/www/frontaccount/reporting/prn_redirect.php:71: require('/var/www/frontaccount/reporting/rep108.php')
/var/www/frontaccount/reporting/includes/reports_classes.inc:53: include('/var/www/frontaccount/reporting/prn_redirect.php')
/var/www/frontaccount/reporting/reports_main.php:465: (BoxReports Object)->getDisplay()
===============================================================
The customer has the email as general and this looks to be at least partly the same error that Joe fixed in last week or two in several reports.
The next problem (I think unrelated to the one just above). After I print the first statement, I go to the customer filter, hit space bar and type in another exact match customer. It comes up with No Customer Filter as before but when I click it, the next exact match customer in listed in the drop down. Then I click that customer, instead of that customer name coming up in the filter text box, No Customer Filter is back in it. Click filter again, customer name is in the drop down, click and again back to No Customer Filter. The only customer statement I am able to print is the first customer. I don't think that this is a caching problem because I tried clearing the cache and it made no difference.
It seems that it the same thing as when you enter a Sales Order and come back to enter a new Sales Order, the system 'remembers' the last customer you used. Seems like the previous customer was in a session var and that gets read as the customer you want to use.
So this post includes 2 problems (the error msgs on the email) and not being able to select another customer for a report (at least the two I checked Account Balance and Print Statement).
I would still like to see the code changed so that when you type in an exact match that customer comes up and if it is not an exact match the first partial match customer is listed. This is the way most searches work on the net.
Hope I have explained this well enough.
ed10
15 02/05/2013 04:30:48 pm
Re: body of an email from reports (6 replies, posted in Wish List)
Janusz:
Do you think this is worth your effort?
ed10
16 02/05/2013 01:00:27 am
Topic: body of an email from reports (6 replies, posted in Wish List)
Hi,
I have been working some on emailing reports, started with quotations and now on to invoices.
The main body of the email seems to be coded in the file reporting/includes/pdf_report.inc using the variable $msg.
I sure would like to be able to write the body of the email using some variable that is in my custom reports in company directory (rep111 for quotations or rep107 for invoices). That way pdf_report.inc will in general stay the same thru the Mercurial updates but if it is edited heavily to get the body of the email set for all the different report, it becomes a real pain to have to follow.
Two other files in sort of the same situation are doctext.inc and header2.inc (seems these two files get suggested to be edited often in the forum). They are often edited just to get a bit of different text in some document. It would be nice it the text stuff was in the company file and the good hard code to make it run was in the doctext.inc and header2.inc.
I don't know if I am missing something in the reports that will do the msg or the task may be very hard to code. But the section of this forum is Wish List and I am wishing.
Thanks Joe, Janusz and apmuthu you have all been a great help to me
ed10
17 02/04/2013 09:40:09 pm
Re: Mercurial help (6 replies, posted in Accounts Receivable)
Hi Janusz:
This: hg clone https://frontaccounting.hg.sourceforge.net/hgroot/fontaccounting/frontaccounting repository4FA
gives:
real URL is https:/sourceforge.net/
abort: 'https:/sourceforge.net/' does not appear to be an hg repository:
---%<--- (no content-type)
download_hostpageprojectsmirror
---%<---
this: hg clone https://frontaccounting.hg.sourceforge.net/hgweb/frontaccounting/frontaccounting 4repositoryFA
works.
Then I get:
real URL is https://frontaccounting.hg.sourceforge.net:8000/hgroot/frontaccounting/frontaccounting
requesting all changes
adding changesets
adding manifests
adding file changes
added 3179 changesets with 13287 changes to 695 files (+2 heads)
updating to branch default
633 files updated, 0 files merged, 0 files removed, 0 files unresolved
then did and got:
/4repositoryFA$ hg branch local_branch
marked working directory as branch local_branch
(branches are permanent and global, did you want a bookmark?)
/4repositoryFA$ hg branch
local_branch
did an edit on class.mail.inc as I was talking about in another thread and did:
/4repositoryFA$ hg commit -m "my local patches"
Now I will just wait till there is a change in the FA repository on sourceforge to see out it works out.
Thanks for the help. So often various pages on the internet say to do a command and neglect to say what dir to run it from, who the user must be and what the file permissions much be.
ed10
18 02/04/2013 01:34:21 pm
Re: Mercurial help (6 replies, posted in Accounts Receivable)
apmuthu, your just trying to get me to work harder and learn more apps, i would rather just learn Mercurial and not GIT,Virtual Box or Wine.
Thanks for all your help.
ed10
19 02/03/2013 02:28:21 pm
Re: Mercurial help (6 replies, posted in Accounts Receivable)
Be pretty tough to do since I don't run a win box.
20 02/03/2013 02:24:06 pm
Re: email of quotes (38 replies, posted in Accounts Receivable)
In currrent_user.inc there is nothing about email so how can $_SESSION["wa_current_user"]->email get populated? I have emails for all the users. when I print $_SESSION I get the following array with values removed:
[wa_current_user] => current_user Object
(
[user]
[loginname]
[username]
[name]
[company]
[pos]
[access]
[timeout]
[last_act]
[role_set] => Array
( edited long list
)
[old_db] =>
[logged] => 1
[ui_mode] => 1
[prefs] => user_prefs Object
( edited long list
)
[cur_con] => 0
)
No email.
ed10
21 02/03/2013 12:53:17 am
Re: email of quotes (38 replies, posted in Accounts Receivable)
I tried this:
$_SESSION["wa_current_user"]->email
earlier and it gave me an error -- from my memory something like no $email var defined.
When I did: echo '<pre>' . print_r($_SESSION, true) . '</pre>';
it shows no email in the wa_current_user array.
I have not tried to use both methods.
I am using the latest verison of postfix for ubuntu from ubuntu repository so would be greatly surprised if my Postfix was non-compliant.
22 02/03/2013 12:28:27 am
Topic: Mercurial help (6 replies, posted in Accounts Receivable)
Thought this was worth a separate thread.
itronics wrote:
If you are looking for easy way for maintaining local patches on top of latest FA, you should simply use mercurial. Just clone sourceforge repository on your development box and maintain your local changes in separate branch e.g.:
hg clone https://frontaccounting.hg.sourceforge.net/hgroot/fontaccounting/frontaccounting hg branch local_branchThen apply all your local patches, and save the changes:
hg commit -m "my local patches"When new changes appears in repo and you want to update your local_branch:
hg pull hg checkout local_branch hg merge defaultWhen no conflicts happen between your changes and chnages in repo you are done. Otherwise you have to resolve conflicts and commit the effect of merge to the local_branch (more details about how to resolve the conflicts you will find in google).
Janusz
This generated some questions. Suppose that the directory I clone Frontaccounting into is /repository4FA. Are all of the hg commands done in the that directory? Where would be the directory (same dir or different one?) that I would have the files I am working on? Do the directories need any particular permissions? I guess what I want to be sure about is how to construct the set of directories needed for Mercurial to work nicely for me and what files go into what directories.
If this whole thread is too off topic, just tell me.
Thanks,
ed10
23 02/02/2013 11:27:16 pm
Re: email of quotes (38 replies, posted in Accounts Receivable)
Looking at $_SESSION["wa_current_user"] it seems that the current user's email address is not set. Is that right?
If it isn't, I am curious why it isn't. If it were set then I could set the add_parm for the 'reply to' using the email of the user who actually sends the email instead of a fixed address. Would be a little bit nicer.
What would really be nice would be putting all this kind of stuff into the custom report (in this case rep111 in company directory) and not the main code pages like pdf_report.inc and class.mail.inc. That would keep the custom stiff together and the main code less hacked by various FA users. Maybe it is not even possible, but possible or not still would be nice
ed10
24 02/02/2013 08:28:57 pm
Re: email of quotes (38 replies, posted in Accounts Receivable)
The patch didn't work here. When I did the patch and took the '-f sales@mydomain.com' out of var $add_params = '-f sales@mydomain'; then the returnpath went to: Return-Path: <"www-data@user"@mydomain.com>
so that is not right. with the -f flag in the add_parms it works.
I don't think you can set that Return-Path in the header, has to be separate parameter sent to postfix.
Take a look at:
me at arronwoods dot com
1 year ago
I've had all sorts of problems with scripts that don't set the "-f user@example.org" parameter when using mail() if postfix is the sendmail agent. ...
in http://php.net/manual/en/function.mail.php
ed10
25 02/02/2013 05:31:02 pm
Re: email of quotes (38 replies, posted in Accounts Receivable)
Ok, got it figured out. The last test email came in just like I wanted it to (almost-the salutation is not right yet). For the user I was logged in for didn't have any entry in user table for real_name so that is why it came up blank. In the line:
$this->user = $_SESSION["wa_current_user"]->name;
'name' is taken from the 'real_name' field in the user table. (I thought it was the user_id)
At least that is what it looks like right now. Time to take a break and look at it all again tomorrow to see if I have it all the way I want it.
Tomorrow is work on Mercurial day also, can't seem to get it to work right for me.