Blog
Infor SyteLine and Epicor Kinetic guides
Practical fixes for the reports, background tasks and data problems that fill every ERP backlog. SyteLine guides are written from three years in-house on SyteLine; Epicor Kinetic guides cover BAQs, SSRS reports, BPM, the REST API, DMT and security.
Free SQL diagnostic scripts and checklists: read-only checks for blocking, slow reports and master data.
Infor SyteLine guides
Start here The SyteLine report and data backlog: a practical guide to clearing it and keeping it clear Why SyteLine report, data and support tickets pile up, the seven types of ticket in every backlog, a triage method that closes a third of them without development, and how to keep the backlog from growing back. Links to every Clear Cutover SyteLine guide.- TroubleshootingWhy Won't My Job Close in SyteLine? Common Reasons in Plain EnglishA SyteLine job that won't close usually has unposted transactions, open purchasing, or unreceived output. Here's what to check and how to close jobs cleanly.
- Data and SQLItem vs Item-Warehouse in SyteLine, Explained Like You're Starting TomorrowItem, item-warehouse, and item-location records in SyteLine explained in plain English: what each holds, why on-hand isn't available, and nettable locations.
- TroubleshootingMade a Mistake in SyteLine? How to Fix Errors SafelyMade a mistake in SyteLine? Work out whether it's saved, posted, or in a closed period, reverse it properly, check what it touched, and leave a clean trail.
- Upgrades10 Questions to Ask Before You Upgrade SyteLinePlanning a SyteLine or CloudSuite Industrial upgrade? Ten questions on customizations, integrations, testing, cutover timing, and rollback to ask first.
- Working with a contractorIs SyteLine Too Big for a Small Manufacturer?Is SyteLine overkill for a small shop? How to judge fit by process complexity and ownership rather than headcount, with signs for and against.
- Working with a contractorWhat Actually Drives the Cost of a SyteLine Implementation?SyteLine implementation cost depends on scope, data quality, customizations, integrations, and your team's time. Here's where the effort goes and what to ask.
- Processes12 Things to Know Before Your First SyteLine Go-LivePreparing for a SyteLine go-live? Twelve practical lessons on data, open WIP, inventory counts, testing exceptions, cutover timing, and the first weeks.
- Working with a contractorSyteLine vs Spreadsheets: 6 Signs It's Time to Leave ExcelIs your manufacturing business outgrowing Excel? Six signs it's time to consider SyteLine or another ERP, and what an ERP will and won't fix.
- CustomizationCustomize or Configure? How to Avoid Over-Customizing SyteLineShould you customize SyteLine or configure it? The supported customization tools, five questions to ask first, and how to keep changes under control.
- TroubleshootingSyteLine report stuck in WAITING, or no PDF in the output folder: a troubleshooting checklistWhy a SyteLine report stays in WAITING or READY, finishes with no PDF, or never appears in Background Task History, and how to check each link in the chain: TaskMan, the Event Service, Report Options and the output folder.
- TroubleshootingWhy a SyteLine task runs for days: one wrong range, and invoicing stopsA real SyteLine 9 case: a packing slip run entered with a mistyped order range ran for days and only showed up when invoicing stopped. How to spot it, confirm the blocking in SQL Server, recover safely, and stop it happening again.
- PerformanceWhy your SyteLine report is slow: T-SQL tuning for AR aging and other heavy reportsA step-by-step method for finding why a SyteLine report takes minutes instead of seconds: queue vs SQL vs rendering, reading the execution plan, the usual culprits (cursors, scalar functions, non-SARGable dates, missing site_ref), and safe ways to fix them without breaking upgrades.
- Data and SQLSyteLine SQL table cheat sheet: _mst vs _mst_all, site_ref, and the tables behind orders, items and jobsA practical map of the SyteLine (CloudSuite Industrial) SQL Server database: what the _mst and _mst_all suffixes mean, why your queries need site_ref, the core tables for sales, purchasing, inventory and production, and three starter queries.
- AutomationHow to schedule a SyteLine report or utility to run automatically (Background Queue)Step-by-step: schedule a SyteLine report or utility daily, weekly or monthly from the Background Queue, keep date parameters moving with each run, email the output, and check that scheduled tasks actually run.
- AutomationSyteLine Background Task Definitions explained: run a report, stored procedure, program or IDO method in the backgroundWhat the SyteLine Background Task Definitions form does, the four executable types (RPT, SP, EXE, IDOMTH), how to find what a report actually runs, and how a custom program should report errors back to Background Task History.
- AutomationSyteLine Workflow Event Handlers: set up email notifications, and change the message safelyHow to switch on SyteLine's built-in workflow notifications (new customer, PO due date changed, PO line received and more), send them by email or to the Inbox, and safely change the message text using Copy for Modification.
- ReportingSyteLine reporting options: DataViews, Report-type forms, SSRS and Crystal, and which to useWhich SyteLine reporting tool fits which request: DataViews for lists, Report-type forms for fixed-layout documents, standard reports, SSRS (now deprecated for custom reports), Crystal (legacy) and external BI, plus a triage rule that shrinks the backlog.
- ReportingMoving off Crystal Reports in SyteLine: retire, replace, or rebuild as a Report-type formA phased plan for retiring custom Crystal Reports in SyteLine: inventory and cut, check standard reports and DataViews, rebuild the data logic, choose Report-type forms (Infor's current recommendation, as custom SSRS is now deprecated), prove the output matches, and switch over.
- Working with a contractorHow to scope a SyteLine report or change request for a fixed price (without getting burned)What to put in a SyteLine report, data or form request so any contractor can quote a fixed price: the eight things to include, a copy-ready template, how to define 'done', and the warning signs of a scope that will blow out.
- SecurityA practical SyteLine security audit: users, groups, permissions and passwordsA hands-on checklist for auditing SyteLine security: leavers and shared accounts, Super User and developer rights, group authorizations, who can open the Users form, password parameters, and testing the login and password screens the way a real user would.
- Working with a contractorSyteLine consultant rates in 2026, and how to hire the right oneWhat SyteLine (CloudSuite Industrial) help costs in 2026, with sourced public benchmarks, what drives the rate, hourly vs fixed price, and a checklist for hiring the right person for reports, support or an upgrade.
- UpgradesUpgrading SyteLine 9 to CloudSuite Industrial 10: the report and customization checklistA practical checklist for the part of a SyteLine 9.x to CloudSuite Industrial 10 upgrade that usually goes wrong: custom reports, forms, IDOs, stored procedures, background tasks and integrations. Inventory, test-upgrade, compare, cut over.
- CloudReporting in CloudSuite Industrial cloud without direct SQL: what to use insteadMoving SyteLine to multi-tenant CloudSuite Industrial means no direct SQL. Which reporting option replaces which old habit: DataViews, Report-type forms, standard reports, the IDO REST API, and the Infor Data Lake, plus how to inventory what will break.
- Data migrationSyteLine data migration: extract, cleanse, map and validate before every loadA practical method for moving data into or out of Infor SyteLine: what to migrate, the cleansing that matters (items, BOMs, customers, vendors, open orders), a mapping workbook, SQL validation checks before every load, and the reconciliation that proves it worked.
- Data migrationSyteLine go-live and cutover checklist: what to prove before the switchA go-live checklist for SyteLine implementations, upgrades and migrations: readiness criteria, the freeze, a timed cutover runbook, the checks to run before users log in, a go/no-go decision, rollback, and the first week of hypercare.
- TroubleshootingSyteLine freezing for everyone? Find the SQL head blocker, and stop deadlock error 1205When SyteLine hangs for every user, the cause is usually one SQL Server session blocking the rest. How to find the head blocker, confirm what it is before killing it, read deadlock error 1205, and stop both from coming back.
- TroubleshootingSyteLine 'An error has occurred during report processing': how to find the real causeThe generic SSRS message hides the real error. How to get the full error text in SyteLine, the five causes behind most report processing errors (data source, stored procedure, parameters, RDL changes, permissions), and how to fix each one.
- TroubleshootingSyteLine 'row has been modified by another user': what it means and how to stop itWhy SyteLine refuses to save with 'this row has been modified by another user since you began editing it', the usual triggers (two users, forms left open, background tasks, integrations, direct SQL), and how to make it stop.
- Data and SQLConnecting Power BI and Excel to SyteLine safely: read-only SQL views that don't slow anyone downHow to give Power BI and Excel SyteLine data on-premises without risking production: a read-only login, reporting views in a separate database or schema, correct joins on the _mst tables, refresh timing, NOLOCK, and upgrade checks.
- Data and SQLHow to find the SQL table and column behind any SyteLine form fieldFour ways to answer 'which table is this field in?' in SyteLine: follow the form's IDO and property binding, search the database columns, trace what the form queries, and handle derived fields that aren't stored anywhere.
- TroubleshootingGet an email when SyteLine is blocked: a simple SQL Server blocking alertA small SQL Server Agent job that checks every few minutes for sessions blocked longer than a threshold on the SyteLine database and emails the details, so a stuck task is caught the same morning instead of days later.
- ReportingSyteLine SSRS report errors and slow reports: how to read the SSRS execution logHow to use the SQL Server Reporting Services execution log (ExecutionLog3) to see which reports failed, why, and where the time went: data retrieval, processing or rendering.
- ReportingSyteLine Report Options explained: PDF, Excel, printer and email output, and why reports go to the wrong placeHow SyteLine decides where a report goes: the Report Options form (output format, printer, email notification, attach report), the Intranets form fallback, Excel output for reports without a DataView, customer and vendor document profiles, and the output folder.
- SecuritySet up a read-only SQL Server login for SyteLine reporting (Excel, Power BI, SSRS)How to give Excel, Power BI and report writers safe, read-only access to SyteLine data: Windows group vs SQL login, which permissions to grant, the cross-database catch with reporting views, and how to test it can't write.
- TroubleshootingHow to find and clear orphan user sessions in SyteLine (and stop them coming back)Why SyteLine leaves frozen sessions after crashes and dropped connections, how to clear them safely in Session Management, why you must never delete $service sessions, and how 'Minutes to close orphan sessions' cleans them up automatically.
- TroubleshootingSyteLine 'Locked' message: how to safely unlock functions and journalsWhy SyteLine says a function or journal is locked, how to confirm the process really stopped, when to use Unlock Locked Functions or Unlock Locked Journals, and why Crash Recovery is the last resort.
- Data and SQLHow to mass update records in SyteLine without SQL: Replace Value in CollectionUse SyteLine's Edit > Replace Value in Collection to change a field across many records safely: filter first, beat the 200-record cap, avoid the partial-match trap, and check the result.
- Data migrationLoad data from Excel into SyteLine with Paste Rows Append (without breaking anything)How to paste many records from a spreadsheet into a SyteLine form with Edit > Paste Rows Append or Paste Rows Overwrite: matching the grid's column order, answering validation prompts, batching, and the traps that put data in the wrong field.
- IntegrationConnecting external systems to SyteLine with the Mongoose IDO REST APIHow SyteLine's Mongoose REST API works: getting a security token, loading IDO collections with filters, record caps and paging, updating records with the Action/ItemId/Properties format, calling through ION API, and integration habits that avoid trouble.
- CustomizationWhy SyteLine form changes disappear: Site, Group and User versions explainedWhy a SyteLine form change shows for you but not for others, or vanishes after an upgrade: the Vendor, Site, Group and User versions, setting editing scope in Design Mode, basic vs major changes, reverting, and FormSync.
- CustomizationSyteLine form scripts for validation: catch bad input before it becomes a ticketWhen to use a validator, a form script or an IDO-level rule in SyteLine, how a Run Script event handler passes parameters and signals failure, a worked example that catches a mistyped order range, and the habits that keep scripts maintainable.
- ProcessesSyteLine customer order to invoice: the full flow, step by step, and where it gets stuckThe SyteLine customer order cycle from entry to invoice: Customer Orders, lines, credit checks, ATP/CTP, shipping, packing lists, Order Invoicing/Credit Memo and posting to AR, plus the usual places it stalls.
- ProcessesSyteLine purchase order to voucher: the full flow, and why a PO won't voucherThe SyteLine purchasing cycle step by step: PO header and lines, Purchase Orders Quick Entry, receiving on Purchase Order Receiving, creating vouchers with Generate A/P Transactions, A/P Vouchers and Adjustments or Voucher Builder, posting, and a checklist for POs that won't voucher.
- ProcessesHow to run a cycle count in SyteLine, step by step (and the mistakes that cause variances)The SyteLine cycle count process from Cycle Count Setup to Cycle Count Posting: Item/Warehouse settings, generating count sheets, entering counts, the variance report, exceptions, and how to avoid the common mistakes.
- ProcessesSyteLine cost rollup explained: Current BOM Cost Roll Up and rolling current cost to standardHow SyteLine builds item costs from routings and BOMs, the right order to run Current BOM Processor, Change Cost Rates and Current BOM Cost Roll Up, what gets skipped, and when to roll current cost to standard.
- PlanningSyteLine MRP vs APS vs Infinite APS: which planning mode, and what each one actually doesHow SyteLine's three planning modes differ: MRP plans by BOM level and ignores capacity, Infinite APS plans demand by demand against shift time, APS plans against real resource availability. Plus ATP/CTP, Plan on Save, and common surprises.
Epicor Kinetic guides
Start here The Epicor Kinetic report and customization backlog: a practical guide to clearing it, and keeping it clear Clear your Epicor Kinetic report and customization backlog: triage incoming requests, choose the right architectural layer, and stop technical debt.- TroubleshootingEpicor Kinetic blank or white screen: causes, fixes, and what to send to supportEpicor Kinetic blank screen or stuck on a spinner? Discover root causes (cache, MetaUI, personalizations), step-by-step fixes, and admin recovery steps.
- TroubleshootingEpicor Kinetic AR/AP posting stuck in process or in the Review Journal: a safe recovery guideEpicor Kinetic AR/AP invoice group stuck in Posting or Reviewing? Clear the Review Journal, release group locks and find missing GL accounts safely.
- TroubleshootingHow to fix an Epicor Kinetic report stuck in ACTIVE (or finished with no PDF)Kinetic report stuck in ACTIVE or no PDF? Isolate the Task Agent, SSRS, output path and Edge Agent (port 6071) before restarting anything.
- PerformanceHow to fix Epicor Kinetic BAQ and report timeouts: PartTran, TranGLC and heavy subqueriesFix Epicor Kinetic BAQ and SSRS timeouts: PartTran index alignment, TranGLC joins, implicit conversions and slow subqueries.
- ReportingBAQ Report vs. RDD report in Epicor Kinetic: which one should you build on?BAQ report or Report Data Definition (RDD)? Learn how each one works in Epicor Kinetic, how they differ, and which to choose for your custom report.
- ReportingHow to add a field to an Epicor Kinetic SSRS reportAdd a field to an Epicor Kinetic SSRS report: expose it in the RDD, update the RDL query and field list, upload and test safely.
- ReportingConverting Classic Epicor dashboards to Kinetic Application Studio: a phased migration guideMigrate Classic Epicor dashboards to Kinetic Application Studio: understand generator limits, pub/sub grid wiring, uBAQ saves, and pilot verification.
- ReportingWhat is a BAQ in Epicor Kinetic? A plain-English guide for beginnersA BAQ (Business Activity Query) is Epicor Kinetic's built-in query tool. Learn what it does, how it works, and when to use one instead of a report.
- ReportingWhat is an Epicor Tracker? A plain-English guide to Job, Part, Customer and Order TrackersEpicor Trackers are built-in inquiry screens for finding records. Learn what Job, Part, and Customer Tracker show and when you do not need a report.
- Data and SQLEpicor Kinetic SQL schema cheat sheet: Erp vs. Ice, plant boundaries and core tablesEpicor Kinetic SQL schema cheat sheet: Erp vs Ice, PlantWhse and PartCost joins, plus starter patterns for orders, jobs and inventory.
- BPM and automationEpicor BPM email alerts: Method Directives vs. Data Directives, without duplicate emailsConfigure Epicor BPM email alerts using Method and Data Directives without duplicate emails, transaction deadlocks, or DMT bulk email spam.
- BPM and automationMethod Directive vs. Data Directive in Epicor Kinetic BPM: which one do you need?Method Directive or Data Directive? Learn the difference, when each one fires, and how to choose the right Epicor Kinetic BPM directive for your rule.
- BPM and automationWhat is an Epicor Function (EFx)? A beginner's guide to reusable server-side logicEpicor Functions (EFx) let you write reusable server-side logic once and call it from BPM, Application Studio, schedules, and REST API v2.
- CustomizationEpicor Kinetic personalization vs. customization: what is the difference?What is the difference between a personalization and a customization in Epicor Kinetic? A simple guide to Application Studio layers and when to use each.
- IntegrationEpicor Kinetic REST API: v1 vs. v2 explained simplyLearn how the Epicor Kinetic REST API works: v1 vs v2 URLs, x-api-key, Access Scopes, reading BAQs, calling EFx functions, and fixing 401/403 errors.
- AdministrationEpicor Kinetic licences: concurrency, browser sessions and seat typesEpicor Kinetic licences explained: concurrent users, shop-floor and API seats, browser session behaviour and clearing stuck sessions.
- AdministrationHow to reset a password or disable a user in Epicor Kinetic: a practical admin guideEpicor Kinetic user management guide: how to reset passwords, resolve lockouts, and safely disable users without breaking scheduled tasks or approvals.
- AdministrationThe Epicor Task Agent and System Monitor explained: how reports and processes run in the backgroundWhat is the Epicor Task Agent, and what does System Monitor show? Learn how reports and processes run in the background and why tasks stay pending.
- SecurityEpicor Kinetic Change Log: track field changes without hurting performanceSet up audit tracking in Epicor Kinetic with the Change Log: what to audit, what to avoid, reporting on Ice.ChgLog, and limiting growth.
- SecurityA practical Epicor Kinetic security audit: users, Security Manager rights, menu security and REST API accessAudit Epicor Kinetic security: manage Security Manager rights, lock down menu vs process security, secure REST API keys, and test field-level rules.
- Data migrationEpicor Kinetic DMT errors: troubleshooting common failuresFix common Epicor Kinetic DMT errors: schema or column errors, parent record missing, date formats, Add vs Update mode and timeouts.
- FinanceEpicor Kinetic credit hold: how the check worksHow credit hold works in Epicor Kinetic: credit limits, what counts toward exposure, customer vs order holds, overrides and the periodic recheck.
- FinanceEpicor Kinetic costing methods: standard, average, FIFO, last and lotCompare Epicor Kinetic costing methods and learn how receipts post to the GL, how cost buckets work, and how to change a method safely.
- InventoryEpicor Kinetic negative inventory: prevention, costing impact and reconciliationPrevent and fix negative inventory in Epicor Kinetic: causes, settings, finding negative balances, costing impact and reconciliation steps.
- InventoryEpicor Kinetic UOM classes: how conversions work and why transactions lock the inventory UOMHow Epicor Kinetic UOM classes work: Base UOM, Sales and Purchasing UOMs, conversion factors, and why transaction history locks the inventory UOM.
- ManufacturingWhy Epicor Kinetic MRP won't generate jobs: 7 things to checkTroubleshoot Epicor Kinetic MRP: part and site settings, release flags, cutoff dates, time fences, firm jobs and revisions.
- Master dataEpicor Kinetic customers, ship-tos, bill-tos and parent accountsHow customers, ship-to addresses, bill-to customers and parent accounts relate in Epicor Kinetic, and which defaults flow to sales orders.
- Master dataEpicor Kinetic part types: manufactured, purchased, sales kits and phantomsEpicor Kinetic part types explained: manufactured, purchased, sales kits and phantom assemblies, and how each affects inventory, BOMs and MRP.
- Working with a contractorHow to scope an Epicor Kinetic report, BAQ or customization for a fixed priceHow to scope an Epicor Kinetic report, BAQ, or BPM for a firm quote: the eight things to specify, a copy-ready template, and scope warning signs.
Rather have it fixed for you?
Send your SyteLine or Epicor Kinetic tickets for a fixed quote within one business day.