Table of Contents

Web Order Field Reference

General section

Web Order No.

The system-wide unique number of the Web Order automatically assigned by E-Commerce B2B.


Version

Indicates the currently viewed version of the Web Order:

Field Value Description
Original The original version as placed by the customer within the Storefront.
Modified by Sales Doc. This version has been updated or refreshed from a Sales Quote or Sales Order after the changes were made in Dynamics NAV to the order originally placed by the customer.

Related topics:


Type

Indicates the type of the customer who has placed the Web Order:

Field Value Description
B2B Customer When placing the order, the customer had signed in, and the customer has its particular Customer record set up in Dynamics NAV.
B2C - Registered When placing the order, the customer had signed in using their account, and the account is linked to the generic B2C Customer card in Dynamics NAV. The customer has their respective Web Account record in Dynamics NAV.
Only available when you have B2C mode enabled for the Storefront.
B2C - Not Registered When placing the order, the customer had not signed in, and the account used for pricing was the generic B2C Customer card in Dynamics NAV. The customer does not have their respective Web Account record in Dynamics NAV, and the customer/shipping details are only available directly on the Web Order.
Only available when you have B2C mode enabled for the Storefront.

Related topics:


Sell-to Customer No.

The Dynamics NAV Customer record No. that will be used as the Sell-to Customer No. upon converting this Web Order to a Sales Order or a Sales Quote.

The Sell-to Customer No. originates from the Sell-to Customer No. field on the Web Account record used for the customer that has placed the order.


Sell-to Customer Name

Customer name according to the Sell-to Customer No.


Sell-to Contact No.

The Dynamics NAV Contact record No. that will be used as the Sell-to Contact No. upon converting this Web Order to a Sales Order or a Sales Quote.

The Sell-to Contact No. originates from the Web Account record used for the customer that has placed the order. If the Web Account is linked to a Contact record in NAV, Sell-to Contact No. will contain the respective Linked-to No. from the Web Account record.


Sell-to Contact

Contact name according to the Sell-to Contact No.


Sell-to E-Mail

E-mail address of the customer that has placed the order.

The Sell-to E-Mail originates from the Web Account record used for the customer that has placed the order, or in B2C scenarios, contains the e-mail address as specified by the customer during checkout.

Sell-to E-Mail is used for e-mails composed by Dynamics NAV upon processing, e.g. requesting customer's approval for changes, e-mail link to order.

Sell-to E-Mail is not used for Sales Order or Sales Quote conversion and is merely informative.

This field is a duplicate for the Web Account E-Mail field in the B2C - Customer Details section.


Sell-to Phone No.

Phone No. of the customer that has placed the order.

The Sell-to Phone No. originates from the Web Account record used for the customer that has placed the order, or in B2C scenarios, contains the phone No. as specified by the customer during checkout.

Sell-to Phone No. is not used for Sales Order or Sales Quote conversion and is merely informative.

This field is a duplicates for the Web Account Phone No. field in the B2C - Customer Details section.


Customer Comment

Includes the initial comment that the customer has added during the checkout upon placing the order.

The comment, if there was one provided, is also found in the Event Log section of the Web Order page.


Order Date

Displays the system date of the day the Web Order was placed by the Customer within the Storefront.

Note: Upon creating Sales Quotes and Sales Orders, E-Commerce B2B will not automatically populate the Posting Date field. The Posting Date field is populated according to Default Posting Date field in Dynamics NAV Sales & Receivables Setup, whereas Posting Date may be left blank or populated with the current date (WORKDATE) when the Quote/Order is created by default.


Sales Document Type

When a Sales Quote or Sales Order has been created from the Web Order, indiciates the respective Dynamics NAV document type (Quote or Order).

Used in conjunction with Sales Document No..

This field is used for document linking within E-Commerce B2B, e.g. to maintain the link between Sales Order being processed and the original Web Order, so that the system can track the Web Order Workflow Status and update the Web Order upon changes in the Sales Order.

This field is blank upon initially receiving a Web Order in Dynamics NAV, unless it is automatically converted into a Quote or Order as per E-Commerce B2B Order Taking Setup.

Note: E-Commerce B2B will track the Quote to Order conversion using the standard Make Order function. The Web Order being linked to a Sales Quote will be automatically linked to a Sales Order once the linked Sales Quote is converted into a Sales Order.


Sales Document No.

When a Sales Quote or Sales Order has been created from the Web Order, indiciates the respective Sales Quote or Sales Order No. that has been created from the Web Order.

Used in conjunction with Sales Document Type.

