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
- Open the respective excel file.
- Logon to the system via Excel add-in.
- Select the option Save Data To.
- 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:
- Open the respective excel file.
- Navigate to the SAP BUSINESS BYDESIGN add-in tab.
- Select Logon.
- Open the Proxy Settings option.
- Remove the Proxy URL.
- Select OK.
- Now, login using the URL, Username and Password.
- Select Save data to.
- 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
Keywords
Excel Add-in, ByDesign, Upload, Template, Error, XmlDocument, SendRequestToA2X, Save data to. , KBA , SRD-FIN-GL , General Ledger , How To