1,401

(8 replies, posted in Installation)

PHP and Apache don't have official supported 64 bit Windows builds.
Only MySQL out of the three does, hence no 64 bit bundle for XAMPP on Windows.

However, the current versions of PHP seem to have some 64 bit builds at https://windows.php.net/.

Processors, manufactured after 2011, most likely support AVX and it's PHP builds. The exact information about the hardware can be retrieved by using the Coreinfo tool.

Current Apache for Windows 64 bit are available at Apache Lounge.

In spite of all the above, give the 32 bit version of XAMPP a try on Win 10 with the specs in my previous post and provide benchmarks on actual concurrent usage and load factors in your network.

1,402

(7 replies, posted in Setup)

Place a bounty with specs on the Job Offers Board here and see what gives.

1,403

(17 replies, posted in Reporting)

Generally the doctext.inc change is sufficient for all reports.

1,404

(8 replies, posted in Installation)

If you are using XAMPP, then only a 32 bit version is available so more than 3.2 GB RAM is meaningless.
You can however, use VMWare Player to run 64 bit Debian/Ubuntu/CentOS, etc., inside Windows, whilst all your end users can be on Windows browsers.

100 Users or 100 concurrently using clients?

They can be normal hardware with 16 GB Win2012R2 running IIS if you need to run FA on the host itself.

1,405

(4 replies, posted in Announcements)

FA 2.4.5 Screenshots of available Charts, Extensions, Languages and Themes attached.

1,406

(1 replies, posted in Reporting)

This is a non standard report - take assistance from the author.

1,407

(3 replies, posted in Reporting)

The fields were made available for the report. You need to write the code in the place where you want it to go.

Try creating 2 separate sales orders - one from each warehouse. Then combine the sales orders to make 1 invoice.

Instead of modifying the invoice, you may have deleted it and re-created it. If not, what happened to the invoice #541 - what PI_* does it bear? Trace back and see which invoice number began to to go out of synch with your PI_* numbers. See if some were voided.

1,410

