The records the whole ERP works with

Master data are the base records: the item you sell, the business partner you sell to or buy from, the prices you work with and the currencies you get paid in. Every document in the ERP relies on them, so well-kept master data saves corrections everywhere else.
What do I add first?
The item, because it is what you will type on the lines of any document. It is each thing you sell or buy, and it can be a product with stock or a service. Adding one asks for three fields and is explained in add an item.
Then, the person or company you deal with. If you sell to them, add a customer; if you buy from them, add a supplier. In both cases the Code and the Trade name are enough; the rest is completed when needed.
Why does the code change when I leave the field?
Because it shows you the format it will be saved in. A code that starts with a number is padded with zeros in front up to the digits for its record in Settings → Sales and documents → Codes, and one with letters is put into capitals: for a sales agent with four digits, typing 32 becomes 0032, and ag7 becomes AG7. That way what you see is what is saved, and it is also how it is searched.
This applies to every record with a code: items, item families, customers, suppliers, sales agents, warehouses, payment methods, currencies, bank and cash accounts, cash keys, workers, customer types, routes, trades and carriers. With ‘No formatting’ in Settings → Sales and documents → Codes, the codes of items, customers, suppliers and sales agents aren’t padded: they are saved as you type them, in capitals. Payment methods have their own length, set on that same screen. Sales agents also have their own, which by default is the same as the customers’ one, as in the Desktop ERP.
Changing one of those lengths regenerates the codes you already have, so that two formats don’t exist side by side: change the length of codes.
Which ledger account does each record have?
The one for its code, with the group of its role: customers in 430, suppliers in 400 and sales agents in 465 (these are changed in Settings → Transfer). When you add the record, the account is opened in the chart and written on the record; if you type a different one, the record warns you that it isn’t the one for its code, but lets you save it. The code suggested when adding is the first free gap whose account is free too. Details in add a customer.
Are customer and supplier two separate records?
No. They are two roles of the same record, the business partner. That explains two things that surprise you the first time: that customer 0001 and supplier 0001 exist side by side without clashing, because the code identifies the business partner within a role; and that deleting a customer can also affect its supplier side.
It is worth reading before adding someone you both buy from and sell to: a business partner that is a customer and a supplier.
How do I group customers?
With four short lists you choose from on their record: the customer type, the delivery route, the trade and the carrier. Each has its own screen and is used to group and filter reports: classify customers by type, route, trade and carrier.
Which customers invoice me the most?
In Customers › Customers by turnover you have the ranking of the fifty that have invoiced you the most in the period you choose, with their average ticket, their margin and what they owe you: which customers invoice me the most (in Spanish).
Can my customers sign in to see their own data?
Yes, with the customer portal: a separate area where each customer signs in with their email and password and sees only their own data. In Customers › Customer panel you invite whoever you want, see how their access is going and remove it: give a customer access to the portal (in Spanish).
Can I send a newsletter to my customers from their list?
Yes, if your company has mailing. In Customers (or in Suppliers) you tick whoever you want and click Send a newsletter, or Add to a mailing list… to save them in a list. The Mailing tab on each record shows their email addresses, their lists and the newsletters they have received: mailing for your customers and suppliers.
Do I keep track of my customers’ vehicles?
If you run a garage or sell vehicles, yes: each one with its registration, its customer and its dates, and each document can say which vehicle it is for. It is explained in add your customers’ vehicles.
Where do I put prices?
In two different places, and they aren’t the same thing. An item’s price lives on its record, Prices tab, in six sale levels. A price list is something else: it is the set of price list conditions —discounts or special prices— of a particular business partner. Both are explained in set prices and price lists.
Two things from there are worth knowing in advance. When invoicing, Sale price 1 is always used: levels 2, 3 and 4 are stored, but today they aren’t chosen automatically. And price list conditions are applied automatically when the item on a line is resolved, in a fixed order: the item’s condition beats the item family’s, and only one is applied, the most specific.
How do I work with sizes and colours?
With variants. An item with sizes isn’t split into several records: it is still a single one, with a grid in which each combination —size M, colour red— has its own code, its own description and, if you want, its own price and its own stock.
It takes three steps, in this order:
- Decide for the whole company how many levels there are and which keys exist in each one: set up the company’s sizes and colours. It is done only once, and the order of the levels is best decided before creating the first variant because it goes into each variant’s code.
- Generate the item’s variant grid: add an item with sizes and colours.
- Sell it, which can be done in three ways —typing the variant code, choosing it in a window or filling in a quantity grid—: sell an item with sizes.
The stock of an item with variants is kept per combination and in total, and can be checked both on the record and in the warehouse report: view stock by size and colour.
And if I get paid in another currency?
Then you need the currency record: add a currency. It stores how the currency is written —ISO code, symbol, decimals— and its exchange rate against the base currency, which is the one your company keeps its accounts in.
What difference does filling in master data properly make?
Day-to-day work stops being typing. The item code appears with its price, the customer’s price list condition goes onto the line automatically, the variant is resolved from its combination and amounts come out with your company’s decimals.
That is the split: master data is thought out once, documents are made a thousand times. A detail missing from the record ends up being typed by hand on every document, and that is where the differences appear.
More about Records
- How do I change the length of codes?
- What are trades for?
- What are customer types for?
- How do I classify my customers by type, route, trade and carrier?
- How do I set up my company’s sizes and colours?
- How do I add a sales agent?
- How do I add an item?
- How do I add a customer?
- How do I add a supplier?
- How do I add my customers’ vehicles?
- How do I add a currency?
- Mailing for your customers and suppliers