Computer Support Forum

invoice creation

Question: invoice creation

I have the microsoft works program and I found the invoice templet but i can't figure out how to erase the heading they've got and put in my company name and address. also I can't figure out how to change the date on the invoice. Please help this computer illiterate. thanks.

Relevance 100%
Preferred Solution: invoice creation

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: invoice creation

Hello there,

To change the general info on your invoice, click on the "customize" button found directly below the invoice No. in the upper right of the actual invoice. That will open up the customization sheet. In there you can change any of the general things.
After you're done making the changes, click the lock and save button on that sheet to save the changes for the next time you use the invoice.
To close it and return to the invoice itself, click on the sheet tab at the top of the task bar at the bottom of your screen. It will say "invoice"

To change the date, just double click on the date on the invoice sheet and it was become active, thus letting you change it. When you are done just hit enter key on your key board to close it.
Let me know if you need any more help.
Nettie

1 more replies
Relevance 72.57%

I have a database I have created for booking education programs for the museum I work for. The overview of the database is this: There is a customer table with the school or group info, a programs table which holds all the info regarding the programs we offer such as price, a contacts table which has info for the specific contact person since we often have many different contacts from the same school or group. There is a bookings table which has an order ID and other relevant info of the particular order. The main way of inputting the info is on the booking form which has a subform for order details, subform for customers and subform for contacts. I created a report to use as an invoice but I am having a hard time with it. Everything works out great for it except now I am only getting the info for one order. The way I would like it to work is that there is a report (invoice) for each Order ID. On that invoice it would display the info pertaining to that Order ID such as customer, contact, etc. as well as the list of programs ordered. This is done by Order Detail ID's and this is all working fine. However, when I open the report it is creating a duplicate pages for one order and it is only creating for that one order. For example if Order ID 1 has 3 programs ordered, it will show everything exactly how I want it to with all values calculated correctly but there will be 3 identical pages.
Is there a way to set up the report so that I have to put in the Order ID number or ... Read more

Answer:Access 2003 Invoice creation

7 more replies
Relevance 72.57%

Hi, I barely understand MS Excel, and have a very hard time to make an invoice just like a scanned one. I know how to make some simple formulas, but have no clue how to make the shape similar in excel. It would tremendous, if anybody could help with that! I didn't know, how to put the scanned invoice into this message, so i put it on a hosting site click hereIf anybody can help me, please contact me here or via e-mail: [email protected] !The language of the invoice is latvian, if anybody is interested in that :)

Answer:Invoice creation in MS Excel 2007

Not knowing exactly what you want on your invoices perhaps the best way would be to search the many free templates that are available for Excel. A few sites for you to look at. click here click here click here click here There are quite a few more, just type 'free Excel templates' into Google.

2 more replies
Relevance 47.56%

I have access 2016, Looking for a invoice that is already created, for my small computer repair business.

I have tried to make my own with many errors and issues.

Can anyone please help me.

Thank you,
Bill
 

More replies
Relevance 41.82%
Question: Invoice help

I've got a form with a command button "print invoice" that prints the shown information as an invoice, the macro 'where' condition code as follows:
[CustomerID]=[Forms]![Customers Order]![CustomerID]
I have a field which is "Invoice printed" yes or no (values 1 and 0 respectively) and i want the "print invoice" command button to change the value of this box to yes once i have clicked on the "Print invoice button. How can i do this? Its so that once i have printed the customers order invoice when i visit the customers orders again i can click this button and only print the orders that havn't been printed before. Any help with the macro which will only print orders with "invoice printed" field = no also appreciated. Any questions please post here if you dont understand, thanks alot.
 

Answer:Invoice help

Are we talking Access here?
If so then if your Form that has the Command button on it also has the field "Invoice printed" you can add this to your Command Button's VBA after the docmd print statement -

me.Invoice_printed = -1.

Yes no check box fields use 0 for not checked and -1 for checked in VBA.
 

1 more replies
Relevance 41.82%
Question: An invoice

Just wondering if any1 knows of a good package for creating an invoice, software etc.I have excel and have tried using it but i'm rubbish at that.thanx in advance.

Answer:An invoice

You can create simple invoices in Word, I believe there are even some templates.

2 more replies
Relevance 41.82%
Question: An invoice

Just wondering if any1 knows of a good package for creating an invoice, software etc.I have excel and have tried using it but i'm rubbish at that.thanx in advance.

Answer:An invoice

Again i apologise!

10 more replies
Relevance 41.82%
Question: Invoice

Hey!
I have a small home business. And would like to know if anyone has any experience with inexpensive (freeware) invoice software.

Thanks

...dpb...

Answer:Invoice

If you just need an application to print a few invoices each week, then MS Word has several Templates that will serve the purpose. And OpenOffice.org (an open-source, free office suite) has one that you can link to its spreadsheet. If you need to print many invoices and have money in the expence budget, there are several small business applications that you can purchase; other members may be able to recommend the best of these.
Regards,
John

3 more replies
Relevance 41.82%
Question: INVOICE

HOW TO GET MY LAPTOP INVOICE NUMBER

More replies
Relevance 41.41%

I bought Lumia 950 XL in your windowsshop in December 2015. I have some troubles with the device now; it swithes off frequently, so it must be repaired.
I would ask you for:
- the cpoy of the invoice you sent me a year ago, which I unforunately lost
- the advice how/where to repaire it.
Thank you,
yours
Andrej Koren
Focheva 27
2000 Maribor
Slovenia
+386 41 66 20 66

More replies
Relevance 41.41%
Question: Invoice software.

Free Invoice/Company management program. Anyone knows where I can find it?

Answer:Invoice software.

What about Excel? You can do wonders with that...

6 more replies
Relevance 41.41%
Question: About invoice copy

I don't have my invoice copy with me , I have only order number , I want my invoice copy for warranty claim , how can I get it from HP site ... I ordered my laptop from hp.com

Answer:About invoice copy

Dear Customer, If you have bought it directly from HP, you should be able to get the receipt online if you have registered an account at HP or by entering your order number/phone.P.S: The order number should be printed on the shipping box if you still have it around.   Hope this helps, for any further queries reply to the post and feel free to join us again  **Click the White Thumbs Up Button on the right to say Thanks**Make it easier for other people to find solutions by marking a Reply 'Accept as Solution' if it solves your problem. Thank You,GBL84I am not an HP Employee

1 more replies
Relevance 41.41%

Hi All, i have two queries,  Query 1 - We purchased a few items from HP.com uk but have not recived an invoice, we would like to get a copy but cannot find where to get a copy to download. Query 2 - part of our order we had an active Pen T4Z24AA , this does not work on either of the two spectre x360 we bought, I tried to raise a case but it was closed and I cannot find a way of raising a case to reurn it.  Can anybody help or advise us please. Thanks

Answer:Invoice and Active Pen