This field is used for document linking within E-Commerce B2B, e.g. to maintain the link between Sales Order being processed and the original Web Order, so that the system can track the Web Order Workflow Status and update the Web Order upon changes in the Sales Order.

This field is blank upon initially receiving a Web Order in Dynamics NAV, unless it is automatically converted into a Quote or Order as per E-Commerce B2B Order Taking Setup.

Note: E-Commerce B2B will track the Quote to Order conversion using the standard Make Order function. The Web Order being linked to a Sales Quote will be automatically linked to a Sales Order once the linked Sales Quote is converted into a Sales Order.


Customer Approval

Indicates the current state of the customer's approval, if requested for either accepting a quote or approving changes to an order.

Field Value Description
blank There is no customer approval process initiated for this Web Order.
Pending You have requested the customer approval, and the customer has not yet approved the request.
Approved You have requested the customer approval, and the customer has approved the request.
Rejected You have requested the customer approval, and the customer has rejected the request.

Note: The customer can only change this field from Pending to Approved using the Storefront, as there is no option to simply Reject approval requests. The rationale behind this implementation is that allowing customers to simply “Reject” is counter-productive, i.e. your only option upon receiving a simple “Rejected” message is contacting the customer and “rescuing the deal”. Instead, customers are asked to either Approve or post additional comments to the Quote/Order while remaining on the “Approval Pending” state, which leads to more productive communication and resolution of issues.

Related topics:


Workflow Status

Indicates the current workflow or processing status of the order, as shown to the customer in the Storefront.

The Workflow Status is a simplified representation of the current order processing stage intended to give the customer a quick understanding of “how far it is”, and it is abstracted from the customer-irrelevant details of Dynamics NAV documents, functions, posting etc.

E-Commerce B2B tracks the actions performed on Sales Quotes and Sales Orders generated from a Web Order, and automatically updates the Workflow Status accordingly, allowing customer to follow-up on order processing within the Storefront.

Field Value Description
Draft System status, only used by the Storefront. Draft orders are not present in Dynamics NAV.
Sent System status, only used by the Storefront.
Received The order has been placed by the customer, it is displayed in the Web Orders list. A Sales Quote may have been created for the Web Order, but the order has not yet been moved into the Sales Order document/stage. From customer's perspective, Received means you have received the order, it is being reviewed, and further actions may take place on your behalf before moving forward to Reservation.
Reservation A Sales Order has been created for the Web Order, either directly or via a Sales Quote. From customer's perspective, Reservation means you have taken the order and are treating it as final, which generally corresponds to having the order in your Sales Orders, which affects your Item Availability.
Note: This status does not have any technical relation to the Item Reservation features in Dynamics NAV, which you may use independently.
Warehouse The Sales Order has been released. From customer's perspective, sales department is done with the order, and the order has moved to the warehouse for picking/shipping. Unless there are special provisions on your behalf, e.g. prepayment collection or similar, this generally corresponds to the meaning of Released in Dynamics NAV.
Partially Shipped You have posted at least one Shipment for the Sales Order, but the order is not completely shipped yet.
Shipped You have posted Shipment for all the quantities on the Sales Order lines.
Rejected You have manually marked the Web Order as Rejected using the Change Workflow Status function.

Related topics:


Lines section

The Lines section on the Web Order page include the items and services the customer has ordered. Web Order lines are organized similar to Sales Order lines in Dynamics NAV.

Type

Displays the type of the item on the line.

With E-Commerce B2B, the Type can be:


No.

The No. of the respective Dynamics NAV record according to Type (Item or Resource) being ordered.


Variant Code

For Items with Variants/SKUs, the Item Variant Code being ordered.

Should the Item have at least one Variant present in Dynamics NAV, the Storefront will only allow to order the particular Variant/SKU of the Item to be ordered.

Note: This field is invisible by default, which matches the default profile of Dynamics NAV (Variant-related fields hidden). You can make the field visible by using the Choose Columns… function or ask your Dynamics partner to make the field permanently visible for all Dynamics NAV users.


Description

Description of the Item or Resource being ordered.


Description 2

Description 2 of the Item or Resource being ordered.

Description 2 is by convention used in E-Commerce B2B in conjunction with Item Variants to describe the particular Variant/SKU of the Item, while Description is used to describe the generic Item itself.

Note: This field is invisible by default, which matches the default profile of Dynamics NAV (Variant-related fields hidden). You can make the field visible by using the Choose Columns… function or ask your Dynamics partner to make the field permanently visible for all Dynamics NAV users.


Quantity

The quantity of Items or Resources being ordered, using the unit of measure specified in the Unit of Measure Code field.


Unit of Measure Code

The unit of measure used for the Quantity field.

