Complete customer and supplier records in bulk
Here you complete records that already exist, all at once.
How to
- In Customers or Suppliers, « More actions », then « Export records to complete ».
- In the file, fill in the empty cells. Do not change the Code column: it links each row to its record.
- « More actions », « Update records from Excel », then « Choose the completed file ».
- Read the counts « N records completed, M unchanged, K points to check », the Before / After table and the recommendations.
- Click « Approve », at the bottom of the page.
Learn more
The export holds one row per active record: Type, Code, Name, then tax ID, trade register (RCCM), e-mail, phone, address, city, country, contact and payment terms (in days). Customers also have the invoices and reminders e-mail and the credit limit; suppliers, the IBAN / bank account and the bank. Values already saved are pre-filled. On the way back, each row is linked to its record by type and code, in this book only, and the preview shows only the changes (empty → filled, old → new value).
The recommendations
Nothing is refused wholesale. A malformed e-mail or phone gets a corrected form; a tax ID already held by another third party of the same type lets you choose (do not take it, or save it anyway); an IBAN / bank account value that is not a valid IBAN can be saved as an account number, which you tick yourself. The other fixes are pre-ticked; unticked, that value stays as it is and the row's other values apply. The file's original value is kept in the history.
A code unknown in the book
A row whose code does not exist for its type is offered for creation, unticked by default. Ticked, the third party is created with the row's code, name and values, under the same duplicate checks as the third-party import (same tax ID or same name: not created, the row says which one already exists).
Supplier bank details
Book administrator only, as on the supplier record: for another user, the IBAN / bank account and Bank columns are exported empty and ignored on the way back. The import only fills empty bank details: to change an existing account, or take an account another supplier already holds, use the supplier record. In the history, the numbers are masked.
Frequently asked questions
No. An empty cell erases nothing until you tick « clear » on that line.
No. The Name column helps you find your way; rename a third party from its record.
Rows are saved in chunks of 200, each in one go. Chunks already saved are kept: import the same file again, the rows already up to date count as unchanged.