Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: printing invoices with increasing unique counts

03 Sep 2016   #1
Bernardus

Microsoft Windows 7 Ultimate 64-bits 7601 Multiprocessor Free Service Pack 1
 
 
printing invoices with increasing unique counts

Anyone who can explain how I to set up invoices with a table or text box with updating numbers in Word?
For example a list of invoices with specific counts like page-numbers. (unique invoice numbers)
But I want them to be placed somewhere else in the sheets, not top or bottom (text box) and starting from a predetermined value. like 1000 and so on.


My System SpecsSystem Spec
.
03 Sep 2016   #2
fireberd

Windows 10 64 bit
 
 

I did that with tickets and MS Publisher. I had to create a table in Excel and link the ticket number box in Publisher to Excel.
I don't know if that will work with Word.

How to generate sequentially numbered documents using Publisher - TechRepublic
My System SpecsSystem Spec
03 Sep 2016   #3
Bernardus

Microsoft Windows 7 Ultimate 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Thanks for the reply
Wow, that's something I have to workout.
Hoped to find an easy way by a macro.
It's pretty foolish that such an option is not build in with Word.
At least not that I'm aware of.
My System SpecsSystem Spec
.

03 Sep 2016   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

What version of Office are you using. In Office 2013, you can get a lot of Invoice Templates to use with Word. To do that click on the Start Button & click on All Programs, scroll down & click on Microsoft Office, then click on Word & when that opens, there should be a lot of templates listed.

If you type Invoices in the search slot at the top & click on the search button a lot of Invoice Templates will be shown & you can download a template that could be suitable, or you could modify it to your needs.

Other versions of Office should work in a similar way.
My System SpecsSystem Spec
04 Sep 2016   #5
Bernardus

Microsoft Windows 7 Ultimate 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Thanks for the reply.
I'm using Word 2010

What I found was publisher with a lot of templates, but still no option to implement a number-generator.
The purpose is to copy an existing invoice design and add a unique number to it.
Printing is quite expensive if you use it only occasionally.
My System SpecsSystem Spec
04 Sep 2016   #6
MoxieMomma

OEM Windows 7 Ult (x64) SP1
 
 

Hi:

Just popping in to say "good advice", to @fireberd and @Ranger4. Good tips!

Cheers,
MM
My System SpecsSystem Spec
04 Sep 2016   #7
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

As far as I know it should be possible to use an invoice template (or create on yourself) then import invoice numbers from an Excel spreadsheet using MailMerge in MS Word. You just select the fields to insert in your invoice and insert the invoice number in the correct position. Unfortunately I don't have MS Word on my home based machine and only use it at work. You'd need to save the merged Word document so that it loads the data from the spreadsheet when opened.

Also take a look here for other software that might be used to create invoices.

Windows Search: invoice
My System SpecsSystem Spec
04 Sep 2016   #8
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

You could also use Excel to create an invoice. The following website has some free invoice templates to use with Excel. You can the tailor it to suit your needs.

https://www.smartsheet.com/free-excel-invoice-templates

It might be easier to get Excel to increment invoice numbers, than in Word.
My System SpecsSystem Spec
06 Sep 2016   #9
Bernardus

Microsoft Windows 7 Ultimate 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Thanks for the replies.
It's clear to use a textbox, but how do I update it every time I generate an invoice?
Occasionally (literately, selling some occasions LOL) you have to generate a unique invoicenumber.
So the sheet must remember the last used number.
I'm not that smart in these specific matters.
No problem to create tables or layouts. Nor formula's as debt and credit, total etc. (to a certain level).
I'm not a bookkeeper.
I know how to couple some data from Excel to Word, like addresses.

The sheet example you added contains a field with invoice numbers.
But it's unclear how the next sheet generates another incrementing number?

There is a difference between printing a list and couple that with another list in Excel.
Or just a single sheet at a time with a formula for numbers.
My System SpecsSystem Spec
06 Sep 2016   #10
Barman58

Windows 10 Pro x64 x2 Windows 10 Enterprise x64, Ubuntu
 
 

I have a slightly different method for the generation of invoices, but as I generate a low volume of invoices my method may not suit most others.

I use this method as IMHO, invoices just need to be Unique, and where stored in the same folder they should be ordered by ascending date order.

My Invoice numbers are the reverse of the issue date and a prefix/or suffix to ID other categories.

An example I wish to send an Invoice to "Fred" today The body of the number would Be 20160906 which I would Store in my Fred Invoice Folder, (or you could use a customer number or name as a prefix if you want to store invoices by Month or Year).

If I issued More that one Invoice to Fred today I would manually add -001. -002 ... Etc I then Save the Invoices in their folders Using the Invoice Number, any suffix Number, and usually a short note to ID the Invoice reason as the file Name.

EG.

Our first Invoice to Fred today would be 20160906-001 (001 only added if you are likely to issue more than one invoice today), and would be saved In the Fred folder as 20160906-001-Party at Hotel.docx or in a Single multi Client folder (date Based) 20160906-Fred-001-Party at Hotel.docx

This sounds more complex than it is but without needing any fancy footwork you have an invoice system that is fully searchable by date, Client, and basic type
and will always produce Unique invoices.

Note. I Use the UK Date so your start point may be different but as long as the date is written as YYYMMDD It will sort correctly
If you are using non client folders It makes sense to incorporate some form of Client ID in the Invoice number to better ID the invoice over the Phone when I client Calls You.

Of course all this system could be Automated by a macro if needed but I find my Client Folder based Storage system and the fact that if I need to issue multiple invoices on the same day to the same day I can remember the last number to add the correct Suffix (I often would create the first Invoice, SaveAs then Modify the contents and details and SaveAS again Etc.

This system will work for most smaller Single trader type companies if you have multiple people, Many Clients, etc then you really need some form of dedicated Accounting package ether off the shelf or Bespoke
My System SpecsSystem Spec
Reply

 printing invoices with increasing unique counts




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How can I stop printing things that are printing endlessly
I tried to print something but it started printing first a whole bunch of pages that I don't need anymore. It must be from the last time I pressed print but didn't connect the laptop with the printer.
General Discussion
Unique fan issue Dv7
Hi everyone ! I have an old Dv7 laptop and I know its known for heating issues but im facing a unique situation. Over the years I have never have any issue , only this week I have noticed it over heats. and on further observation I can see that the fan isnt running most of the time. However...
Hardware & Devices
Is Product ID unique as well?
Yes, the product key is unique, but how is the ID created? Is that a pre-determined id for that particular version of Win7 or is if unique to the key?
General Discussion
Is there a program that counts the traffic?
hi Is there a program that counts the traffic on my laptop? please do say DU Meter because it is stupid.
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 06:12.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App