Hi! here is my problem. i have four files: products, order, customers and line items. this is a simple invoicing system. However, i need to post automatically to all clients an order for existing products. I need a script that would take from inventory of one item (jars, for example) where i have 1000 and divided among some 100 stores/warehouses. it is the same as a regular invoicing only i make the decision of what product each store gets. Once i go through the list of items in inventory i wish to print the client's order (or invoice). i hope i'm clear.

thanks

Can you explain your wish on example?

in warehouse i have let's say 1000 jars of jams. i wish to have a script which will automatically divide this quantity into the number of clients/subwarehouse (with certain criteria) and produce a purchase order for each client/subwarehouse. store1 gets 20 jars, store2 gets 20 jars...

each month i get a list of items which i have to distribute to all locations (store1, 2,3.... the script should automate the process.

As i anderstand you want automaticaly create invoices to your all clients for one product?

yes... exactly

You have Rest_of_product and Count_of_Customers.Use algorithm:

For each customer by relation to invoice create record where quantity=Rest_of_poduct/Count_of_Customers. If you have lineitem file will be little difficult. In that case you must by relation from invoice to lineitem create item in lineitem file.