Hi, 1. For the invoice, please contact HP Store in the UK directly. This is a forum for you and me.2. For the pen, did you check the compatible products before order ? It does not support x360 machines.         http://store.hp.com/UKStore/Merch/Product.aspx?id=T4Z24AA&opt=&sel=ACC Please check the store and swap for a different pen. Regards.

1 more replies
Relevance 41.41%
Question: Saving Invoice..

I made an example of excel invoice,

In the example invoice is registered with the macro.

View example

Regards.
 

Answer:Saving Invoice..

Think of a better method to attach, the code shown is not acceoted.
Why such a large file? Which version of Excel?
 

3 more replies
Relevance 41.41%
Question: invoice in access

Can someone advise me whether an invoice is a query or a form. I need it to be able to calculate price against quantity for a small tuck shop. Or is there a template about.

I set up my data base and read plenty but the only thing the book doesnt say is how to create an invoice.I can create the sheet but i cant work oiut how to gtet the calculations done.

Thanks
 

Answer:invoice in access

10 more replies
Relevance 41.41%
Question: Invoice Required

my friend brought a laptop for me from US 6 month back, he ordered from amazon.com and now i want Invoice of my laptop but i don't have my friend contact number, how do i get a invoice of my laptop

Answer:Invoice Required

The only way is to contact the buyer.

2 more replies
Relevance 41.41%
Question: email invoice

impossible to invoice a email

I receive always the same message

SYMANTEC error 1003,9

Thank you for solution

Kindest regards

Daniel Bastogne
 

Answer:email invoice

I don't have any idea what it means "to invoice a email" but the error obviously has to do with Norton Anti-Virus or Norton Internet Security Suite scanning email.

Things I'd try include:

a. Check the Symantic site support section;
b. Turn off email scanning;
c. Uninstall Norton and reinstall it.
 

1 more replies
Relevance 41.41%
Question: invoice document

hi where can i find a invoice/reciept type document ??? thanks in advance

Answer:invoice document

Microsoft office product's usually have tmeplates in them!!

2 more replies
Relevance 41.41%

as stated in the tittle i need an invoice copy of an order from 2013 im moving out of my city and the courier is asking me for iti have the order number and all

More replies
Relevance 41.41%

Not sure if I am in right forum nevertheless, here goes. I am just starting up as self employed - now need simple invoice application - preferably free - that will run on ME anyone got any ideas please.

Answer:Invoice application

What do you mean, an application that will print them out perhaps with your logo? or a database of your records or ???

4 more replies
Relevance 41.41%

I use Firefox but am plagued with a persistent invoice for 39.99 which keeps popping up on IE for access to "my sex world.com" Being of an age where i would rather read the paper than follow the links to a sex site this is driving me mad. My 2 sons insist that they have never been on a sex site - so we must have ghosts.This dammed thing locks itself for 2 mins and I cannot for the life of me get rid of it. I thought i was quite security minded but cannot figure out how to kill this thing and I have no intention of paying it. It looks as though it was created on April 28th and will continue to plague me until i either pay or find someway of getting rid of it from my system.Any suggestions please before my wife kills me

Answer:Invoice from "sex" site

click hereCould be this; I seem to remember the FE asking about people experiencing this but can't find the thread at the moment.

9 more replies
Relevance 41.41%
Question: Missing Invoice

Hi,I just purchased a Thinkpad E560 and I need the invoice as short as possible.I have visited the"Check your product"page and I have written the product code and the password I have setted for my Lenovo ID, but It always appears this message"Wrong order number or password"...maybe I have to insert another password?Because in the mail I received after purchase it's written"use the order number and password indicated below", but below there is only the order number. I'll wait for your help.Thank you in avance.Regards 

More replies
Relevance 41.41%
Relevance 41.41%
Question: Invoice software??

Need a legitimate piece of quality software to handle invoicing for a small business. Don't want something that is never updated and will hijack client information.

If anyone knows of something, please let me know. Even a larger program that has invoicing functions would be great.
 

Answer:Invoice software??

The ones that come to mind off the top of my head are: Peach Tree, and Quickbooks. It is a little more than just invoicing. I think Peach Tree is a little more difficult to learn, and if I remember correctly it is a little more pricey. You can download eval versions from their website and try them out for 30 days.

Hope this helps.
 

4 more replies
Relevance 41.41%
Question: publisher invoice

Is there a way to make an invoice using publisher that will do calculations? specicaly total, sales tax, etc. I can create an invoice in excell to do it, but the person that wants it likes the graphics he has in publisher. I have tried putting a spreadsheet into publisher. But when i do it loses its funtionality.

thanks,

Spotts
 

Answer:publisher invoice

you could try putting the publisher graphics into excel...
i know you can save publisher as a web page and then you should get all th egraphics out seperatly - and with a bit of formating use excel
 

1 more replies
Relevance 41%

Hi. I am looking to create an invoice with the image of the paper image I use for my business in word. My business is a landscaping business and has a tree plus and invoice format on it. How do I create this invoice so that I can email it to my customers. Is this a graphics issue (do I need Adobe Illustrator)? Do I need a special color scanner ? or can this be done simply in word? Please help.
 

More replies
Relevance 41%

hello there,

My brother and I own a bakery, retail and wholesale, and currently we are looking for a software to do the invoices. as of right know we are using excell. It has worked alright for the past few years but now due tothe lack of time, increase in business, it has become tedious to do reports and monthly statements. all we need is a software to be able to do daily invoices, montly or weeklly statements and basic inventory. we don't need anything else. right know we have found "instantinvoice 3" which we really like. However, there is no inventory and the big thing is that they are based in australia. do any of you have any recomendations? thank you le
 

Answer:simple invoice software

le4358 said:

hello there,

My brother and I own a bakery, retail and wholesale, and currently we are looking for a software to do the invoices. as of right know we are using excell. It has worked alright for the past few years but now due tothe lack of time, increase in business, it has become tedious to do reports and monthly statements. all we need is a software to be able to do daily invoices, montly or weeklly statements and basic inventory. we don't need anything else. right know we have found "instantinvoice 3" which we really like. However, there is no inventory and the big thing is that they are based in australia. do any of you have any recomendations? thank you leClick to expand...

Did you look further down the page?
Here's the link back to it.
 

1 more replies
Relevance 41%

in sheet1 i created basic invoice template in such way in b1 is invoice number in a2 date, in b2 customer name, in c2 product, in d2 qty, in e2 rate, in f2 amount = rate x qty. and on sheet1 i created save command button. and in sheet2 from A1:G1 is title like Invoice no, Date, Customer no, Product, Qty, Rate, Amount now when i click save on save button on sheet1, the sheet1 data goes in sheet2 and in their respective fields and gets saved with "Edit" hyperlink at end of each invoice in sheet2 in H2. when i click on this edit button the invoice gets open and when i make some changes and save and close that edited invoice the databse that i created on sheet2 of that particular invoice doesnt effect on changes. so please help.