For both Items and Resources, E-Commerce B2B only supports the base unit of measure as specified on the respective Item and Resource cards. Consequently, this field will always match the base unit of measure for the respective item being ordered.


Unit Price

Displays the price per unit of the Item or Resource being ordered.

According to Customer card setting Prices Including VAT, which is linked to the Web Account representing the customer placing the order, the caption of this field may be either Unit Price Incl. VAT or Unit Price Excl. VAT, which is the same behavior found in standard Dynamics NAV Sales Quotes and Sales Orders.

Note that the unit price, applicable discounts, as well as line and order totals presented were calculated by E-Commerce B2B at the time the order was placed. When creating a Sales Quote or Sales Order from the Web Order, E-Commerce B2B will let Dynamics NAV to recalculate the pricing for the Quote/Order, and not force using the prices set on the Web Order lines. In case there are differences, which may arise from updated pricing after the order has been placed, E-Commerce will detect the amount mismatch upon Releasing the Quote or Order and present a dialog raising the amount difference issue. You can then decide how to properly handle the price change and:

  1. Update your Sales Order/Quote to match the pricing the customer got upon placing the order
  2. Refresh the Web Order to the current pricing/amounts and optionally request customer's approval for the changes.

Line Discount %

Line discount percentage applicable to the order line.


Line Amount

Total amount for the line, based on Quantity, Unit Price, and Line Discount %


Shipping section

Ship-to Code

When placing orders, B2B customers have an option to select the shipping address from the list you maintain in Ship-to Addresses for the Customer record. If the customer has selected such address during checkout, this field will display the selected Ship-to Address Code.

Upon creating a Sales Quote or Sales Order for the Web Order, E-Commerce B2B will populate the Ship-to Code based on this field, which will determine the contents of the Shipping section for the Quote or Order.

This field will be blank for B2C scenarios, as B2C customers do not have an option to select the addresses from your Ship-to Address lists.


Ship-to Name

For B2B scenarios, where the customer has selected an existing Ship-to Address for order delivery, Ship-to Name will contain the Name of the respective Ship-to Address record.

For B2C scenarios, Ship-to Name will match the customer name.


Ship-to Address

For B2B scenarios, where the customer has selected an existing Ship-to Address for order delivery, Ship-to Address will contain the Address of the respective Ship-to Address record.

For B2C scenarios, Ship-to Address will include the Address for delivery as provided by the customer during the checkout.


Ship-to Post Code

For B2B scenarios, where the customer has selected an existing Ship-to Address for order delivery, Ship-to Post Code will contain the Post Code of the respective Ship-to Address record.

For B2C scenarios, Ship-to Post Code will include the post code for delivery as provided by the customer during the checkout.


Ship-to City

For B2B scenarios, where the customer has selected an existing Ship-to Address for order delivery, Ship-to City will contain the City of the respective Ship-to Address record.

For B2C scenarios, Ship-to City will include the city for delivery as provided by the customer during the checkout.


Ship-to Country/Region Code

For B2B scenarios, where the customer has selected an existing Ship-to Address for order delivery, Ship-to Country/Region Code will contain the Country/Region Code of the respective Ship-to Address record.

For B2C scenarios, Ship-to Country/Region Code will include the country/region for delivery as provided by the customer during the checkout.


Requested Delivery Date

Contains the requested delivery date for the order as specified by the customer during checkout.

When creating a Sales Quote or a Sales Order from a Web Order, this field will be used to populate the Requested Delivery Date field on a Sales Quote or a Sales Order.


Shipment Method Code

Indicates the shipment method for the order as chosen by the customer during checkout.

When creating a Sales Quote or a Sales Order from a Web Order, this field will be used to populate the Shipment Method Code field on a Sales Quote or a Sales Order.

Related topics:


Shipment Zone Code

Indicates the shipment zone according to the shipment method for the order, as chosen by the customer during checkout.

If, as per your Shipment Method/Zone setup, there is a shipping price for this zone, E-Commerce B2B will automatically add an additional line, usually of Type=Resource, for the shipping service. This is done by E-Commerce B2B during the checkout, so that the customer confirms the final order amount upon placing the order with the shipment method and zone selected.

This field is not used when creating a Sales Quote or Sales Order, and is merely informative.

Related topics:


B2C - Customer Details section

Web Account No.

If the customer who placed the order has an account and the customer was signed in using the account upon placing the order, Web Account No. will include the respective Web Account No. from the Web Accounts list in Dynamics NAV.

If the customer was not signed in upon placing the order, this field is blank.


Web Account Name

Name of the customer that has placed the order.

For registered customers (those with Web Account No. present) the Web Account Name originates from the Web Account record used for the customer that has placed the order. If not registered, this is the Name as specified by the customer during checkout.


Web Account E-Mail

E-mail address of the customer that has placed the order.

For registered customers (those with Web Account No. present) the Web Account E-Mail originates from the Web Account record used for the customer that has placed the order. If not registered, this is the e-mail address as specified by the customer during checkout.

Web Account E-Mail is used for e-mails composed by Dynamics NAV upon processing, e.g. requesting customer's approval for changes, e-mail link to order.

Web Account E-Mail is not used for Sales Order or Sales Quote conversion and is merely informative.

This field is a duplicate for the Sell-to E-Mail field in the General section.


Web Account Phone No.

Phone No. of the customer that has placed the order.

For registered customers (those with Web Account No. present) the Web Account Phone No. originates from the Web Account record used for the customer that has placed the order. If not registered, this is the phone No. as specified by the customer during checkout.

Web Account Phone No. is not used for Sales Order or Sales Quote conversion and is merely informative.

This field is a duplicate for the Sell-to Phone No. field in the General section.


Web Account SSN / Reg. No.

Some legislations require that you collect the identification details of the individuals placing online orders. You may also want to do this according to your business procedures.

Web Account SSN / Reg. No. is the ID of the individual customer in the form of Social Security Number (SSN) or Registration Number, or similar as per your legislation.

For registered customers (those with Web Account No. present) the Web Account SSN / Reg. No. originates from the Web Account record used for the customer that has placed the order. If not registered, this is the ID as specified by the customer during checkout.

Web Account SSN / Reg. No. is not used for Sales Order or Sales Quote conversion and is merely informative.


B2C - Payment Information section

If you are using E-Commerce B2B in a public webstore (B2C) scenario, it is common to include the online payment in the order checkout process, so that received Web Orders are already paid by the means of credit card, Paypal or similar.

E-Commerce B2B does not include any such online payment integrations out of the box, however the following fields are typically used to store online payment details once the payment integration has been added by the means of customizing the Storefront.

Payment Method Code

Indicates the payment method used for the Web Order, e.g. credit card, Paypal, or similar.


Payment Authorization Result

Indicates the payment authorization result relevant to the Payment Method used for the Web Order.

This field unanimously determines whether the payment was successful or not, with the typical values of OK, FAILURE received from the payment gateway.


Payment Status Info

Indicates the payment status information related to the Payment Authorization Result.

Typically includes any failure codes or additional information provided by the respective payment gateway.


Payment Transaction ID

Includes the payment transaction identification key with the respective payment gateway.

You use this ID when dealing with the payment gateway directly regarding the particular payment, e.g. in order to reverse the transaction, check up on details etc.


Amount Paid

Contains the amount paid, based on the information provided by the payment gateway.

This field is used to ensure the payment integrity with the order totals, which is of great imporance in case you change the order in Dynamics NAV during the processing flow.


Event Log Section

The Event Log table for a Web Order contains the list of actions performed on the Web Order since it's placement.

Events logged include any Workflow Status changes, as well as e-commerce related actions on linked Sales Quotes and Sales Orders. The list will also contain any customer comments and approval status changes posted via the Storefront after the order has been placed.

The Event Log list is shared by both the Original and Modified by Sales Doc. versions of the order.

User Type

Indicates the type of the user who performed the action represented by the Event Log entry:

Field Value Description
Web Account The action was performed by the customer using the Storefront.
NAV User The action was performed by the back office user or manager using Dynamics NAV.

User No.

The Code or ID of the user who performed the action, according to the User Type.


Entry Time

The system date and time when the action was performed.


Event Type

Indicates the type of the event:

Field Value Description
Workflow Status Change The Workflow Status field was updated either automatically due to order processing trigger, or manually using the Change Workflow Status function.
Update from Sales Doc. The Web Order was refreshed from a Sales Quote or Sales Order, and the Modified by Sales Doc. version was created.
Customer Comment Indicates the additional customer comment posted in the Storefront.
Approval Status Change The Customer Approval field was updated from Dynamics NAV using the customer approval functions, or by the customer using the Storefront.
Payment Gateway Event Indicates an event generated by the online payment gateway.

New Status

When Event Type is Workflow Status Change or Approval Status Change, indicates the new status of the respective type assigned to the Web Order.


Comment

When Event Type is Customer Comment, includes the comment text as posted by the customer in the Storefront.

For other types of events, this field may include additional details of the event.


Person Name

Indicates the name of the person (the customer or NAV user) who initiated the event, according to User Type and User No. fields.


Company

Indicates the company name of the user or customer who initiated the event, according to User Type and User No. fields.