Not working: Automatic Increase of reference number fields in FA 2.4.2 (Page 1 of 3)

Just try to enter the form again and submit with the fresh reference. It is possible that more than one person attempted to use the same entry screen simultaneously and one got the next reference number whilst the other failed since there would now be a record already in the db with that reference number. The post referenced above explains the scenario and a possible solution using an auto check for a new reference number just before adding the record for a more reliable means but not notifying the user of the reference number change if any.

@davidkumi, I guess the code has issues with  parsing the regrex,  so here is the function code, just try display_error to check the inputs.

 function get_next($type, $line=null, $context=null) 
    {

        if (isset($line))
            $refline = $this->reflines->get($line);
        else {
            $refs = $this->reflines->get_all("trans_type=".db_escape($type)." AND `default`");
            $refline = db_fetch($refs);
        }

        if ($this->_legacy_line($refline))
            return $refline['pattern'];

        return $this->_parse_next($type, $refline['prefix'].$refline['pattern'], $context);
    }

and the display_error function

  display_error($type.'---'.$line.'---'. $context);

https://frontaccounting.com/fawiki/index.php?n=Devel.TrobleshootingFrontAccounting

The reference number iterates fine. I've tested many times.

you said automatic increment not working. Now you are saying its iterating , i am getting confused.

What you want to do actually?

The reference is not showing in the sales order form or its showing previous reference number.?

ok , than check the sales_order_ui.inc by the line no 361,

 ref_row(_("Reference").':', 'ref', _('Reference number unique for this document type'), null, '', $order->trans_type, array('date'=> @$_POST['OrderDate']));

.

before this line,just use display_error to see the reference,whether its coming here or not.

 display_error($_POST['ref']); 

try and if its not working, trace back the route of reference.

Make sure that the auto form filling in the browser setting is not enabled. A browser refresh may also mitigate it.

OK, what if I want to use the next available ref to save without prompting the user if the one on the form is already used?

For instance, let's say the ref on the form is 155/2017 but it's already used. Instead of prompting the user that it's used, I want it to automatically pick the next available, say 157/2017 (assuming 156/2017 is also used) and not prompt the user but rather just go ahead and save the order with 157/2017.

How do I do that? How do I skip the prompting and just go on to save with the next available ref?

Not working.

If you want to replicate this problem to try, open new sales order in two different browsers. They'll have the same refs. Save one (it'll go through successfully) and then click to save the second and you'll get the error we're discussing on this page.

I still need the help of you all. This is important to me.

Any other idea?

@davidkumi you mean that at any point if the system faces the duplicate reference issue, instead of notifying the user it shall just jump to next available reference?

I am also facing this problem. Most of the time references are working fine but sometimes I am notified that the Reference already in use. In such situation the system shall be smart enough to jump to next reference instead of notifying the user.

This is very important in a case where different data entry operators are punching data on the same form at same time. When two of them will open say Journal Entry Form they will get the Next Available Reference Number and that will be same for both. One of them when process it it will be saved Fine but the other will get message Reference Already In Use.

@davidkumi, Why don't you try a new installation with recent one. If the new on works, you can compare the code and get solution for the problem .