Microsoft Dynamics GP

Sales Order Data

This article contains the description of the Sana specific sales order 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, add reference number and comment, select requested delivery date. All this information is stored in the sales order in Microsoft Dynamics GP.

To check the Sana specific sales order data in Microsoft Dynamics GP, open the necessary sales order and at the top of the Sales Transaction Entry window click: Additional > Sana Commerce.

The table below provides the description of the Sana specific fields.

Field	Description
General
Web Shop	The webshop ID where an order was created.
Sana Order ID	The ID of the order which was created from the Sana webshop when connection between the webshop and Microsoft Dynamics GP was lost. In this case, when connection is back and the order is sent to GP, it will be checked by this ID not to create the order duplicate.
Document No.	The number of the sales document.
SOP Type	The type of the sales document.
Reference No.	The reference number which a customer can enter on the Order Overview step while placing an order in the webshop.
Shop Account Email	Customer's shop account e-mail from Sana Admin.
Order Authorization status	The status of the order after authorization. The order can be approved or declined. For more information, see "Shop Account Roles".
Shipment Method Name	The name of the delivery method selected by a customer in the Sana webshop while placing an order.
Quote Promotable	This option is applicable only to the sales quotes. The Quote Promotable checkbox indicates whether a customer can convert a quote into an order from the quote details 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".
Payments
Payment Method	The name of the payment method selected by a customer in the Sana webshop while placing an order.
Payment Status	The status of the order payment.
Payment Transaction ID	The unique payment transaction ID. For more information, see "Payment Transactions".
Promotion
If a customer applied a discount code (from Sana Admin) to the sales order, information about discount will be available in the Promotion section. There you will see the title of the discount code, discount type and amount/percentage, etc.
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

Comments and requested delivery date

 NOTE

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

When placing an order in the webshop, it is possible to enter a reference number, comment and requested delivery date on the Order overview step.

This information is also saved with the sales order to Microsoft Dynamics GP.

The Comments field is limited with 2048 characters.

To view sales order comments in Microsoft Dynamics GP, open the necessary order and in the Comment ID field click on the expansion button.

To view the Requested delivery date, click on the expansion button in the Date field. The requested delivery date is stored in the Requested Ship Date field. If a customer does not enter the requested delivery date while placing an order in the webshop, the current date of the order will be used.