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.
Confirm the scope
Confirm Contractor region/version and authorized access to the actual database schema.
Agree the mapping
actrec.recnum/jobnme → job key/name; actpay.recnum/vndnme → vendor key/name; invoice _idnum → document key.
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.
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.
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.