Unique data fields

I’m with you.

Here’s another option:

Set your accounting to CRM up so that every time you add a customer to your accounting software it automatically puts them into your CRM in an app called ‘Backend’ for example, so the unique ID and the rest of the details always matches your accounting software as they’re pulled from there rather than created in Fibery. You’d then have a ‘Customers’ app that has a lookup field for the unique ID from the ‘Backend’ and a linked record field to add new customers that you want in your system so the ‘Backend’ app that matches your accounting software would never need to be opened, it would act as a backend link between them so you’d never be able to duplicate a record as you can create a one-way direction with a link record so you’ll never duplicate. All their data could be pulled in from accounting too like balance etc and linked to your bank so every payment they or you make would show in your CRM.

You’d set it up so that any supplier, contact or any entity would be pulled from your accounting into the ‘Backend’ app of Fibery so you’d never ever make a mistake or need to check them. All your data from Fibery and your accounting software on any individual or company you choose would all be in one place, the ‘Backend’ app that you back up regularly.

You’d then restrict all access to the ‘Backend’ app so your staff (if any) can only view the ‘Customers’ app, if that’s all you’d want them to see. You could then create a Suppliers app or view and repeat for suppliers if you wanted them separate or don’t include them at all.

If you wanted to add customers that aren’t in your accounting system you can do so by going into the Backend app and adding it yourself.

Could this possibly work for you?