Answer:Invoice Create and Edit

Without seeing the code for the "Edit" button, it's kind of hard for us to determine why your changes are not being saved.Is the Save operation part of the macro behind the Edit button or are you simply using Excel's basic File...Save steps?We need to know a little bit more about how you use the workbook before we could offer any suggestions.If you plan on posting any VBA code, please click on the following line and read the instructions found via that link.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 41%

I purchased a  HP Pavilion Notebook 15-au111TX  in september 2016  and my laptop bill/invoice got misplaced. i actually wanted to get a duplicate bill/invoice of my laptop.  My laptop details are mentioned below :-Notebook Serial No.                           : 5CD6312XLTNotebook Model                                : HP Pavilion Notebook 15-au111TX Can anyone tell me the procedure to get a duplicate bill at earliest ? Thankyou

More replies
Relevance 41%

Hi, I have created a database that does invoicing. The invoice works well. It calculates everything and a locates all the data by combo boxes and so forth. However, the problem I have is that if I change the price for an item in the products table, it automatically change the price in the previous invoices. How do I correct that so that it only applies to the new invoices and not the previous ones?

Someone please help me to correct that.

Thank you.
 

Answer:Invoice Data Problem

16 more replies
Relevance 41%

I received  several emails that contains attachments with name 'invoice' and I could not open the attachment. Someone told me after that it's a malware that could be use to get my personal banking information. How could I remove it on my system or even check if it's still there.

More replies
Relevance 41%

Ebuyer. So if it goes wrong what comeback do I have?

Answer:I didn't get an invoice with my latest buy from

is the confirmation email any good, must be some proof of purchase, at least it has the order no on it.

4 more replies
Relevance 41%
Question: Fake invoice email

I received an email from my accountant on my iPhone 5 few days ago with subject "Invoice number xxxx".  The email contains a button which points to a google drive document.   I clicked on the button and it displayed a screen very similar to the Google log on screen and asked for my user name and password.
 
I didn't enter my detail as it looks suspicious.   I then called my accountant and confirmed that it's not a real invoice.  As a result, I immediately deleted the email and cleared my browser's (Chrome) cache.
 
Is my iPhone still secure?  Is there anything else I need to do?  My iPhone is not jail broken.
 
Any advice is appreciated.

Answer:Fake invoice email

Hi Superbull That email was simply trying to link you to a phishing page. As long as you didn't enter any information (username, password, etc.) on it, you are safe. Your iPhone is still secure, and since you deleted the email, there's nothing else you need to do.

3 more replies
Relevance 41%

Hey guys, Im looking to build a program that can print out very simple invoices. The programming behind the logic will be super simple. However, I never learned in school how to send a job to a printer. I assume this is possible with C++. Anyone have any good tutorials out there that can help me figure out exactly how to do this?
 

Answer:Invoice Printing Program

How do I "Print" in C++ code? Anyone?
 

1 more replies
Relevance 41%

Hi
I'm new to this site but after a few internet searches I found this place. I'm trying to set up a basic macro but am having difficulty because I'm not very good.

I want 3 tabs:
The first tab is a a spreadsheet I fill in manually with rows of invoices raised with columns for invoice no., invoice date, Customer, order no, invoice amount and paid (Y/N).

Then from the information above and particularly the paid (Y/N) column I would like all the paid invoices to go to another spreadsheet and all the unpaid invoices to go to another spreadsheet.

Thanks for looking.
 

Answer:Invoice Listing Macro Help

To be honest doubt anyone would do this for you from start to finish. If you start it off, create your workbook with your tabs, format it as you want it, maybe even try writing the macro...

Then someone incluing myself will be more inclined to help.

Its just easier that way so please attach a workbook as above and we'll help you out
 

1 more replies
Relevance 41%

Greetings fellow members,

I am in in need of suggestions or recommendations for accounting and invoicing software.
I am deeply opposed to all of these new cloud based software, i would feel safer and more secure if the information is stored on my private computer.

Quickbooks , zoho books and most of the popular ones i heard of seemed to have all moved to the cloud.
I despise paying any sort of subscription and never owning the entire product.

So i rather pay 1 fee for the software and be done with it, preferably something that is easy to use for 2 new employees to learn fast.

Free would be nice but all the free software i see its limited to specific number of people being able to use it or how many total invoices can be made.

i heard of waveapp but since its cloud based no way i would store CC, bank accounts and all this information on their servers.

This would be for a windows OS ( 10 and 7)
 

Answer:Accounting And Invoice Software

Are you in UK ?.
I created my own some years ago to link everything, wages, National insurance, Invoices, even the VAT to automatically update. It was really very simple to adjust the rates, and print out at the end of the year- probably something like the ones you talk about. All the pages were linked.
I will try to find a copy, but it might be a few days, as I would have to update as best I can. You keep the package on your desktop/laptop, whatever, and do not have to post on-line.
I will come back to you if you are interested- uses EXCEL, but I am sure it would . It was last used in Windows 7, (before I lost my son who was using it) and if you are living IN USA, or, anywhere else, I am sure I could change it to dollars, or, whatever.
I will look it out, and see what I can do , if it sounds appealing to you. I used it myself for about 10 years, before recreating for my son when I retired.
 

4 more replies
Relevance 41%

Anyone received an 'invoice' from Platte International or Platte Media?
 

Answer:Platte Media Invoice

What do have there, a possible phishing scam? Why did you post the question?
 

7 more replies
Relevance 41%

I am fairly green when it comes to MSAccess and SQL. I am just learning, slowly I might add. But we need to create an accounting database for one of our departments. I was working on the invoice and can not quite get it the way I want. I am hoping you can give me some help and guide me on how to do this correctly.

What I want to be able to do is this: Have a contact/customer table. Have an invoice table. Then create a form that I can enter the invoice information and pull the customer from the contact table. I can't seem to get this part. It seems as though it should be easy. I will add the database attachment and see what you think. Thanks!
 

Answer:Solved: Invoice in Access

7 more replies
Relevance 41%

following your letter of May 16 2011 I want to update my Credit Card data

Answer:need to update invoice info

this ones confusing, I will admit? if you are asking if you should post creditcard information online, i recommend against it. if there is a program asking you to submit your card information dont unless its legit, and then still think about it. if you have recieved an email with this in it, its probably fake.feel free to add information and i will try to help you.mike

3 more replies
Relevance 41%

How do I close out an open invoice that used to be paid for as a credit card vendor and move the balance to a New Vendor that is a loan?

Please help. Cherri
 

Answer:Mas 90 A/P paying an invoice with a new loan

Hi CherriNewbury

I'll take a stab at it.

Zero out the original amount with a reference to the new Vendor's number and if space permitting, note that the payment terms have changed.

