If a primary key ID is added to the Customer Delivery Addresses data table, it could then be possible to overwrite / replace records using an upload based on matching record ID.
Nicola Burns
| Idea Benefit | To enable simply data cleanse |
| How do you solve for this problem today? | I cannot find a current work around other than manual manipulation of records one at a time |
| Product Variant | Sage 200 Professional |
Actually I have done a desktop list for delivery addresses that includes an import that will add or update addresses - see attached screenshot. Contact me geoff.turmer (at) gtsagedev.co.uk
Attachments Open full size
Are you aware of a process to download, update and cleanse then upload Delivery Address data please Geoff?
Once I have updated the exported data I have only managed to add rather than overwrite when uploading.
Attachments Open full size
CustDeliveryAddressID is unique, as is the combination of CustomerID and Description
Attachments Open full size