briangriffin
Programmer
This was an interesting request I received yesterday - it wasn't quite as easy as it appeared at first. Those of you who aren't as experienced with formulas, especially using variables, might find this an good exercise.
The report returns a listing of invoice numbers and amounts, and the export file produced is imported into another database. However, that database can only accept unique invoice numbers.
For the first duplicate invoice, they need an "A" appended to the invoice number. Subsequent duplicates will append "B", "C", etc.
It's not unusual for there to be more than 100 duplicates in a batch, so after we reach "Z" we have to begin with "AA", "AB", etc.
So if you have the time and inclination give it a go - I think it will expand your formula knowledge.
The report returns a listing of invoice numbers and amounts, and the export file produced is imported into another database. However, that database can only accept unique invoice numbers.
For the first duplicate invoice, they need an "A" appended to the invoice number. Subsequent duplicates will append "B", "C", etc.
It's not unusual for there to be more than 100 duplicates in a batch, so after we reach "Z" we have to begin with "AA", "AB", etc.
So if you have the time and inclination give it a go - I think it will expand your formula knowledge.