P
Patrick Gough
The existing integration with Camelot/Excalibur does not include a number of fields (which are included on the standard Camelot API) in the available Reference Mappings for receipts and shipments. Ideally, these could be added in order to enhance the Camelot/Excalibur integration.
Specifically:
  • The Notes on a Sales Order are mapped to the Comments field on the Camelot API. However, there is no such mapping for Purchase orders - ideally this could be included as a Purchase Order Reference option.
  • The CodeDate and GroupID fields on the Camelot API is not mapped as a Purchase Order Line Reference or Sales Order Line Reference. Both of these are useful, especially the CodeDate field which allows for lot expiry dates (etc.) to be communicated.
  • The Purchase Order mapping does not communicate any date values to Camelot apart from the receipt's creation date - in scenarios where the Purchase Order data is sent to Camelot's API as an Advance Shipping Notice it would be ideal to have the date field's in Camelot's API available as Purchase Order Reference options (especially the ExpArrivalDate field).