Skip to Content

Can't Customize Excel Template for ByDesign

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/#comment-68077

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.

node-element.jpg (52.9 kB)
data-type.jpg (39.4 kB)
nodo-1.jpg (96.3 kB)
nodo-2.jpg (141.2 kB)
nodo-3.jpg (139.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 21 at 01:16 AM

    Harshal Vakil COuld you please help to answer this ?

    Add comment
    10|10000 characters needed characters exceeded

    • 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. ;)

      Luis Eduaro Domínguez Ochoa : 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