Skip to Content

Can't Customize Excel Template for ByDesign

Feb 13 at 11:26 PM


avatar image

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.

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:

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Anant Acharya
Feb 21 at 01:16 AM

Harshal Vakil COuld you please help to answer this ?

Show 1 Share
10 |10000 characters needed characters left 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.