Load Accounting Trade via Excel - Process Details

Once the SUBMIT button is clicked, the following sequence is initiated: a XML document is assembled from the non-empty fields of the Accounting Trade object form, it is then sent as a SOAP message with specified credentials to the specified server for synchronous load.

The TSR is then retrieved and displayed on the TSR sheet of the workbook formatted as a table:

  • The number of rows on this sheet depends on xml depth.
  • Each node corresponds to its own column.
  • The header of each column contains a name of the node it corresponds to.
  • Rows below the header contain values of the corresponding nodes.