Skip to content

What if I both buy from and sell to someone?

In the ERP, customer and supplier aren’t two different things: they are two roles of the same record, the business partner. That explains two surprising things: that a customer and a supplier can have the same code without clashing, and that deleting a customer can also affect its supplier side.

Can a customer and a supplier have the same code?

Yes. The code doesn’t identify the business partner: it identifies the business partner within a role.

Customer 0001 and supplier 0001 are different codes for the program and exist side by side without any problem. When you add a customer, the repeated-code warning only looks among customers; for a supplier, only among suppliers.

This is intentional. Customer and supplier files usually come numbered separately, each one starting from 0001, and forcing them to share numbering would mean renumbering one of the two.

Is the data shared if they are a customer and a supplier at the same time?

Not today, in practice. The model allows it —the same business partner can have the customer role and the supplier role at the same time, with a different code in each—, but the screens don’t offer a way to do it.

New customer always creates a new business partner. So does New supplier. There is no button that says ‘this customer is also a supplier’.

So if you both buy from and sell to a company, today you end up with two records: one in Customers and another in Suppliers. The common details (Tax ID, address, phone) have to be typed and kept up to date in both.

So what happens with their price conditions?

Sales and purchase conditions are separate from the start, and will stay that way when the two records become one.

Each business partner has at most one sales price list —the one you see on the Price lists tab of their customer record— and one purchase price list —the one on their supplier record—. The discount you give them isn’t confused with the one they give you.

It is explained in detail in set prices and price lists.

Are the custom fields the same for customers and suppliers?

The names are, the values aren’t.

The five custom fields are named only once, in Settings, section Custom fields on customers. Those five names appear the same on the Details tab of the customer record and of the supplier record. There is no separate list of names for suppliers, and there doesn’t need to be: they are your company’s open fields, not a role’s.

What you write in them does belong to each record. A customer and a supplier can have different contents even though the box has the same name in both places.

What happens if I delete a business partner that has two roles?

The whole record is deleted, with all its roles.

Delete on the customer record doesn’t only remove the customer role: it removes the entire business partner, with its addresses, its contacts and its other roles. Before deleting it, all its price list conditions are withdrawn, both sales and purchase ones.

As long as the screens create one record per role, you won’t notice this: each record is a different business partner. When the same business partner has both roles, it will matter.

If you just want to stop working with someone, don’t delete them: change their Status.

Why doesn’t the customer list find a supplier, and vice versa?

Because each list filters by its role. Customers shows business partners with the customer role and Suppliers those with the supplier role.

If you search for someone in Customers and they don’t appear, they may exist in the system but only as a supplier. Look for them in Suppliers too.

The search in the customer selector on a sales document works the same way: it only offers business partners with the customer role.

If something goes wrong

What you seeWhat has happenedWhat to do
A repeated-code warning you don’t understandAnother business partner with the same role already uses that codeCheck the list for that role, not the other one
The same Tax ID on two recordsThey are two different business partners: one a customer, the other a supplierThat is what to expect today. Keep the details up to date in both
You change the address in Customers and in Suppliers the old one is still thereThey are separate recordsChange it in the other one too
You delete a customer and purchase conditions disappearDeleting withdraws the price lists of all its rolesIf the record had both roles, don’t delete it: change its Status

See also: Add a customer · Add a supplier · Set prices and price lists

More about Records