151

(10 replies, posted in Report Bugs here)

Yes sir @joe. Its working as expected. Thanks for your efforts.

152

(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

(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...

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.

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

(12 replies, posted in Setup)

May I ask what software the front server is using and if it is chargeable.?

157

(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

(5 replies, posted in Report Bugs here)

Hi @kvvaradha
Any suggestion on how to repair this?

159

(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.

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, &amp@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&lt;user@example.com&gt;>

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 &amp; Tudengid) still show &amp; 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

(6 replies, posted in Setup)

In ../config_db
$tb_pref_counter = 1;

162

(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.

@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

(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

(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.

Yes I can reproduce the above easily. FA2.4.10
I will post it in mantis.

167

(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

(11 replies, posted in Installation)

Anything in /tmp/errors.log?

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

(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

(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

(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.

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.

This is discussed before.

https://frontaccounting.com/punbb/viewtopic.php?id=338

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