Input the amount from the original Vendor number to the new Vendor number, referencing the old Vendor number and if space permitting, note that the payment terms have changed.

That should keep the General Ledger in balance.

If you keep an actual paper folder for your Vendors, make a print screen copy of each transaction entered and place a copy in each Vendor's file.
 

3 more replies
Relevance 41%

I created an invoice today and it somehow got recorded as a "Pending (non-posting)" invoice. It appears on the invoice like the "Paid" note at an angle. I cannot figure out what I did to make this happen. Can I make it a regular invoice without deleting and recreating it? I'd like to keep the invoice # as this is the one I sent out. Thanks to any QuickBooks guru out there.
 

Answer:QuickBooks Invoice Pain

To rectify - go to the Edit menu when you're in the Create Invoices window. Select the option "Mark invoice as final". This removes the "pending" banner. Pending is v useful if you want to remind youself to send an invoice in a couple of months time - the invoice will appear in an "Invoices pending" list.

I guess you got there by going to the edit menu and accidentally hitting the "Mark invoice as pending" option

Good luck
 

3 more replies
Relevance 41%

I am making an invoice template to use at work. We are running on 30 day net. How do I add 30 days to the date on the invoice? Date will be in F5 and Due Date will be in F7.
Thanks....Bud
 

Answer:Solved: Invoice help needed

10 more replies
Relevance 41%

This is not a technical question, if i'm posting in the wrong section I request the moderators to move it to the correct place.
I'm from India. We have an online shop here, called "Snapdeal". Purchased a laptop from here, it's a Dell Vostro. When I check the Dell warranty page, I see the "Shipping Date" is different from the date on my invoice. Called up Dell support, they asked me to mail a scanned copy of the invoice, and they will make the appropriate corrections. I did, and the next day Dell called me back and informed my request has been rejected, as there's no "Service tag" or "Express service code" mentioned in the invoice. It's impossible for Dell to verify this invoice is for the laptop in question, and i need to contact the "place of purchase" for an updated invoice which includes the service tag of the laptop.
I've since called "Snapdeal" a number of times. They keep telling they have taken a complaint and will send an updated invoice in 24 hours, but I'm yet to receive this. This is not really a Dell problem, it's a "Snapdeal" problem. Could someone please suggest what do I do now? If the laptop gets stolen, I won't even be able to complain to the police, as my invoice is pretty much meaningless without the serial number of the laptop mentioned on it :-(

More replies
Relevance 41%

I am trying to print invoices from Quickbooks Pro 2008. The form itself prints fine, but all of the field information is blank. The print boxes are checked under additional customization. Any help at all would be great!
 

More replies
Relevance 41%

I have created an invoice in MS Excel. I have also worked it to were it will assign invoice numbers in sequence. My problem is how do I get to Invoice #2???
 

Answer:MS Excel Invoice question

Are you going to make a new spreadsheet for each invoice? How about tabbing worksheets across (ie IV001, INV002...) then just reference the invoice number to the previous + 1. This is still pretty clunky... Keeping invoices in excel will be cumbersome unless sales per day is a small number (but hopefully high $). You really need a database in my opinion.
 

2 more replies
Relevance 41%

OK I got so far..... I sorted my queries and even created a report,, of sorts,,, but..

What i want to achieve is to list several different journeys on one report (invoice). what my report gives me is customer info and one journey on first page. It creates a page for every journey but does not display rest of journeys on following pages.

HOw do i bring all jobs on to front page please?
 

Answer:invoice thro Access

11 more replies
Relevance 40.59%

The invoice templates provided by Intuit for this software include Ship-to and Bill-to addresses, but do not include the Customer Name. I would like to know if there is a way to add the Customer Name field to the invoice template? Any help will be appreciated.
 

Answer:QuickBooks Pro 2007 - Invoice Customization

Tom.cabo said:

The invoice templates provided by Intuit for this software include Ship-to and Bill-to addresses, but do not include the Customer Name. I would like to know if there is a way to add the Customer Name field to the invoice template? Any help will be appreciated.Click to expand...

Click on Lists | Templates | then select the invoice template you want to customize. You will then be at Basic Customization. Click on the Additional Customization command button at the bottom. This will bring up a bunch of fields you can select to be on the screen when you prepare an invoice but NOT on the printed invoice, etc. For you specifically, select the "Bill To" field and change its title to "Customer Name". Save the invoice as a custom invoice and make the Intuit ones inactive. Uncheck the "Ship To" field so it won't print.

This should do it for you.
 

3 more replies
Relevance 40.59%

Hi I need someone's help. I want to transfer data from one sheet to another (invoice) once I add a Quantity in one sheet I want it to send 4 pieces of information to the Invoice (Quantity, Description, Item ID and Price) The Invoice will start in line 18 I would really appreciate it if someone could help me with this. Thank you.

Answer:Transfer Data from Sheet to Invoice

Is this Excel, Open office or other?Always pop back and let us know the outcome - thanks

5 more replies
Relevance 40.59%

Hi all, yesterday, I ordered a T440p through the lenovo.de website. Since a company will pay for the laptp, I need an official invoice from Lenovo for the company so they can start the payment-process. My order is listed on www.findmyorder.com after I login, but there's no official invoice-download. The website says (my translation): "You can download your invoice as a pdf-document - with an official electronic signature - in a few hours." I ordered more than 24 hours ago - and there's still no invoice-download How long will it take to generate the invoice? Thanks in advance!Arcx

Answer:Ordered a T440p yesterday - still no invoice?

Hi,I have exactly the same problem. My employer also wants to see the invoice first.Given that your question is a while back, how long did you wait for it?

2 more replies
Relevance 40.59%

hello,i purchased a T500 laptop online from lenovo.com 2 years ago. does anyone know if i can somehow trace the invoice and parts order for that laptop?the reason i need that is that i remember buying 6GB RAM for that laptop but since it arrived with winxp pro downgrade i could only see 3GB available RAM. i have recently installed win7 and to my surprise i could only see 4GB RAM on my system. any help will be much appreciated

Answer:laptop invoice and the missing RAM mistery.

you can check the amount of memory in bios. or using free program like CPUID www.cpuid.com (see memory for each slot).if you have windows 7 32 bits though you can only use approximate 3gb of ram due to hardware and OS limitations.





Lenovo T410, 2518EUG, Windows 7 Pro x64

4 more replies
Relevance 40.59%

I need an invoice/receipt for a HP Printer which was replaced, where can I contact someone for this.

More replies
Relevance 40.59%

I'm so close to completing the attached database but have run into a snag on the invoice report. When they select "Jobs by Customer" from the switchboard, they can then click the Invoice button to either preview or print the invoice for that particular job. The problem is this:
The current invoice date is set to Today() which of course will have a different date (for the same invoice) tomorrow and the day after, etc. I need the invoice date to always remain the same. In other words if they preview or print the invoice today, I would like the invoice date to always display today's date. I can't figure out how to do that.

The other problem is giving the invoice a unique number. Their current invoice numbering works like this:
If they are invoicing for April, their first invoice number will be 4 for the month, then 000. Their second invoice for the month will be 4 then 001. In other words, 4000 and 4001, and so on. The numbering then starts over in May with 5000, 5001, and so on. I'm unable to come up with an automatic numbering system for this also.

Thanks for any help you can offer!
 

Answer:MS Access: Creating Invoice report

8 more replies
Relevance 40.59%

So, I finally received my Y580.  Unfortunately, the graphics card is defective.  Spent a very unproductive weekend reading through all the posts and trying to find a solution to no avail.  I did everything everyone suggested here. I called the tech support over the weekend and told them everything and they just said to call post-sales and ask for a replacement (no case number provided; didn't even ask for my order number or laptop serial number). I called post-sales this morning and firmly asked for a replacement which they said they would submit and get back to me in 3 to 5 business days (per standard from what I read).  But I was looking through the documents for the RMA (is this an RMA?) which states that it should include the invoice.  When I received my laptop, it was in a box with 2 large white labels and large plastic sticker where I presume the invoice would be but there wasn't any (I paid via PayPal if that makes any difference).    There was also a hole cut out of the shipping box showing the serial numbers. Should I be worried about the missing invoice delay a replacement? Thanks.

Answer:Missing invoice on new received laptop?

Hello Lingraye,
 
Did you order directly through Lenovo? If so, your order should provide proof or purchase through our internal ordering database. Sales may be referring to an invoice if ordered from a 3rd party or retailer. Feel free to send me a private message with additional details (ie. order number, contact details) and I can check with post-sales to make sure things are moving in the right direction for you.
 
Best Regards,
 
Ty

1 more replies
Relevance 40.59%

OK, here is the problem:

I am trying to create an automated Invoice/Packslip maker in Access for my work. I got all of it ready exept for one vital part: the listing of all the items being shipped. I cant seem to wrap my head around it. I dont want to put this information into a seperate database if I dont have to.

Basicaly I need five feilds that can be repeated over and over with at least two of the feilds being summed (like an excel spreadsheet) inside a record to list the items. I dont know how to even begin. Any suggestions?
 

Answer:Creating Invoice sheets in Access

13 more replies
Relevance 40.59%

I want to tranfer my laptop warranty in India for which HP INDIA Customer Support is requesting a copy of the Invoice. Whom should i contact (email or call) to get the invoice copy.

Answer:How can i get the Invoice for my laptop purchase for transfe...

Hello Ankur2017, Welcome to Forum !!  I would like to ask few questions here : 1) Invoice is Proof of Purchase2) Where and how did you buy this PC  Hope this helps, for any further queries reply to the post and feel free to join us again  **Click the White Thumbs Up Button on the right to say Thanks**Make it easier for other people to find solutions by marking a Reply 'Accept as Solution' if it solves your problem. Thank You,GBL84I am not an HP Employee 

