So, I created a Calculation field for my Invoice number. It is based on date; type of customer AND a Global field which starts everyday by the number one. I set up the script so every time I create a new invoice it uses the last value of this Global field and then increments it by one. I also set a script to set back this Global Field to ''1'' at Midnight.
Now, this works very well as I would want it to, except when I use it on another computer. The number stays the same and starts at "1" again even though we already created several invoices.
I have read that the Global Field doesn't work well for this in a Multi User environment.
So I was wondering what was the best way to make it work and still keep the serial number when I want to create a new invoice on a different computer.
Please let me know if I am clear enough.
Have a good day,