Invoicing Number Question

[Bob]

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a invoicing access software written for me , It has increasing
invoice numbers when you make a invoice, where would I go and do to start
these increment numbers from 1000 instead of 1

Thanks in advance.........Bob Vance

 

[PC Datasheet]

Look in the code behind the form where invoices are created. (It's highly
likely the same form you use to print an invoice.) On that form you enter
the information on the invoice. The invoice number is automatically created
in code behind the form. The code probably looks like:
Me!InvoiceNum =
IIF(DCount("[InvoiceNum]","Invoices")=0,1,DMax("[InvoiceNum]","Invoices")+1)
To start at 1000, change the 1 after the 0 in the middle to 1000.
The above code statement says, if there are no invoices entered yet in the
Invoices table then make the current invoice number 1 else make the current
invoice number 1 higher than the largest invoice number in the Invoices
table.

 

[Albert D. Kallal]

I have a invoicing access software written for me , It has increasing

invoice numbers when you make a invoice, where would I go and do to start
these increment numbers from 1000 instead of 1

Thanks in advance.........Bob Vance

There is no particular place were you could/would "go" to change the
increment number. This question is kind of like asking where the volume
controls for the radio in a car are to be found. Well, we know that cars
radios have volume controls..but as to where you will find them (dash,
steering wheel...knobs...buttons....sliders etc...that is going to be up to
the person who designed the system).

So, without more details, it is actually very difficult to answer you
question. However, just like in a car..I would suggest to look at the area
above the console..as most cars do have the radio and volume controls in
that area.

And, most developers take the general following approaches to generating a
invoice number system:

Option a)
Look at existing data, find the max invoice number, and add + 1 to this
invoice value for the invoice just created.

Option b)
The developer used a autonumber field (this is a bad design..and should have
been avoided).

Option c)
create a table with a single record, and a single field. You can enter the
value of the next invoice (or the starting value) into the table with ONE
record, and ONE field. The developer of the software will then open this
table, read the invoice value..add + 1 to the invoice value, and then save
the value back to this one field. This approach means that the code does not
have to find the "max" value, or use auto number. This approach also means
that a screen can be built where you can set/view/enter the next invoice
number (this screen would not be used very much..but would generally fall
under some type of "configuration" menu that the developer made for you).
And, likely some type of security would be used to prevent your users of the
software being easily able to modify this value.

Of course the above 3 options are just common approaches, and not the
definable answer. Without more details as to how the invoice number was
setup by your developer....any suggestion is a mere guess on my part. (just
like where you could/would/should find the volume controls for your radio in
your car!!).


So, in fact, there are actually millions of different ways to create a next
invoice number.

If the developer used the table idea (option c), the you would just simply
go and find the table, open it..and enter the next invoice value you want.
If the developer used option a, then you will always get + 1 after the MAX
invoice number currently in the system.

If the developer used option b, then a compact and repair of the database
will usually re-set the starting number. However, if there are invoice
numbers already in the system..then usually the "max" value is the starting
point. (so, perhaps you could enter a dummy invoice with the starting
number..and then do a compact and repair if you are taking about a empty
database).

I would simply ask the developer of the software what method was used..and
were any previsions/designs in the software made to allow you (or he
developer) to easily change the next invoice number.

Good luck..and best of the season to you...

 

[Bob]

Ok I went to Table/Invoice and made my first invoice 1000 then the next one
I issued 1001 so I suppose I found the volume Knob Thanks Bob

Look in the code behind the form where invoices are created. (It's highly
likely the same form you use to print an invoice.) On that form you enter
the information on the invoice. The invoice number is automatically
created
in code behind the form. The code probably looks like:
Me!InvoiceNum =
IIF(DCount("[InvoiceNum]","Invoices")=0,1,DMax("[InvoiceNum]","Invoices")+1)
To start at 1000, change the 1 after the 0 in the middle to 1000.
The above code statement says, if there are no invoices entered yet in the
Invoices table then make the current invoice number 1 else make the
current
invoice number 1 higher than the largest invoice number in the Invoices
table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a invoicing access software written for me , It has increasing
invoice numbers when you make a invoice, where would I go and do to start
these increment numbers from 1000 instead of 1

Thanks in advance.........Bob Vance

 

[PC Datasheet]

If your database is designed as I suspect and you only have the two invoices
now, your next invoice should automatically come out as 1002. If it does
not, an option for you would be to send your database to me and I will fix
it so you get the invoice numbers in the sequence you want. My fee would be
very reasonable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Ok I went to Table/Invoice and made my first invoice 1000 then the next one
I issued 1001 so I suppose I found the volume Knob Thanks Bob

Look in the code behind the form where invoices are created. (It's highly
likely the same form you use to print an invoice.) On that form you enter
the information on the invoice. The invoice number is automatically
created
in code behind the form. The code probably looks like:
Me!InvoiceNum =
IIF(DCount("[InvoiceNum]","Invoices")=0,1,DMax("[InvoiceNum]","Invoices")+1)
To start at 1000, change the 1 after the 0 in the middle to 1000.
The above code statement says, if there are no invoices entered yet in the
Invoices table then make the current invoice number 1 else make the
current
invoice number 1 higher than the largest invoice number in the Invoices
table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a invoicing access software written for me , It has increasing
invoice numbers when you make a invoice, where would I go and do to start
these increment numbers from 1000 instead of 1

Thanks in advance.........Bob Vance

 

[Bob]

Thanks see what happens at the end of the month!

If your database is designed as I suspect and you only have the two
invoices
now, your next invoice should automatically come out as 1002. If it does
not, an option for you would be to send your database to me and I will fix
it so you get the invoice numbers in the sequence you want. My fee would
be
very reasonable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Ok I went to Table/Invoice and made my first invoice 1000 then the next one
I issued 1001 so I suppose I found the volume Knob Thanks Bob

Look in the code behind the form where invoices are created. (It's highly
likely the same form you use to print an invoice.) On that form you enter
the information on the invoice. The invoice number is automatically
created
in code behind the form. The code probably looks like:
Me!InvoiceNum =
IIF(DCount("[InvoiceNum]","Invoices")=0,1,DMax("[InvoiceNum]","Invoices")+1)
To start at 1000, change the 1 after the 0 in the middle to 1000.
The above code statement says, if there are no invoices entered yet in the
Invoices table then make the current invoice number 1 else make the
current
invoice number 1 higher than the largest invoice number in the Invoices
table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a invoicing access software written for me , It has increasing
invoice numbers when you make a invoice, where would I go and do to start
these increment numbers from 1000 instead of 1

Thanks in advance.........Bob Vance