Engrana manual

Contents › Settings

Go-live: initial data

In short

Transferring data from the previous program, once, when you start with Engrana. The steps go in order: customers and suppliers → customer vehicles → items → retail prices → opening warehouse stock → opening debts. At the bottom: the stock reconciliation and the list of opening debts.

Why it matters

  • Start working with your own customers, vehicles, items, stock and debts instead of an empty program.
  • Check that stock and debts match the previous program.

Who can

The screen is shown to the administrator and to an employee with a role for the whole company (not one branch), if they have permission for at least one step: customers, vehicles, items, goods receipt or opening debts — for example, Finance / accountant sees "Go-live" for the opening debts. Each step needs its own permission (customers, vehicles, items, goods receipt, opening debts).

How to do it

  1. Every upload works the same way. "Upload file" → "Download template" → fill it in → "Choose file (CSV, TXT or XLSX)". First the program only checks the file: "Check: nothing has been saved yet" and a list of errors by line. Then "Apply: save N": lines with errors are skipped, the rest is saved.
  2. Order matters. Customers and suppliers first, then their vehicles (the owner is found by the customer code). Items first, then prices and stock. Debts after customers and suppliers.
  3. Stock — quantity and cost on the count evening, into the workplace warehouse.
  4. Reconciliation. In "Reconciliation with the previous program", the stock value at cost must match the previous program.
  5. Opening debts. A customer debt of the workplace branch is paid right here with "Take payment" (needs the payment permission); a debt to a supplier via "Open invoice", paying it in "Purchases".

Common messages

  • "Columns not recognised and not loaded: …" — the column names differ from the template: fix the headers.
  • Errors by line — fix those lines in the file and upload it again. Uploading again creates no duplicates.
  • "no warehouse" — the workplace has no warehouse: pick a branch with a warehouse at the top.
  • "no permission" — your role does not allow this step.

Questions and answers

How do I correct opening stock uploaded with a mistake? Not by uploading again: if an item already entered comes with a different quantity or cost, the line fails: "Opening stock for this item has already been entered (… at …) — correct it with a receipt or a write-off." Correct it with an ordinary receipt or write-off in "Warehouse".

Does opening stock change retail prices? An item without a retail price gets one from the company's pricing policy (if one is set), based on the cost in the file, as on a first receipt. For an item that already has a price, opening stock does not change it, so upload retail prices before stock.

Can customer advances be uploaded? No: the debt amount must be above zero, otherwise "The debt amount must be above zero: advances are not loaded." Settle advances in the previous program.

What date do opening stock and debts get? Stock gets the upload date; debts get the invoice date from the file (empty means today; a future date fails the line). Documents cannot be posted in a closed period, so upload before the period is closed.

Who can enter supplier debts? Someone with permission for both supplier invoices and supplier payments: the administrator, Finance / accountant or a branch manager with a company-wide role. A purchaser has no supplier payment permission: the debts step shows "no permission", and a supplier line in the file fails with "No permission to enter supplier debts."

Where next

  • "Customers", "Warehouse", "Purchases" — working with the transferred data.
  • docs/GO_LIVE.md — the detailed go-live plan.