(5 replies, posted in Modules Add-on's)

The documentation is at:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/repgen/doc

1,411

(17 replies, posted in Reporting)

Study the use of the $Footer array in reporting/includes/doctext.inc.

At the end of the reporting/includes/doctext.inc file, the following was added to get the output attached:

    $Footer[] = "THIS IS A SYSTEM GENERATED REPORT AND NO SIGNATURE IS REQUIRED";

1,412

(3 replies, posted in Modules Add-on's)

This parameter 4 is available only when the company preferences is set to use 2 dimensions and the report request form has the second dimension chosen. If you still get this error, then you should get a similar error when using report rep706.php too - Balance Sheet - with similar form request parameters chosen. The same applies to the Cash Flow Statement as well.

Customer Ledger Report: The constants ST_BULKDEPOSIT and ST_CASHDEPOSIT are not part of standard FrontAccounting and is what @braathwaate has in his fork. You may remove those entries in the said line and it should work.

1,413

(5 replies, posted in Modules Add-on's)

Yes, that's right.
How did it go?

CTRL-P is a browser attached command and has nothing to do with FA.
Assign CTRL-P to something in the browser shortcuts customisation if you want it browser wide for all sites.

The popup page comes from gl/view/gl_trans_view.php.

Comment out the last php line in the above file (line 160).
Output Attached.

1,415

(17 replies, posted in Reporting)

I trust the attachment will speak for itself.

Checkout the function hyperlink_back() in includes/ui/ui_controls.inc, specifically the echo lines 213 and 215:

    if ($no_menu)
    {
        echo "<td align=center><a href='javascript:window.print();'>"._("Print")."</a></td>\n";
    }    
    echo "<td align=center><a href='javascript:goBack(".($final ? '-2' : '').");'>".($no_menu ? _("Close") : _("Back"))."</a></td>\n";

If you want to remove the Print/Close in all pages, then make the above to be:

    if ($no_menu)
    {
        echo "<td align=center>&nbsp;</td>\n";
    }    
    echo "<td align=center><a href='javascript:goBack(".($final ? '-2' : '').");'>".($no_menu ? "" : _("Back"))."</a></td>\n";

1,417

(17 replies, posted in Reporting)

See the release post for changed files.

1,418

(4 replies, posted in Announcements)

Attached is the set of changed files between FA 2.4.4 and FA 2.4.5.

All upgrade caveats apply and among others they are:
1. backup files and sql first
2. sys_prefs table entries - ref_no_auto_increase, print_dialog_direct
3. config.php variables and their settings
4. db changes if any
5. sequential updates from each version
6. extensions compatibility
7. language strings

The Sourceforge mirrors may not yet have been updated (Excellmedia, Kent). The following links work now:

https://liquidtelecom.dl.sourceforge.net/project/frontaccounting/FrontAccounting%202.4/2.4.5/frontaccounting-2.4.5.tar.gz
Size: 1,574,771 bytes
MD5: C0AA7D697E8DCB5F3A44E709165DE3485E396911
md5: c0aa7d697e8dcb5f3a44e709165de3485e396911

https://sourceforge.net/code-snapshots/git/f/fr/frontaccounting/git.git/frontaccounting-git-080086d679db208567059b420ebfb5fcd7aae5b5.zip

The first 2 day download stats for FA 2.4.5 since it's release shows the UK (57) just leading India (41) with the others way behind. Weekend may be a reason as well.

1,419

(17 replies, posted in Reporting)

This has been fixed a few weeks ago for PHP 7.x users. Upgrade to FA 2.4.5 or use the appropriate commits for fixing it.

1,420

(3 replies, posted in Modules Add-on's)

These are strict variable scoping issues with PHP 7.2+. Just declare the said variables as 0 just before the structure ("if", "while", etc.,) in which it is used for the first time. In the case of your first issue, you will need to insert the following just before the "if" statement at line 110 in rep_statement_reconcile.php:

$total_debit = $total_credit = 0;

1,421

(5 replies, posted in Modules Add-on's)

What version of PHP are you using?
It could be a scope issue in some later versions of PHP.
Just place the following statement above the "if" statement at line 50 in repgen/includes/repgen_def.inc:

$protocol='';

or hardcode as desired.

1,422

(3 replies, posted in Reporting)

You need to alter the reporting/rep103.php file.

Lines 30 to 53 in it:

function get_customer_details_for_report($area=0, $salesid=0)
{
    $sql = "SELECT debtor.debtor_no,
            debtor.name,
            debtor.address,
            debtor.curr_code,
            debtor.dimension_id,
            debtor.dimension2_id,
            debtor.notes,
            pricelist.sales_type,
            branch.branch_code,
            branch.br_name,
            branch.br_address,
            branch.br_post_address,
            branch.area,
            branch.salesman,
            area.description,
            salesman.salesman_name
        FROM ".TB_PREF."debtors_master debtor
        INNER JOIN ".TB_PREF."cust_branch branch ON debtor.debtor_no=branch.debtor_no
        INNER JOIN ".TB_PREF."sales_types pricelist    ON debtor.sales_type=pricelist.id
        INNER JOIN ".TB_PREF."areas area ON branch.area = area.area_code
        INNER JOIN ".TB_PREF."salesman salesman    ON branch.salesman=salesman.salesman_code
        WHERE debtor.inactive = 0";

may be replaced with:

function get_customer_details_for_report($area=0, $salesid=0)
{
    $sql = "SELECT debtor.debtor_no,
            debtor.name,
            debtor.address,
            debtor.curr_code,
            debtor.dimension_id,
            debtor.dimension2_id,
            pt.terms,
            debtor.credit_limit,
            debtor.notes,
            pricelist.sales_type,
            branch.branch_code,
            branch.br_name,
            branch.br_address,
            branch.br_post_address,
            branch.area,
            branch.salesman,
            area.description,
            salesman.salesman_name
        FROM ".TB_PREF."debtors_master debtor
        INNER JOIN ".TB_PREF."cust_branch branch ON debtor.debtor_no=branch.debtor_no
        INNER JOIN ".TB_PREF."sales_types pricelist    ON debtor.sales_type=pricelist.id
        INNER JOIN ".TB_PREF."areas area ON branch.area = area.area_code
        INNER JOIN ".TB_PREF."salesman salesman    ON branch.salesman=salesman.salesman_code
        INNER JOIN ".TB_PREF."payment_terms pt ON debtor.payment_terms=pt.terms_indicator
        WHERE debtor.inactive = 0";

The necessary fields will now be available for placement as needed in the report.

1,423

(7 replies, posted in Setup)

That should be a breeze with a cronjob.
Make one entry in VirtueMart in the normal course of wok and compare the before and after backups of VirtueMart and see what gets inserted and what is modified.

Manually make the corresponding entry in FA and compare the before and after backups of the FA DB and check what gets inserted and what gets modified.

Now it should be easy to make an sql construct to select from VirtueMart table(s) and then insert into the FA DB. These sqls caan then be made generic with variables as placeholders and used in a php script that handles the necessary insert/update sqls.

1,424

(3 replies, posted in Fixed Assets)

Take a backup of your FA DB and search for your asset code and asset name there. Then check the appropriate reference in FA.

1,425

(7 replies, posted in Setup)

Which direction?
From FA to Virtue Mart or from Virtue Mart to FA ?

DB: Database
Each Database is comprised of tables which in turn is comprised of records which have several fields which are the smallest nuggets of data you can query out.

Would you like to make the master entries in FA and have them sucked into Virtue Mart or the reverse way?

If you had to sell a new item, where would you enter it - FA or Virtue mart? Once the data is entered into one application, the other would have to take it in from there. If you start entering master data in both applications without synching them, it would lead to chaos.

Similarly, the transactional data like daily sales - would you like to have them taken into FA from Virtue Mart or the other way around?