Diff Files from FA v2.3.16 to FA v2.3.17 is attached herein.
5,477 09/06/2013 06:38:02 am
Re: Release 2.3.16 (3 replies, posted in Announcements)
FA v2.3.16 is synched with the unstable v2.4.
The diff file set from v2.3.15 to v2.3.16 is attached herein. Minor SQL changes pertaining to extra fiscal years and default company fiscal year are needed (see the sql file diffs).
5,478 09/06/2013 06:28:35 am
Re: Release 2.3.18 (4 replies, posted in Announcements)
The changed list of files that can safely overwrite existing ones for migration from FA v2.3.17 to FA v2.3.18 is attached herein.
No database changes needed.
5,479 09/06/2013 05:48:43 am
Re: The tuffy.php font file for changing FA default document fonts (1 replies, posted in FA Modifications)
No attached files. Zip up the font files together and upload the zip file.
5,480 09/06/2013 05:47:38 am
Re: Changing default font for documents in FA - instructions (2 replies, posted in FA Modifications)
Where are the three font files?
More on Tuffy Font:
http://www.fontsquirrel.com/fonts/tuffy
http://www.dafont.com/tuffy.font
http://packages.debian.org/squeeze/ttf-tuffy
In Linux:
apt-get install ttf-tuffy
ln -s /usr/share/fonts/truetype/ttf-tuffy/* reporting/fonts5,481 09/06/2013 05:40:02 am
Re: International Wire Fee's (2 replies, posted in Accounts Receivable)
Quick Entries is the way to go.
5,482 09/06/2013 05:32:14 am
Re: Add custom fields into item (24 replies, posted in FA Modifications)
FA has an includes folder in each major functionality's folder (sales, reporting, etc) besides a common one in the webroot. Each db folder in the major functionality's folders are basically models in the MVC architecture where themes serve the views, the actions coming from the URL GET parameters and the ACLs from the session variables.
Using a trigger to make the extra fields get inserted when the primary table's insert succeeds is one way to avoid writing php code.
As for docs, what little I have culled out is placed in the Wiki which would benefit from better organization as I have been left on a limb quite often when searching for my own nuggets hidden there in not very intuitive key word search terms.
Where possible, I have cross referenced in the wiki pages, the forum posts that pertain to it but not vice-versa very much.
Foreign Keys and references are due in FA v2.4 only.
5,483 09/05/2013 12:41:44 pm
Re: Add custom fields into item (24 replies, posted in FA Modifications)
The function add_item is in inventory/includes/db/items_db.inc and the sql statement for the insert referred above is at line 49 onwards:
$sql = "INSERT INTO ".TB_PREF."stock_master (stock_id, description, long_description, category_id,
tax_type_id, units, mb_flag, sales_account, inventory_account, cogs_account,
adjustment_account, assembly_account, dimension_id, dimension2_id, no_sale, editable)
..
..From a design sustenance point of view, it might be better to have a separate table and link the primary keys on a 1-to-1 basis and use another insert statement in a new function that gets executed after this function's success. Then such scripts can be bundled into a separate Extension and installed into any FA instance. It will then possibly be compatible with future FA versions or be considered redundant if the functionality gets incorporated into the FA core.
5,484 09/05/2013 12:32:08 pm
Re: Textcart Git lag (8 replies, posted in Modules Add-on's)
Thanks Elax. That settles it for the record then.
5,485 09/05/2013 09:39:36 am
Re: Sample CSV/Excel file for Items import (5 replies, posted in Items and Inventory)
1. Manually enter one item directly from the FA GUI
2. From the Import Items Extension, choose to export the Items
3. Prepare the rest of your Items as per the exported file
4. Now import this prepared file into FA from within the Import Items Extension
5,486 09/05/2013 07:17:00 am
Re: Import Tax (7 replies, posted in Items and Inventory)
Create a dummy client / supplier to whom you sell the goods at the first 5% tax and then buy from that client/supplier at 13% tax using the original price with the 5% tax as your cost..... Confusing I'm sure - just kidding....
5,487 09/05/2013 07:09:22 am
Re: End of Month or Closing a Period (11 replies, posted in Banking and General Ledger)
Unfortunately, the Sourceforge Mercurial Download Snapshot for the stable branch only provides a 442Kb subset of the files needed, but for the unstable branch, the full complement of 1.8Mb is downloadable.
The Git Mirror however has the full complement of files for snapshot download of the stable branch.
5,488 09/05/2013 07:05:47 am
Re: Request For Quotation Module (new) (3 replies, posted in Modules Add-on's)
Post the code at GitHub or some publicly accessible repo and you'll find that the module gets developed real fast.
Incidentally, the links are not accessible in India - possibly because the domain is Pakistani!
No Open Source enthusiast will want to test proprietary / secretive / closed source code.
5,489 09/05/2013 06:58:03 am
Re: Textcart Git lag (8 replies, posted in Modules Add-on's)
Both versions of Textcart (Git and PKG) files have been extracted and zipped for comparison. All files in both are same (checked with WinMerge) except the config file where version numbers are different and the PKG version alone has the hooks.php file. If the Git version without the hooks.php is the later version, then please clarify on whether it is needed at all.
5,490 09/04/2013 05:20:43 pm
Re: Textcart Git lag (8 replies, posted in Modules Add-on's)
hooks.php is available in the PKG downloadable from inside the FA Web GUI but not in the Git Repo.
The Git repo version stands at 2.3.9-1.0 whereas the PKG version is 2.3.9-3
Hence the Git Repo version seems to be lagging behind the PKG version.
5,491 09/04/2013 03:11:42 pm
Topic: Textcart Git lag (8 replies, posted in Modules Add-on's)
The TextCart AddOn in the Official Git seems to lag the PKG available for install. Has the Git development stopped for it or moved elsewhere?
5,492 09/04/2013 02:31:02 pm
Topic: Updated config.php variables in Wiki (0 replies, posted in Setup)
Updated config.php variables in Wiki to show those added in FA v2.3.17..
5,493 09/04/2013 01:25:18 pm
Re: Email Client name in Invoice sending displayed wrong (6 replies, posted in Report Bugs here)
Wiki-ed it.
5,494 09/04/2013 01:17:49 pm
Re: Page numbering on sales invoice PDF's (12 replies, posted in Accounts Receivable)
Wiki-ed it.
5,495 09/04/2013 01:07:59 pm
Re: Seeking FA expert in Santa Clara area (2 replies, posted in Jobs wanted/offered, non-free offers)
Setup Tax Types first as TaxFree and VAT in Setup -> Item Tax Types
Then set it for each item in:
Items and Purchases -> Items -> Item Tax Type -> (TaxFree or VAT)
5,496 09/04/2013 12:31:27 pm
Re: Enter "Create new item" button on Direct invoice (12 replies, posted in FA Modifications)
Thanks Janusz.
5,497 09/04/2013 12:29:08 pm
Re: check overdue delivery date (5 replies, posted in Report Bugs here)
Thanks Janusz.
The updates on 30th and 31st August 2013 did not make it to the Git Repo in time and some time ago in May 2013 the HG repo was lagging and hence assumed it was discarded but found it uptodate now and further wrongly assumed it to be a reverse mirror.
Corrected the links on the main page of the Wiki on the Mirror status and in my repo as well.
5,498 09/04/2013 12:25:44 pm
Re: Print Traditional Chinese (7 replies, posted in Reporting)
Provided backlink to this post in the Wiki.
5,499 09/04/2013 12:21:43 pm
Re: Release 2.3.17 (12 replies, posted in Announcements)
Thanks Janusz. The patch set has been updated as well.
5,500 09/04/2013 02:16:44 am
Re: Supplier Payment With Bank Charges (5 replies, posted in Report Bugs here)
Please check if this issue has been sorted out using the latest patch.
