Sales Document Fields

You can use sales document fields from your ERP system to:

  • Add and remove fields that are shown in the header of sales documents in the Sana webstore.
  • Add and remove fields that are shown as columns on the sales document list (overview) pages in the Sana webstore.
  • Use different fields to filter sales documents in the Sana webstore.

Adding extra fields to the sales documents is a great way to show additional information to your customers from your ERP systems. You are free to show and hide the necessary data from your ERP system for any sales document type: you can add and remove any field, change the order of fields, show or hide them for different sales document and customer types.

NOTE

Please consider that excessive fields and data on a page can compromise its design quality. Additionally, it may impact performance, as the retrieval of extensive data from the ERP system can slow down operations. Thus, it's advisable to avoid overloading your sales history with unnecessary information.

You can configure the sales document fields for each sales document separately. In Sana Admin click: Setup > Sales documents.

The list of fields is specific to each sales document. You can add, remove, show, and hide the fields for different sales documents and customer types.

You can change the order in which the fields should appear in the sales document header or in the sales document list in the webstore by dragging and dropping them.

The sales document fields are retrieved from the relevant sales document table in your ERP system. In the Field name dropdown list, you can see all available sales document fields that you can use. These fields are retrieved from your ERP system when you run the General information import task in Sana Admin.

Sales Document Column Fields

NOTE

Sana ERP Connector compatibility:
  • Microsoft Dynamics 365 Business Central - [Sana ERP connector version 10.0.90 and higher]
  • Microsoft Dynamics 365 for Finance and Operations - [Sana ERP connector version 10.0.90 and higher]
  • Microsoft Dynamics AX - [Sana ERP connector version 10.0.90 and higher]
  • Microsoft Dynamics NAV - [Sana ERP connector version 10.0.90 and higher]
  • SAP Business One - [Sana ERP connector version 1.0.96 and higher]
  • SAP S/4HANA - [Sana ERP connector version 133 and higher]

You can manage the sales document column fields in the Column fields section of the necessary sales document.

The sales document column fields are shown on the sales document history page in the Sana webstore.

Sales Document Filters

Customers can filter sales documents in the Sana webstore using the filters at the top of the page. Filtering is available for all sales documents.

You can configure these filters by selecting them from the list of sales document column fields. Use the Filterable checkbox to select those sales document column fields that should also be used for filters. Some fields cannot be used for filtering, that is why for these fields the Filterable checkbox is not available.

Limitations

  • SAP Business One: Currently, it is not possible to filter sales documents by the Status and Shipping status fields.

  • SAP S/4HANA: Currently, customers can only filter sales documents using the following fields: Document no., Document date, Shipping status, Status, Shop account email, Order date, Due date, and Reference number.

Sales Document Header Fields

NOTE

Sana ERP Connector compatibility:
  • Microsoft Dynamics 365 Business Central - [Sana ERP connector version 10.0.63 and higher]
  • Microsoft Dynamics 365 for Finance and Operations - [Sana ERP connector version 10.0.63 and higher]
  • Microsoft Dynamics AX - [Sana ERP connector version 10.0.63 and higher]
  • Microsoft Dynamics NAV - [Sana ERP connector version 10.0.63 and higher]
  • Microsoft Dynamics GP - [Sana ERP connector version 10.0.70 and higher]
    To use this feature in a Sana webstore connected to Microsoft Dynamics GP, additional configuration is required in ERP. For more information, see Editable Checkout Fields.
  • SAP Business One - [Sana ERP connector version 1.0.70 and higher]
  • SAP ECC – [Sana ERP connector version 96_5 and higher]
  • SAP S/4HANA – [Sana ERP connector version 126 and higher]

You can manage the sales document header fields in the Header fields section of the necessary sales document.

The sales document header fields are shown at the top of the sales document details page in the Sana webstore.

You can also show these fields in the order confirmation e-mails. To show both default and additional sales document fields in the order confirmation e-mail, you need to add two replacement tags to the e-mail template: ORDER_FIELDS_LEFT and ORDER_FIELDS_RIGHT. The ORDER_FIELDS_LEFT replacement tag corresponds to the fields shown in the left column in the sales document details. The ORDER_FIELDS_RIGHT replacement tag corresponds to the fields shown in the right column in the sales document details. You can also add these replacement tags to other e-mail templates, for example, quote confirmation, edit order confirmation, return order confirmation, etc.