Request CalculateOrder: Customer does not exist

Tomas Gomez

Posted on 12/04/2022 13:38:24

Hi,

I have an issue with a Bussiness Central integration from BC. There is an error for the request CalculeOrder when sending an order to BC (see attached dump) so orders are not sent to BC.

The log says that "An error occurred processing the request. Exception: The Customer does not exist. Identification fields and values: No.='PV0003723". But the user exists (user get the product info in former requests) and the user ID is CL005430 (OrderCustomerNumber) but the error names the ID PV0003723. This PV0003723 is an identification for the order lines (or similar), as seen later in the log, there are IDs from PV0003719 upto PV0003722 but the PV0003723 doesn't exist neither is the user ID

Does anybody know about this issue? How can we solve it?

Regards,
Tomas

Request_CalculateOrder.txt

Replies

Dmitriy Benyuk

Posted on 12/04/2022 21:09:39

Hi Tomas,
what is Dynamicweb Plugin unit application version are you using? If it is one of the latest then the issue can be a Bill to Customer being used.
Try to open the customer CL005430 and check its Bill to customer number, maybe it is set to this failing "PV0003723" number.
BR, Dmitrij

Tomas Gomez

Posted on 13/04/2022 16:11:17

Hi Dmitriy,

Our client reinstalled the versión 1.2.0.19 in a OnPrem BC14.

We told him about the "Bill to customer number". I'll keep you informed

Regards,
Tomas

Tomas Gomez

Posted on 14/04/2022 11:35:26

Hi Dmitriy,

We did further investigation. The error message has slightly changed, now it is:

DebugInfo: Response CalculateOrder (ID: ORDER443, CreateOrder: True) received: 'An error occurred processing the request. Exception: The Customer does not exist. Identification fields and values: No.='''.

The customer exists in BC, as he can see live prices. The order XML looks fine, I send it as an attchment. As well, I send a screenshot of the orders configuration in the LiveIntegration.

What more test can we do? Which requests would you suggest to get more info?

Regards,
Tomas

Order_ORDER443.xml

Dmitriy Benyuk

Posted on 14/04/2022 13:17:21

Hi Tomas,
can you check your customer and its Bill To Customer No if they have correct values?
Do you use only our standard plugin unit app? Or do you also have some custom extensions?
BR, Dmitrij

Tomas Gomez

Posted on 14/04/2022 13:54:24

Hi Dmitrij,

We asked our partner about it, but no answer yet. We have acces to BC but we are not experts so don't know how to check it. We searched in the Customer card but no success.

Where can we check the "Bill to customer"? Which value should it have?

Regards,
Tomas

Dmitriy Benyuk

Posted on 14/04/2022 16:24:56

Hi,
you need to check No and Bill to customer as shown here:
(Bill to customer is empty by default)

BR, Dmitrij

Tomas Gomez

Posted on 19/04/2022 11:35:53

Hi Dmitrij,

