It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
The company/# folder may have changes and hence duplication may be in order.
Use OpenVZ Virtual Machines and synch the db and rsync the company folder - no need to change the company # as well and the db backup will be restored faithfully on the training VM.
Void the payment and create a new payment will have a proper record of the error and it's correction - that is the right way accounts should be maintained.
Correcting it in the database should be done carefully after backup and browser cache should be eliminated - logout and login again - so that there is no bad session variable lurking to trip us.
It is possible that the backup itself had the double records!
If negative inventory is used, then the quantity that is negative should not be used to update the standard cost - this will most probably be the source of the error.
It is more a system level db centric update. Rarely changes within a minor version - sometimes a force update may be in order when manually upgrading. If used, use with care after backup.
Yes, let us wait for the official one - it will have all the incremental changes as well. The unofficial one I have put up has only release-to-release changesets.
Placed a caveat there as no one should be mislead.
This repo will be updated only when I have the time.
It is meant to enable easy localised forking on GitHub from any release.
It can be used to study differences for migration between versions where individual proficiency in using GIT is better than in using Mercurial
Like any development code repo, code here should be used with care.
Do not be fooled that any snapshot is well tested stable release, while in many times it is not.
Using full random snapshots of FA repo is officially unwelcome
FA Repo code is placed here for study, development and local deployment only especially where internet is not available
FA versions are not released too often in order to provide a minimal acceptable level of stability, which is important especially in accounting software
Very soon the FA project will establish an automatically updated GIT mirror repo that should have all the incremental HG changes
This is meant for those upgrading from a lower database schema version from older versions of FA. It is not used in fresh installs.
A manual GitHub Mirror of the SourceForge Mercurial repo and the FA PKG Repo is now available at:
http://github.com/apmuthu/frontaccounting
All FA Releases from v2.2.1 till v2.3.15 (HG 3184) and the latest as on date HG 3212 are available in the core folder. The extensions are available is fully expanded form ready for manual install / development.
The Announcements topic will have info on recent releases.
Release v2.3.15 Announcement Thread has it's latest HG Repo diff file set posted.
This will hopefully help debugging new issues without having to revisit old solved ones.
HG 3212 does the job. All line endings fixed as well. Thanks Janusz for the quick turnaround.
Here is a oneliner to convert all the Windows / DOS CRLF to UNIX LF line endings:
find ./ -type f \( -name "*.php" -o -name "*.css" -o -name "*.js" -o -name "*.txt" -o -name "*.inc" \) | xargs dos2unix -UCurrently only 3 files seem affected as of FA v2.3.15:
sales/inquiry/sales_orders_view.php
purchasing/includes/db/grn_db.inc
manufacturing/includes/db/work_orders_db.inc
Wonder when it was introduced and by whom.....
Thanks Janusz. Dashboard r5 along with HG 3207-3210 sets right the issue natively without resort to the patches in this thread since the js inclusion has been moved back to the theme's renderer.php back again from the module's hooks.php.
Since the $path_to_root variable is hardcoded as "../../" in the dashboard setup and other php scripts in the modules/dashboard folder, it is necessary to see that the correct path is used to make sure that the install_tabs() in the hooks.php file works correctly for submenu clicks. This is ensured by patching the includes/page/header.inc till a proper alternate solution is found.
Also the FA-dashboard-r4/modules/dashboard/sql/update.sql file can have the AUTO_INCREMENT=6 phrase removed in both table creation statements.
Those who have already installed the dashboard can reset the AUTO_INCREMENT counter with:
ALTER TABLE `0_dashboard_reminders` AUTO_INCREMENT=1;The id nos 4,5 and 8 are missing in the widgets table data.
Also the readme can list some means to populate the dashboard_setup.php and reminder_setup.php script links as a widget in the setup panel besides mentioning that the module must first be installed before the theme is installed and used.
The installed_extensions.php file in the company/# folder gets populated with "active=>false," instead of "active=>1," for the dashboard_theme v2.3.15-1 entry.
File: includes/page/header.inc
Line 85 already assigns $theme = user_theme();.
Hence line 139:
include_once($path_to_root . "/themes/".user_theme()."/renderer.php");can become
include_once($path_to_root . "/themes/$theme/renderer.php");Managed to make the dashboard module/theme work as it should by hardcoding the inclusion of jquery-1.3.2.js file and investigated it's cause.
modules/dashboard/hooks.php declares function install_tabs().
Function install_tabs() lists the js files to be included (array $js_userlib) by using the function add_js_ufile().
Function add_js_ufile() (uses full URI / local path and filename) is defined in includes/main.inc along with another function add_js_file().
Only the function add_js_file() (uses only filename) does a file exists check in the fixed webroot's js location as well, using the file include list in array $js_static.
Both add js functions make sure that each file/URI is included only once from their respective arrays.
The file includes/page/header.inc declares the function send_scripts() which includes the files in the $js_static array (from company/#/js_cache/*.js or js/*.js) first and then includes the files from the $js_userlib array with no checks (neither existence nor once only inclusion)
The renderer class is instantiated in both the page_header() and page_footer() functions with the same name $rend.
Another function add_js_source() is also defined in includes/main.inc where the js to be included is in $text variable sent as an argument but is used in the function page_footer() defined in includes/page/footer.inc and is not used here.
The way out here would be to include the jquery scripts int the main webrootjsfolder itself and switch theadd_js_ufile()function to theadd_js_file()function for the said files in the themodules/dashboard/hooks.phpfile. The main menu click determines the $path_to_root as "./" but the submenu click sees it as "../../" though the global one is "../" for it, which confounds the js inclusion function.
It is possible that many extensions will use the jquery function and this will avoid duplicate files - versions of the jquery will however have to be taken into account for the specific extension concerned.
What was the sequence of operations that led to this state of the db?
Please make a fresh test instance of FA (take the latest patches on board) and make a set of operations that will result in one set of negative values. Then we can decipher what went wrong.
Also, make a comparison between a backup sql (where the entries were positive) and a current (negative) sql dump and see what tables and records are affected.
Items and Inventory -> Standard Costs
1. select item
2. Standard Material Cost Per Unit is shown
3. if you want to adjust the standard cost enter it in the field and click Update
For RTL languages must the underscore succeed the character?
A nice caveat to it's use but when secure FA is run in an offline environment, this might be the only solution. If being online is necessary for other aspects of google charts then it would be of no use in this situation.
Thanks @AlastairR for the note and it's potential pitfalls.
The dashboard_theme v2.3.15-1/renderer.php line 42:
echo "<script type='text/javascript' src='https://www.google.com/jsapi'></script>\n";refers to an external javascript file than can be internalised.
Also line 10 of js/jquery-ui-1.7.2.custom.min.js in the same theme refers to:
http://www.w3.org/2005/07/aaaIf there are any files included from external sites, addon authors are advised to state them.
This code has since been moved to line 25 of hooks.php in the google code svn:
add_js_ufile("https://www.google.com/jsapi");which can now become:
add_js_ufile("$path_to_root/themes/dashboard/js/jsapi.js");after uploading the jsapi file as js/jsapi.js
The problem exists in MSIE v8.0 / WinXP SP3 as well.
Located the issue as something to do with javascript error Line 18 Char 1 that is explained in this page. The solution to fix by resetting MSIE does not work.
The comparative portions of the html source of the working and non-working pages are attached herein.
Thanks Janusz - Bug Fixed in HG 3206.
In FireFox v19.0.2, in a Dashboard theme, on clicking a left menu entry, the resulting page has clickable menus on the left but they cannot be clicked.
Updated the 3 files (attached) from the googlecode svn - no luck yet.
Try to put all the actual values for highest amount and there will be no more columns left and data will be truncated. Maybe possible if the invoice was in landscape format.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.