Can't Customize Excel Template for ByDesign

[Eduardo_Domingu]

Hello ByD experts,

I tried to customize an excel layout for journal entries on ByD. I failed after trying several times, using the following entries as guides, the excel template does not show errors or warnings, but when synchronizing, the data that was entered in the required field does not appear on ByD.

https://blogs.sap.com/2015/02/25/how-to-guide-for-journal-entry-voucher-excel-customization/

https://blogs.sap.com/2014/07/28/how-to-customize-excel-import-template-example-for-marketing-leads/...

The requirement is to import manual journal entries with the Excel Add-In with the proper template but we want ONE specific field to be available in this template and currently it is not available on it. This field is a localization for Mexico as an standard SAP solution, it's name is LEGAL AUTHORIZATION ID.

The node element is inside the node "Item" on business object "AccountingEntry" and has the following characteristics:

We tried to modify the .xlsx by unzipping and modify the xmlMaps.xml by adding the following lines according to the blog entries enlisted befor:

Is there any step I am missing? Anyone that has a solution that can help me?

In the following you can find the .xlm and final .xlsx file:

https://drive.google.com/drive/folders/1V8-AfNw-DV5H4fEN7vPObQbw3mJVfiu6?usp=sharing

Thanks, Eduardo.

[anant_acharya]

9002e0962c054c48ac31cb3fd8d4f801 COuld you please help to answer this ?

[HarshalVakil]

Hi Anant,

Process followed by Eduardo is the correct one. Since the after adding the lines in XML maps file, new template is not showing any error (If there is then while opening excel, it would show that file is corrupt..) which is a good sign.

Currently, since data entered in the excel is not being passed to system field, I am suspecting that there is a mismatch in data type or other property of the field. to validate this, some one has to check this from the back end of the system. That's where I am unable to check/suggest further. 😉

eduardo.dominguez.enable : Can you please raise an incident with SAP. Provide them the modified template and reference them to the field on screen (Only available in the Maxico system) and the link to the blog post to further investigate on the issue.

I hope this will help.

Regards,

Harshal