x Want to participate? Join the group to interact
New

Open for voting

Amend Customer or Supplier Account Reference

We have suppliers or customers that change their name and although you can change their name in the name field you are unable to change their actual account reference.

This would be useful especially as we have Sage linked to another sys

Sophie Steward
Parents

  • It looks like this is a merge of:

    • Amend Customer Account reference
    • Amend Supplier Account reference
    • Amend Product code
    • Amend Nominal code

    The First two are desirable from a change in name (or just to fix a bad account name) without losing history

    The last two are desirable when rationalising product codes and the COA  to avoid losing history.

    Can I guess from the merge that Sage are possibly working on converting their database to use a hidden internal unique number which never changes to be the primary linking key and thus allowing the current key to be a changeable field which the user can still search?  (Or am I living in fantasy land.)

Comment

  • It looks like this is a merge of:

    • Amend Customer Account reference
    • Amend Supplier Account reference
    • Amend Product code
    • Amend Nominal code

    The First two are desirable from a change in name (or just to fix a bad account name) without losing history

    The last two are desirable when rationalising product codes and the COA  to avoid losing history.

    Can I guess from the merge that Sage are possibly working on converting their database to use a hidden internal unique number which never changes to be the primary linking key and thus allowing the current key to be a changeable field which the user can still search?  (Or am I living in fantasy land.)

Children
No Data

*Community Hub is the new name for Sage City