The Foreign Item Code is to be able to sell a bunch (Quantity) of items as a single bulk coded item.
3,651 12/16/2015 07:38:43 am
Re: Foreign Item Codes Quantity and Description (1 replies, posted in Items and Inventory)
3,652 12/15/2015 04:46:07 pm
Re: FA v2.4 development (48 replies, posted in Setup)
Today's commits have replaced aqua and cool standard themes with canvas and dropdown themes.
Dashboards can now be used in all themes with these new commits.
When we logout, the user session is completely destroyed and if the "login again" link is clicked, the previous session's username is not pre-populated in it's form field.
A small bugfixis necessary for thecanvastheme to show the graphic links and standscommitted in my unofficial repo. This has now been committed in the official repo.
The de_DE and pt_PT install lang files have yet to be corrected in the official repo. It stands committed in my unofficial repo.
3,653 12/15/2015 03:48:26 pm
Re: Decimal places of prices (14 replies, posted in Setup)
Have a look at includes/ui/ui_input.inc lines 768 to 775:
//JAM Allow entered unit prices to be fractional
function unit_amount_cells($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
{
if (!isset($dec))
$dec = user_price_dec()+2;
amount_cells_ex($label, $name, 15, 15, $init, $params, $post_label, $dec+2);
}Either 2 or 4 more decimal places are used when evaluating the unit amount.
If you extend the number of decimal places in the db table fields for unit price, the you can do all computations on unit_price with such more decimal places.
@joe: Is this issue addressed in FA 2.4?
3,654 12/14/2015 03:27:02 am
Re: Popup Window For Searching Items, Suppliers, Customers, & GL Accounts (8 replies, posted in FA Modifications)
10 items that match the filter is displayed. cool-autosuggest would be nice.
3,655 12/13/2015 01:44:02 pm
Re: Popup Window For Searching Items, Suppliers, Customers, & GL Accounts (8 replies, posted in FA Modifications)
Yes, the existing popup search functionality F2,F3, F4 and space.
See my previous post again for some edits and the attachment.
3,656 12/13/2015 01:23:59 pm
Re: Popup Window For Searching Items, Suppliers, Customers, & GL Accounts (8 replies, posted in FA Modifications)
I do hope they do not clash with the new popup search functionality in FA 2.4 and the existing one in FA 2.3.
Whenever you make changes to the core files, make sure you make all your white space changes first and then do a commit before the actual commit with your code changes. This will make it easier to follow the real changes.
Attached is an example of your latest BOM Session change.
When we login, a new session is created but when we access the init() function during FA usage thereafter, we need to make sure that we have a new BOM session but not when editing one. Hence it may need review.
3,657 12/12/2015 06:02:41 am
Re: FA v2.4 development (48 replies, posted in Setup)
Today's commits have brought on FA v2.4RC1 with most FA 2.3 bugfixes ported forward to FA 2.4.
The de_DE and pt_PT install language strings need to be fixed in the core. It is available from my unofficial FA 2.4 repo.
FA 2.4.x sports a new feature while restoring a backup - the default option of keeping existing security settings.
3,658 12/12/2015 06:00:11 am
Re: change bank account type (2 replies, posted in Banking and General Ledger)
In FA, just change the Account Name / description.
3,659 12/12/2015 05:59:09 am
Re: Self-billing (Invoicing ourselves to a supplier) (9 replies, posted in Accounts Payable)
You can use the Document Upload feature in FA and link it to the Customer Invoice.
3,660 12/12/2015 05:57:04 am
Re: Import Multiple Journal Entries results in "Internal Server Error" (3 replies, posted in Modules Add-on's)
It is possible that php is not enabled for your server or FA folder or there are folder / file permission issues.
3,661 12/11/2015 03:52:37 pm
Re: FA v2.4 development (48 replies, posted in Setup)
Todays commits have removed the popup search feature for Fixed Assets since there will be only a few in most accounting scenarios. The commits are:
Removed fixed assets from list item search and popup search.
and
Rerun of last non fixed assets search.
The above can be reverted for those who want it - use cases: Asset / Equipment / Building Leasing companies and large Fixed Asset companies.
3,662 12/11/2015 03:12:28 pm
Re: Size limit on restoring backup (14 replies, posted in Reporting)
Did you try to restore a backup that already exists on the FA server or attempted to upload one thru' the FA web interface? It could be a Apache limit - check the httpd.conf files.
3,663 12/11/2015 03:10:18 pm
Re: Self-billing (Invoicing ourselves to a supplier) (9 replies, posted in Accounts Payable)
Thanks for pointing this out. FA currently has no means of printing out Supplier Invoices. Only Purchase Orders can be printed.
@joe: Print Supplier Invoices is now needed for this use case. This way we can keep track of how they have been entered in FA.
3,664 12/11/2015 02:38:48 pm
Re: Self-billing (Invoicing ourselves to a supplier) (9 replies, posted in Accounts Payable)
That would be manual. Make the Supplier Invoice in FA, print it out and then email it.
You can look at how the Customer invoices are mailed out and hack the code into purchase invoices for auto mailing.
3,665 12/11/2015 02:13:35 pm
Re: Query Simplification functions (5 replies, posted in Announcements)
For generic CRUD type applications like phpMyAdmin, Adminer, etc, these functions are okay.
For some of the cases in FA where we predominantly have PHP based threshold WHERE conditions when a strange set of records with or without primary keys and/or structured generic JOINs needs to be selected or updated/manipulated we will end up making several atomized queries if we use the functions you suggest.
Also do not land up double db_escaping values!
However, most of the atomic changes can be accommodated using your functions and in the extreme, a SOAP API can be integrated into FA to perform such tasks generically other than for the exceptions in the light of optimization.
FluentPDO is one such PHP Library.
WordPress and Joomla have their own.
Time saving DB Functions
10 Useful PHP DB Functions | MySQLi variants
Which of your repositories has your functions.php file?
3,666 12/11/2015 02:05:50 pm
Re: Size limit on restoring backup (14 replies, posted in Reporting)
Increase the script max execution timeout as well in the php.ini apart from the max POST size and max upload size values and restart the webserver.
3,667 12/11/2015 02:03:46 pm
Re: Self-billing (Invoicing ourselves to a supplier) (9 replies, posted in Accounts Payable)
FA provides for entering Suppliers Invoices - assume the Supplier has billed you and make an appropriate Supplier Invoice Entry.
3,668 12/09/2015 01:18:46 pm
Re: Supplier Payment Entry(Rounding Problem) (8 replies, posted in Accounts Payable)
Thanks @joe.
3,669 12/09/2015 08:37:30 am
Re: Entry Purchase > Supplier Invoice (fa 2.4) (1 replies, posted in Report Bugs here)
This is a feature option.
In FA 2.3, check the config.php for the lines 161-172 (FA 2.4 - lines 115-126):
/* Accounts Payable */
/* System check to see if quantity charged on purchase invoices exceeds the quantity received.
If this parameter is checked the proportion by which the purchase invoice is an overcharge
referred to before reporting an error */
$check_qty_charged_vs_del_qty = true;
/* System check to see if price charged on purchase invoices exceeds the purchase order price.
If this parameter is checked the proportion by which the purchase invoice is an overcharge
referred to before reporting an error */
$check_price_charged_vs_order_price = True;3,670 12/09/2015 03:48:55 am
Re: FA v2.4 development (48 replies, posted in Setup)
The ERD Anomalies in the previous post have been addressed in today's commits along with the typo fix in en_US.new.sql in the 44th post.
The FA version number will be updated during release of FA v2.4rc1 as also the *.mo files in the install/lang language folders along with all translations in the core.
Company level configurable sys_prefs (company.setup) options to be able to hide the Fixed Assets and Manufacturing applications are now available in today's commit - use_manufacturing and use_fixed_assets.
Two new config file options have been introduced - $use_popup_search and $max_rows_in_search - enabling popup search in Customers, branches, suppliers, inventory, fixed assets and GL Accounts.
Some 14px icons have been replaced by 16px icons but the css is retained to display them as 14px icons.
A small fix to the upgrade scriptis in my repo. Committed in the official core now.
stock_fa_class table field widths and form field widths for Fixed Assets Classes form is attached for review and correction.
3,671 12/09/2015 03:34:53 am
Re: How to disable custom report link (1 replies, posted in Reporting)
Set the config variable:
$hide_inaccessible_menu_items = 1;3,672 12/09/2015 03:32:14 am
Re: Supplier Payment Entry(Rounding Problem) (8 replies, posted in Accounts Payable)
This is possibly done to increase the precision for computing to avoid rounding errors / deltas where unit amounts are computed from large quantities based bulk pricing.
3,673 12/08/2015 06:24:23 pm
Re: Uploading transactions (5 replies, posted in Setup)
The ERD is available in the Wiki.
The method I outlined above is to make sure the "scripting" is right before making it into a php script - form to acquire the csv, validate it, process it.
3,674 12/08/2015 05:53:16 pm
Re: Uploading transactions (5 replies, posted in Setup)
Actually you can do it all in excel and then paste it into any MySQL client like phpMyAdmin / SQLyog.
1. Take a backup of FA from within the Web GUI.
2. Enter a typical set of transactions from one record (row) in excel in several steps in FA in the Web GUI manually.
3. Take another backup of FA from within the FA Web GUI.
4. Compare the 2 Backups and see what has changed - tools like SQLyog can provide for database synch sql commands across databases (copies of before and after).
5. Using your Excel record's set of FA transactions SQLs, generate the SQLs using CONCATENATE for all the other records and paste them into the MySQL client.
3,675 12/08/2015 05:42:40 pm
Re: WP Plugin Frontaccounting Connect (4 replies, posted in Modules Add-on's)
The GitHub link is empty.
The SVN link has been zipped and attached here.
The original WP post is here.