Microsoft Dynamics 365 Business Central

Sales Order Data

This article contains the description of the Sana specific sales data which is filled in by a customer in the Sana webshop during the checkout process.

While placing an order in the Sana webshop a customer can select delivery method, payment method, enter reference number, delivery date, comment and apply a discount code. All this information is stored in the sales order in Microsoft Dynamics 365 Business Central.

To check the Sana specific sales data in Dynamics 365 Business Central choose the Search for Page or Report icon and enter Sales Orders. Open the sales order details and click Navigate > Order > Sana Commerce.

The table below provides the description of the Sana Commerce sales document fields.

Field	Description
General
Webshop ID	The ID of the webshop where an order was created.
Date Received	Date when an order was placed.
Time Received	Time when an order was placed.
Sana Order No.	The ID of the order which was placed in the Sana webshop when connection between the webshop and the ERP system was lost. In this case when connection is back and the order is sent to Dynamics 365 Business Central, it will be checked by this ID not to create the order duplicate.
Sana Customer No.	The ID of the customer who placed an order in the webshop.
Shop Account E-Mail	Customer's shop account e-mail from Sana Admin.
Admin User Email	Applies to: Sana 9.3.4 The e-mail address of a web store administrator. If a customer faces some difficulties in the checkout process, a customer service representative can impersonate the customer and place the order for him or her. If a customer service representative impersonates a customer and places an order in the Sana web store, then the e-mail address of the web store administrator will be recorded into the sales order. Using this field, a sales manager in Dynamics 365 Business Central can easily differentiate sales orders placed by the customer and customer service representative. For more information, see "Shop Accounts".
Shipment Method Name	The name of the shipment method selected in the Sana webshop while placing an order. The shipping cost is stored in the sales order lines and is registered on the shipping cost account set in the Webshops table.
Authorization Status	The status of the order after authorization. The order can be approved or declined. For more information, see "Shop Account Roles".
Payment
Payment Method Name	The name of the payment method selected in the Sana webshop while placing an order. The payment cost is stored in the sales order lines and is registered on the payment cost account set in the Webshops table.
Payment Method Status	The status of the payment method.
Payment Transaction id	The unique payment transaction ID.
Promotion/Coupon
If a customer applied a discount code (from Sana Admin) or a coupon (LS Retail) to the sales order, information about discount will be available on the Promotion/Coupon FastTab. There you will see the name of the discount code/coupon, discount type and amount, etc.
Quote Promotable	This option is applicable only to sales quotes. The Quote Promotable checkbox indicates whether a customer can convert a quote into an order from the order detail page in the Sana webshop. If this checkbox is selected a customer can convert a quote into an order directly in the Sana webshop. For more information, see "Order Processing".
Pickup Location
Pickup Location ID	Some delivery services support pickup locations, for example Consignor. If a customer places an order in the Sana web store and selects a shipping carrier which supports pickup locations, he or she can select a pickup location instead of the shipping address. In this case, the ID and address of the selected pickup location will be stored in these fields.
Pickup Location Address

Reference number, comments and requested delivery date

 NOTE

Comments, delivery date and reference number are available only to business customers up to Sana 9.3.1, starting from Sana 9.3.2 to all customers.

When a customer or a sales agent places an order in the Sana webshop, he or she can enter the reference number, comments and the requested delivery date on the Order Overview step. This information is stored in the sales order in Dynamics 365 Business Central.

The requested delivery date and the reference number are stored in the sales order details, on the General FastTab.

In Dynamics 365 Business Central the Requested Delivery Date field is optional. Thus, if a customer does not enter the requested delivery date while placing an order in the webshop, the Requested Delivery Date field will be blank in Dynamics 365 Business Central and in the order confirmation e-mail.

To see the comment added by the customer to the order, at the top of the sales order click: Return Order > Comments.