5000Invoices generated from Blanket Order. How to do a batch

Kosmos

hey everyone again,
We have to generate 5000 invocies for one item. I realize that all 5000 customers can be copied from Blanket Order one by one.
I tried to copy a range of customers from Blanket Order to Invoice but failed.
Could you tell me please if there are any opportunities to create an invoice for 5000 customers for a certain item at once?
Thank you very much
Anna

DenSter

I would probably think of some sort of template invoice, where you'd create an invoice with the Items that you want that you would want to copy to other customers. Then use standard 'copy document' functionality to automate this.

The trick is to determine which customers to select. How do you know that customer A needs to get an invoice, but not customer B?

Savatage

I would probably copy the customer list (hopefully filtered) to the the customers in question. Copy & paste the numbers into into excel.

Add in column A "Order"
Add In column B an Order #
Colum C will be the cust no.

b2=b1+1

Basically to create an CVS file & use a dataport.

Then for the sales line
Column a "Order"
Column B " Order No
Column c Type:Item
Column d (Line No) 10000
Column e (Item No) abc1234 (your Number)
column d (qty) 1

and make a dataport for that.

Now if this is a one time thing mabye something quick like this is the way to go. If it will happen more often I was thinking of a report using
Customer
-Sales header
--Sales Line that would INSERT records using OnfafterGetRecord.
:-k

Kosmos

Thank you everyone,
Savatage, I beleive the last solution is the best one fo us (report use)
Good luck
Anna

Kosmos

Hey, me again
Does anyone know any add-in granule which can perorm this function.
We wanna do without customization.
Thank you in advance.
Anna