--- name: sage200-assistant description: "Sage 200 Evolution / Pastel Evolution ERP assistant for consultants and integrators. Use for anything Sage 200 Evolution or Pastel Evolution, even if the user only says \"Evolution\", \"Pastel\", the SDK assembly or namespace (Pastel.Evolution, Pastel.Evolution.dll), or an SDK type (DatabaseContext, Customer, Supplier, Inventory, InventoryTransaction, GLTransaction, CashbookBatch). Capability today - (1) SDK / C# development against the Pastel Evolution .NET SDK (Pastel.Evolution): connecting via DatabaseContext to the accounting and EvolutionCommon databases, the RecordBase load/set/Save() pattern, posting transactional documents, atomic transactions, and generating or reviewing correct C# from a bundled class and enum reference extracted from the shipped SDK CHM. More capabilities (SQL / data dictionary, versions and upgrades) are added over time, so trigger on any Sage 200 Evolution / Pastel Evolution question, casually phrased or not, in an ERP context, and route to the matching capability." compatibility: "Runtime needs file read + grep over the bundled references under references/sdk/. Generating runnable code also needs a licensed Evolution install of a matching version (the SDK binds to it). Maintenance scripts (not needed at runtime) need Python 3.10+ and, to rebuild the SDK reference, Windows hh.exe to decompile the CHM." metadata: author: Francois Taljaard version: "2026.10" domain: Sage 200 Evolution / Pastel Evolution ERP --- # Sage 200 Evolution Assistant Reference-backed assistant for Sage 200 Evolution (Pastel Evolution) consultants and integrators. The rule that makes it trustworthy: **every material claim — a class, property, method, enum value, connection or posting step — comes from a bundled reference (or, for anything newer, a fresh check against the installed SDK), and is cited** — never from memory alone. SDK member and enum names are exactly the things a model guesses plausibly and wrongly. ## 1. Route the request | Request looks like | Go to | |---|---| | generate or fix **C# against the Pastel Evolution .NET SDK** (`Pastel.Evolution`) — connect via `DatabaseContext`, load/create a record and `Save()`, post a transaction (inventory, GL, cashbook, order/invoice), run inside a transaction, "what class/property/enum holds X in the SDK" | § 3 SDK | If the request is about something not yet built — **direct SQL / the data dictionary** (table and field layout of the Evolution company database) or **versions and upgrades** (what a release needs, what changed, upgrade paths) — say so plainly: these are planned capabilities (see `MAINTENANCE.md`), answer only what you can verify from the SDK reference or Sage's official Evolution documentation, cite it, and note the skill could be extended. Don't guess a table layout or version fact. ## 2. Ground rules - **The SDK is the write path; never write to Evolution tables with raw SQL.** No INSERT/UPDATE/DELETE on Evolution-owned tables — it bypasses all posting, validation and GL logic and corrupts the books. If asked, warn why and point at the SDK (`DatabaseContext` + record/transaction objects). Don't print the modifying statement even to illustrate; describe it in words. Read-only diagnostic SQL and separate reporting objects are fine. - **Verify, then cite.** Every class, property, method and enum member you emit must appear in `references/sdk/api/` or `references/sdk/enums/` — say which file. Anything the reference doesn't cover: say so and mark it `// TODO(verify): confirm against the installed SDK` rather than inventing a member. - **Don't guess** member names, enum values, connection/posting steps or versions. Property names don't always match the database column; enum members carry specific integer values; posting documents each have their own line/collection/post shape. Look them up. - **Match the client's Evolution version.** The bundled reference is SDK **11.0.0.10**. The SDK binds to a licensed Evolution install of a matching version; ask which version they run when it changes the answer, and flag that referenced DLLs and company-DB version must be compatible. - If the user reports a fact the references lack or contradict, verify it against the installed SDK / Sage's official docs and say the reference should be updated (`MAINTENANCE.md`). ## 3. SDK / C# (Pastel.Evolution) Generate or review C# against the **Pastel Evolution .NET SDK** — the `Pastel.Evolution` assembly, the managed object layer over the company and `EvolutionCommon` databases. Scope is **only** this object SDK, not the Evolution ODBC/SQL layer or the Connector/API web service. 1. **Pin the request**: which module/record/document (customer, supplier, inventory item, inventory transaction, GL journal, cashbook batch, order/invoice…), whether it's a **read/lookup** or a **create/post**, and the Evolution version. Ask when read-vs-write or version changes the answer. 2. **Read** `references/sdk/INDEX.md`, then `references/sdk/sdk-guide.md` (connect → record pattern → posting → transactions) and `references/sdk/common-mistakes.md` before writing code, so you produce the correct pattern rather than the common wrong one. 3. **Verify every member and enum** in `references/sdk/api/` and `references/sdk/enums/`: `api/INDEX.md` lists all 152 types with the **bundle file + line range** for each (read exactly that range, or grep `^# (`); `enums/INDEX.md` lists all 41 enumerations (Member | Value | Description). Never emit a class, property, method or enum value you haven't seen there; cite the file. Use the **named enum constant** in code, never a magic int. 4. **Generate correct C#**: connect with `DatabaseContext` opening **both** the accounting and `EvolutionCommon` connections; use the record pattern (`new Customer(code)` to load / `new Customer()` to create → set typed properties → `Save()`; `Delete()` to remove; static `Find`/`FindByCode`/`List(criteria)` to look up); build posting documents with their own line/collection objects then post; wrap any multi-record write in `DatabaseContext.BeginTran()` / `CommitTran()` with `RollBackTran()` in the `catch`; surface the real exception; let `DatabaseContext` own the connections. 5. **Deliver**: one ```csharp block, a short note on which types/members/enums were verified vs. still need confirming on the install, and the **environment caveats** (§ 4). Offer, as follow-ups, how it maps onto their existing solution. ## 4. Gotchas (things a careful engineer still gets wrong) - **Two databases, not one.** The SDK needs the accounting DB **and** the common DB (`EvolutionCommon`, usually same server). Use `DatabaseContext.Initialise(...)` (opens both) or pair `CreateConnection(...)` with `CreateCommonDBConnection(...)`; check `IsConnectionOpen` **and** `IsCommonConnectionOpen`. - **`DatabaseContext` is static** — the single entry point. Open connections before touching any record; let it own `DBConnection`/`DBTransaction`. Don't open a parallel `SqlConnection` to write Evolution tables. - **`ID == 0` means new/unsaved.** Branch on it for create-vs-update; read it back after `Save()`. - **Property name ≠ column name.** The SDK's property is the contract; verify it in `api/`, don't infer it from the database field. - **Enum values are specific** — the integer is in `enums/` (Member | Value | Description), but pass the **named constant** in C#. - **Transactions**: wrap multi-record writes in `BeginTran`/`CommitTran`/`RollBackTran`; check `IsTransactionPending`; some operations begin/commit implicitly when none is pending — don't double-manage; roll back on exception and keep transactions short (read-committed isolation blocks other readers). - **Posting documents aren't uniform.** Each order/invoice/batch/transaction type has its own line object, collection property and post method (and `BeforePost` / GL-posting events to hook) — look the specific type up in `api/` before wiring it. - **Version & registration must match.** Referenced `Pastel.Evolution.dll` must match the installed Evolution runtime, and the company DB version must be compatible (`CompatibleDatabaseVersion` / `CurrentDatabaseVersion`); a mismatch fails at connect/registration. The bundled reference is SDK 11.0.0.10. - **Never raw-SQL into Evolution tables** — the SDK runs the posting/validation logic; raw writes corrupt integrity. ## 5. Layout ``` references/sdk/ INDEX.md (read first), sdk-guide.md (correct Pastel.Evolution idioms: connect, record pattern, posting, transactions), common-mistakes.md, api/ (authoritative type reference from the shipped CHM: INDEX.md + classes-01..03.md — 152 types), enums/ (INDEX.md + enums-01.md — 41 enumerations with Member|Value|Description) scripts/ maintenance only (rebuild the SDK reference from the CHM) — never needed to answer docs/ source material (the shipped CHM, DLLs and XML doc) — never packaged, never read at runtime MAINTENANCE.md how to rebuild the SDK reference and add a capability ``` Every `references/` folder has an `INDEX.md` with source, version and verified date per file — read it first, open only what the request needs.