539
Hi,
I'm updating Customers sales tax group using Excel add-in.
when overwriting the values (cut and past and selection "values" in one column) and click Publish, I'm receiving the below error message
Any one found a work around ?
Thank you !
Hi GirishS,
It worked, I was able to remove the duplicates using the filter then Refresh (that was the only way I was able to do)
Thank you for the solution.
Kamel.
Hi Kamel,
Do you want to update the entity across companies?
Have you tried to remove duplicate entries from the excel file and then try to publish? Please check if there are duplicates customers in your list.
Hi Kamel Sadek,
I don't know what is the cause of the issue. But for time being you can add filters on the excel to the datasource and publish. It will work.
For example if you are entering transaction lines for X customer, you can add that customer X as filter.
Please go through the below link for adding filters in excel.
https://organicax.com/2016/03/29/using-the-filter-button-in-the-excel-add-in/
Thanks,
Girish S.
From the customer list, when I click on export and select Customers (GEN), the export is not done from the D365 GRID but from the Table itself CustTable. The grid doesn't contain duplicates but it looks like the Table contains one duplicate (shown in the Excel after the export).
I don't know how to fix this.
Thank you !
Kamel.
Hi Komi,
I have many thousands records to correct :)
Yes I verified, i have no duplicates.
Thank you !
Hi Kamel Sadek,
Instead of cut and paste, did you try inputting yourself before publishing?
Before you click publish. You should please confirm that you have no duplicate record.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (