====== 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: |< 100% 200px - >| ^ 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: * See [[docs:order_processing:features_weborder#web_order_versions|Web Order Versions]] for details. * Clicking **Show Original Version** when viewing the //Modified by Sales Doc.// version will open another Web Order window displaying the original version of the same Web Order. ----- ===== Type ===== Indicates the type of the customer who has placed the Web Order: |< 100% 200px - >| ^ 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: * [[docs:pricing_and_discounts#scenarios|Pricing and Usage Scenarios]] for E-Commerce B2B. * [[admin:generic_b2c_customer|Setting up a generic "B2C" Customer card]] in Dynamics NAV. ----- ===== 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. * For B2B scenarios, it will indicate the respective No. of the Customer record you have created the Web Account for. * For B2C scenarios, the //generic B2C customer// No. will be used. ----- ===== Sell-to Customer Name ===== Customer name according to the **Sell-to Customer No.** * For B2B scenario, Name from the respective Customer card will be used. * For B2C scenarios, this field will display the customer's name as entered during the checkout. ----- ===== 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.** * For B2B scenario, Name from the respective Contact card will be used. * For B2C scenarios, this field will display the customer's name as entered during the checkout. ----- ===== 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. [[docs:order_processing:features_order#collecting_approval_for_changes|requesting customer's approval for changes]], [[docs:order_processing:features_weborder#e-mail_link_to_order|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. * Upon converting Web Order to Sales Quote, this field will be used for **Document Date** on the Sales Quote * Upon converting Web Order to Sales Order, this field will be used for both **Document Date** and **Order Date** on the Sales Order. //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 [[https://msdn.microsoft.com/en-us/library/hh895308(v=nav.90).aspx|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 [[docs:order_processing:order_taking_setup|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 [[docs:order_processing:order_taking_setup|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. |< 100% 200px - >| ^ 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: * [[docs:order_processing:features_weborder#manually_changing_approval_state|Manually Changing Approval State]] //(from a Web Order)// * [[docs:order_processing:features_quote#collecting_approval_for_order_placement|Collecting Approval for Order Placement]] //(from a Sales Quote)// * [[docs:order_processing:features_order#collecting_approval_for_changes|Collecting Approval for Changes]] //(from a Sales Order)// ----- ===== 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. |< 100% 150px - >| ^ 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: * [[docs:order_processing:flow_web_order|Flowchart: Supported Processing Flow at the Web Order Stage]] * [[docs:order_processing:flow_quote|Flowchart: Supported Processing Flow at the Quote Stage]] * [[docs:order_processing:flow_order|Flowchart: Supported Processing Flow at the Order Stage]] * [[docs:order_processing:features_weborder#manually_changing_workflow_status|Manually Changing Workflow Status]] ----- ====== 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: * **Item** - for products being ordered, which are Items in your Dynamics NAV * **Resource** - for shipping services, which are usually set up as Resources in Dynamics NAV ----- ===== 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 [[docs:order_processing:features_quote#releasing_an_e-commerce_quote|Quote]] or [[docs:order_processing:features_order#releasing_an_e-commerce_order|Order]] and present a dialog raising the amount difference issue. You can then decide how to properly handle the price change and: - Update your Sales Order/Quote to match the pricing the customer got upon placing the order - //Refresh// the Web Order to the current pricing/amounts and optionally [[docs:order_processing:features_order#collecting_approval_for_changes|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: * [[admin:shipment_setup|Setting up Shipment Methods and Zones]] ----- ===== 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: * [[admin:shipment_setup|Setting up Shipment Methods and Zones]] ----- ====== 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. [[docs:order_processing:features_order#collecting_approval_for_changes|requesting customer's approval for changes]], [[docs:order_processing:features_weborder#e-mail_link_to_order|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.// [[docs:order_processing:features_weborder#web_order_versions|versions of the order]]. ===== User Type ===== Indicates the type of the user who performed the action represented by the Event Log entry: |< 100% 200px - >| ^ 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**. * For entries with //User Type=Web Account//, **User No.** will contain the Web Account No. * For entries with //User Type=NAV User//, **User No.** will contain the Dynamics NAV User ID. ----- ===== Entry Time ===== The system date and time when the action was performed. ----- ===== Event Type ===== Indicates the type of the event: |< 100% 200px - >| ^ 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.