ERROR: Failed to send AR Invoice Update the exchange rate

[honeytoyorada]

We are preparing for a large physical sale event in London from April 24th to 27th and need some assistance in ensuring that all sales process correctly through Shopify while also being able to identify sales item vs usual item.

Last year, we processed sales through the Shopify UK Point of Sale (POS) channel and tagged sale items so we could separate transactions at the end of the day. Given that we have more time to prepare this year, we created a separate POS "sale" channel in Shopify specifically for this event. This sales channel is also linked to an API following the same logic as  both API UK 6 Silver Place - POS Orders 

We have recently duplicated our POS api's in the UK to be able to process orders from multiple shopify location. Even though the API's are exact duplicated of our current connection in terms of logic, we get the below error: 

ERROR: Failed to send AR Invoice (ID: 11585479049602/Number: CO29046) to SAP: Update the exchange rate 

This connection has 3 differences to our current ones: 

1.The GL account is the sales Revenue which is 400005 - Sales revenue Pop-ups UK.

2.  The warehouse code to be 03 rather than 02

3. The location is linked to 103733657986 (see attached) on shopify, this is our new Pop up location. 

I've cross checked multiple times and the changes made have been cross checked and everything seems to be set as it should be. 

The payload that failed can be found below, thank you in advance for your help!

{
  "U_PTA_order_id": 11585479049602,
  "U_Magento_WebId": 11585479049602,
  "NumAtCard": "CO29046",
  "TotalDiscount": 0,
  "DocTotal": 4,
  "DocCur": "GBP",
  "CardCode": "CNL254995",
  "DocDate": "2025-03-10",
  "DocDueDate": "2025-03-10",
  "ShippingMethod": "8",
  "JournalMemo": "POS Invoice %s Payment Method: %s",
  "Comments": "POS Invoice %s Payment Method: %s",
  "TotalDiscountSC": 0,
  "paymentMethods": "Credit Card",
  "customer": {
    "CardName": " ",
    "CardType": "C",
    "GroupCode": "105",
    "CompanyPrivate": "cCompany",
    "Series": "69",
    "Phone1": "",
    "EmailAddress": "l@p.nl",
    "Address": "",
    "City": null,
    "County": null,
    "Country": null,
    "ZipCode": null,
    "MailAddress": null,
    "MailCity": null,
    "MailCounty": null,
    "MailCountry": null,
    "MailZipCode": null,
    "PriceListNum": "9"
  },
  "DocumentLines": [
    {
      "ItemCode": "PA-AW23-5-O-CLOCK-L-001",
      "Quantity": 1,
      "Price": 3.3333,
      "AccountCode": "140100",
      "GOGSAccountCode": "400005",
      "WarehouseCode": "03",
      "TaxCode": "O1"
    }
  ]

[ens_]

Dear @honeytoyorada 

Since this is complaining about Exchange rate, I'd check the exchange rate of your target database (SAP Business One) is set for the period the transaction is taking place based on the currencies. From the payload, it looks like you are working with GBP. 

Is your Exchange rate set between System Currency and GBP?
Is your GL Account 140100 and 400005 a multicurrency account? GBP Account? something else?
You are also sending 

"TotalDiscountSC": 0,

 along with 

"TotalDiscount": 0,

This tells me that the system currency is different than the document currency. Hence the question about your exchange rate between the 2 currencies.

If you are certain that system currency and GBP has the correct exchange rate for the period you are posting, and everything looks good, try creating the document in SAP Business One manually and right click "Preview Journal Entry" and see if you get the same error as the error you provided seems like a custom error and not something seen on Service Layer or DI API.

Sincerely,

@ens_ 

[honeytoyorada]

Hi @ens_

Thank you for your response.

The database Exchange Rate was for EUR x USD

[ens_]

So you are sending for GBP how could the issue be with the exchange rate of EURxUSD? Im confused about that 🙂

 Try testing manually filling in the document without posting it and right click → preview journal entry to see the error. Ensure your currency is GBP on the document.