The following should do the job:
sed -e 's/AUTO_INCREMENT=[0-9]* //g' -i sql/en_US-demo.sql
sed -e 's/AUTO_INCREMENT=[0-9]* //g' -i sql/en_US-new.sql1,226 03/04/2019 03:37:24 pm
Re: Line 1369 in en_US-demo.sql can be removed (4 replies, posted in Misc. Charts of Accounts)
1,227 03/03/2019 05:24:15 pm
Re: Line 1369 in en_US-demo.sql can be removed (4 replies, posted in Misc. Charts of Accounts)
Line 1950 needs to be PRIMARY KEY:
UNIQUE KEY `record_id` (`record_id`,`tag_id`)Check in en_US-new.sql also.
1,228 03/03/2019 04:34:10 pm
Topic: Line 1369 in en_US-demo.sql can be removed (4 replies, posted in Misc. Charts of Accounts)
@joe: Please check if line 1369 in en-US-demo.sql is necessary - it is dated in 2012:
('1', '0', '001/2012'),There are many long char fields that should actually be varchar.
All AUTO_INCREMENT=XXX strings can be removed.
1,229 03/03/2019 04:24:45 am
Re: What are Document Date: and Event Date: in journal entries for? (6 replies, posted in Banking and General Ledger)
The event date is "as on" that date. In your case, though the payment was due, it was actually paid later (hence use Feb 28th) as against if payment was made on the event date and was forgotten to be booked, then it would be Nov 30th..
1,230 03/01/2019 04:41:15 pm
Re: Enter Opening balances during middle of fiscal year (2 replies, posted in Banking and General Ledger)
Take the trial balance and pass it as a JE with net zero of the credits/debits. This can be done by a CSV import using the Multiple JE import extension.
1,231 03/01/2019 04:39:41 pm
Re: Providing fix for Import Multiple Journal Entries module in v2.4rc1 (6 replies, posted in Modules Add-on's)
Read the docs/readme.txt in the module.
1,232 03/01/2019 04:34:59 pm
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
The plain default is best retained as default whilst the "best" can be others in the dropdown list.
1,233 03/01/2019 05:14:31 am
Re: function round2 on FA (3 replies, posted in Banking and General Ledger)
That is the php ternary operator.
1,234 03/01/2019 05:11:38 am
Re: Recurrent Invoices in 2.4 is not sending (15 replies, posted in Report Bugs here)
There might be a delay in generating the PDF file that needs to be emailed. Try a sleep time waster or check for the presence of the last invoice in the PDF before attempting to email.
1,235 03/01/2019 05:09:22 am
Re: how to make sure that columns table_section 2 or 3 does not show (2 replies, posted in FA Modifications)
Identify the form field names and make defaults for them and set the css style to display none.
1,236 02/27/2019 03:00:00 am
Re: How to Add Column Undefined property ? (3 replies, posted in FA Modifications)
It is in sales/includes/cart_class.inc.
1,237 02/26/2019 05:08:21 pm
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
@braathwaate's suggestion seems nice especially for those who have no access to config.php - just form request fields for the report.
1,238 02/23/2019 06:03:43 am
Re: Bug in rep101.php (3 replies, posted in Report Bugs here)
@joe: is this warranted?: Fixed
1,239 02/23/2019 06:00:18 am
Re: Textcart module (31 replies, posted in Modules Add-on's)
That is indeed perseverance! Thanks. When all works well, kindly send a link to the zipped module for inclusion in the FA24extensions repo. It currently is in GitHub for the FA 2.3.x branch.
1,240 02/23/2019 05:51:43 am
Re: need some advice about sql is this bug or error on my end? (1 replies, posted in Report Bugs here)
Have you included the file that defines the said function? Check if the function exists and is in scope at that point.
1,241 02/23/2019 05:49:15 am
Re: Password not working for new company(1) (8 replies, posted in Setup)
You used the same database for the second company. Wonder how the admin user record did not get created in it's users table.
1,242 02/23/2019 05:47:35 am
Re: Duplicated Invoice Numbers if 2 users generating invoices at same time (23 replies, posted in Accounts Receivable)
Setup => Transaction References => Edit the "Pattern" field to include {UU} somewhere in it so that each user will have their own numbering.
1,243 02/19/2019 06:09:10 pm
Re: RepGen (4 replies, posted in Modules Add-on's)
Follow instructions in the docs folder of the module.
Basically try to generate some sample reports that are pre-populated in the sql folder which gets executed on activation and is usable on enablement of permissions for the desired role.
1,244 02/19/2019 04:21:30 am
Re: RepGen (4 replies, posted in Modules Add-on's)
Use the version in the FA24extensions repo. The official one does not work for FA 2.4 properly
Your issue is with the path not properly set in the official version of the extension and possibly permissions issue with the said folder if it still persists.
1,245 02/19/2019 04:18:18 am
Re: Last Visit Date with Time (2 replies, posted in Wish List)
@joe: This can be included in the core.
Setup => User Accounts Setup
Top Listing.
1,246 02/16/2019 05:15:25 am
Re: Duplicate entry on the GL Trial Balance (1 replies, posted in Banking and General Ledger)
Check the document number to see if the debt was doubly entered.
1,247 02/15/2019 02:47:15 pm
Re: Can't Find Dashboard Extension in 2.4.6 under Installed Extensions (2 replies, posted in FA Modifications)
Dashboard is now integrated in FA 2.4.x. There are a few themes that have been updated to partake of these new hooks to render them. One or two standard themes too leverage them.
1,248 02/13/2019 11:39:51 pm
Re: Password not working for new company(1) (8 replies, posted in Setup)
The users db seems okay.
Even though you could not log into the company 1, the errors would still be available in the tmp/*.logs files as well as the apache error logs at /var/log/....
The key error that appears is the lack of the en_AU locale from:
"Missing system locale: en_AU.iso-8859-1"
that the chart wants.
On a fresh install of FA 2.4.6+ Git Master code base, create company 0 and company 1 using the en_US-new and demo sql files as the chart of accounts.
Set the default "C" or en_US language locales to start with - do not make any changes for the Australian locale now.
Now see if you can login to both companies.
If all goes well, then install the en_AU locale in the server OS and then reboot the server for good measure and try with en_AU chart of accounts drawn from the FA24extensions repo - the official chart may not have been updated as yet.
The IP Hijacking code is listed in the wiki and referred to in a few posts in the forum but that addresses a connectivity recognition issue that may mostly not be directly relevant here.
The use of the bleeding edge MariaDB may have issues with FA's use of zero dates where strict date mode may need to be switched off. Assume you are using Ubuntu 18.04.
1,249 02/13/2019 03:40:09 pm
Re: couple of queries regarding 'Process Depreciation' (7 replies, posted in Fixed Assets)
@itronics: I hope this has not affected the depreciation / fixed assets reports
1,250 02/13/2019 03:26:23 pm
Re: Bank Account Charges (5 replies, posted in Banking and General Ledger)
Bank Account Charge is where you would have the contra entry for transactions that the bank injects like Account Maintenance Charges, Interest on Loan Account, Credit Card charges (not the direct spend), instrument clearing charges, exchange conversion fees, etc.