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

I would disagree for removing the reference field. Without removing the Reference Field the Functionality shall be added to jump to Next Available Reference without notifying user.

Keeping Reference field open sometimes allow users to maintain a different sequence manually maintained specially in case of Invoices.

Like in our area we have a practice that Sales Taxed Invoices must have a separate sequence then Normal Invoices. In such situation we suggest users to manually maintain a sequence for Sales Taxed Invoices and Put that sequence in the Reference Field before Processing the Invoice.

Yes, I think that'll be great.

In the interim though, any way I can get the value in the ref field on the form increasing to the next available ref? Or automatically saving with the next available ref if the one displayed is used?

I have just tested the fix by Janusz, and it works perfectly.

@davidkumi
Maybe you need to refresh your browser caches. It should work now.

You will get an error saying the reference is already in use. Another line tells that the reference is updated, so you should save again. The reference is updated and when you save it should be ok. Well it could happen that other users are playing with the same numbers, so it could be repeated a few times.

/Joe

Oh yes, you're right. It works like magic. Just had to comment out those two other lines as below:

unset($_POST['ref']); // force refresh reference
display_error(_("The reference number field has been increased. Please save the document again."));
//$_POST['ref'] = $_SESSION['Items']->reference = $ref;
//$Ajax->activate('ref');

Thank you, thank you, thank you all

@itronics, thanks for the reason behind the slight inconvenience of re-submission. When would one want to change the reference the form automatically provides?

@itronics you solution works only for SalesOrder/Invoices. What for JE, Bank Payments, Bank Deposits and other such transaction forms?

Yes please have a look into this. Also sometimes it happens that auto increment of the reference gets stopped without any reason. Unless you manually go to the Forms Setup and increase it.

The next reference number routine shall check the reference table as well as the transaction table and If any reference in transactions table is higher than the reference in reference table than it shall automatically takes the next reference from the Transaction table and update the next reference in reference table.

I've just installed 2.4.2 and the Reference number fields setup screen cannot be found.
It used to be in "Forms Setup". Can anyone tell me where to find this option?
Thank you.

Thanks Joe. It is better than the 2.3.21.
Well done team!

Hi all, I used this solution also for delivery and invoices and it worked. However, I'm struggling with the other forms - customer payments, bank payments, bank transfers, inventory adjustments, location transfers, etc.

Is there one thing we can do to fix them all?

If not, kindly guide me through how to fix the The entered reference is already in use. problem in each. We can start with bank payments.

Thanks.

Just installed it - FA 2.4.3 - but  the same problem. Sales order is OK but not customer payments, bank payments, bank transfers, location transfers, inventory adjustments.

None of the others have any externally sourced references like a sales order did.

@joe: should the concurrent edit issue have a more generic solution to cover all auto generated references?