I would still prefer the existing default theme. The PurV1 @kvvaradha's default theme (screenshots attached here) is a little large and well spaced out but needs scrolling on smaller monitors. No clutter now.
1,151 04/27/2019 04:25:56 pm
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
1,152 04/27/2019 04:07:28 pm
Topic: osc_orders - which osCommerce? (21 replies, posted in Modules Add-on's)
When designing any extension and keeping it uptodate, let us use the Git Master version of FA when not changed too often as sometimes the released versions have fixes applied thereafter.
The osc_orders extension to FA 2.4.x repo is here. Those of you who have tested it it, please state FA version and osCommerce versions used.
There are several versions of osCommere and most are listed here:
osCommerce v3.0.2 was released on 2011-08-06
https://github.com/osCommerce/oscommerce/releases
It's last real commit was on 2012-03-14 and the readme was updated on
2012-10-30
https://github.com/osCommerce/oscommerce/commits/master
The officially supported online merchant version is 2.3.4.1
https://www.oscommerce.com/Products
The beta version there is 2.4.0
There is also a v2.2RC2a version listed at:
https://www.oscommerce.com/Us&News=130
https://forums.oscommerce.com/topic/412630-github-tls12-sourcetree-broken/
For a new install or if your store isn't mobile-friendly, get the
community-supported responsive osCommerce (2.3.4.1 CE) here:
https://github.com/gburton/Responsive-osCommerce/archive/2341-Frozen.zip
With Bootstrap 3:
https://forums.oscommerce.com/topic/396152-bootstrap-3-in-234-responsive-from-the-get-go/
Last release of https://github.com/gburton/Responsive-osCommerce with
Bootstrap 4 is on 2018-05-18:
https://github.com/gburton/Responsive-osCommerce/releases
And the last commit there is at 2019-04-10
Discussions at:
https://forums.oscommerce.com/forum/107-oscommerce-online-merchant-community-bootstrap-edition/
The Sourceforge version is stuck at v2.2ms2-060817 dated 2006-08-17
https://sourceforge.net/projects/tep/files/osCommerce/2.2%20Milestone%202%20060817/
oscMax2 is at v2.5.4 released on 2014-07-03 - https://github.com/osCmax/oscmax2/releases
osCmax is based on osCommerce 2.2RC2a and is an
extension of that application.
Last commit on 2016-04-10 - https://github.com/osCmax/oscmax2/commits/2.5.5
Showcased at: https://www.oscmax.com/
osCommerce v2.4.x is on GitHub at https://github.com/osCommerce/oscommerce2
The latest version 2.4.2 was released on 2016-11-21
https://github.com/osCommerce/oscommerce2/releases
The last commit in that branch was on 2016-11-24
1,153 04/27/2019 03:54:46 pm
Re: Download GL Transaction Report on the basis of MEMO (1 replies, posted in Reporting)
Need some controls on use of common words that will deluge the report.
Modify the GL Transactions report rep704.php and chaneg the sql as desired using _memo LIKE ....
1,154 04/27/2019 05:55:51 am
Re: Chart of Accounts for Peru (1 replies, posted in Misc. Charts of Accounts)
Generate your own and place it in the sql folder and use it.
1,155 04/27/2019 05:54:38 am
Re: FA doesn't show all text in new language (Spanish) (1 replies, posted in Translations)
If you can help with translation, take the .po file and edit it and submit it to the project.
1,156 04/25/2019 07:06:55 am
Re: Cost of Inventory For Back Dated Transactions (5 replies, posted in Items and Inventory)
@boxygen: Please state what logic can be applied to such transactions especially when stock moves, costing / valuation, etc are going to be affected and all transactions since will have to have their reports amended.
1,157 04/25/2019 04:42:25 am
Re: Cost of Inventory For Back Dated Transactions (5 replies, posted in Items and Inventory)
It should suffice to make a separate transaction in the current date with all current values for the changed part alone as only now the error came to light.
Otherwise, all average values since the Month 1 will get affected and so will all transactions that rely on such computed values.
In your situation, a backdated Journal Entry to an adjustment revaluation account may be in order and contra-ed on current date so as not to affect the entries in between.
1,158 04/24/2019 04:19:44 am
Re: Error while installing front accounting to my server (2 replies, posted in Installation)
It appears that you are using an outdated version of some chart of accounts. FA 2.4.6+ uses only InnoDB as the Engine Type and your MySQL seetings too should then be checked.
State your Server Platform and PHP/MySQL/FA versions and which chart you are using. For a start, check your chart of accounts and replace all instances of MyISAM with InnoDB and then try again after dropping / emptying your existing FA DB.
1,159 04/22/2019 06:10:42 pm
Re: barcode (9 replies, posted in Reporting)
The sizing of what you want is attached - 5cm x 3cm.
As the code in my previous post has all the necessary variables and functionality, you can now engage anyone in the Job Board to do it for you specific to your printer.
If you print all your barcodes in one A4 page then you can use a regular printer with Avery like labels - but printing on them may waste paper if you just need one or two.
1,160 04/22/2019 05:58:01 pm
Re: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
The new code works for now.
More testing is needed to check for edge conditions stated above.
I had to set config.php variable "$no_check_edit_conflicts = 1;" in windows for it to work though - it did not work for earlier commits.
1,161 04/22/2019 05:50:09 pm
Re: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
!isset($_POST['stock_id'])
does not necessarily mean that the stock_id does not exist - it merely states that it was not chosen in the $_POST variable.
1,162 04/22/2019 05:47:23 pm
Re: removing a company messes up the system (9 replies, posted in Installation)
The database must not be removed at any cost as in shared hosting it may contain tables pertaining to other applications and the end user may not have permissions to create a new database at all.
1,163 04/22/2019 05:44:33 pm
Re: Delete old customers (8 replies, posted in Accounts Receivable)
If a transaction was made and then voided, then the branch is needed to be deleted before the customer is deleted.
1,164 04/21/2019 08:19:26 pm
Re: removing a company messes up the system (9 replies, posted in Installation)
FA has the ability to use a different database for each company. When setting up a new company, choose the dbname as needed and make sure that the db user has the rights to create a new db or have it created and provide it's access credentials therein.
Deleting a company does not delete the database. It merely removes the stanza from config_db.php file. The database and the tables therein need to be removed manually.
1,165 04/21/2019 07:45:42 pm
Re: barcode (9 replies, posted in Reporting)
Here is a first draft of rep311.php which should do the job.
@joe: Move the defines to sys_prefs table with appropriate settables in the Company Setup and incorporate it into the core if found useful.
Additional variables could be number of barcodes per sheet (here 1) besides suppressing the header if not necessary.
1,166 04/21/2019 07:42:39 pm
Re: removing a company messes up the system (9 replies, posted in Installation)
The first default company must not be removed.
However all is not lost.
Edit your config_db.php and set your default company to the index of the company you now have. It is also possible that your original company 0 database is still there and you can create a stanza for it in the sid file as well.
1,167 04/21/2019 07:18:16 pm
Re: removing a company messes up the system (9 replies, posted in Installation)
Start from scratch and install FA 2.4.6+ anew.
Use the en_US-new.sql chart - the one with no demo data for your default install and keep this "0" company as default. Only this company can create other companies.
FA has been in production use around the world for over a decade now.
1,168 04/21/2019 05:32:56 pm
Re: barcode (9 replies, posted in Reporting)
If rep303.php has the 'EAN' replaced with 'C128B', the attached Stock Check Sheets would ensue.
1,169 04/21/2019 05:06:35 pm
Re: barcode (9 replies, posted in Reporting)
The EAN8 barcode type is hardcoded in the reporting/rep303.php file in lines 327-329:
$barcode = str_pad($trans['stock_id'], 7, '0', STR_PAD_LEFT);
$barcode = substr($barcode, 0, 8); // EAN 8 Check digit is auto computed and barcode printed
$rep->write1DBarcode($barcode, 'EAN8', $rep->cols[$firstcol++], $bar_y + 22, 22, $SysPrefs->pic_height, 1.2, $style, 'N');
The default FA reporting/includes/barcodes.php file is from the TCPDF 's 1dBarcode library when used.
The reporting/rep303.php file however uses another library's extracted barcode functionality which supports only the following subset of formats:
EAN, EAN-8, EAN-13, GTIN-8, GTIN-12, GTIN-14, UPC, UPC-12 coupon code, JAN
Using another subset of TCPDF from a GitHub project for barcode generation is also feasible. This library is set to be PHP 5.4+ compatible but for backwards compatibility with PHP 5.3.x, just replace all instances of "= []" with "= Array()" in it's src/BarcodeGenerator.php file.
Sample code for using it in a standalone manner would be:
<?php
include('src/BarcodeGenerator.php');
include('src/BarcodeGeneratorPNG.php');
$generator = new Picqer\Barcode\BarcodeGeneratorPNG();
file_put_contents('src/files/081231723897-code128.png', $generator->getBarcode('081231723897', $generator::TYPE_CODE_128));
echo '<img src="data:image/png;base64,' . base64_encode($generator->getBarcode('081231723897', $generator::TYPE_CODE_128)) . '">';
The above will both generate a file and display it inline as well.
1,170 04/21/2019 03:17:45 pm
Re: Translating to nl_NL (8 replies, posted in Translations)
1,171 04/21/2019 12:07:17 pm
Re: Delete old customers (8 replies, posted in Accounts Receivable)
Delete branches first and then delete customer with no branch. Transactions may be pertaining to the first branch created when the customer was created.
1,172 04/21/2019 12:05:19 pm
Re: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
@kvvaradha: Your Post #3 is the same as your post #7 which has been incorporated in this official commit which is what I would like to revert and make it as per my commit.
1,173 04/21/2019 04:27:39 am
Re: FA2.4 Addons - providing updates (1 replies, posted in Modules Add-on's)
Send it to ME :-)
I'll atleast update it in the FA24extensions repo which has some fixes over the years that others have reported or that which I just stumbled upon.
1,174 04/21/2019 04:24:06 am
Re: Delete old customers (8 replies, posted in Accounts Receivable)
Whilst realising the method I mentioned above is too involved, an alternative way of looking at it would be:
1. Before closing a fiscal, make sure all "deletable customers" have zero balances with adjustment Journal Entries as appropriate.
2. Make a list of all such customers who then have zero balances for the year on closure using the Trial Balance before closing the fiscal.
3. Identify those customers chosen for deletion.
4. In the new year, after closing the previous fiscal, just attempt to delete the customer branches first and then the customer (is there any such option in the FA UI?).
5. Pray for the best!
@joe / @itronics: Making a provision to delete a customer with no transactions anywhere in the current fiscal will render the past records orphan - any good fix..... - maybe a check in all open fiscal years alone?
1,175 04/20/2019 04:51:50 pm
Re: barcode (9 replies, posted in Reporting)
Setup => Company Setup => tick "Use Barcodes on Stocks" and optionally tick "Company Logo on Reports" if logo is present and desired.
Items and Inventory => Items => Add New Item
You will now see the EAN-8 Barcode which if clicked, will yield a random EAN-8 barcode
Any other barcodes you will need to make changes in the codebase and you can also use third party online tools to generate them like:
https://barcode.tec-it.com/en/EAN8
https://www.free-barcode-generator.net/code-128/
Items and Inventory => Inventory Reports => Stock Check Sheets => Select "Yes" for "Show Pictures" and optionally "Inventory Column" and now all barcodes will be listed.
Since you want code-128 barcode and one barcode per sheet with your fields listed there, just edit the Stock Check Sheets reporting/rep303.php file to suit your need.
If you need technical assistance for it, post your specs and bounty in the Jobs board and hopefully someone will assist you.