Sage 200 UKI Ideas Portal

Index Customer Delivery Addresses

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
  • Mar 7 2024
  • Idea Accepted - Gauging Support
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
  • Geoff Turner commented
    14 Mar 07:17am

    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)

  • Nicola Burns commented
    8 Mar 08:37am

    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.

  • Geoff Turner commented
    8 Mar 08:19am

    CustDeliveryAddressID is unique, as is the combination of CustomerID and Description