1 more replies
Relevance 40.59%

I Have ordered Dell Inspiron 15R online from amazon 1 year back.  I have the invoice copy from amazon but  as I lost my laptop and need some invoice which will have serial number to match with the laptop and to be given as proof to Police that the laptop belongs to me.
When I checked on Dell site its asking for Dell order number and what all I have is amazon order number.
Could someone please help me in getting the invoice for my laptop which I can produce as proof that the laptop belongs to me.

Answer:I lost my dell laptop and looking for help in getting invoice for same

Hi arpitajain2104,Check if you have the service tag of the laptop. You can use this link http://dell.to/1hnYHA9 to report to Dell. Also would suggest you to lodge a police complaint regarding the same. 

7 more replies
Relevance 40.59%

Hey guys, I need somebody to help steer me in the right direction on where to get started with this. My work requires me to submit data from a pre-existing spreadsheet into a form on an external site and to then use those returning results to fill in another column on the same spreadsheet with a value. In other words I input an invoice# and ID# into a site, see what pops up, and input a value into a third column which reflects that information. I do this thousands of times a day using copy/paste manually .

I don't mind taking the time to learn how to code this myself in my free time, but I just need to know where to begin! Your feedback would be greatly appreciated.

I assume I would first have to be able to take the ID#'s from excel, inputting them into the specific fields on the designated site, then pull the results that it returns, and scan that for the specific information I need. And then finally, using a set of rules to decide, based on that information, what values to input back into excel.

Thanks in advance.
 

More replies
Relevance 40.59%

I have just received the email below and am trying to find the answer as to how to search for any malware and also remove any harmful programmes etc that I may have inadvertently downloaded.

Hello,

Please can you let me have a payment date for the attached March Invoice?

Kind Regards

Sue Mockridge

Accounts Administrator

 (Main) 01884 242626   (Direct Dial) 01884 250764

Please consider the environment before printing

Broad Oak Toiletries Ltd, Tiverton, Tiverton Way, Tiverton Business Park, Tiverton, Devon, EX16 6TG

Registered No. 1971053 England & Wales

Telephone: +44 (0) 1884 242626

Facsimile: +44 (0) 1884 242602

CONFIDENTIALITY:

The information in this email and any attachments is confidential. It is intended solely for the attention and use of the named addressee(s). The unauthorised copying, retransmission, dissemination and other use of, or taking of any action in reliance upon, this information is prohibited. Unless explicitly stated otherwise, the contents of this message are strictly subject to contract; any views expressed may be personal and shall not create a binding legal contract or other commitment on the part of Broad Oak Toiletries Ltd.

______________________________________________________________________

This email has been scanned by the Symantec Email Security.cloud service.

For more information please visit http://www.symanteccloud.com

23 April 2014: Invoice 288910 March 2014 ( 10 kb) E... Read more

More replies
Relevance 40.59%

Hello,
I am using Quickbooks Pro 2006. Everything normaly works fine. Recently some of my invoices that I e-mailed have not been recieved by the recipient. Most of the time if I send the same invoice out again it will normally go through on second attempt. Any help is appriciated.

thank you.

J
 

More replies
Relevance 40.59%

I have an Thinkpad T420 laptop with serial number xxxxx, this laptop was given by amazon company to the employer. when my friend was working in amazon they has given the laptop he has given his laptop to me and he went to USA now i am having some problems with the laptop so i have to give this laptop for service so can i get the invoice of this laptop from lenovo company.
 
 
Moderator comment: Serial number(s) removed to protect member from mischief.

Answer:How to get INVOICE of laptop with my serial number?

You don't need an invoice.  The warranty goes with the serial, not the original owner. You can check warranty status here:
http://support.lenovo.com/en_US/product-service/warranty-status/default.page?

6 more replies
Relevance 40.59%

