Contact any paid support entity and be specific about your server/platform/FA version details, custom requirements, support and data integration.
1,751 05/05/2018 03:08:18 pm
Re: Customize frontaccounting (1 replies, posted in Jobs wanted/offered, non-free offers)
1,752 05/05/2018 03:05:47 pm
Re: Inventory Items CSV Import (13 replies, posted in Modules Add-on's)
Contact any paid support entity to resolve your issue that will most probably need manual intervention or post a bounty in the Job Offers board.
1,753 05/05/2018 08:30:35 am
Re: Australian Tax Invoice extension (9 replies, posted in Modules Add-on's)
@joe: Please add in an extra column in function get_customer_trans_details to obtain just the price without tax as it is needed for the likes of the Australian Tax Invoice and possibly elsewhere. This is in file sales/includes/db/cust_trans_details_db.inc. Hence the lines 19-21 in the said file:
$sql = "SELECT line.*,
line.unit_price+line.unit_tax AS FullUnitPrice,
line.description As StockDescription,
should now be lines 19-22:
$sql = "SELECT line.*,
line.unit_price+line.unit_tax AS FullUnitPrice,
line.unit_price AS UnitPriceExTax,
line.description As StockDescription,
@PaulShipley: The said function is used in rep107.php (sales invoice), rep110.php (deliveries) and rep113.php (credit notes).
1,754 05/04/2018 10:22:24 am
Re: Failed to load PDF document (3 replies, posted in Report Bugs here)
The document stands delinked from the transaction. Manually delete it physically if it is a permissions issue. It is possible that one may want to link it to another transaction otherwise.
The code for deletion is in lines 145 to 154 in admin/attachments.php:
if ($Mode == 'Delete')
{
$row = get_attachment($selected_id);
$dir = company_path()."/attachments";
if (file_exists($dir."/".$row['unique_name']))
unlink($dir."/".$row['unique_name']);
delete_attachment($selected_id);
display_notification(_("Attachment has been deleted."));
$Mode = 'RESET';
}
The unlink statement clearly is supposed to delete the file.
1,755 05/03/2018 02:06:15 am
Re: Inventory Planning Report (18 replies, posted in Items and Inventory)
@joe: Lines 50 and 52 can be removed in reporting/rep302.php as there can be only one description for one id for both category_id and stock_id fields.
Also Line 77 filters on ST_CUSTCREDIT (11) and ST_CUSTDELIVERY (13) instead of on ST_SUPPRECEIVE (25) and ST_CUSTDELIVERY (13) and the need to take care of transactions pertaining to ST_MANUISSUE (28) and ST_MANURECEIVE (29) with the signs being taken care of as well.
Further, lines 38 and 39:
IF(move.stock_id IS NULL, '', move.loc_code) AS loc_code,
SUM(IF(move.stock_id IS NULL, 0, move.qty)) AS qty_on_hand
can be re-coded as
COALESCE(move.loc_code, '') AS loc_code,
SUM(COALESCE(move.qty, 0)) AS qty_on_hand
1,756 05/02/2018 05:58:31 pm
Re: Inventory Planning Report (18 replies, posted in Items and Inventory)
You can still insert file write statements to spit out the inspection points / variable values. Read the Wiki.
Inventory Planning Report is reporting/rep302.php.
1,757 05/02/2018 05:52:58 pm
Re: Support both Chinese and English (4 replies, posted in Translations)
What is your server platform - Windows / Linux?
Waht are your PHP/MySQL/Apache/FA versions?
Are you using Simplified or Traditional Chinese?
Do you have the necessary locales installed both in the OS and for your client browser?
Do the weird strings when recalled in the Web UI appear as the correct characters?
1,758 05/02/2018 08:10:50 am
Re: Journal Entries Round to 2 decimal places on add, not update (2 replies, posted in Banking and General Ledger)
Items in the Cart are used for both display and for populating the tables. To conserve screen real-estate, the display is generally rounded off to 2 decimal places. Hopefully all the 8 digit amounts can fit into the Chart of Account table fields.
It is the function add_gl_item that needs to be fixed - inspect the value of $amount at the point when $this->gl_items[] = new gl_item(..... is executed whether it has the 8 digits in the decimals at line 130.
@joe: Worth fixing.
1,759 05/02/2018 01:43:19 am
Re: Today we passed 200 000 downloads on Sourceforge. (9 replies, posted in Announcements)
FA Forum spam registrations predominantly from SEO sponsored users / competition malfeasance lobbies has been on the increase. In April 2018, 3 in 4 registrations are undesired ones. This is probably due to a FA release in the latter half of March 2018 where forum visibility was anticipated to be high and hence reap rich rewards for SEOs certainly not shared with the project!
Attached is the user registration stats since Jan 2017.
1,760 05/01/2018 03:17:07 pm
Re: Disabling a user is un-intuitive. This is how ... (1 replies, posted in Setup)
Yes, you're right.
It is now Wiki-ed.
1,761 04/30/2018 04:34:49 pm
Re: Exclusive Theme not working with PHP7 or higher (3 replies, posted in Installation)
This is a known issue and is pending acceptance of the fix.
1,762 04/29/2018 12:45:21 pm
Re: Ajax Times out in Print Recurring Invoices (3 replies, posted in Accounts Receivable)
Others of it's ilk are:
ini_set('default_socket_timeout', 2);
// your socket based code here
// restore to the default socket timeout
ini_restore('default_socket_timeout');
ini_set('max_execution_time', 0); // unlimited and default for CLI script usage.
You can not change this setting with ini_set() when running in safe mode.
The duration of sleep() will be ignored in the execution time.
Stands Wiki-ed.
1,763 04/29/2018 09:16:22 am
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
Wiki-ed it.
1,764 04/27/2018 04:05:34 pm
Re: Setup DB Connection Error (37 replies, posted in Installation)
The snippet:
$db = mysqli_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"], "",
!empty($connection["port"]) ? $connection["port"] : 3306); // default port in mysql is 3306
can be changed to include the dbname directly like:
$db = mysqli_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"], $connection["dbname"],
!empty($connection["port"]) ? $connection["port"] : 3306); // default port in mysql is 3306
1,765 04/27/2018 04:02:56 pm
Re: refs table (20 replies, posted in Items and Inventory)
You might also want to modify the "//Example" in transfer.inc to match your multiple {stock_id, quantity} line entries. In which file did you make the changes listed in your second code snippet above?
1,766 04/27/2018 03:27:03 am
Re: refs table (20 replies, posted in Items and Inventory)
@justapeddler: Thanks for your submissions and feedback. This is the real spirit of FA that keeps it ticking!
As stock transfers are part of inventory, it might make sense to extend inventory.inc, but keeping it in a separate transfer.inc will make for independent development. Please go thru it thoroughly for different scenarios and then I can add it in to the FA24extensions repo.
1,767 04/26/2018 09:01:28 am
Re: inventory valuation report (6 replies, posted in Reporting)
Wiki-ed it.
1,768 04/25/2018 02:56:32 am
Re: How to find the query for a specific report? (10 replies, posted in Reporting)
Even queries for the Web UI Inquiry pages do not generate any records in the tables - they are merely select queries. If the show_sql and debug flags in the config.php file are enabled along with show select, then the select queries too will be shown.
1,769 04/25/2018 02:51:32 am
Re: User or password is invalid or you have no permissions to create datab (9 replies, posted in Installation)
Check the config_db.php file if your db access credentials for the target company are okay and the privileges have been flushed for it to come into effect.
1,770 04/25/2018 02:49:18 am
Re: Invoice size to Thermal printer (7 replies, posted in Jobs wanted/offered, non-free offers)
Read and understand the said file and make small adjustments where you see font and observe the changes in the output and then go from there.
You can also post a bounty in the Jobs offered board here for others to see if it is worth their while to assist you.
1,771 04/25/2018 02:47:27 am
Re: Company Table (6 replies, posted in Setup)
Yes. You will have to adjust the pattern in the reflines table in Setup => Transaction References => Dimension.
As for the wiki, you are free to make it more understandable.
1,773 04/23/2018 02:46:44 pm
Re: refs table (20 replies, posted in Items and Inventory)
Since stock transfer needs another argument, the prototypes too must be modified.
1,774 04/23/2018 02:45:08 pm
Re: Inidan Forex Rates from RBI (6 replies, posted in Banking and General Ledger)
@boxygen: the json output can be parsed into an array and then manipulated.
If some currency pairs are one way only quotients exceeding 4 digits of zeroes in the decimal places then an intermediate exchange rate can be used in the division in reverse.
1,775 04/23/2018 02:40:53 pm
Re: The Future of FrontAccounting (6 replies, posted in Development)
The Bug Tracker is sufficient for that.