How do I change the length of codes?
The length of a code is how many digits it has: with 5, customer 12 is
00012; with 9-digit sub-accounts, customer 2’s account is430000002. Changing it regenerates the codes that already exist, so that they all have the same format and can still be found.
Which lengths can be changed?
Six, and all six are regenerated:
| Length | Where it is changed | What is rewritten |
|---|---|---|
| Sub-accounts | Settings → Transfer → Sub-account digits | The posting accounts and every place where one is written: the account on the customer, supplier and sales agent record, the item’s purchase and sales accounts, those of the VAT rates, fixed assets, predefined journal entries and default accounts |
| Customers | Settings → Codes | The customer code, the tablets’ customer ranges and the POS immediate-payment customers |
| Suppliers | Settings → Codes | The supplier code |
| Sales agents | Settings → Codes | The sales agent code and the tablets’ sales agent |
| Items | Settings → Codes | The item code, those of its sizes and colours and the travel item on service reports |
| Payment methods | Settings → Codes | The payment method code and the default methods for documents and POS |
Journal lines, balances, documents and receipts don’t move: they are linked to the record, not to its code. A customer’s ledger account doesn’t change either when you change the customers’ length: it comes from their digits, and 00012 and 000012 are the same customer 12.
How do I do it?
- Type the new length in its field.
- A notice appears: You have changed the length of…. Click See what changes.
- The table shows, for each record type, how many codes change, how many stay unchanged (those with letters, the grouping levels of the chart), how many references are corrected, and an example.
- Click Regenerate codes and confirm.
Until you do, the settings aren’t saved: saving without regenerating would leave the old codes in the previous format and they could no longer be found.
What does ‘free’ mean in the length?
That the code isn’t padded with zeros: it is saved and searched exactly as typed. You enter 0 in the field. Switching to free doesn’t rewrite any code: the ones you already had stay as they were.
Items without padding can also have a Maximum item code length, on the same screen. A new or changed code that is longer isn’t accepted; the ones already saved are kept. This is what the Desktop ERP does with ‘Do not format codes’, and the migration copies it from there. With 0 there is no maximum of its own (up to 30 characters). With padding it isn’t used: the length decides.
And if I haven’t changed anything but some codes are wrong?
Use Normalise codes, on the same screen. It brings codes that aren’t in their correct format into it, without changing any length: an 8-digit sub-account in a 9-digit chart, a customer saved without its zeros. It often happens with data that comes from another program.
What does ‘It cannot be done’ mean?
That two records would end up with the same code, or that a sub-account doesn’t fit in the new length (when shortening it, only zeros can be removed: 43012345 doesn’t fit in 7). Nothing is changed. The table names the codes: correct them and try again.
A code that was already wrong and that would clash with another when regenerated doesn’t prevent it: it stays as it is and the table warns you. It is usually a repeated account (570000 alongside 570000000); the chart review, in Accounting → Accounts, helps you decide which one to keep.
And when migrating from the Desktop ERP?
The migration does the same before importing: it sets your company to the Desktop ERP’s lengths and regenerates what you already had. It shows you and asks you to confirm: migrate from Powergest.
Is there anything that isn’t regenerated?
Yes, and the table warns you when it applies:
- The formulas of the balance sheet, the profit and loss account and the notes to the accounts use group prefixes (
430,57) and don’t change. If you wrote a full sub-account in any of them, check it. - The tablets keep the codes that were sent to them: they receive a full upload with the new ones.
- An online store that keeps the item code as a reference needs a full synchronisation.
- The length of the document number and the series isn’t regenerated: the numbers of issued invoices can’t be changed.
More about Records
- 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
- The records the whole ERP works with