StevenSBC Bronze Medal

@splemp I haven't solved my problem as yet but I have the SQL working to highlight the data I need to change. I've just managed to update my first transaction using your awesome data patcher! Next job to merge the two together. Your tool is going to be amazingly useful I suspect going forward.

@splemp I've only had a little time today to look into this. I have the data patcher up and running and will take a deeper look tomorrow.

hi, thanks for posting. I am a SQL developer as my main job and have a query that works in that regard. I will take a look at the data patcher tomorrow as its 9pm here. It certainly looks like it could be really useful for a number of tasks!

The createdpo field in the above example is populated with linked/dropship po. On the sales order in question, the drop ship PO has been generated. However, when you switch on the SO edit mode the createdpo field shows "Drop Shipment" despite already having been drop shipped. My function is returning null which is getting…

Hi, I thought that field would yield the data I wanted. However, it seems to be returning 0. Maybe that is due to the entry point I'm using of field changed? This is my first attempt at a script myself, I was using some pre existing scripts to base it on. I'll move it over to SuiteScript 2.x next :-) function GetPONumber…

I have made some decent progress on this and I can update the related purchase order lines and it works perfectly when I KNOW what the tran ID of the PO is ie I've hard coded it. I can't seem to get this information however from the sales order object. Am I missing something? Any bright ideas? function GetProductionRef (){…

Hi, so I've managed to source the field. It is contained in the table TransactionStatus which I couldn't see until granting permission to Setup Company on the Setup tab of the role! Maybe this will help someone else. The join is straightforward once you have the table.