Create a Copy and Rename a Stored Procedure so I can update a field

mtolliver

I am trying to find documentation on how to create a copy of a Stored Procedure that I can rename and then change the name of some of the fields it updates within.

Ultimately I am trying to make my own custom Customs Invoice Report that runs from the Shipment Master, however the code for updating the Checkbox that the Customs Invoice was printed is embedded in the stored procedure. I am using the Shipment ProForma stored procedure for my customs invoice report so I need to update the Proforma_printed_flag to the Customs_printed_flag which sounds so simple, however I can't figure out how to just create a copy that is not extended or changes the original Shipment Proforma since we still want that to function as well.

Any help would be greatly appreciated!

kazuyuki-mochizuki

Havent tried this but here's what I think. In the new report create a new custom load that points to the new IDO Method that calls a custom assembly, inside that custom assembly invokes the original IDO method. you can extend and replace and create a NEW method for the new report or you can create your own ido and ido method that invokes the original IDO method. The idea is getting the result of the old inside custom assembly and manipulate after passing it to the new report.

Or maybe you can copy the old report form to a new report and inside the formscript you can loop and change values and do create read update or delete while looping inside formscript.