[SL] Looking for SQL scripts to set ROP based on Sales

[Ronald K. <rj...@ya...>]

I've been live on Sql for 14 months now.  Current version 2.6.14.  I've lim=
ped through some cumbersome tasks hoping the system will become more effici=
ent.  I am not a programmer; I've paid a programmer to customize my system.=
 He has contributed my patches back to the community.  He has other project=
s and is not interested in my future customization needs......=0A=0ACan any=
one on this board help with simple management tasks?   =0A=0AI've emailed D=
ieter in the past;  he either does not answer or says he doesn't have time.=
=0A=0AMy current needs are:=0A=0ASet ROP=0AMy current need is to establish =
ROP's for my 130,000 skus in inventory.  40,000 skus on hand.  My thought i=
s a script that will clear ROP.  Run a report on my 14 months of sales hist=
ory for items.  Set ROP equal to an item's monthly sales.  Seasonally adjus=
t ROP based on previous year would be great too.=0A=0AGenerate Weekly Purch=
ase Order=0AI currently have a script that runs Sunday nights that generate=
s an SO based on M-Sun sales.  It takes all sales that run through AR to ge=
nerate this PO.  I would like this program edited to generate an SO based o=
n WIPROP.  WIPROP =3D ROP - SO + PO. =0A=0AYou can email me directly=0A=0AT=
hank you=0A=0A...@ml...=0A=0A=0A =0A_________________________________=
___________________________________________________=0AExpecting? Get great =
news right away with email Auto-Check. =0ATry the Yahoo! Mail Beta.=0Ahttp:=
//advision.webevents.yahoo.com/mailbeta/newmail_tools.html