So this script finally showed its flaw, on the SO Invoice it would only display the first SO entered on the invoice instead of "multiple orders" in the "sales order number" field. It pulls all the information from the applied sales orders, however, after you invoice the subsequent SO's they stay in Sage as an open order, looking like they never were invoiced. I am going to have to find another way around to give the user the ability to change the sales tax schedule. Looking at the file layouts the 42.tax schedule field under SO_Invoice header has this as a note
" MultipleSO Notes: {SO5$(394, 9)}", could anyone tell me the meaning of this? Thinking I will have to figure out how to make this field editable, because ROI solution was not easy and unrealistic.