Hi,

I completed my first invoice made in Excel. Now I want to send it to my client.

How can I send it so he can print it, but without him being able to edit cells?
Thankss!!
 

Answer:Solved: Sending an invoice vie email

16 more replies
Relevance 40.59%

I want to create and invoice with several columns as Product, colour, size, amount etcBy input only the code (letters) of the product and fill each of the columns with the relevant info.

Answer:Create Invoice with external data

Don't know how to do what you asked.Here are a few free programs to try.TurboCASHhttp://www.softpedia.com/get/Others...http://www.softpedia.com/progScreen...http://sourceforge.net/projects/tur...Invoice Expert XE Litehttp://www.softpedia.com/get/Others...http://www.softpedia.com/progScreen...http://www.invoiceexpert.com/Express Invoicehttp://www.softpedia.com/get/Others...http://www.softpedia.com/progScreen...Get it Free. A free version of this program is available for home users or businesses with fewer than 5 staff members. Download the free version here, which does not expire and includes most of the features the professional version has.http://www.nchsoftware.com/invoice/...65 pages of business Freeware.http://www.softpedia.com/catList/14...

2 more replies
Relevance 40.59%

I am desperately needing a invoice application for my small/medium business. Our old software is functional but i is way outdated. Believe it or not its a dos app. It is sorely lacking in decent reporting and is fragile if you try to remove very old data you will break the app.

We have a product based business. Need something simple and fast, with data files compatible with dbf or excel in case we need to change in the future. I have yet to find anything decent. Dont mention qbooks becuase its invoicing it really weak IMHO. We had various developers try and make a custom app for us and we have been burned three times.

Its not that we need something overpowering. The developers were just flaky and did not finish the work. Some of the apps I have seen online (canned apps) looks very poor in their interface and or operation. Of course we dont want to pay thousands of dollars for some high end biz app either. Maybe there is something out there that I have missed? We run approx 10-50 invoices per day. Appreciate any advice or ideas.
Rob
 

Answer:Need Small business invoice application?

6 more replies
Relevance 40.59%

Hello!

I've lost the invoice of my Satellite L300, which I bought on 5. 5. 2008.
What can I do now???
Can I become back the warranty???

Monika

Answer:I've lost the Invoice of my Satellite L300

Do you have another proof of purchase, like a credit card bill showing the purchase?

5 more replies
Relevance 40.59%

Hi all,

Can someone help me with my small business invoicing, hope to do something that just a click of button will create the whole invoice and autogenerate the invoice number.

Am a complete idiot with excel macro... Hope somebody can help me out. Thanks in advance
 

More replies
Relevance 40.59%

I have used a few invoice programs but have not found one that works really well and is free. Can anyone recommend a good program for me to use, it only needs to be able to create basic invoices. If it can print to a PDF that is a plus but not necessary.
 

Answer:Free invoice creator that works well?

umm.. this might help.. but there is a program called NEWT, and there is a freeware version on download.com.. and it can scan a computer network and tell you what hardware and software is on each comptuer.. is that what you need? there is another one called remote system information, that isn't free, but cheap... it does the same thing, but is different... both are equally good i think, but do different things...
 

10 more replies
Relevance 40.59%
Relevance 40.59%

I have a bunch of template icons but made some unknown contact with my INVOICE while typing in details and lost the whole thing, how could I get it back or where should I go to reload office templates
Thanks
 

Answer:Want to download office template, INVOICE

8 more replies
Relevance 40.59%

hi all i need a simple pos or billing system for my shop
 

More replies
Relevance 40.59%

Hi Team,I have a 450 rows in excel containing particular in (A2:F2) and (K2:L2) as follow(Ship date, Invoice Number, Product Name, Quantity, Currency, Sale Price )( Country, Address)Below is sample file link:-http://www96.zippyshare.com/v/6sAEM...I'd like to create invoice for same with this data sheet.Also need a fixed space on top of invoice on right for fix Shipper information also. Which remains intact.Any luck with thisHighly appreciable your cooperation in this matter.

Answer:Automatic invoice from excel database

Unfortunately I am unable to download the file you have uploaded due to restrictions on my network... please can you provide some sample data on here, using the PRE tags as described in the below linkhttp://www.computing.net/howtos/show/posting-tables-with-the-pre-tag/484.htmlmessage edited by AlwaysWillingToLearn

2 more replies
Relevance 40.59%

Could you please assist me on this one. I have this data on one sheet that require to be auto-filled on the invoice template whenever I type in on the order number on B17. I believe this would be a macro to assist me do this. I would like the following to appear on the invoice automatically as it appears on the raw data whenever we change the order number. - Agent name -Customer name/no-Sales associate- Invoice date-Code-Product Description- Quantity - Unit price The file is attached on zippysharehttp://www87.zippyshare.com/v/xhsff...

Answer:How to create an invoice from excel data

I noticed that this question has not been answered. Are you still looking for some help or have you solved your issue?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 40.59%

I purchased my laptop HP 14 R212TX on 18th October 2015. My HP Support Assistant as well as the HP support website shows that my warranty is expired.I had a One Year Warranty for my laptop. I have the invoice with me.I don't think my warranty should have expired. Please look into the issue urgently. P.S. Also I have tried the Warranty Dispute procedure two times and stil no response from HP.

More replies
Relevance 40.59%

Ok, on one pc, there is a template we uses for invoices that is formatted with graphics and such. I'm trying to move this template to another pc so that I can print invoices too.

How do I do this? Help!!!!

TIA
 

More replies
Relevance 40.18%

Hi,Ive very minimally modified the below code based on another response i found on here. The basics are there for what i need but basically i want if the quantity in column a is changed to zero that the entry onto sheet 1 is removed, and if a quantity in column a is changed from 1 to 2 or whatever, that it changes the entry on sheet 1 to match, rather than adding another row with the new quantity as well as retaining the old row.So basically on sheet 1, if i have columns a, b, c & d, with quantity, description, size, & choice from data validation list (either option 1 or 2).I also want each entry on the invoice to end up on the next row, which could be quite difficult maybe if you go back and change something that was previously 1 or higher, to a zero.But i have absolutely no idea how to code aside from very basic macro stuff.Any help would be much appreciated!Private Sub Worksheet_Change(ByVal Target As Range)'Check if a value is entered in Quantity column (a) and that it is > 0 If Target.Column = 1 Then If Target > 0 Then'Determine next empty row in Invoice sheet nxtInvRow = 1chkInvRow: If Sheets("sheet1").Cells(nxtInvRow, "a") <> "" Then nxtInvRow = nxtInvRow + 1 GoTo chkInvRow End If'Copy data from changed row to Invoice Sheet Sheets("sheet1").Range("a" & nxtInvRow) = Cells(Target.Row, "a") Sheets("sheet1").Range("b" & nxtInvRow) = Cells(Target.Row, "b") Sheets("sheet1").Range("c" & nxtInvRow) = Cells(Target.Row, "c") Sheets("sheet1").R... Read more

