Dynamics Community Forum Thread Details

Error when pasting Excel lines into form grid

Hi Experts,

I’m facing an issue while pasting records from Excel into a custom line table grid in D365FO.

My line table has a unique index on (LineNum, HeaderRef).

In initValue(), I assign default values when the user clicks New Line:
- LineNum is assigned starting from 1, and increases by 1 each time a new record is created.
- HeaderRef= Header.RecID After that, the user pastes records from Excel.

After that, the user pastes records from Excel.

If the pasted records also contain the same values (e.g., LineNum = 1 and HeaderRef = Header.RecId), I get this error message:
“Changes to a previous row cannot be saved until you fix a validation issue. Continue working until you’re ready to fix this.”
If the Excel file doesn’t contain that same combination, the paste works fine.

Questions:

How is this scenario handled in standard forms like PurchTable/PurchLine where pasting works fine?
Is there a way to detect paste in the form so I can skip default initialization?
What’s the best practice to avoid this duplicate issue (e.g., handling in initValue() or elsewhere)?

Thanks in advance for your help !

Categories:

Quick Links