Yes sir @joe. Its working as expected. Thanks for your efforts.
152 11/16/2021 09:11:46 am
Re: Tax Report and Inquiry Bug (10 replies, posted in Report Bugs here)
One last thing @Joe and hopefully we will be out of the woods:
The tax within the QE in the Supplier Invoice (GL Items for this invoice) is accounted for in the report but in in the Inquiry.
So either we remove from Report or add to Inquiry. (I prefer add to Inquiry)...It depends of course on the requirement of different users.
153 11/15/2021 07:10:42 pm
Re: Tax Report and Inquiry Bug (10 replies, posted in Report Bugs here)
@Joe
The Tax report now shows Tax on Bank Payments, Customer Credit Notes ...etc. I believe this should not be the case because now the Inquiry and the Report don't tally. Of course I prefer these to be included but then both the Inquiry and Report should be the same.
I think we should stick to the previous version of rep709 if we are not introducing Tax on Bank Payments ..etc...
154 11/01/2021 10:34:25 am
Re: Cash collection transactions (5 replies, posted in Banking and General Ledger)
After you Direct Invoice the $10 then Receive the $50 ...Go
Banking and General Ledger ->Journal Entry
Journal Date Account Code Account Name Debit Credit Memo
01/11/2021 1060 Checking Account 50.00
01/11/2021 1200 00001 Accounts Receivables: Donald Easter 10.00
01/11/2021 2100 00001 Accounts Payable: Dino Saurius 40.00
Total 50.00 50.00
You then can go to Customer Payments and allocate the $10.
Then go to Payments to Suppliers and allocate the $40.
155 10/26/2021 10:25:59 am
Re: Customer Allocations - Can't allocate journal entry (10 replies, posted in Report Bugs here)
This might be a stupid question. But are you sure you are running 2.4.10?
I tell you why.. I am running 2.4.4 and 2.4.10 on the same database. The problem only shows on 2.4.4 and not 2.4.10.
156 10/22/2021 12:12:01 pm
Re: Username login security? (12 replies, posted in Setup)
May I ask what software the front server is using and if it is chargeable.?
157 10/16/2021 08:58:36 am
Re: Rep109 in Print Profiles (5 replies, posted in Report Bugs here)
Thanks @kvvaradha
You meant
open the rep109.php and find this line
$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);
and replace with a title like this
$rep = new FrontReport(_('SALES ORDER'), "SalesOrderBulk", user_pagesize(), 9, $orientation);
and it will work for you.
@joe consider updating the FrontReport Headers same for email and non email headers
158 10/15/2021 10:32:45 am
Re: Rep109 in Print Profiles (5 replies, posted in Report Bugs here)
Hi @kvvaradha
Any suggestion on how to repair this?
159 10/14/2021 04:08:59 am
Topic: Rep109 in Print Profiles (5 replies, posted in Report Bugs here)
I am not sure if this is a bug but would like to know why this looks the way it is. Rep109 works perfectly though.
But in FA2.4.10
Setup->Print profiles
Produces ???1) in the description field against Report Id 109.
Whereas ???1) means - no title was found in this report definition file.
Can someone explain why this is the case? I went thru rep109 code but could not find the problem.
Note: I copied rep109 from 2.4.8 and the display is as expected (SALES ORDERS)
Please see attached screen shot from fa2.4.10.
160 10/11/2021 03:10:19 am
Re: Mailing doesn't work if the header contains "&" (9 replies, posted in Report Bugs here)
Hi, I decided to help out so I set up the following environment.
FA2.4.10
Linux Mint 19
MySql 5.7
Php 7.2
Apache 2.4
Postfix 3.3.0
I also setup Mail Relay thru gmail SMTP [smtp.gmail.com]:587
1. With no change to Code:
Setup Company name Tegusad Õpilased & Tudengid
Created Invoice to Customer Donlad Easter
Emaild the invoice. to user@example.com
Finding:
Mail is sent and received.
In the company Name the & is displayed as &(Tegusad Õpilased & Tudengid)
The from field is displayed as Tegusad@zkbts, Õpilased@zkbts, &@zkbts, Tudengid <>
2. With no change to code but user is user<user@example.com>
Mail is not sent. Error in postfix log (bad address syntax). the < and > are translated into <user<user@example.com>>
3. With changes incorporated as in peacecop suggestions and user is user@example.com
Mail is sent and received, The Subject header (Invoice 17 from Tegusad Õpilased & Tudengid) still show & in all other places its correctly &.
4. With changes incorporated as in peacecop suggestions and user is user<user@example.com>
Mail is not sent. <user@example.com>> (bad address syntax) Extra > in the address.
161 10/09/2021 08:33:45 am
Re: Sage 100 Data Import (6 replies, posted in Setup)
In ../config_db
$tb_pref_counter = 1;
162 10/08/2021 02:40:56 am
Re: Private Messages (16 replies, posted in Announcements)
Unless I misunderstood the question.
But Sorry guys.. one can attach files, screenshots and code. The forum is full of such attachments. The only restriction is you need to be a senior member to do that. Its easily achievable by posting more than 50 posts and then automatically one is a senior member and can use attachments.
163 09/26/2021 03:00:36 am
Re: qty_done is not updated correctly when partial invoice is voided (7 replies, posted in Report Bugs here)
@cedricktshiyoyo,
I think the developers are looking at experienced programmers like you to suggest a solution, This is what open source is all about. A community collaboration. So if you think you have a solution then suggest it. If they see it feasible they will include it. Also Fixed Assets is an optional module and the usage is not as much as Sales or Purchase..Its normal to have more focus on widely used modules. I don't see any bias between any of FA modules.
164 09/24/2021 08:18:03 pm
Re: Problem logging in (11 replies, posted in Installation)
Strange the restore of the backup did not resolve the issue..unless the backup also contains the corrupted data..then you are restoring what is already corrupted. Anyway "DROP TABLE IF EXISTS" is important to have and it is inserted by the FA backup routines.. I guess you are exporting via phpmyadmin or mysql command line which does not have the DROP command.
Now I am concerned even if you reinstall xampp and restored the bad backup then you will end up in the same situation as before. You might want to try and restore an older backup to start with ..just to eliminate the chance that the one your are working with is not the problem.
If you do XAMPP fresh install you can import the DB from your exported data without the DROP command , but that should be to an empty DB.
165 09/24/2021 03:50:30 pm
Re: Problem logging in (11 replies, posted in Installation)
If you have the luxury to reinstall xampp then be it. Because this way you are reinstalling a fresh copy of your environment...including Apache, Mysql and Php. You will also need to reinstall fa code and restore the db backup. I would say this is a very good learning exercise. If you do not have the time and luxury then restoring the db first is a good idea.
We are here if you need help.
Good luck.
166 09/24/2021 03:31:48 am
Re: qty_done is not updated correctly when partial invoice is voided (7 replies, posted in Report Bugs here)
Yes I can reproduce the above easily. FA2.4.10
I will post it in mantis.
167 09/23/2021 07:12:32 am
Re: Problem logging in (11 replies, posted in Installation)
The problem clearly indicates a db problem,,its either not found or is corrupt. Are you sure your db name is frontacc?
The dbuser, dbpassword are mysql parameters to access the db, they are different from userid and password in front accounting which is normal in your case...as your fa id is jeff with a password. Do you have other companies in config_db?
If you are confident you can restore the db using phpmyadmin from a previous backup and try again. All data after the backup will be lost though..
168 09/22/2021 06:03:45 pm
Re: Problem logging in (11 replies, posted in Installation)
Anything in /tmp/errors.log?
169 09/20/2021 05:10:16 pm
Re: Withdraw the cash directly from the company for personal use (10 replies, posted in Banking and General Ledger)
Of course the best thing is to talk an Accountant that knows your Chart of Accounts. He/She can advise you best.
Having said that the first thing to find out is in which account the owner contributed his money in your company's COA. Then with Bank Payment you can Credit the Bank (1061 for example) and Debit the Contributing account i.e Common Shares (3350) or alternatively create a new account with the name of the owner i,e John Common Shares (3351) and Debit that account.
170 09/02/2021 08:01:31 am
Re: Invoice Editable (23 replies, posted in FA Modifications)
It should work. I have it working on 2.4.10 latest without any problem. It s installed as any other extension. One thing thing you will notice is that it does not show as an extension because it replaces the some core Sales programs. So to see if it is installed and after giving the right permissions just go into Customer Transaction --> Sales Invoices and choose one and try to edit it.
171 08/31/2021 04:40:00 am
Re: Edit invoice (2 replies, posted in Accounts Receivable)
https://frontaccounting.com/punbb/viewtopic.php?id=7029
It works for Direct Invoices only...and no purchase invoice edit ..
172 08/30/2021 07:17:50 am
Re: Logo on invoices in RTL (2 replies, posted in FA Modifications)
Try in header2.inc
// Company Logo
$this->NewLine(2);
It will give you an extra line. More than this then it will overlap with Customer Box.
OR at the beginning of header2.inc insert
***/
$this->row = $this->pageHeight - $this->topMargin;
$this->NewLine(x);
where (x) is the number of lines you want to skip. But this will also reduce the number of lines to be printed on the report.
173 08/29/2021 02:39:15 am
Re: Recurring invoices result in no dimensions on gl_trans (11 replies, posted in Accounts Receivable)
Hi,
Been testing this and I agree with @advocaat.pollet. I dont see the dimension in the Balance Drill Down for recurrent invoices.
@kvvaradah..can you please guide us on how to test this ..maybe we are doing something wrong.
174 08/17/2021 01:35:57 pm
Re: Accounting for nonprofit (5 replies, posted in Banking and General Ledger)
This is discussed before.
https://frontaccounting.com/punbb/viewtopic.php?id=338
175 08/17/2021 01:13:57 pm
Re: Accounting for nonprofit (5 replies, posted in Banking and General Ledger)
Basically members subscriptions is a revenue.. So when you enlist a donation and the member pays, you debit your bank account and credit your revenue account. This revenue account is dependent on your COA. In FA 5 Digit American COA its the 4xxx accounts..so you can choose any of them ..or you can add another i.e 4511 and Call it Membership Dues for example, and you credit this account.
Tell us what you did.
Good Luck
/Rafat