SAP Knowledge Base Article - Public

3554207 - Issue with Uploading Data through Excel Add-in in ByD

Symptom

  • Unable to upload template through Excel Add-in.
  • Error message displayed is:

"The following Error(s) occurred while saving data:

XmlDocument SendRequestToA2X(A2XRequest a2xRequest)reported error

Total Number of Records Saved : 0"

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Open the respective excel file.
  2. Logon to the system via Excel add-in.
  3. Select the option Save Data To.
  4. The following error message is displayed:

"The following Error(s) occurred while saving data:

XmlDocument SendRequestToA2X(A2XRequest a2xRequest)reported error

Total Number of Records Saved : 0"

Cause

The issue is not from the ByDesign system or the Excel Add-In, but instead the issue is from the Excel itself.

Resolution

To resolve the issue, follow these steps:

  1. Open the respective excel file.
  2. Navigate to the SAP BUSINESS BYDESIGN add-in tab.
  3. Select Logon.
  4. Open the Proxy Settings option.
  5. Remove the Proxy URL.
  6. Select OK.
  7. Now, login using the URL, Username and Password.
  8. Select Save data to.
  9. The record will be uploaded successfully

If the issue persists, please reach out to the IT team, as it appears to be related to Excel.

See Also

2586194 - Common Issues and Troubleshooting with SAP Excel Add-in for Business ByDesign and Cloud for Customer

Keywords

Excel Add-in, ByDesign, Upload, Template, Error, XmlDocument, SendRequestToA2X, Save data to. , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions