Skip to content

Systems and records

Infor SyteLine history: what to archive when upgrading to CloudSuite

By SourceX Editorial · Updated

Short answer

Before a SyteLine to CloudSuite Industrial migration, archive the closed history the new system will not carry: completed jobs with routings, materials and labor transactions, quality records, closed customer and purchase orders, and lot and serial trails. Many cutovers convert only open transactions and master data, so take a full, verified copy of the old database first.

Key takeaways

  • Conversion scope is agreed with Infor or the implementation partner, so get a record-by-record list of what moves in detail, in summary or not at all.
  • Closed jobs with estimated versus actual hours are the history estimators and controllers miss most after cutover.
  • Quality records often live outside SyteLine, so archive them with the job and lot numbers that link them to production.
  • Most manufacturers combine a full database backup with a queryable extract of jobs, orders and quality history.
  • Customer-owned drawings and export-controlled work should be flagged during extraction and kept out of any outside reuse.

What usually moves to CloudSuite Industrial, and what stays behind?#

A SyteLine to CloudSuite Industrial migration usually carries forward what the business needs to keep running: item and customer masters, open orders, open jobs, balances and current bills of material. Closed history is the part most often left behind or brought over only in summary, because converting years of transactions is slow, costly and easy to get wrong.

CloudSuite Industrial is the later name of the SyteLine product line, so the path matters. An upgrade that carries your existing database forward can bring history with it, while a move to Infor's multi-tenant cloud is often run as a fresh implementation with data loads. Confirm which path you are on before assuming either.

The exact scope is set in your project with Infor or its partner, so get it in writing. Ask, record type by record type, whether history converts in detail, in summary or not at all. The table shows a typical split to test your own scope against.

What usually moves to CloudSuite Industrial, and what stays behind?
Record typeOften convertedOften left in SyteLine
Items, customers and vendorsActive mastersObsolete items and inactive accounts
Bills of material and routingsCurrent revisionsSuperseded revisions and change history
JobsOpen jobs and work in processClosed jobs with labor and material transactions
Customer orders and shipmentsOpen ordersClosed orders, shipments and returns
Purchase orders and receiptsOpen POsReceipt history and vendor delivery performance
General ledgerOpening balances or summarized periodsTransaction-level detail
Quality recordsOpen nonconformancesClosed NCRs, inspections and corrective actions

Which SyteLine history matters most?#

The SyteLine history that matters most is the record of planned work against actual work. Estimates and routings say what a job should take; job transactions show what it took, including labor, materials, scrap and moves between operations.

Pull the code tables with the history. Reason codes for scrap and rework, work center definitions, product codes, customer and vendor masters, and the status codes for jobs and orders are what make the transactions readable once SyteLine itself is gone. Without them, an archive is a set of numbers nobody can interpret.

  • Closed job orders with operations, work centers and estimated versus actual hours.
  • Job material transactions, including substitutions and scrap.
  • Estimate jobs and quotes, including those that never became orders.
  • Customer order, shipment and return history by item.
  • Purchase order receipts and vendor delivery performance.
  • Lot and serial genealogy linking raw material to shipped product.
  • Engineering change history for items, bills of material and routings.
  • Nonconformance reports, inspection results and corrective actions, wherever they are kept.
  1. 01Your work records
  2. 02Personal details removed
  3. 03You approve the release
  4. 04Licensed to AI developers
How it works with SourceX: Your work records → Personal details removed → You approve the release → Licensed to AI developers.Illustrative

Closed jobs are where estimating knowledge lives#

Closed jobs are the most useful history a job shop or make-to-order plant owns, because they show where the routing was wrong. Repeated overruns at one work center, setup times that never matched the standard and parts that always needed rework are visible only in transaction detail.

Estimators use that history to quote the next job; controllers use it to explain margin. Once only summaries survive, those patterns are gone, and the new system starts with standards nobody can check against reality.

Quality records often live outside SyteLine, in a quality module or a separate QMS. Archive them with the job and lot numbers that tie them back to production, or the link between a nonconformance and the job that caused it is lost.

Tax and audit reasons to keep history readable#

Tax and audit needs are a second reason to keep SyteLine history readable after cutover. The IRS says to keep records that support an item of income, deduction or credit until the period of limitations for that return runs out, and to keep records relating to property until the limitations period expires for the year you dispose of it.

