Date Stamp as an Invoice Number
It would be great if it can do a "Date Stamp" ( YYYYMMDDHHMMSS) as an invoice number instead of incremented numbers. eg; INV-20160628101255.
Nicholas Vella
shared this idea
-
Marcus
commented
Another great idea ignored by Zoho. Some context.
The problem with incremented numbers is that they don't do you any good when trying to manage invoice inventory. A macro-based auto gen system would actually be preferred vs. a straight over date stamp.
Example using my invoice numbering:
10{year,2}{day,2}{month,2}
Where "10" is a static value. The others are basically macros to work off of calendar events, and an integer to tell it how many digits from the right to use. So for an invoice generated today you would get:
10191608
And when I look at that number, I can see that it's a '10' invoice (where 10 might correlate to a customer ID or whatever), generated in 2019 on August 16th. That deals with the problem of different interval invoicing; my client now wants an invoice each week to correspond to timesheets, but another client may want monthly billing. Doing sequential numbering just doesn't make sense.
I would also point out that this is dirt stupid simple in Microsoft Excel formulas.
-
cory
commented
This would be great...is it possible?