SuiteForce Red Ribbon

@Richard James Uri-Oracle that for sure helps with getting the related record, but how do you then reference those search fields to put the value in the newly created record? is it fieldLookUp.fieldid where fieldid is what you pulled into the columns and fieldLookUp is the variable for search?

@Richard James Uri-Oracle this worked! thank you! my next requirement would be to have the values pulled in from other fields that are related to the sales order. we currently use the contracts renewals module and need to pass the address through that process. is it possible to reference a lookup record and pull values…

@Richard James Uri-Oracle i attempted to update the file you sent over but received a syntax error. i went ahead and updated my script to have an individual set value for each field update and the address did not update.

@Richard James Uri-Oracle can this also be applied to billing address? also it seems like that article is setting the address at the item level. I am just needing to update the billing and shipping address at the main line.

@Richard James Uri-Oracle thanks for your response! when looking at the linked suiteanswers article i did see this in the part where it states you cannot choose between new or custom and is treated as custom, that is exactly what i am wanting to do, however any script i build to target those fields does not error and does…

Thanks @"Jack Daryl Espiel-Oracle"! @"Erick Dela Rosa-Oracle" @"Mikko De La Fuente-Oracle" My situation is we have discount items on sales orders that give a negative alt. sales amount, however we are still paying commissions to sales reps for those negative amounts. On current work around is to manually add an adjustment…