In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Replace statement
We currently have a setting in the import for Replace Staff Notes which is shown below for the “Amazon Order ID” to go into the Customer Reference on the SO.
This work however it also includes the “Amazon Earliest Ship Date” as well. How do I just get the “113-9876544-12345677” and nothing else? Here is the statement: =iif([OrderData.PaymentMethod]='amazon',Replace( [OrderData.StaffNotes], 'Amazon Order Id ',''),'')
Amazon Order Id 113-9876544-12345677
Amazon Earliest Ship Date 2021-11-22T0800.000Z
Amazon Earliest Delivery Date 2021-11-24T0800.000Z
Amazon Latest Ship Date 2021-11-24T0759.000Z
Amazon Latest Delivery Date 2021-11-27T0759.000Z
Amazon Fulfilment Method FBM