Hi,
So I am updating 2 items using excel and changing the 'sales blocked' field to 'True'.
When I go to publish the change, it does change the two fields but it also does some other changes
Some do fail as per below:
A row update in data set Item_Card_Excel was not published. Error message: 'You cannot change Unit Cost because there are one or more ledger entries for this item. CorrelationId: bb55081b-e1c8-4c7c-872b-4222b2bb3d8d.'
My question is why is it updating a few items, different to the ones I am trying to change?
When I check in Excel it shows as two decimal places aswell and if i format it to show more decimal places its 7.70000000...
Does this Excel Add in and BC communicate differently in the background or am I missing something?