Copy a PO in RMS SO

Can somebody (Ahmed Nashat?) please provide me whit a script to copy a P.O. in RMS SO 2.0.0115 ? Basically I need to copy almost everything from an existing PO (especially the PO line item entries) exactly into a new PO (except for obviously the status and the PO Number which could be the copied PO Number plus NEW appended to it or something like that).

Any help would be appreciated

P.S. I know that there are add-ons available for this but I only need to this once every three months or so at the most

Reply to
Alex
Loading thread data ...

HYG Alex, i hope it does what u need

Reply to
Ahmed Nashat

Ahmed, thanks a lot for the quick reply and your script, it does exactly what I want it to do!

P.S. The field size for the PO number in the DB table is 20 but RMS SO Manager only lets me type in a max of 14 characters, does anybody know why?

Reply to
Alex

If it allowed you to enter more than 14 you would encounter a problem with HQ and interstore Transfer. Theineterstore adds store 00001- etc.. to the exiting PO and if it allowed you to type more than 14 then the store from which the transfer is coming would be truncated. This was the way MS fixed a bug reported in 1.1 or 1.2 (it is a while back)

Reply to
Afshin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.