Yes, it is a complete do-over. However, if some re-entry could be saved by importing a client list, that would be very helpful.
2 12/27/2020 05:54:29 pm
Topic: Importing/Exporting to/from FA (3 replies, posted in Installation)
Feature Request: Although this doesn't solve my problem below, creating a new company should enable users to copy settings such as COA, GL, System and GL Setup, etc., from an existing company (or a template company).
Hello,
About a year ago I made a mistake editing the database. Consequently some information is incorrectly associated (e.g. payments for an invoice appear with the wrong customer name). It looks too involved to correct, and the full extent of errors is hard to determine, therefore re-entry is the preferred method...
How can I safely copy non-financial transaction data from an existing company? Most helpful would be the list customers and contacts. The GL and GL Setup would also be helpful. The rest I can manually enter, and I would really like to avoid breaking relationships again.
Thank you
3 12/22/2020 06:33:41 pm
Re: Setup DB Connection Error (37 replies, posted in Installation)
Thank you guabeff. Good testing.
Continuing on this. I checked my password: only 10 characters. However, it contained an ampersand. On a hunch I replaced "&" with "a" and everything works. There is obviously some string sanitation going on that's breaking passwords (only enough, manually entering port 3306 will partially bypass it).
I replaced the "&" character with the letter "a", in my 10 character password, and everything works--it was only 10 characters.
4 12/22/2020 05:53:41 am
Re: Setup DB Connection Error (37 replies, posted in Installation)
kvvaradha wrote:
Your mariadb port no is different. Guess your hosting provider is using different port no for mariadb. Check with them to get it. Usually most of the MySql server configured with 3306. And some servers they might changed port no for some other apps. So you have to get right port no for your mariadb and input here. With right port no, it will work.
It's my server on a rack 2 m to my left. Default port, 3306. This also doesn't explain why adding 3306 will get past the first database login to a confirmation screen, only to fail and loop back to the database login screen. Something is amiss.
5 12/22/2020 05:27:16 am
Re: Setup DB Connection Error (37 replies, posted in Installation)
Still no solution, but perhaps this will save someone else a few steps.
I have a similar setup running correctly on another Apache server that ran FrontAccounting 2.4.6 on PHP versions 7.1 up to 7.4. It may have been installed on PHP 5.6, and later upgraded. I can no longer recall for certain but I believe it was installed on PHP 7.1.
Both databases are local to the server and have the exact same privileges, database names, etc.
MariaDB [(none)]> show grants for username@'localhost';
GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY PASSWORD '******'
GRANT ALL PRIVILEGES ON `username`.* TO 'username'@'localhost'
I took a look at changes in the code and found nothing significant in the following three files:
$ diff frontaccounting-2.4.9/includes/db/connect_db_mysqli.inc frontaccounting-2.4.6/includes/db/connect_db_mysqli.inc
13c13
< define('SQL_MODE', 'STRICT_ALL_TABLES'); // prevents SQL injection with silent field content truncation
---
> define('SQL_MODE', ''); // STRICT_ALL_TABLES,NO_ZERO_IN_DATE ?
$ diff frontaccounting-2.4.9/includes/db/connect_db.inc frontaccounting-2.4.6/includes/db/connect_db.inc
(no change)
$ diff frontaccounting-2.4.9/install/index.php frontaccounting-2.4.6/install/index.php
(no change)6 12/22/2020 04:49:14 am
Re: Setup DB Connection Error (37 replies, posted in Installation)
I spoke too soon.
Adding 3306 does allow the installation to proceed to the next screen. The following message is displayed:
"All application preliminary requirements seems to be correct. Please press Continue button below."
However, clicking continue returns to the database login, and the same connection parameters no longer work. It is possible to get back to the preliminary requirements confirmation by trying once to login without 3306, and then again with.
There appears to be a fail in the logic check around the port number.
7 12/22/2020 04:42:30 am
Re: Setup DB Connection Error (37 replies, posted in Installation)
FWIW, me too, and I found the problem. The connection is not using 3306 when it is not specified.
It looks like it is, but there could be a mistake in this line, or perhaps a non NULL value is being passed by the database connection in the install script.
$db = mysqli_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"], "",
!empty($connection["port"]) ? $connection["port"] : 3306); // default port in mysql is 3306
FrontAccounting 2.4.9
PHP 7.3
MariaDB 10.3.18
8 11/14/2019 08:06:43 pm
Re: Reversing A Customer Allocation (3 replies, posted in Accounts Receivable)
Thank you, but I'm not sure this is the solution.
I was able to void the customer payment, but the allocation of the payment is what remains. I suppose what I need to do is allocate another payment on a test system and see what changes in SQL.
It's strange there is no way to reverse an allocation.
9 11/14/2019 02:29:24 am
Topic: Reversing A Customer Allocation (3 replies, posted in Accounts Receivable)
Hello, I seem to have run into a bug, or limits of my understanding of how FA works.
Now I'm attempted to recall my steps, which may be inaccurate.
I entered a customer payment for a prepayment transaction before converting the quotation to a work order.
This prevented me from issuing a delivery against the work order because the payment wasn't allocated (a work order didn't exist).
It seemed the solution was to create a work order and allocate funds to it.
However, it was still not possible to create a delivery against a work order because it did not register the allocation as a prepayment.
Therefore, I decided it best to void the customer payment and follow the correct order of steps.
Unfortunately, the allocation remains, but the payment is gone.
In other words, I can't enter a new payment, nor can I create the work order, invoice, etc. This is a dead end.
How can I remove the allocation?
Thanks!
10 09/06/2019 10:59:03 pm
Re: Prepayment Invoicing (6 replies, posted in Accounts Receivable)
oakstreet1 wrote:
What I did was I modified the invoice report (rep107.php) slightly to include an amount paid and the net amount payable.
That allows you do skip a bunch of steps and just create a direct invoice, apply the customer payment to the invoice, then generate an invoice that shows it is paid or partially paid with a net payable amount.
I can see how that would be helpful. Invoicing for prepayments should run through like Direct Delivery and Direct Invoice; when the amounts are paid of course. That's a good suggestion for FA to adopt.
Is it possible to get the payment terms from company setup moved further up the chain to Quotations?
11 08/30/2019 12:32:44 am
Topic: Prepayment Invoicing (6 replies, posted in Accounts Receivable)
I feel like I must be doing prepayments wrong.
The Sales Order does not include "Legal Text on Invoice:" from System and General GL Setup, and it is not possible to issue an on Invoicing Prepayment Orders; this causes an error: "There is no non-invoiced payments for this order. If you want to issue final invoice, select delayed or cash payment terms." Due to these conditions, the client never receives notice of payment terms on prepayment sales because the invoice cannot be generated. It's a catch-22.
Likewise, invoicing paid in advance order generate a Pre-Payment invoice that shows the payment terms. It's a little confusing to appear on a final invoice document.
Do I have this someone complete backward?
Thanks
12 08/29/2019 03:39:10 pm
Re: Include In Tax Register (6 replies, posted in Banking and General Ledger)
Thank you rafat, I did confirm the report date range. The items do not show up. This may be related to a bug mentioned in the other thread, but I do take you are confirming they should have appeared in those locations, which helps explain the purpose.
Thank you
13 08/29/2019 03:55:34 am
Topic: Include In Tax Register (6 replies, posted in Banking and General Ledger)
What is the purpose of the "Include in tax register" check box on the Journal Entry page? I have searched and searched...
It does enable the "Tax Register" tab, which calculates the input tax using the Base Amount Description (from quick entry setup) and clicking the "Go" button. What puzzles me is why, since tax payable and expenses were debited, and chequing credited.
I tested a journal entry with and without the tax register and "Tax Inquiry" and General Ledger Reports > General Leger > Tax Report are not affected (this could be related to a bug/issue reported in other threads - https://frontaccounting.com/punbb/viewtopic.php?id=8003 ).
14 06/03/2019 12:20:24 am
Re: Budget Entry doesnt save (20 replies, posted in Banking and General Ledger)
This seems to be the same issue with the English Canadian COA.
15 07/22/2018 01:29:42 am
Re: Entering Old Records (3 replies, posted in Banking and General Ledger)
Hi apmuthu,
So, if I understand correctly, I have to work within each current fiscal year, and pre-sort my transaction history by date. If I later find an error was made during entry, I can make changes to prior fiscal years (if enabled), but this should be considered a last resort.
Thank you for the reply
16 07/21/2018 02:42:52 am
Topic: Entering Old Records (3 replies, posted in Banking and General Ledger)
Hi,
I have a small volume of transactions over four years that would be reasonable to re-enter (I am full time parenting and consult on the rare occasion). I don't have bank accounts or bank reconciliation to do (sole proprietorship and shared personal bank account). Can I enter transactions into FA over multiple years? ...can they be entered out of order? ...any problems to avoid?
(Some other year I'll incorporate, and add banking, to another FA database.)
Thanks!