Our partner tells the bill-to-customer number is correctly configured to "CL007952" (see image).
This ID appears in the request of the order (see trace below) but the error persists: The Customer does not exist. Identification fields and values: No.='''.
As well, we tried we another user whose bill-to-customer is empty and the error is the same. That is we have the same error on all users.

Is there anything we are missing?

Regards,
Tomas

4/19/2022 11:04:41 AM: DebugInfo: Updating order with ID: ORDER446. Complete: True. Order submitted from the backend: False
4/19/2022 11:04:41 AM: DebugInfo: Request CalculateOrder (ID: ORDER446, CreateOrder: True) sent: '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><tables source="LiveIntegration" submitType="LiveOrderOrCart" referenceName="OrdersPut"><table tableName="EcomOrders"><item table="EcomOrders"><column columnName="OrderCustomerAccessUserExternalId">CO0005464</column><column columnName="OrderCustomerNumber">CL007952</column><column columnName="OrderCustomerName">tomas gomez netaservice</column><column columnName="OrderCustomerAddress">VALLE DE LOS CHILLOS</column><column columnName="OrderCustomerAddress2"></column><column columnName="OrderCustomerCity">QUITO</column><column columnName="OrderCustomerState"></column><column columnName="OrderCustomerZip">EC-001028</column><column columnName="OrderCustomerCountryCode">EC</column><column columnName="OrderCustomerEmail">tomasgomez@netaservice.com</column><column columnName="OrderCustomerPhone">0999999991</column><column columnName="OrderCustomerFax"></column><column columnName="OrderCustomerCompany">TOMAS GOMEZ</column><column columnName="OrderCustomerComment"></column><column columnName="OrderCustomerFirstName"></column><column columnName="OrderCustomerSurname"></column><column columnName="OrderCustomerRefId"></column><column columnName="OrderDeliveryName">tomas gomez netaservice</column><column columnName="OrderDeliveryAddress">VALLE DE LOS CHILLOS</column><column columnName="OrderDeliveryAddress2"></column><column columnName="OrderDeliveryCity">QUITO</column><column columnName="OrderDeliveryState"></column><column columnName="OrderDeliveryZip">EC-001028</column><column columnName="OrderDeliveryCountryCode">EC</column><column columnName="OrderDeliveryEmail">tomasgomez@netaservice.com</column><column columnName="OrderDeliveryPhone">0999999991</column><column columnName="OrderDeliveryFax"></column><column columnName="OrderDeliveryCompany">TOMAS GOMEZ</column><column columnName="CreateOrder">True</column><column columnName="OrderId">ORDER446</column><column columnName="OrderAutoId">53</column><column columnName="OrderIntegrationOrderId"></column><column columnName="OrderCurrencyCode">USD</column><column columnName="OrderDate">2022-04-19T11:04:33</column><column columnName="OrderPaymentMethodName" isInformationalOnly="True">Transferencia</column><column columnName="OrderPaymentMethodId">PAY2</column><column columnName="OrderShippingMethodName" isInformationalOnly="True"></column><column columnName="OrderShippingMethodId"></column><column columnName="OrderShippingFee"></column><column columnName="OrderPriceTotal">1.3</column><column columnName="OrderCaptureAmount">0</column><column columnName="OrderVoucherCode"></column><column columnName="OrderTransactionId"></column><column columnName="OrderStateId">OS1</column><column columnName="OrderStateName" isInformationalOnly="True">New</column><column columnName="ErpControlsDiscount">True</column><column columnName="OrderShippingAgent" isCustomField="True"></column></item></table><table tableName="EcomOrderLines"><item table="EcomOrderLines"><column columnName="OrderLineId">OL14473</column><column columnName="OrderLineOrderId">ORDER446</column><column columnName="OrderLineParentLineId"></column><column columnName="OrderLineProductId">BCDI-001</column><column columnName="OrderLineProductVariantId"></column><column columnName="OrderLineProductNumber">BCDI-001</column><column columnName="OrderLineProductName">BATA CIRUJANO IMPERMEABLE TALLA ESTANDAR C/60 UDS</column><column columnName="OrderLineProductIdentifier">BCDI-001..LANG1</column><column columnName="OrderLineQuantity">1</column><column columnName="OrderLineUnitId"></column><column columnName="OrderLinePriceWithoutVat">1.16</column><column columnName="OrderLineUnitPriceWithoutVat">1.16</column><column columnName="NetPrice">2</column><column columnName="OrderLineType">0</column><column columnName="OrderLineTypeName">Product</column><column columnName="OrderLineBom">False</column><column columnName="OrderLineBomItemId"></column><column columnName="OrderLineGiftCardCode"></column><column columnName="OrderLineIsGiftCardDiscount" isCustomField="True">False</column><column columnName="OrderLineFieldValues"><OrderLineFieldValueCollection /></column></item></table></tables>'.
4/19/2022 11:04:41 AM: DebugInfo: Response CalculateOrder (ID: ORDER446, CreateOrder: True) received: 'An error occurred processing the request. Exception: The Customer does not exist. Identification fields and values: No.='''.
4/19/2022 11:04:41 AM: ResponseError: Response is not valid XML format: 'Data at the root level is invalid. Line 1, position 1.'.
4/19/2022 11:04:41 AM: ConnectionError: Error CalculateOrder Order Id:'ORDER446' CreateOrder:'True' Message:'Response is not valid XML'.

Dmitriy Benyuk

Posted on 19/04/2022 13:59:24

Hi,
I can not reproduce it. How about the same request for Calculating order (not creating) just changing <column columnName="CreateOrder">False</column>?
Does it work?
BR, Dmitrij

Tomas Gomez

Posted on 19/04/2022 14:50:25

Hi Dmitrij,

The request is sent automatically from the frontend. Where may I change the CreateOrder to false?

I can give you access to test it if you send me your mail, or in a support ticket. Please tell me what is best.

Regards,
Tomas

Dmitriy Benyuk

Posted on 19/04/2022 15:53:45

you can send to mine email: dbe@dynamicweb-cms.com

Tomas Gomez

Posted on 21/04/2022 11:14:21

Hi Dmitrij,

We solved it

It was an issue in BC. It became corrupted after trying different plugins for solving another issue (installing the plugins for BC18 and BC19 and then reverting to the plugin for BC14, as suggested at https://doc.dynamicweb.com/forum/integration/integration/import-productlongdescription-from-bc). A new BC copy with a fresh plugin installion has no issues.

Thanks a lot for your help :-)
Tomas

You must be logged in to post in the forum

Developer forum

Request CalculateOrder: Customer does not exist

Replies