Inventory costing, fixed asset and job cost detail can all support those positions. Customer quality agreements and industry requirements may add their own retention expectations for production and inspection records. Confirm periods with your tax advisor and quality team rather than relying on whatever the new system happens to keep.

Archive options before cutover#

Archive options range from keeping SyteLine running to taking a single verified snapshot, and most manufacturers combine two of them.

  • Take and verify a full database backup before conversion work begins.
  • Extract closed jobs, transactions, orders and receipts keyed by job, item and order number.
  • Pull quality records from wherever they live and link them by job and lot.
  • Write a data dictionary covering tables, keys and status codes.
  • Test a restore or a set of real queries before the old servers are switched off.
Archive options before cutover
OptionWhat it keepsTrade-off
Keep SyteLine running read-onlyEvery screen and report users knowLicenses, servers and security patching continue
Full database backup with documentationEverything, in its original structureNeeds skills and a compatible environment to read
Extract to a reporting database or warehouseSelected history in queryable tablesMapping effort up front and a data dictionary to maintain
Report snapshots in PDF or ExcelReadable views of key historiesFixed views that are poor for analysis

Illustrative: a machine shop moving to CloudSuite#

Illustrative: a fictional precision machining company that makes pump and compressor components is moving from an on-premise SyteLine installation to CloudSuite Industrial. The implementation partner's scope converts masters, open orders and open jobs only.

The CFO and IT lead add an archive workstream. They take a full database backup, then extract closed jobs, routings, job transactions, estimates and shipments into the company's reporting database, keyed by job, item and order numbers. Nonconformance reports from a separate quality system are linked by job and lot, and customer-supplied drawings and any export-controlled jobs are flagged and kept out of the extract.

After go-live the old servers are retired on a planned date. Estimators query past actual hours by part family, auditors get transaction detail on request, and the company knows which records are its own and which belong to customers.

Records to keep out of any reuse#

Some manufacturing records should be archived for the company's own use but kept out of any outside reuse. Customer-owned drawings, models and specifications usually belong to the customer, and work subject to export controls such as ITAR or EAR carries restrictions well beyond ordinary confidentiality.

Pricing agreements under confidentiality terms, supplier quotes and employee time records with personal details deserve the same flag. Tag them during extraction, while the people who know the jobs are still around, instead of sorting them years later.

How SourceX approaches manufacturing ERP history#

SourceX approaches SyteLine history as records of production decisions: quotes, routings, overruns, nonconformances and their dispositions. Under the SourceX Enterprise Data Value Framework, that history rates on domain expertise and human-generated signal, while preparation cost and privacy burden reduce net value.

Customer-owned designs and export-controlled work are excluded from the start. Anything else moves through the SourceX five-step transaction only with the manufacturer's approval at each step, and a SourceX Evidence Packet records provenance, licensing rights, permitted use, the privacy record and release authorization.

Frequently asked questions

Can we keep SyteLine running after go-live?

Yes, and many manufacturers keep it read-only for a period. It costs licenses, hosting and security maintenance, so set an end date and use the overlap to build a permanent archive. A read-only system is a bridge, not an archive.

Will Infor convert our historical transactions?

That depends on the scope agreed with Infor or your implementation partner. Ask for a record-by-record list of what converts in detail, in summary or not at all, and make sure it is written into the statement of work before cutover planning is locked.

What does end of support mean for our SyteLine version?

It generally means fewer or no updates and fixes for that release. Check Infor's lifecycle notices for your exact version, because the answer affects how long a read-only system can safely stay connected to your network.

What format should the archive use?

Use two layers: a full database backup in its native format, and flat extracts such as CSV files or warehouse tables for the histories people will query. Add a data dictionary, since SyteLine table and field names are not self-explanatory to anyone outside the ERP team.

Who should own the archive after cutover?

Give it a named business owner, usually the controller or CFO, with IT responsible for storage and access. Document who may open it, how restores are tested and when the archive will next be reviewed.

Sources

  • The IRS says to keep records supporting an item of income, deduction or credit until the period of limitations for that return runs out, and to keep records relating to property until the period of limitations expires for the year in which you dispose of the property. Source

Related resources

See if your company qualifies

A short company assessment. No data uploads are needed.

See if your company qualifies