You can override values in the information sent using the Overrides area under the supplier menu.
This should only be done by a qualified system administrator.
You can override values on the following documents
- Document (Prevalidate)
- Document (Validate)
- Document (Validated)
- Invoice
- Order
- OrderAck
- OrderChanges
- Shipment
- ItemRegistryType
- ItemList
You can pick which retailers this override applies to (blank for all)
You can pick which freight company this override applies to (blank for all)
You can use either XPath or Lamda expressions
Notes around Paramatized Value
- You can use '{}' values for supplier, invoice, and document objects when available
- (blank) can be used to indicate a blank string
- You can apply rules such as
- STRIPSPACE
- REMOVESPECIALCHRACTERS
- MAXLENGTH
- REPLACE
- R: (Right)
- L: (Left)
- F: format
- D: Date format
- When using XPATH you can also use
- relative:
- = (formula) -> ensure you spaces between the mathematical symbols Wrong A+B. Correct = A + B
XPath
Use the XML XPath to locate a specific node or node list
Example #1 : Set the shipment identification to the first 6 didgiets of the GS1 number, followed by 2 zeros, then the last 8 characters of the invoice number
Object : Shipment
XPath :
Property Name : ShipmentIdentification
Paramatized Value : {SUPPLIER.CompanyGS1Number:L:6:0}00{INVOICE.InvoiceNumber:R:8:0}
Example #2 : Set the quantity left to receive to the ordered quantity - the shipped quantity
Object : Shipment
XPath : /rsx:Shipments/rsx:Shipment/rsx:OrderLevel/rsx:ItemLevel/rsx:ShipmentLine
Property Name : rsx:QtyLeftToReceive
Paramatized Value : =rsx:OrderQty - rsx:ShipQty
Lamda
You will need to supply an Lamda expresession that selects the values to be updated, the property to be updated, and the value to update. You will need to refer to the document structure and definition to work out Lamda's and allowed values.
Example #1 : Set the shipment date type 17 to be today's date
Object : Shipment
Lamda Expression : Shipment.Header.Date.Where(DateTimeQualifier1 =="Item017")
Property Name : Date1
Paramatized Value : {DATETIME}
Example #2 : Set the ItemScheduleQualifier to 068.
Object : OrderAck
Lamda Expression : OrderAck.LineItems.SelectMany(LineItemAcknowledgement)
Property Name : ItemScheduleQualifier
Paramatized Value : Item068