Hello,
I have created a format mapping for a sales order confirmation in Electronic Reporting (ER) by using an Excel (.xlsx) as the attachment. This document has a header, body and footer. I have created derived versions of the following:
- Order model version 75 (Microsoft Global Repository)
- Sales confirm model mapping (RDP) version 73.42 (Microsoft Global Repository)
- Sales order confirmation (Excel) version 73.76 (Microsoft Global Repository)
I understand how to create a structure in the Excel document with the name manager, importing that structure in ER and binding fields from the model to the format. What I cannot figure out, is how:
1. To deal with empty lines and reorganizing the document making sure there are no line gaps.
2. Lock a range of data to be moved by another range of data outside a header or footer - e.g. lines, where the amount can differ per sales order. Data from the system needs to be mapped to certain fields of the range that need to be locked, and I cannot figure out how to map this in the Excel header or footer.
Example point 1 - how it will be printed
Sales order id: SO-000001
Customer reference:
Delivery date: 10/18/2021
Example point 1 - desired
Sales order id: SO-000001
Delivery date: 10/18/2021
The Customer reference is empty, so desired is to not use a line for just the label and make room for the next possible value and label, which is the Delivery date.
Example point 2
Is there a way to accomplish this in ER? If so, how?
Thanks in advance:)
