I am in the process of transitioning a customers orders and invoices to EDI.
I am trying to populate the customers ‘Customers Own Address ID” field. The customer has 10 sites and have provided their ‘location codes’ that we need to use in the EDI submissions when we invoice them. Their sites are simply numbered 1-10.
Most of the sites allow me to add the appropriate site number in but a couple of them (1 and 5) give the following error when I try to save the record:
This customers own address id already exists on another address for this customer or another customer
I have checked through each site for the customer and none of the other sites have the Customers Own Address ID set to 1 or 5 (they all have their own numbers of course) so looking at the error, I am reading it as if ANY other customer has this field set to 1 or 5 then I cannot use these values. Surely this can’t be right? Is it really saying that the value in this field must be unique throughout all our customers despite it being the ‘customers own’ address ID?
Any ideas or direction on this would be much appreciated.
Best answer by william.klotzView original