Esc

↑↓ move↵ openIndex · Pagefind
← All integrations

Accounting

Sage 100 Contractor

Planned

Read-only extraction planned; edition and schema need confirmation. Flat CSV/XLSX exports can be imported today through Accounting Imports.

Planned. This connection is not available in os.construction yet. This page describes the intended scope; it is not a release date.

Coverage by service or edition

Scope under evaluation. Each service needs its own permissions and acceptance checks.

  • Contractor

    Planned

    Region/version/schema clarification required; separate from Sage 100 ERP.

Prepare for a scoped walkthrough

Use this checklist to agree the scope. These are preparation steps, not instructions for an available authorization or sync screen.

  • Confirm Contractor region/version and authorized access to the actual database schema.
  • Confirm the destination company/project and the reviewer responsible for approving imported records.
  1. Confirm the scope

    Confirm Contractor region/version and authorized access to the actual database schema.

  2. Agree the mapping

    actrec.recnum/jobnme → job key/name; actpay.recnum/vndnme → vendor key/name; invoice _idnum → document key.

  3. Preview and reconcile

    Reconcile balances, currency, payments and retainage at one as-of date. Differences block approval; posted corrections use the accounting reversal or void workflow.

  4. Review before applying

    An authorized reviewer must confirm destination scope, unresolved records and control totals. A successful extraction is not proof that data has been applied.

  5. Check recovery and access

    Pause on expired or revoked access. Restore authorization before resuming from the last complete checkpoint. An incomplete list or permission error is not proof of deletion; inspect uncertain outcomes before retrying.

Mapping and synchronization

Record mapping

actrec.recnum/jobnme → job key/name; actpay.recnum/vndnme → vendor key/name; invoice _idnum → document key.

Sync boundary
Validate required columns; reconcile invoice, payment and retainage totals at one cut-over date.
Source ownership
The provider remains authoritative for its source records. Local project placement, access and workflow decisions need explicit destination ownership. Match by scoped IDs, not names alone.
Outbound policy
No provider business writes are offered here. Sending, posting, inviting, deleting and permission changes require separately approved capabilities.

Conflicts and recovery

When records disagree

Reconcile balances, currency, payments and retainage at one as-of date. Differences block approval; posted corrections use the accounting reversal or void workflow.

When a run stops

Pause on expired or revoked access. Restore authorization before resuming from the last complete checkpoint. An incomplete list or permission error is not proof of deletion; inspect uncertain outcomes before retrying.

Limits to plan around

  • Observed tables are not universal. No direct database writes. Separate from Sage 100 ERP.
  • Not available in os.construction yet. Provider documentation describes the upstream API, not an os.construction connection.

No provider connection is initiated from this page. For the reviewed accounting import workflow available today, see the accounting import guide.

Documentation and source dates

Provider documentation establishes upstream capabilities, not os.construction availability. Confirm the current edition and API contract before planning setup.

Back to integration directory
Open file