Automate Daily Sage 50 Invoice Posting
Publicada el 2026-07-21
Descripción de la oferta
I already have sales invoices sitting in our Sage-native database and need them posted automatically into Sage 50 Accounts (UK). Using the Sage 50 COM/SDK, please create a small Windows service or script that runs once a day, reads the un-posted invoices from the same Sage database, posts them, and then flags them as completed so we never hit duplicates. Everything must first be proven on a full copy of the live company file; I want to see successful test runs and logs before anything touches production. Key points you should know while planning the build: • Source format: invoices are stored directly in the Sage database, not CSV, XML, or any external store. • Schedule: the task must trigger daily without manual intervention—Windows Task Scheduler or a similar reliable mechanism is fine as long as it never misses a day. • API: Sage 50 COM/SDK only; no screen-scraping or manual UI automation. Deliverables I expect: 1. Compiled executable or service plus documented source code. 2. Simple configuration file where I can change company path or schedule. 3. Clear deployment notes and rollback steps. 4. Log output that records each posting attempt, success, or error. 5. Short test report proving the routine works on the copied company file. Acceptance criteria: – All sample invoices in the test copy post with correct totals, VAT codes, and nominal mappings. – Duplicate-prevention logic confirmed. – No orphaned or partially posted entries. – Job finishes within a reasonable window (under five minutes on 5,000 invoices). If you have already worked with the Sage 50 COM/SDK and understand its locking behaviour, I’d love to hear how you would approach error handling and future scaling.
Skills
Fuente original: freelancer