Developer forum

Forum » Integration » The type of the Sell-to Customer Name FlowField in the Webshop Sales Header tablr must be Decimal

The type of the Sell-to Customer Name FlowField in the Webshop Sales Header tablr must be Decimal

Kim Søjborg Pedersen
Reply

Hi,

when I send this CalculateOrder XML in live integration -> test connection I get the message "Error checking connection: The type of the Sell-to Customer Name FlowField in the Webshop Sales Header tablr must be Decimal"

Any idea where to go from here?

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<CalculateOrder>
  <Orders>
    <Order>
      <column columnName="OrderCustomerAccessUserExternalId">50016830</column>
      <column columnName="CreateOrder">True</column>
      <column columnName="OrderID">DEMOORDER545</column>
      <column columnName="OrderCurrencyCode">DKK</column>
      <column columnName="OrderDate">22-01-2015 15:58:35</column>
      <column columnName="OrderPaymentMethodName"></column>
      <column columnName="OrderShippingMethodName"></column>
      <column columnName="OrderCustomerName">xxx</column>
      <column columnName="OrderCustomerAddress">xxx</column>
      <column columnName="OrderCustomerAddress2">xxx</column>
      <column columnName="OrderCustomerCity">Ålborg</column>
      <column columnName="OrderCustomerCountryCode">DK</column>
      <column columnName="OrderCustomerEmail">xxx</column>
      <column columnName="OrderCustomerFax"></column>
      <column columnName="OrderCustomerPhone">99311101</column>
      <column columnName="OrderCustomerZip">9000</column>
      <column columnName="OrderDeliveryName"></column>
      <column columnName="OrderDeliveryAddress"></column>
      <column columnName="OrderDeliveryAddress2"></column>
      <column columnName="OrderDeliveryCity"></column>
      <column columnName="OrderDeliveryCountryCode">DK</column>
      <column columnName="OrderDeliveryEmail"></column>
      <column columnName="OrderDeliveryFax"></column>
      <column columnName="OrderDeliveryPhone"></column>
      <column columnName="OrderDeliveryZip"></column>
      <Fields>
        <column columnName="ReferencePerson">xxx</column>
        <column columnName="RequisitionNumber">Test indk rekv.</column>
        <column columnName="Comment">Dette er en test fra Besked feltet</column>
      </Fields>
    </Order>
  </Orders>
  <OrderLines>
    <OrderLine>
      <column columnName="OrderLineID">OL9761</column>
      <column columnName="OrderLineProductID">2169</column>
      <column columnName="OrderLineQuantity">1</column>
      <column columnName="OrderLinePriceWithoutVAT">1389,76</column>
      <column columnName="OrderLineUnitPriceWithoutVAT">1389,76</column>
    </OrderLine>
    <OrderLine>
      <column columnName="OrderLineID">OL9762</column>
      <column columnName="OrderLineProductID">1927</column>
      <column columnName="OrderLineQuantity">1</column>
      <column columnName="OrderLinePriceWithoutVAT">61,12</column>
      <column columnName="OrderLineUnitPriceWithoutVAT">61,12</column>
    </OrderLine>
    <OrderLine>
      <column columnName="OrderLineID">OL9763</column>
      <column columnName="OrderLineProductID">2114</column>
      <column columnName="OrderLineQuantity">10</column>
      <column columnName="OrderLinePriceWithoutVAT">66,2</column>
      <column columnName="OrderLineUnitPriceWithoutVAT">6,62</column>
    </OrderLine>
    <OrderLine>
      <column columnName="OrderLineID">OL9764</column>
      <column columnName="OrderLineProductID">1419</column>
      <column columnName="OrderLineQuantity">1</column>
      <column columnName="OrderLinePriceWithoutVAT">396,33</column>
      <column columnName="OrderLineUnitPriceWithoutVAT">396,33</column>
    </OrderLine>
    <OrderLine>
      <column columnName="OrderLineID">OL9765</column>
      <column columnName="OrderLineProductID">2063</column>
      <column columnName="OrderLineQuantity">1</column>
      <column columnName="OrderLinePriceWithoutVAT">156,86</column>
      <column columnName="OrderLineUnitPriceWithoutVAT">156,86</column>
    </OrderLine>
  </OrderLines>
</CalculateOrder>


Replies

 
Morten Snedker
Reply

Hi Kim,

What exactly is Sell-to Customer Name FlowField in the Webshop Sales. I take it that it is a NAV internal field, yes? Error message indicates that you are trying to pass a value from the <Order> section that on NAV side cannot be parsed as a decimal value.

 

/Snedker

 
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Kim,

looks like you have a code unit in NAV that has a mapping to "Sell-to Customer Name" which may be filled with the value from the Dynamicweb CalculateOrder request field "OrderCustomerName". And maybe in your NAV this field has a decimal values while in Dynamicweb it can be a string.

Votes for this answer: 1

 

You must be logged in to post in the forum