Answer:populate invoice-sheet1 with info from sheet2

also if this is the wrong way to go about it please let me know! thankyou

22 more replies
Relevance 40.18%

I have viewed another page in this firum that shows this but it did not work for me.
I simply want to open my Excel Template, fill in the data and save as to My Documents. When I open the Template again and fill in and save I want the invoice number to be the next in the sequence.
I have not done much with VBA or Macros so treat me as a Dummy ;-(((
Peter
 

Answer:Excel 2007 auto invoice numbering

7 more replies
Relevance 40.18%

Teamviewers invoice users after certain number of connections?
This is about Teamviewer -- questions about it charging users?  I've been using Teamviewer on my three home computers and I've never run into a "pay us now" notice or invoice.  Does the "pay us now" kick in if a certain number of connections are made -- per day? per week?  per month?

Answer:Teamviewers invoice users after certain number of connections?

To my knowledge, Teamviewer won't send invoices to free users. However, what they'll do is that if you use the free version and abuse it (like, you use it way, WAY too often), they'll start nagging you about a message saying that they suspect you're using the product for commercial purposes and encourage you to buy it. This will last a certain time after which they'll basically "blacklist" you saying that you're without any doubts using the free version for commercial purposes, and limit your connections to 5 minutes per remote computer. After which you have to wait X time to reconnect to that computer again.

3 more replies
Relevance 40.18%

I am a new user to QB at work. I mark invoices as 'pending' as a first step, so that nothing posts right away. I created a pending invoice to capture reimbursable expenses I plan to bill the customer for. I checked "all" and brought all of the billable expenses into the draft invoice. After reviewing the list of expenses on the pending invoice, I wanted to remove one or two expenses off the pending invoice, to be billed at a later date. How do I reverse it so that it shows up as unbilled, but coded reimbursable, for future use? (In this case, I don't have the supporting receipt for a couple of them, but will by the time I bill the next round of reimbursable expenses). Can someone help me with this seemingly simple task?
 

Answer:Removing reimbursable expense from pending invoice

9 more replies
Relevance 40.18%

Teamviewers invoice users after certain number of connections?
This is about Teamviewer -- questions about it charging users?  I've been using Teamviewer on my three home computers and I've never run into a "pay us now" notice or invoice.  Does the "pay us now" kick in if a certain number of connections are made -- per day? per week?  per month?

Answer:Teamviewers invoice users after certain number of connections?

To my knowledge, Teamviewer won't send invoices to free users. However, what they'll do is that if you use the free version and abuse it (like, you use it way, WAY too often), they'll start nagging you about a message saying that they suspect you're using the product for commercial purposes and encourage you to buy it. This will last a certain time after which they'll basically "blacklist" you saying that you're without any doubts using the free version for commercial purposes, and limit your connections to 5 minutes per remote computer. After which you have to wait X time to reconnect to that computer again.

2 more replies
Relevance 40.18%

I use an MS Office 2000 excel invoice template.Unfortunattely, the date changes after doing an invoice and storing it in a database. This means that when a particular invoice is retrieved fron the database and printed, it shows today's date instead of the date of the day it was prepared.How can I store an invoice using this template and have its date remain unchanging? Solutions, please. Thanks in advance.

Answer:Changing date in Excel invoice template - why?

I would guess that if you look at the formula in the date box is says "now()" correct?This is an auto update to the date the PC is set to.Simply type the date when you start a new invoice istead of using the auto-date option.Select the box, format cell to a date cell of your choice, and type the date in. Then when you open it up, it will keep the original date.Why not just keep a copy though in paper format so you have the original dates anyway, that's what I do?BA

6 more replies
Relevance 40.18%

Need some suggestions on software for printing out customer invoices. I have been handwriting them forever. Do you guys make your own or do you use some sort of software package with premaid templates?
 

Answer:Small business invoice printing software

I just use the template that comes with Word.


Steve
 

6 more replies
Relevance 40.18%

Hi.
I'm the IT mgr of a company that does a lot of shipping & logistics. We hand key a lot of invoices, and shipping documents into our system. We receive PDFs which is supposed to be EDI but thats not EDI. How can I convert these to XML so I can use them
without keying them in?
I used adobe and exported to XML but that just gave me an unusable XML file, I need something structured.
Help would be much appreciated.

Answer:Convert PDF documents (Invoice, Shipping docs etc) to XML?

If the PDFs you are receiving are not scanned then you can use a PDF to XML conversion service. You are right that Adobe wont' do it - its a generic XML with the text only without any true layout structure and thus unuseable for business documents and importing
into business software.
You can try a service like EDI Link Connect website: ecdynamics.com/pdf-conversion.php - that service converts (non scanned) PDFs to XML and other formats so you can import them properly into your software. They will map your document so that its exactly
what you need and not just a generic "dump" of data which doesn't help.
Its a new and interesting way of doing EDI. I've been meaning to do some more research on this myself.
search "PDF conversion" or "PDF to XML" on the web to find out more.
Hope that helps...
JTT.
 

4 more replies
Relevance 40.18%

Hi ,

I want to know that i have my invoice format in excel 2007, i want that whenever i save my file after making a invoice then it should be saved somewhere and a next invoice number should be generated in palce of that , so that i can proceed for the next invoice automatically. please help me in this i badly need it,
i am also attaching the format of my file for ur reference.
 

More replies
Relevance 40.18%

Quick Timeline:

Roughly a year ago - Invoice2go included templates that could be highly customised.

From then to now - VERY-LONG-AND-OFTEN-FRUSTRATING-DECISION-MAKING-PROCESS
Instant Invoicing + Mobile Money = Prompt Payment + Buoyant Business
- pretty logical, unless you're a dedicated, change-reluctant 'technophobe' . . . ;-P

Between then and now - Invoice2go has adopted an approach that's as user friendly as the carbon copybooks it was intended to replace, with similar flexibility to that of a standard grey-lead pencil and about as customisable as a ruler.

Now - can someone please help me before I'm beaten by a text box?


I'm trying to work out how to alter the overall format of the form so that I can at least add the 'vertical-align: middle' element to the text boxes and tables (I've managed to find 'where' the style is set hiding in the source code - I think - but as to 'how' to change it (and make the changes stick) I'm getting nowhere fast . . . :-(
 

More replies
Relevance 40.18%

I am trying to do inventory through Excel. We use Excel to do our customer invoices. We run into a problem with software that is set up to run inventory because we don't sell everything by cases. We sometimes open up cases and sell them individually. I found a way to do it on Excel, but I'm running into an issue. I use the following code to help us keep our customer invoices organized.I want to do another close code to take the items that are ordered on worksheet 1 and subtract it from the inventory on worksheet 2. I can link the cells, but when I x it off for it to save as the customer name, it doesn't keep the updated inventory on worksheet 2. This needs to be saved to the original instead of to the sheet that is created upon close. Does that make sense? E-mail me with a sample if needed.Sub myCloseCode()'Standard module code, like: Module1.Dim strDate$, strCustomer$, strFileNm$, strMsg$, myUpDate$Application.EnableEvents = FalseOn Error GoTo myErr'Test for Save option or Exit without saving?strMsg = "Save this file before closing?"myUpDate = MsgBox(strMsg, vbQuestion + vbYesNo, "Save Now?")'Chose "Yes" button!If myUpDate = 6 Then GoTo mySave'Chose "No" button!If myUpDate = 7 ThenApplication.EnableEvents = TrueExit SubEnd IfmySave:'Build file name!strDate = DatePart("m", Date) & "-" & _DatePart("d", Date) & "-" & _Right(DatePart("yyyy", Date, vbUseSystemDayOfWeek, vbUseSystem), 4)strCustomer = Sheets("Carolina Fireworks Order Form").Range("C7").ValuestrFileNm = "\\... Read more

Answer:Inventory in Excel linked w/ customer invoice

Also, the owners of the business won't pay for an inventory software. I'm lucky to have gotten the customer invoices to work in Excel. I'm trying to figure out an inventory system to help the business. We have to pull the order first and then let the customers know what is out instead of knowing ahead of time.

7 more replies
Relevance 40.18%

I'm experimenting with several (downloaded) invoice templates in Word 2000, in an attempt to find one that does everything I want. I have one that's pretty close, but I'm having difficulty making the last column of the itemized invoice update itself.. (where the formula is for totaling hours worked times hourly labor rate). I have to highlight each individual cell and right click and tell it to "Update". I can't even highlight an entire range of cells and do them all at once. Very time consuming. Seems there should be a global operation to tell the entire invoice to "Update". Anyone have any ideas? For that matter, I'm open to suggestions to other templates that may work for me. I'm doing this for my aircraft maintenance shop, so is very similar to an automotive shop order or repair invoice.
Dave Danger
 

Answer:Solved: Help with Word(2000) Invoice template

I started off using Word templates, but went to using Excel, as Word was just not well suited.

The ease of formula updating in Excel, and the ability to customise the printed form to look just as I need is fine.
 

2 more replies
Relevance 40.18%

Hi All,

I need to match each bill to its invoice (bill sheet and invoice sheet)

each bill should match each invoice by the memo

the memos are not entirely same between each bill and its invoice so what i have been doin is running =LEFT for the memo until the first space.

once i know that each bill matches its invoice... i need the ship date in the invoice to be moved to the ship date in the bill

if anyone understands this and would feel like helping.. i would greatly appricate it!
 

Answer:Matching Bill to Invoice in Excel 2007

16 more replies
Relevance 40.18%

I have been trying to produce an invoice template which will update the invoice number each time it is opened:-
ie.

Open Invoice template numbered 100.
Enter details
save as (unders Customers name)
Close template (without saving)
Reopen template for new invoice with the number updated to 101.

I found the following post which is what I am looking for

http://forums.techguy.org/business-applications/929704-excel-2007-auto-invoice-numbering.html

but am unable to get Keebellah's solution to work mainly due to the fact I have not enough experience in VBA.

His solution is exactly what I require.

Could someone supply VBA code to solve my problem and explain in simple terms how to input it.

Keebellah has made his solution" read only" to stop anyone changing the layout and this seems an excellent idea.

Is it possible to also supply VBA to carry this out which I can use when I have made all my ammendments.

I have attached a copy of my workbook and as you can see I have included an option to update dates through a pop up calendar.

The invoice cell is M12
 

Answer:Solved: invoice template number update

12 more replies
Relevance 40.18%

I am trying to create a business invoice in Excel. (windows 8). I have most of it done.
On all the invoices, there is a standard money amount owing in a subtotal box by all customers.
But I would like a cell where, if the customer owes something more than the standard amount (ie from previous time period that they haven't payed), I can enter a plus sign (and the amount owing) and it is added to my subtotal, giving the customer a new total owing.

OR if the customer has a credit, I can enter a -minus sign and the amount they have a credit for, and it will show the new amount owing. Is there an equation for this?

Or any other way it can be done?

I am new at this, hope I am being clear.
 

Answer:Solved: invoice in excel: what is the value for credit or owing?

7 more replies
Relevance 40.18%

I've designed an invoce in Excel. I'd like to have it automatically increment the invoice number each time I open it.

Right now I open it, increment the number by one, save it, then put the original number back in. It works, but is a pain.
Is there some way (macro, VBA, formula) that would do this for me?

I'm not worried about saving the invoice I'm working on, I print it and close without saving the changes.

TIA

Will
 

Answer:automatic increment invoice number in excel

>> Is there some way (macro, VBA, formula) that would do this for me?

Formula, no ; VBA, yes.

Rightclick the Excel icon left of "File" in the menu bar, select "View Code".

Paste this into the workbook module:

Private Sub Workbook_Open()
Range("A1") = Range("A1") + 1
ActiveWorkbook.Save
End Sub

, then change "A1" (both refs) to the cell where you want the number.

Close the VBE, save & close the file.

Open & close it a few times to test (don't forget to clear the range then save the last time you test).

Rgds,
Andy
 

3 more replies
Relevance 40.18%

Hi ,

Would anyone know how to generate invoice numbers in Microsoft Word automatically. By this I mean, the first invoice I have is 00001, then when I write another invoice, the number 00002 will generate automatically. The operating system is windows xp and the version of word that this can be done in is 2000, 2003 or 2007

thanks
 

More replies
Relevance 39.77%

I have put some serious hours into to trying to make this invoice template work with Windows 7. It came originally with Office 97 and Office 2000 and was designed by Village Software for Excel usage. What is nice about it is that it has a visual basic database attached to it to track fields of data on the invoice. I have tried everything to make this darn thing work and I really need it for my business. The file names that I copied over to Windows 7 are:

INVDB.XLS
TMPLTNUM.XLS
WZTEMPLT.XLS

I pasted these files into location C:/Program Files (x86)/Microsoft Office/Office12/Library as many on the net have suggested in XP (except it would be Office11). I have successfully performed this feat in XP but not Windows 7. Keep in mind that I did change the file location of INVDB.XLS in the template but everytime I try to save the file it says "cannot locate INVDB.XLS". I also do not get the number toolbar to sequentially increase the invoice number.

Has anyone successfully made this awesome template work on their Windows 7?

Answer:How can I make my Excel 2000 invoice template work?

Wow...have I stumped the gurus out there? Amazing. If you need the template to play with or analyze go to

http://www.taclatch.com/taclatch.xlt

9 more replies