Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 100 of 245)
Topics by apmuthu User defined search
Posts found: 2,476 to 2,500 of 6,111
Works as expected for Customer Credit Note Edit.
1. Create a Credit Invoice for 3 items (Payment Terms: Not Cash Invoice as it will have a Cash payment entry automatically made)
2. Create a Credit Note for 1 item returned
3. Create a payment for 1 item and allocate it to the Invoice
4. Edit earlier Credit Note and make it as 2 items returned
5. Allocate the Credit Note to the Invoice
6. The settled Invoice will show it's fulfillment transactions as okay.
Attached is the sequence of operations documents.
The same sequence should suffice for a Supplier Txn.
Possible bug in the Supplier Credit Note Edit - each edit makes a separate Credit Note!
Also getting:
Rounding error -0.01 encountered for trans_type:11,trans_no:1
Since the format from every supplier need not be the same, the script will need to be customised as per your need - make an extension for it then.
When using FA, make sure there are no other instances of the browser / browser tab open.
This tool misses out on CHAR to VARCHAR conversions and some other small constructs, but yes, it is a quick and dirty fix.
Attached is the SQLyog output for the same FA 2.3 to 2.4 official diff.
Yes, variable assignment is not acceptable inside the gettext function call since it is checked for presence in the compiled .mo file if available and else the string is returned verbatim if valid.
The person_id field in both gl_trans and bank_trans tables are of tinyblob type whereas it is of INT type in all other tables (crm_contacts, cust_allocations, supp_allocations) where it exists. Luckily, it does not form part of any index when in the tinyblob avatar.
@joe: Would you like to correct this inconsistency by making it INT everywhere it is a tinyblob? Or is there any reason for this different type casting?
The ,po file should then be compiled into a .mo file which is what the gettext engine will lookup. If any string does not exist in the translations files then the source string will be used. All translations will generally get updated during the release phase. Compare the empty.po file with the one you have for your language and update as necessary. Alternatively code and collect at Transifex.
Whichever currency is the settlement currency agreed upon for the transaction should be taken and the appropriate exchange rate accepted / adjusted in the company's home currency to provide for the contra. The Exchange Rate Profit/Loss account should take care of the rest.
Decide on what language you want the Chart for Lebanon to be in and if English, it can be named en_LB.sql.
1. Start by making a copy of sql/en_US-new.sql as say en_LB.sql.
2. Edit the en_LB.sql file for chart_master, currencies and sys_prefs tables data among others as suited to Lebanon.
3. Place the en_LB.sql file in the sql folder in FA.
4. Insert a stanza for the Lebanese chart in installed_extensions.php file.
The newly created Lebanese Chart of Accounts will now be available in creation of new company form.
Please share your code so that it can be evaluated to accomodate it into the core.
You probably mean:
When a user enters the price of an item, if that :
price < cost (which cost: average, last, etc?) show a yellow notification alert
price < list price (which list price - there may be many) show a red notification alert.
Make an extension to implement your rules.
The fix is a little long. @poncho1234's fix to acquire the inactive field's value directly in the sql may have sufficed as the combo box generation routine merges the $show_inactive variable appropriately like all other tables based combos. Functions like item_type_inactive($id) if replicated for each and every inactive field in FA's multitude of tables would become a veritable maze. Any overarching issues that were encountered in fixing it this way would be a lesson on coding similar pages for the community at large.
@itronics: Thanks for the quick fix.
The sales/manage/customer_branches.php already has hidden('popup', @$_REQUEST['popup']); in it's line 226 and hence F3 - Select Branch works as expected in Direct Invoice like forms.
Line 303 of sales/manage/customers.php:
should now be:
div_start('controls');
if (@$_REQUEST['popup']) hidden('popup', 1);
Similarly for purchasing/manage/suppliers.php at line 169 as well.
The Supplier deletion notification is obtained by making line 281 in purchasing/manage/suppliers.php:
$Ajax->activate('_page_body');
to be
$Ajax->activate('_page_body');
display_notification("#" . $_POST['supplier_id'] . " " . _("Supplier has been deleted."));
@joe: Tested. Can commit.
The sql/alter2.4*.php files are there to migrate the data into the new fields/tables and the FA web user interface is the correct way to upgrade an FA install.
To compare the standard chart differences and sql statements needed to synch the database from FA v2.3 to FA v2.4 we can use the online tool at http://www.infoom.se/compare-mysql-online/ by pasting the FA 2.4.2+ sql/en_US-new.sql's contents in the upper textbox and that of the FA 2.3.x counterpart in the lower textbox and click "Compare".
Attached is the current state.
On further investigation, your fix is in order. See attachment. The inactive item_tax_type is seen with a strikethrough (CSS styled).
@joe: can commit it.
Looks like there must be atleast 1 entry in the "item_tax_types_list()" - there is no filter to remove the inactive ones. This is the "item_tax_types_list" and not merely the" tax_types_list".
I still see the inactive tax type.
The inactive field is missing in the SELECT field list in the functions tax_types_list() (line 1171) and tax_groups_list( (line 1205) too apart from your above item_tax_types_list() (line 1237) and templates_list() (line 1369) and workorders_list() (line 1399).
For any of the combo boxes, is it possible to add new elements on the fly?
@joe: is this fix necessary?
SESSION may have not been refreshed. Logout and close all instances of the browser and then try again.
Check your CHARSET settings in your Navicat for the DB used.
Hex 0x3830354e = Dec 942683470
Check for CRLF ("\r\n") characters in the strings. Excel has cell delimiters that can go awry.
The Wiki page on Exchange Rates now sports troubleshooting issues thereat. The files used in the FA webroot are attached herewith.
The import transactions can be used possibly for importing Purchase Orders in CSV) too. These Purchase Orders can then be turned into Invoices as needed in the FA UI.
The Auto Fill form can be implemented as a popup with a multiple select list checkbox set as well but the system will not accept if the order quantity is 0 or absent. A comma separated item code list if input into the item code field (form field size to be addressed) it should expand it accordingly but what if invalid item_codes were input?
Stands corrected now in the official repo.
Good catch @notrinos. This is what happens when a blind copy/paste occurs. My repo has the right code.
The PRIMARY KEY of the 0_bom table in both FA 2.3 and FA 2.4 is part of the list below:
PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
KEY `component` (`component`),
KEY `id` (`id`),
KEY `loc_code` (`loc_code`),
KEY `parent` (`parent`,`loc_code`),
KEY `workcentre_added` (`workcentre_added`)
It can be re-arranged like this to save an index that would then have become redundant:
PRIMARY KEY (`parent`,`loc_code`,`component`,`workcentre_added`),
KEY `component` (`component`),
KEY `id` (`id`),
KEY `loc_code` (`loc_code`),
KEY `workcentre_added` (`workcentre_added`)
Also why have the erstwhile VARCHAR fields like loc_code and some other fields now become CHAR in FA 2.4?
The official repo mirror on GitHub now stands committed for the supp_trans table fix as well.
All Chart maintainers are requested to submit suitable changes / devs may update the charts in the official pkg repo.
Everything works as expected. See attachment with files in transaction sequence.
Posts found: 2,476 to 2,500 of 6,111
