1,026 Reply by apmuthu

(6 replies, posted in Banking and General Ledger)

The affected report reporting/rep602.php was last changed in 2016-09-06 and that too for only a column width change. However, it's include files may have changed since then.

Upgrading to FA v2.4.7+ is trivial as there are no real DB changes.

Go to forum: Banking and General Ledger

1,027 Reply by apmuthu

(16 replies, posted in Items and Inventory)

@poncho1234: This may not be tenable this way as the checkbox for Editable Description can be changed independant of the specific transaction at any time. However, if it is implemented by checking f a change in standard description from the one used in the PO, then any inadvertent change there may get reflected in the Supplier Invoice without notice - hence a prudent way was sought in the current implementation where a human re-check is envisaged before finalisation.

Go to forum: Items and Inventory

1,028 Reply by apmuthu

(9 replies, posted in FA Modifications)

Forecasting from how many years it took to come in from FA 2.3 to FA 2.4 and the fact that the devs are much older now, take it to be atleast 5 years from when the initial 2.5 branch began. If it is any sooner, thank the advances in coding technologies and that we are now older and wiser wink

@kvvaradha: Whatever changes you have in mind to make a start, do let us know here so that it can atleast get into the codebase for those who wish to benefit from it in the meanwhile and form part of FA 2.5 if and when it appears.

Aug 17th 2019 - probably last commit to the 2.4(.7) branch.
Aug 19th 2019 - first commit to merge stable into unstable for 2.5 branch

Go to forum: FA Modifications

1,029 Reply by apmuthu

(16 replies, posted in Items and Inventory)

@joe: If this was the original intended functionality, then it must be changed.

When a PO is raised and the Description is edited, then it must persist through to the Supplier Invoice.

Go to forum: Items and Inventory

1,030 Reply by apmuthu

(16 replies, posted in Items and Inventory)

To rule out PHP/MySQL versions being the cause, check it out on say PHP 5.3.x with MySQL 5.1 and see what gives.

Go to forum: Items and Inventory

1,031 Reply by apmuthu

(16 replies, posted in Items and Inventory)

You will have to logout and clear browser cache and then login again.

State which version (and date) of FA you are using and what is the server platform and PHP/MySQL versions and browser type and version used.

Go to forum: Items and Inventory

1,032 Reply by apmuthu

(6 replies, posted in Accounts Receivable)

The sys_prefs table by default has ref_no_auto_increase disabled but it still works in AutoInc mode.

The error is in the absence of an "else" for line 294 in sales/includes/cart_class.inc and it's positioning after a blank check. The lines 287 to 301 are reproduced here:

    function write($policy=0) {
        
        global $SysPrefs, $Refs;
        
        begin_transaction(); // prevents partial database changes in case of direct delivery/invoice
        if ($this->reference != 'auto' && $this->trans_no == 0 && !is_new_reference($this->reference, $this->trans_type))
        {
            if (!empty($SysPrefs->prefs['ref_no_auto_increase']))
                $this->reference = $Refs->get_next($this->trans_type, null, array('date' => Today()));
            if (!is_new_reference($this->reference, $this->trans_type))    
            {
                commit_transaction();
                return -1;
            }    
        }
...
...

Go to forum: Accounts Receivable

1,033 Reply by apmuthu

(6 replies, posted in Accounts Receivable)

Keep changing the next invoice number manually in Setup => Transaction References and then let it auto-populate this manually provided value in the invoice you enter. The responsibility of maintaining non duplicate Invoice Number will then vest with you as the system will simply reject duplicates only after entering the invoice.

Go to forum: Accounts Receivable

1,034 Reply by apmuthu

(3 replies, posted in Accounts Receivable)

Direct Database intervention in the following tables among others:

debtors_master
cust_branch
crm_persons

Possibly the audit_trail, sys_prefs, journal and voided tables may have some telltale leftovers.

Go to forum: Accounts Receivable

1,035 Reply by apmuthu

(9 replies, posted in FA Modifications)

Since this does not affect the DB schema, can we not make a start here?

Go to forum: FA Modifications

1,036 Reply by apmuthu

(7 replies, posted in Items and Inventory)

1. Search the forums and the wiki.
2. Study the DB changes for each transaction / form entry and see if it makes sense.
3. Keep track of the FA version and the DB version in version.php
4. Study the commits in the Repos - Core and Extensions (official and others you follow).
5. Make sure the config.php and sys_prefs table entries match the changes committed in each version.
6. Plug and Pray that nothing breaks.
7. Wish @joe & @itronics a long life to fix anything that goes wrong and gets found wink

Go to forum: Items and Inventory

1,037 Reply by apmuthu

(2 replies, posted in Reporting)

@joe committed it.

Go to forum: Reporting

1,038 Reply by apmuthu

(15 replies, posted in Reporting)

Fixed by @joe in repo

Go to forum: Reporting

1,039 Reply by apmuthu

(16 replies, posted in Items and Inventory)

Done.
Also referred in this post.

Go to forum: Items and Inventory

1,040 Reply by apmuthu

(7 replies, posted in Items and Inventory)

@joe: want to add this?

Go to forum: Items and Inventory

1,041 Reply by apmuthu

(9 replies, posted in FA Modifications)

Putting it in a variable and then using it everywhere will make sense.
@joe?

Go to forum: FA Modifications

1,042 Reply by apmuthu

(10 replies, posted in Setup)

If you got your en_ZA chart and language files from the official extensions repo, then try to use the ones from the unofficial repo.

Go to forum: Setup

1,043 Reply by apmuthu

(3 replies, posted in Wish List)

FA currently just has "Ship Via" specific Shipper info and no shipping rates based on volume/weight/distance on a per shipper basis. Maybe this might be a good inclusion into FA 2.5.

Go to forum: Wish List

1,044 Reply by apmuthu

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

The potential files are:

access/login.php
includes/current_user.inc

Go to forum: Modules Add-on's

1,045 Reply by apmuthu

(1 replies, posted in Reporting)

We cannot add apples and oranges.

Go to forum: Reporting

1,046 Reply by apmuthu

(2 replies, posted in Items and Inventory)

This is so that all other actuals if changed or differently dated will still fit in and any changes that need to be done can be made to the adjustment entry alone.

Go to forum: Items and Inventory

1,047 Reply by apmuthu

(9 replies, posted in Report Bugs here)

Abbreviations.com has some nice elaborations (just in jest only):
ORACLE: One Rich A** Called Larry Ellison
SAP: Slow and Painful
MICROSOFT: My Incredible Computer Runs Oddly So Oust Forged Trash

Using above may be like using a hammer to swat a fly/ant in most cases. That's where FA scores - with KISS technologies and gratis indeed. Some things are better than what money can buy and FA seeks to be the numero uno here.

Go to forum: Report Bugs here

1,048 Reply by apmuthu

(1 replies, posted in Jobs wanted/offered, non-free offers)

The following users from your country may be of assistance:

@chase
@Farhaj
@PHPdv
@dz
@boxygen
@emiangel839
@twlight118

Go to forum: Jobs wanted/offered, non-free offers

1,049 Reply by apmuthu

(7 replies, posted in Setup)

Check if your input data had any extraneous characters that caused a mess up in escaping (or double escaping?). The escape was to prevent SQL injection.

Go to forum: Setup

1,050 Reply by apmuthu

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

It's okay now in both themes. Tnx.

Go to forum: Modules Add-on's