dnlairways
New Member
Hello All,
I am referring to a reader question post back 20 July 2009. The question was about generating an NCF number if the customer had a Government Registration Number RCN and not using an NCF if the customer was without a RCN. I am using similar formulas to generate invoice numbers but using a client number instead of NCF. The problem is that when old invoices are removed from the database the other invoice numbers (remaining) all decrease by the number of how many are removed. i.e. remove 1 to 4 and the next becomes 1 and so forth. This happens on both the reader question and in my spreadsheet.
Old invoices will have to be removed from the database from time to time as these will slow the array formulas used in the lookup. (they are slow enough now!)
Thanks in advance.
Dave The-slave
I am referring to a reader question post back 20 July 2009. The question was about generating an NCF number if the customer had a Government Registration Number RCN and not using an NCF if the customer was without a RCN. I am using similar formulas to generate invoice numbers but using a client number instead of NCF. The problem is that when old invoices are removed from the database the other invoice numbers (remaining) all decrease by the number of how many are removed. i.e. remove 1 to 4 and the next becomes 1 and so forth. This happens on both the reader question and in my spreadsheet.
Old invoices will have to be removed from the database from time to time as these will slow the array formulas used in the lookup. (they are slow enough now!)
Thanks in advance.
Dave The-slave