Compare your current backup with your initial CoA and cherry pick what you want. The theme's tables / files can be managed after the import. You can also seek professional assistance - post in the jobs offered topic or contact any of the FA consultants.
4,302 03/19/2015 03:29:33 pm
Re: Add columns to gl_trans table (5 replies, posted in FA Modifications)
Creating new fields in tables in FA's core will break upgrade ability.
4,303 03/19/2015 03:28:02 pm
Re: Import Transactions 2.3.22-4 2.3.22-4 (7 replies, posted in Banking and General Ledger)
Link to commit would be useful. Your commit list does not show it as yet.
4,304 03/19/2015 03:25:32 pm
Re: Journal Entries Against Suppliers/ Customers (2 replies, posted in Banking and General Ledger)
Credit Notes and Debit Notes for Suppliers and Customers may be what you want.
4,305 03/19/2015 03:22:50 pm
Re: Currency differences appear when bank transfer (3 replies, posted in Banking and General Ledger)
If you allow automatic exchange rate conversion to be used then your preferred exchange rate provider will be contacted for the first transaction of the day and the rate table will be populated. If you want to manually multiply the rate and not use the FA Exchange rate system, then use only the company's default currency for your customers / suppliers / bank and manage the conversions outside of FA.
The exchange rate profit and loss is there to allow you to contra all payments in the respective currencies of each account and accommodate the differences here.
4,306 03/19/2015 03:20:27 pm
Re: can't display any translation (6 replies, posted in Translations)
Thanks for the link @baselbj!
4,307 03/16/2015 01:31:43 pm
Re: Release 2.3.22 (7 replies, posted in Announcements)
The consolidated set of changed files since the release of FA v2.3.22 is attached herein and is current as on date.
4,308 03/16/2015 01:28:27 pm
Re: can't display any translation (6 replies, posted in Translations)
Can you paste the link to the specific PHP 5.5 bug?
4,309 03/16/2015 01:27:19 pm
Re: Currency differences appear when bank transfer (3 replies, posted in Banking and General Ledger)
Make sure that the company default Currency matches the Banks currencies then, if you do not want to use the multi currency feature of FA.
4,310 03/16/2015 01:25:24 pm
Re: Restore Help (5 replies, posted in Installation)
Which are your source and target FA versions?
What extensions do you have in your current FA?
What purpose do you wsih to achieve in doing such a migration instead of a full sql restore?
4,311 03/16/2015 01:23:19 pm
Re: Customer code (1 replies, posted in Accounts Receivable)
It is possible you are being afflicted by browser cache. Clear the cache and close all instances of the browser and then try again.
4,312 03/16/2015 01:22:05 pm
Re: Item code (1 replies, posted in Items and Inventory)
Please state whether you are using the stock FA v2.3.22 or the latest bugfixed snapshot. Also what platform and component versions you are using. The exact screen menu navigation sequence that leads to your error would be useful for the community to assist you.
4,313 03/16/2015 12:58:29 am
Re: FA ERD (1 replies, posted in Installation)
The Wiki Page https://frontaccounting.com/fawiki/inde … RDiagram23 is correct as the pdf was prepared several years ago probably when FA v2.3.1 was released.
4,314 03/15/2015 12:03:28 pm
Re: can't display any translation (6 replies, posted in Translations)
Navigate to Menu "Setup => Display Setup => Language" and choose your language, save and logout and login again.
Also read the Wiki.
4,315 03/15/2015 04:18:23 am
Re: Remove all color from PDF's (3 replies, posted in Reporting)
Try to change the font from Normal to underlined.... for the said report field
4,316 03/15/2015 04:16:30 am
Re: Elegant theme - missing page_edit.png file - fix (1 replies, posted in Report Bugs here)
Thanks @p2409 for detecting this issue. Take the file from dynamic, exclusive or exclusive_db theme which share common code.
Committed it in my GitHub repo and attached it here.
4,317 03/14/2015 05:09:44 am
Re: Cannot process item adjustment (2 replies, posted in Items and Inventory)
Add a SS?
Are you using the latest textcart in my GitHub Repo. On Jan 21st, some updates were done to accommodate the allowing of negative inventory.
The following commits address them:
elax synch
core synch
Attached is the latest fileset for the textcart extension.
The official pkg repo has not been updated in a while.....
4,318 03/13/2015 08:31:04 pm
Re: Release 2.3.22 (7 replies, posted in Announcements)
Those downloading the 2015-03-12 snapshot of the stable branch (FA 2.3.x) from the Official Git/Hg repo should be aware of the changes done and what breaks in the theme's renderer.php files.
The following have been done across 85 files:
quotes or double quotes attributes in the html tags
removes many short closing tag slashes
<script language to <script type
ref_cells() to ref_row()
removal of trailing whitespace
new function display_caption() - only the align property of the <caption> tag not supported in HTML5
removed colspan when width='100%'
The W3C HTML5 specification supports negative tabindex values which had been used only in the cool theme hitherto.
If the value is a negative integer
The user agent must set the element's tabindex focus flag, but should not allow the element to be reached using sequential focus navigation.
In themes/cool/renderer.php the aqua image files of help.gif and login.gif are used.
The aqua and default themes have errors in the $img file html img src tags.
All whitespaces have been synched across all theme renderer.php files and above errors rectified in the patch file sent to the devs. Line numbers may differ since the whitespace and blank lines have been synched. This will be useful when we propagate one theme's changes to the others.
The devs have been notified.
The devs have now fixed it in the snapshot on 2015-03-14.
4,319 03/13/2015 03:16:25 pm
Re: ADD SALES MAN EMAIL AND PHONE NUMBER ON QUOTATION (1 replies, posted in Accounts Receivable)
Look at the Salesman Report rep106.php.
4,320 03/13/2015 03:07:15 pm
Re: How do I print a check? (10 replies, posted in Banking and General Ledger)
Post the "USA" standard check layout and the check printed on it (superimposed as well) both scaled to size as an image somewhere and state the link here in.
Locate the file modules/rep_check_print/reporting/rep_check_print.php and edit the function print_check().
4,321 03/13/2015 02:43:14 pm
Re: retrieve tax from item (1 replies, posted in FA Modifications)
The SQL is:
SELECT tt.rate
FROM `0_stock_master` sm LEFT JOIN `0_tax_types` tt
ON (`sm`.`tax_type_id` = `tt`.`id`)
WHERE stock_id="MY_ITEM";Tax rates are not that straightforward. The items may be having different tax rates depending on the actual invoice where a Customer may have tax overrides.
Attached is the ERD for the SQL provided here.
Will the function get_item_tax_type_for_item($stock_id)
function get_item_tax_type_for_item($stock_id)
{
$sql = "SELECT ".TB_PREF."item_tax_types.* FROM ".TB_PREF."item_tax_types,".TB_PREF."stock_master WHERE
".TB_PREF."stock_master.stock_id=".db_escape($stock_id)."
AND ".TB_PREF."item_tax_types.id=".TB_PREF."stock_master.tax_type_id";
$result = db_query($sql, "could not get item tax type");
return db_fetch($result);
}in lines 61 to 70 intaxes/db/item_tax_types_db.inc suffice or would you like to clone it by replacing the sql?
4,322 03/13/2015 02:32:25 pm
Re: need retrieving tax rate per item during invoice generation (14 replies, posted in Reporting)
At the moment, just increase the number of decimal places in the Setup => Display Setup and round off the field in the report to 2 decimal places.
FA v2.4 has been in the making for quite a few years now....a few more months to wait is okay perhaps....
4,323 03/13/2015 02:27:47 pm
Re: 0-VAT again (44 replies, posted in Reporting)
I have attached the output of your SQL statement for the en_US-demo CoA - I do not see any duplications. Please show which ones you consider duplicate for what set of restricted unique keys.
4,324 03/11/2015 12:24:59 pm
Re: 0-VAT again (44 replies, posted in Reporting)
@dls: I think @elax did mention some limitations, possibly for Supplier Invoices.
@elax: please have a look.
4,325 03/11/2015 09:37:39 am
Re: 0-VAT again (44 replies, posted in Reporting)
After comparing elax FA v2.3.19 Tax Support Patch, incorporated changes in FA 2.3.22+ as on date retaining all white space in the latter.
Please provide feedback.