127
In Business documents you can use Ranges to create repeating sections: for example to show all lines on a document. Next, you can also use criteria "Enabled"/"Removed", in order to delete part of your document, should this value be empty.
In Excel you can also use them in combination (e.g. Notes on your sales packing slip lines: there can be a note on line 2 but none on line 1. You only want to show the note of the line if it is actually filled in).
This logic does not work in Word however. In Word: the "Removed" criteria can be:
- ISEMPTY(@.Note): Then he looks if there are notes on line 1. If yes, he shows note on all lines. If No, he does not show notes anywhere.
- ISEMPTY(ALLITEMS(@.Note)): If there is one note on one of the lines, then D365 will show notes everywhere. Also, if the notes are empty on some other lines (white spaces).
See also fix: https://fix.lcs.dynamics.com/Issue/Details?bugId=562546&dbType=3&qc=1a93cc383a735cb75470ee7ee5952b0dc6e0196981f23cdb03355dd0f9674483
However, this is an important restriction to Business documents in Word! Two examples below, but there may be many more:
- Project invoice
Here we create 5 blocks: for hours, fees, items, expenses and on-account. Then we repeat these blocks per project. So for project 1 we might have only hours and fees. For project 2 we might have only expenses.
Still, we will see twice the full 5 blocks of hours, fees, items, expenses and on-account even though 7 out of 10 blocks will be empty.
- If you want to include pictures in your lines
Suppose you want to pick up the image of your release product on your line. If the images are present for all products on all lines, there is no problem. However, if one of the products does not have an image, then you will get an error message and the report will not print.
Therefore, we suggest to enable the use of criteria "Enabled"/"Removed" in combination with a Repeating section.
In Excel you can also use them in combination (e.g. Notes on your sales packing slip lines: there can be a note on line 2 but none on line 1. You only want to show the note of the line if it is actually filled in).
This logic does not work in Word however. In Word: the "Removed" criteria can be:
- ISEMPTY(@.Note): Then he looks if there are notes on line 1. If yes, he shows note on all lines. If No, he does not show notes anywhere.
- ISEMPTY(ALLITEMS(@.Note)): If there is one note on one of the lines, then D365 will show notes everywhere. Also, if the notes are empty on some other lines (white spaces).
See also fix: https://fix.lcs.dynamics.com/Issue/Details?bugId=562546&dbType=3&qc=1a93cc383a735cb75470ee7ee5952b0dc6e0196981f23cdb03355dd0f9674483
However, this is an important restriction to Business documents in Word! Two examples below, but there may be many more:
- Project invoice
Here we create 5 blocks: for hours, fees, items, expenses and on-account. Then we repeat these blocks per project. So for project 1 we might have only hours and fees. For project 2 we might have only expenses.
Still, we will see twice the full 5 blocks of hours, fees, items, expenses and on-account even though 7 out of 10 blocks will be empty.
- If you want to include pictures in your lines
Suppose you want to pick up the image of your release product on your line. If the images are present for all products on all lines, there is no problem. However, if one of the products does not have an image, then you will get an error message and the report will not print.
Therefore, we suggest to enable the use of criteria "Enabled"/"Removed" in combination with a Repeating section.
STATUS DETAILS
Needs Votes
