Announcement

Collapse
No announcement yet.

Account References - Sage Link

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Account References - Sage Link

    Our account references are made up of the first 4 letters of the customers surname followed by a / and then three numbers which run in sequence from 000 to 999.
    For example, the first ever 'Smith' to order will have this reference:
    SMIT/001
    Then it would be
    SMIT/002
    SMIT/003
    SMIT/004 etc etc.

    We have now reached SMIT/999 and are having problems importing new customers into sage.

    We have tried deleting the following account references in the hope that new customers will be assigned a reference starting from the next free number available:
    SMIT/001
    SMIT/002
    SMIT/003
    SMIT/004
    SMIT/005
    SMIT/006
    SMIT/007
    SMIT/008
    SMIT/009
    SMIT/010

    But when we try to import the new account details, we receive a message:
    "No sequence numbers left"

    The account is imported with this reference:
    !BPPLA01
    But also with the address details of what was formerly SMIT/001.

    What can we do to remedy this so that the format is still the same for new customers if the number sequence is maxed out?
    We want to avoid changing the way that the references are generated in order to keep uniformity between all accounts.
Working...
X