Home Page link  

How to create a 9000 items invoice?

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
How to create a 9000 items invoice? Lawrence 02-16-2008
Posted by Lawrence on February 16, 2008, 1:23 pm
Please log in for more thread options
 I know I can individually key in 9000 items and the quantity, but is it a
easier way to do it?

Like import from an Excel file or even an add-on module to extract
information from the inventory list.

Thanks in advance...

Lawrence

Posted by Golden California Girls on February 16, 2008, 3:41 pm
Please log in for more thread options
 Lawrence wrote:
> I know I can individually key in 9000 items and the quantity, but is it a
> easier way to do it?
>
> Like import from an Excel file or even an add-on module to extract
> information from the inventory list.
>
> Thanks in advance...
>
> Lawrence

Might tell us what you are really doing

I will tell you no sane person would ever ask QB to have 9000 items on a single
invoice.


Posted by Allan Martin on February 16, 2008, 4:10 pm
Please log in for more thread options

> Lawrence wrote:
>> I know I can individually key in 9000 items and the quantity, but is it a
>> easier way to do it? Like import from an Excel file or even an add-on
>> module to extract information from the inventory list.
>>
>> Thanks in advance...
>>
>> Lawrence
>
> Might tell us what you are really doing
>
> I will tell you no sane person would ever ask QB to have 9000 items on a
> single invoice.

I'm assuming this is a bulk sale of some sorts or mass transfer of goods to
another related company. Needless to say I do not have the faintest idea if
the program can handle it. My gut says no, but then I never tried it.




>


Posted by Lawrence on February 16, 2008, 6:27 pm
Please log in for more thread options

> Lawrence wrote:
>> I know I can individually key in 9000 items and the quantity, but is
>> it a easier way to do it?
>>
>> Like import from an Excel file or even an add-on module to extract
>> information from the inventory list.
>>
>> Thanks in advance...
>>
>> Lawrence
>
> Might tell us what you are really doing
>
> I will tell you no sane person would ever ask QB to have 9000 items on
> a single invoice.
>

I have a wholesale/distribution center that handle about 9500 of dollar
store items.

Recently, a new dollar store in my area just established and would like to
order about 9000 different items from my list.

I know I can just put "see attached items list" and put the total amount in
my invoice, but then I will not be able to update my "quantity on hand"
information.

It is going to be a one time deal, because later, that store will only
order as my other customers, probably 100 items at a time.

Thanks!

Posted by Golden California Girls on February 17, 2008, 3:44 am
Please log in for more thread options
Lawrence wrote:
>
>> Lawrence wrote:
>>> I know I can individually key in 9000 items and the quantity, but is
>>> it a easier way to do it?
>>>
>>> Like import from an Excel file or even an add-on module to extract
>>> information from the inventory list.
>>>
>>> Thanks in advance...
>>>
>>> Lawrence
>> Might tell us what you are really doing
>>
>> I will tell you no sane person would ever ask QB to have 9000 items on
>> a single invoice.
>>
>
> I have a wholesale/distribution center that handle about 9500 of dollar
> store items.
>
> Recently, a new dollar store in my area just established and would like to
> order about 9000 different items from my list.
>
> I know I can just put "see attached items list" and put the total amount in
> my invoice, but then I will not be able to update my "quantity on hand"
> information.
>
> It is going to be a one time deal, because later, that store will only
> order as my other customers, probably 100 items at a time.

So it is a real invoice transaction rather than some bulk thing that might have
been easier with journal entries and an inventory adjustment.

From my personal experience I would break it up into a bunch of smaller
invoices. I'd do that because opening, closing and saving a 9000 item invoice
could take a long long time. It has been a while, last time I was doing some
big ones, around 20 pages I was using 2003, but it took almost an hour to save
the invoice. And while it was saving everyone else looked at "company file
busy!"

As to your question, I really don't know of any software that is made to say
scan the PO and turn it into an invoice. I'm sure it could be done. There may
well be stuff out there to read an excel file or filemaker file and make an
invoice or you might be able to whip something up with QODBC.

However you might just want to hire a temp data entry person. Might be less
expensive than a one shot software solution.

Similar ThreadsPosted
About invoice line items April 12, 2007, 1:29 pm
"Hiding" items in an invoice January 20, 2008, 11:52 am
Sell items without appearing on invoice November 24, 2006, 7:51 pm
Sell items without appearing on invoice December 6, 2006, 8:48 pm
cannot create statements July 20, 2006, 2:15 pm
Invoiced by Month - How can I create this report? May 25, 2007, 10:27 am
Company Create Time - Import Timer Activities March 31, 2008, 12:04 pm
Paying invoice without invoice number? July 24, 2006, 11:41 pm
Items Vs Expenses Tab August 19, 2006, 2:08 am
Tax only a percentage of certain items? October 30, 2007, 5:27 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap