Are you on Linux or Windows?
Are you running FA on your local machine?
PM me remote access if you cannot find local technical help.
3,901 08/30/2015 10:50:55 am
Re: Restore Password (19 replies, posted in Installation)
3,902 08/30/2015 09:55:18 am
Re: FA v2.4 development (48 replies, posted in Setup)
Ref: Recent commit into the FA 2.4 branch:
PDF documents sent by email have now meaningful names.
Remove erroneous line 134 inreporting/includes/class.email.inc - stands removed in commit.
for ($i = 0; $i < $max; $i++)In order to use this functionality for download as well (insecure), lines 972 to 975 in reporting/includes/pdf_report.inc:
// if ($email == 1)
// $fname = $dir.'/'.$this->filename;
// else
$fname = $dir.'/'.uniqid('').'.pdf';should be uncommented as:
if ($email == 1)
$fname = $dir.'/'.$this->filename;
else
$fname = $dir.'/'.uniqid('').'.pdf';It is better to have some switch flag in the company preferences to do this instead if desired.
This feature can be safely backported into FA 2.3 if needed.
The other two commits too can be backported to FA 2.3:
Void a Transaction: fixed GRN voiding.
Fixed sparse js dialog when canceling sales document entry.
3,903 08/30/2015 09:27:42 am
Re: FA v2.4 development (48 replies, posted in Setup)
FA 2.4 Official Repo PKGs as available today within the FA application as screenshots are posted in the wiki in my unofficial GitHub.
3,904 08/30/2015 08:47:36 am
Re: New Modern theme (5 replies, posted in Modules Add-on's)
Populate some autosearch field and take a snapshot of the auto search suggestion list - see if the existing older js files work with your theme.
3,905 08/30/2015 08:29:33 am
Re: Restore Password (19 replies, posted in Installation)
Use a MySQL client like SQLyog to make sure that your MySQL user permissions for the FA db is okay and the permissions reloaded (FLUSH PRIVILEGES;).
3,906 08/29/2015 09:49:16 am
Topic: Unchanged Languages Version Bumped (0 replies, posted in Modules Add-on's)
The following language translations in the Official FA PKG Repo have been version bumped despite having no changes in them:
bg_BG_2.3.0-4
bs_BA_2.3.0-4
de_CH_2.3.0-4
en_NZ_2.3.2-4
es_CO_2.3.0-4
id_ID_2.3.0-63,907 08/29/2015 08:38:04 am
Topic: Unchanged themes - versions bumped (2 replies, posted in Modules Add-on's)
The following themes do not have any changed files but their versions have been bumped:
dashboard_theme-2.3.15-5 (/images/alloc.png still missing)
greyred-2.3.0-9 (grayred => greyred typo in files yet to be corrected or theme to be renamed to grayred)
modern-2.3.0-7
studio-2.3.0-7The theme elegant-2.3.0-8 still has /images/page_edit.png missing.
3,908 08/29/2015 07:46:12 am
Topic: Chart Updates in Official FA Repo (0 replies, posted in Misc. Charts of Accounts)
Updates to the various Chart of Accounts (CoAs) from the Official FA Repo have been incorporated along with other fixes in my GitHub Repo.
Those using the following CoAs:
ar_EG-8digits.sql
en_GB-general.sql
id_ID-4digit.sqlwill need to follow these instructions if they have already used the old CoAs:
ar_EG-8digits.sql
=================
`0_purch_orders`.`total` should be after `delivery_address` field and not at the end.
`0_suppliers`.`tax_included` should be after `payment_terms` field and not at the end.
INSERT INTO `0_sys_prefs` (`name`, `category`, `type`, `length`, `value`) VALUES
`0_sys_prefs` VALUES ('bcc_email', 'setup.company', 'varchar', 100, '');
UPDATE `0_sys_types` SET `type_no` = 1;
`0_bank_accounts`.`bank_account_name`: varchar(60) => varchar(120)
`0_chart_types`.`name`: varchar(100) => varchar(120)
en_GB-general.sql
=================
Drop field: `0_bank_trans`.`bank_trans_type_id`
Remove dashboard_* tables
Outdated fiscal year entries
`0_currencies`.`auto_update` should be after `hundreds_name` field and not at the end.
`0_cust_branch`.`branch_ref` should be just after the `br_name` field
`0_stock_category`.`inactive` should be just before the last field.
UPDATE `0_sys_types` SET `type_no` = 1;
`0_chart_master` table:
Replace all account_code values of 00xx with 10xx
Change 8601 Profit and Loss account code to 9990 to conform to en_US-new
id_ID-4digit.sql:
=================
Replace all instances of dimension0 with dimension23,909 08/29/2015 07:40:35 am
Topic: Unchanged extensions - versions bumped (0 replies, posted in Modules Add-on's)
As on date, the Official FA pkg Repo has been updated with version bumps for the following extensions without any changes to the code:
asset_register-2.3.3-11
import_items-2.3.0-3
import_multijournalentries-2.3.0-8
import_paypal-2.3.10-4
rep_tax_cash_basis-2.3.7-5
repgen-2.3.9-5Updates to the zen_import module have yet to be incorporated into the official PKG repo and it remains at zen_import-2.3.15-1, whilst my GitHub repo has the updated code as zen_import-2.3.15-2
3,910 08/29/2015 07:32:50 am
Re: Automatic Invoice report for sales order. (5 replies, posted in Reporting)
When a Sales Order is placed, there has been no delivery and no invoice as yet. Hence there will be no Invoice Report. Only when the Invoice has been generated will there be an Invoice Report as is available when a Direct Invoice has been prepared.
3,911 08/29/2015 05:08:32 am
Re: Automatic Invoice report for sales order. (5 replies, posted in Reporting)
You probably need to do a Direct Invoice which generates the Sales Order as well.
3,912 08/29/2015 05:07:00 am
Topic: Import Transactions Filter fix not yet included (0 replies, posted in Modules Add-on's)
The Filter Fix provided in the forum post has not yet been incorporated in the latest import_transactions-2.3.24-1.pkg.
3,913 08/29/2015 04:23:57 am
Topic: Dashboard PKG - wrong version in extensions? (0 replies, posted in Modules Add-on's)
Today's check on the official FA 2.3 Repo reveals that whilst the dashboard theme is at dashboard_theme-2.3.15-5.pkg, the dashboard extension now shows dashboard-2.4.0-1.pkg.
3,914 08/28/2015 03:12:06 pm
Re: New UI For Frontaccounting (12 replies, posted in Announcements)
Too spaced out - conserve screen real-estate.
Thin white lettering on light blue background makes for low contrast.
Bootstrap use is minimal.
Not made responsive as yet suiting multiple width devices to justify using Bootstrap.
3,915 08/28/2015 03:06:19 pm
Re: Recurring invoices (2 replies, posted in Accounts Receivable)
Look at line 44 in sales/create_recurrent_invoices.php
$doc->Comments .= sprintf(_("Recurrent Invoice covers period %s - %s."), $from, add_days($to, -1));The above file is called only in line 38 of applications/customers.php - lines 37-38:
$this->add_rapp_function(0, _("&Create and Print Recurrent Invoices"),
"sales/create_recurrent_invoices.php?", 'SA_SALESINVOICE', MENU_TRANSACTION);which is just the menu entry to create and print Recurrent Invoices.
3,916 08/28/2015 02:58:22 pm
Re: New Modern theme (5 replies, posted in Modules Add-on's)
Please make it into an installable theme with no core file overwrites.
Most changes pertain to CSS.
Avoid duplicating the need for js files that already exist in the core.
Keep up the good work.
3,917 08/28/2015 02:53:32 pm
Re: Theme with chat (7 replies, posted in Wish List)
Chat can be a link to some chat application or web-service placed inside any theme's top menu portion (header).
3,918 08/28/2015 03:04:17 am
Re: Restore Password (19 replies, posted in Installation)
Since this will be asked quite often, it has been wiki-ed as well.
3,919 08/27/2015 05:38:18 pm
Topic: Free eBook on Accounting Pinciples (1 replies, posted in Setup)
Accounting Principles - Financial Skills
fme-accounting-principles.pdf
32 pages, 355 KB
This book, though copyrighted is being offered free at distrowatch.com - screenshot attached.
3,920 08/27/2015 05:01:00 pm
Re: Import Transactions (154 replies, posted in Modules Add-on's)
@gbw: Thankyou for your valuable feedback regarding spaces.
Since the strings in the CSV are not quoted or double quoted, spaces should be taken as a zero for numerical fields and trimmed for others in the extension.
Wiki-ed it.
3,921 08/27/2015 10:10:08 am
Re: New inventory related custom field (5 replies, posted in Wish List)
@joe: How would we go about using the Foreign Item Code as a Bin Location? Must we somehow manually edit the item_codes table to make such foreign code entries have their is_foreign field as 0 instead of the default 1? It would also have to set it's Quantity field to 1 and possibly prevent it from inundating the sales invoice item drop down boxes as duplicates of their parent items.
Here is a sample set of transactions sql results on the training database:
-- Items and Inventory => Items => Add New Item
-- On Adding Item001
INSERT INTO `1_item_codes` VALUES
('6', 'Item001', 'Item001', 'Test Item 001', '1', '1', '0', '0');
INSERT INTO `1_loc_stock` VALUES
('DEF', 'Item001', '0');
INSERT INTO `1_stock_master` VALUES
('Item001', '1', '1', 'Test Item 001', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
-- Items and Inventory => Foreign Item Codes => Add New Foreign Item
-- On Adding 2 Foreign Item Codes for newly added item
INSERT INTO `1_item_codes` VALUES
('7', '2154658', 'Item001', 'Foreign Item Code of Test Item 001', '1', '45', '1', '0'),
('8', '32568', 'Item001', 'Foreign Item Code for Next Test Item 001', '4', '14', '1', '0');
-- Items and Inventory => Sales Pricing => Add New Sales Price
-- Added Sales Prices
INSERT INTO `1_prices` VALUES
('5', 'Item001', '1', 'USD', '3'),
('6', 'Item001', '2', 'USD', '2.5');Attached is the screenshot of a direct invoice entry in progress.
Adding foreign codes form has a Category field for the item - must we allow such a field to introduce ambiguity with that in the parent Item? This will make for the same stock_id having different category_id in the item_codes table!
3,922 08/27/2015 05:56:22 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Have a look at the templates folder in the said module. There are 9,10,11 or 24 commas in each field in the CSV files there.
Your data set seems to be following the templates/bank_en_GB.csv file.
Which CoA are you using? The UK CoA has some errors in field order.
Check out the corrected extensions and CoAs in my unofficial GitHub Repo.
3,923 08/26/2015 03:25:12 pm
Re: Restore Password (19 replies, posted in Installation)
Replace the users.password field value with a known one like "5f4dcc3b5aa765d61d8327deb882cf99" and use the string "password" to login.
The users.user_id field has the username.
Use appropriate table prefix as needed.
3,924 08/26/2015 03:18:22 pm
Re: quick entries question (5 replies, posted in Banking and General Ledger)
Wiki-ed it under Workarounds in the Quick Entries page.
3,925 08/26/2015 03:10:20 pm
Re: New inventory related custom field (5 replies, posted in Wish List)
Such information in FA 2.3.x can be stored as part of the stock_master.long_description field and used as in the Wiki Article on Bin Locations.
In FA 2.4, a separate field in the stock_master table to provide for BinLocation would be useful.