Upload the file anywhere and paste the url here. @joe needs to give you upload rights.
4,101 05/01/2015 11:55:32 am
Re: Supplier Credit Note Incorrect Header and GST (12 replies, posted in Accounts Payable)
4,102 05/01/2015 11:49:43 am
Re: FA - Tamil Translation (8 replies, posted in Translations)
Updated the Tamil language files in my GitHub Repo with 322/2997 strings translated.
Make sure that the dejavu fonts are installed.
Upload to lang folder and append to array in lang/languages_installed.inc file as in first post in this thread.
In Debian Squeeze, Tamil fonts are installed with:
apt-get install ttf-tamil-fonts
sed -i -e 's/# ta_IN UTF-8/ta_IN UTF-8/' /etc/locale.gen
dpkg-reconfigure --frontend=noninteractive locales
4,103 04/30/2015 04:33:54 pm
Re: Thousands separator - FrontAccounting v.2.3.24 (1 replies, posted in Report Bugs here)
Setup => Display Setup
Set your decimal and thousands separators.
Which menu navigation sequence are you not able to enter more than 999 in the item price field?
Which version of FA are you using?
What platform are you on?
Attached is a screenshot on FireFox 37.0.2 using FA 2.3.24+ on Windows that seems okay.
4,104 04/30/2015 04:29:23 pm
Re: Cannot Download Repo Index File (6 replies, posted in Report Bugs here)
Which browser are you using - try FireFox. Also manually try to download the files from the repo like:
http://anonymous:password@repo.frontaccounting.eu/2.3/Release.gz
It is possible in FireFox but not in MS IE 8.
4,105 04/30/2015 03:33:09 pm
Re: attached payment, return and other term page (4 replies, posted in Accounts Receivable)
The devs would need to code it into FA 2.4 before it becomes available.
4,106 04/30/2015 03:32:08 pm
Re: Supplier Credit Note Incorrect Header and GST (12 replies, posted in Accounts Payable)
@mark0300: Kindly post a revised screenshot after the fix. The demo data does not have a sample with data for this screen for posting in the wiki.
4,107 04/29/2015 08:18:23 pm
Re: Adding Dimensions in Supplier invoice (4 replies, posted in Wish List)
@joe: Thanks. Wiki-ed it.
4,108 04/29/2015 08:08:28 pm
Re: Inventory Sales Report (14 replies, posted in FA Modifications)
The snapshot in the repo can be used directly without having to wait for a new release.
4,109 04/29/2015 05:41:43 pm
Re: Is it possible to enter entries in two different years? (3 replies, posted in Banking and General Ledger)
@seahawk: Thanks. Wiki-ed it.
4,110 04/29/2015 05:34:04 pm
Re: Adding Dimensions in Supplier invoice (4 replies, posted in Wish List)
Did you mean create a service item in each such supplier invoice?
4,111 04/29/2015 05:32:24 pm
Re: How to handle customer deposits on sales? (17 replies, posted in Accounts Receivable)
@seahawk: Thanks. Wiki-ed it.
4,112 04/29/2015 05:26:01 pm
Re: attached payment, return and other term page (4 replies, posted in Accounts Receivable)
Yes. Study the report class and append a preset pdf page to the reports desired - a working knowledge of TCPDF and it's wrapped functions will be needed.
In FA 2.4, we can program to possibly place select box for appending one pdf from a certain company folder in the report request form itself.
4,113 04/29/2015 05:22:36 pm
Re: Supplier Credit Note Incorrect Header and GST (12 replies, posted in Accounts Payable)
@joe: Thanks. That was a nice fix.
4,114 04/28/2015 06:10:20 pm
Re: PayPal import issues (15 replies, posted in Modules Add-on's)
Try to slice the list of paypal import entries and verify failure on specific transaction - any extra characters, quotes, double quotes, etc....
4,115 04/28/2015 06:05:51 pm
Re: FA v2.4 development (48 replies, posted in Setup)
FA v2.4 is now fully installable and the reports display with correct paths in Windows thanks to Joe's commit reverting to FA v2.3 config variable $comp_path assignment.
The above commit now means that relative path addressing listed in the 22nd post in this thread is no longer valid.
4,116 04/28/2015 10:27:02 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Your attachment is attached to this post.
4,117 04/28/2015 03:04:52 am
Re: PayPal import issues (15 replies, posted in Modules Add-on's)
Actually Paypal Import Transactions is more of a payment transaction basically and not an invoice generation / customer creation transaction although the code sports it. The Customer and their Invoice should generally pre-exist for a PayPal transaction to effect payment allocation to it. It is therefore no wonder that no transactions are related to existing customers and is either not imported at all or is imported as an orphan record. You can try to create the customer and invoice manually if they do not exist and then manually allocate / edit allocation of the payment.
4,118 04/27/2015 10:38:24 am
Re: Item Name exported as description (2 replies, posted in Items and Inventory)
Do not confuse (Sage) Pastel Accounting with FrontAccounting.
1. Check if your CoA matches the field order in the various tables when compared to the standard US New CoA.
2. Verify that you have the latest bugfixed code of the said extension that may be obtained from my unofficial GitHub repo.
FA v2.3.24 was released on April 5th, 2015. Several fixes to the core have been committed since then.
Actually the long_description field is generally not imported at all.
4,119 04/27/2015 10:30:01 am
Re: Sensible 2.4 Migration Plan? (1 replies, posted in Installation)
Sounds great. Regular Backups with a manual computing journal of activities and comparison of the backups will help during the skilling-up phase. How do you handle wrong entries - using new contra entries or just making changes in the raw db tables?
Making the FA period just 1 month instead of a full fiscal year or a dummy accounting year shifting one month forwards each month on restoration will help simulate closing month by closing dummy year.
The devs can put out a list of new features in FA 2.4 that will help users in deciding if and when to update.
4,120 04/26/2015 12:45:19 pm
Re: FA v2.4 development (48 replies, posted in Setup)
Changes in FA 2.4 unstable till 2015-04-21:
The error reported in the 22nd post in this thread is still present in this snapshot.
DB Schema Changes:
ALTER TABLE `0_cust_branch` DROP KEY `branch_code`;
ALTER TABLE `0_supp_trans` DROP KEY `SupplierID_2`;
ALTER TABLE `0_supp_trans` DROP KEY `type`;
Ported all fixes in FA v2.3.24 to the FA 2.4 stream.
Collation settable in Company Creation / Installer.
Option to preserve security roles during import of CoA.
4,121 04/25/2015 03:59:50 pm
Re: PayPal import issues (15 replies, posted in Modules Add-on's)
If you have a backup prior to the paypal imoprt, then revert to it.
Then manually do the transactions necessary for 1 paypal transaction.
Take a backup.
Now revert back to previous db state.
Now import the same transaction using the import_paypal extension
Take a backup again.
Now compare the last 2 backups using a diff tool like WinMerge and see what is different.
The fact that the SQL executed without error incicates that the absence of transactions is a functional application error. Need to also contact the module author.
4,122 04/25/2015 08:23:27 am
Re: PayPal import issues (15 replies, posted in Modules Add-on's)
If the TB_PREF = "1_", then execute :
SELECT
trans.*
,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total
,cust.name AS DebtorName
, cust.address
, cust.curr_code
, cust.tax_id
, com.memo_
, shippers.shipper_name
, sales_types.sales_type
, sales_types.tax_included
, branch.*
, cust.discount
, tax_groups.name AS tax_group_name
, tax_groups.id AS tax_group_id
FROM 1_debtor_trans trans
LEFT JOIN 1_comments com ON trans.type=com.type AND trans.trans_no=com.id
LEFT JOIN 1_shippers shippers ON shippers.shipper_id=trans.ship_via
, 1_debtors_master cust
, 1_sales_types sales_types
, 1_cust_branch branch
, 1_tax_groups tax_groups
WHERE trans.trans_no=''
AND trans.type='10'
AND trans.debtor_no=cust.debtor_no
AND sales_types.id = trans.tpe
AND branch.branch_code = trans.branch_code
AND branch.tax_group_id = tax_groups.id;
4,123 04/25/2015 08:09:32 am
Re: PayPal import issues (15 replies, posted in Modules Add-on's)
Try to execute the sql on your database in some MySQL client like SQLyog or phpMyAdmin:
SELECT
trans.*
,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total
,cust.name AS DebtorName
, cust.address
, cust.curr_code
, cust.tax_id
, com.memo_
, shippers.shipper_name
, sales_types.sales_type
, sales_types.tax_included
, branch.*
, cust.discount
, tax_groups.name AS tax_group_name
, tax_groups.id AS tax_group_id
FROM debtor_trans trans
LEFT JOIN comments com ON trans.type=com.type AND trans.trans_no=com.id
LEFT JOIN shippers ON shippers.shipper_id=trans.ship_via
, debtors_master cust
, sales_types
, cust_branch branch
, tax_groups
WHERE trans.trans_no=''
AND trans.type='10'
AND trans.debtor_no=cust.debtor_no
AND sales_types.id = trans.tpe
AND branch.branch_code = trans.branch_code
AND branch.tax_group_id = tax_groups.id;
and see what results you get.
Unless you used no Table Prefix, it seems to be missing here.
4,124 04/25/2015 04:59:40 am
Re: PayPal import issues (15 replies, posted in Modules Add-on's)
The write_bank_transaction() having less arguments in a call than defined in the function is okay here as the rest have default values defined in the function as well in gl/includes/db/gl_db_banking.inc.
You might want to check out any file differences between those in your import_paypal module install and those in my unofficial Github repo.
The function write_customer_payment() is defined in sales/includes/db/payment_db.inc with 12 arguments with the last 3 being optional with defaults provided. Furthermore, if there are less than 12 arguments, the rest are filled with zeroes in line 29 in it:
$args = func_get_args(); while (count($args) < 12) $args[] = 0;
The said function is called with 13 arguments in modules/import_paypal/import_paypal_update.php Lines 117 to 119 are:
$payment_no = write_customer_payment(0, $customer_id, $branch_id,
$paypal_bank_id, $recpt_date, $ref,
$gross, 0, $company, 1, 0 - $fee, $gross, $paypal_fee_act);
The $gross appears twice.
4,125 04/24/2015 08:36:00 pm
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Wiki-ed the info.