How to create a 9000 items invoice?

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.

it might be c government job . . .

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.

how about a normal QB invoice, with the statement "see attached documentation"?

Golden California Girls wrote in news:2UHtj.181$kI4.154@trnddc05:

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!

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.

Golden California Girls wrote in news:5uStj.36060$we5.14412@trnddc02:

I just try to see if there is a easier way to key in those items other than doing it one by one.

I might want as suggested to break the invoice into smaller invoices of say

Anyway, more suggestions are welcomed and thank you very much for your suggestion "California Girls"! :)

Lawrence

"Gil Faver"