Share
Report
45Hi to all!
I need help to manage a problem. What I needed to achieve was to add a new unmapped field to a system data entity (OpenPurchasePriceJournalLine), then get it as a new column in the Excel the system outputs when you click on Open in Microsoft Office -> Open in Excel button.
What I did is to create an extension of the OpenPurchasePriceJournalLine Data Entiy in my model. Through it, I added the unmapped field, then added it to the "AutoGroup" data group. After build and sync, I tried it: it worked, as I see a new column in the exported excel that contains the correct values.
Now, what's the problem? The added field is a "Product Name" field, and the customer wants it to be side by side with the "Product number" column. But the system automatically puts the extensions field columns in the end of the excel, in the far-right side.
I had tried to change the order of my added field in the group, but as it is an extension of the DE, I can't move it among the default fields. I know that if it was a custom DE I would have been able to do this without any problem, but it is not my situation...
Do you have any solution for this matter? Thank you!
All responses (
Answers (
