How Visual Integrator Works
Visual Integrator uses an import definition to describe how information in a source file corresponds to fields in Sage 100. The configuration establishes the source data structure, destination fields, and processing rules required for the selected import task. For AP invoice imports, the destination structure must match the relevant Sage 100 Accounts Payable data-entry requirements.
A typical workflow begins with preparing an import file, configuring the import definition, checking field mappings, and running the import. Users then review the imported records in Sage 100 and complete the appropriate validation and posting activities. The exact steps depend on the Sage 100 version, installed modules, and supported import configuration.
For example, a distributor receiving hundreds of supplier invoices each month may consolidate invoice information from a purchasing application into a structured file. A configured import definition can map the supplier identifier, invoice number, invoice date, due date, and transaction amount to their corresponding destination fields, reducing repetitive data entry.
Key Fields and Import Preparation
Successful imports depend on source data that is complete, consistently formatted, and compatible with the destination fields. Before importing, accounts payable teams should establish a standard file structure and confirm that each required field contains the expected value.
- Vendor number: Identifies the supplier using a valid vendor record in Sage 100.
- Invoice number: Preserves the supplier's reference for invoice identification and duplicate checks.
- Invoice and due dates: Support accounting-period assignment, payment scheduling, and aging reports.
- Invoice amount: Records the transaction value and must agree with the applicable invoice details.
- General ledger account: Identifies the expense, asset, or other account associated with the transaction when required by the import structure.
- Purchase order and distribution details: Connect the invoice with purchasing records and appropriate accounting distributions when applicable.
Teams should also confirm date formats, decimal precision, required fields, vendor identifiers, and accounting-period settings. A small test file helps verify that the import definition maps fields correctly before the full transaction file is processed.
Validation, Matching, and Approval
Importing invoice data is one stage of the accounts payable workflow; it does not automatically establish that every invoice is ready for payment. Finance teams must review imported records, verify supplier details, and confirm that invoice amounts and accounting distributions are appropriate.
Invoice Matching compares invoice information with relevant purchase orders and receiving records when the transaction requires matching. This helps establish whether billed quantities, prices, and received goods agree. Accounts Payable Matching Approval represents the approval step associated with reviewing matched invoice information before the transaction proceeds under the organization's controls.
When invoice capture, extraction, validation, and general ledger coding are standardized, invoice automation can complement file-based imports by preparing structured invoice data for downstream processing. For organizations using multiple invoice intake channels, consistent validation rules help maintain reliable records regardless of how the information enters the accounting system.
Clear status communication also supports supplier relationships. How Vendor Portals Improve Invoice Transparency explains why visibility into invoice receipt, review, and approval can help vendors understand transaction progress without repeatedly contacting the AP team.
Accounting Controls and Financial Impact
Imported invoices affect expense recognition, vendor balances, cash requirements, and financial reporting. Organizations should reconcile import totals with source files, review rejected or incomplete records, and verify that invoices are assigned to the correct accounting period. These checks support accurate accounts payable accruals and month-end cut-off, particularly when goods or services have been received but the invoice has not yet been recorded.
Invoice import also connects with broader finance activities. AP Automation Software can help coordinate invoice processing and payment planning, while vendor management supports consistent supplier records and reliable vendor information. The wider procurement process establishes purchasing details that may later be used to validate supplier invoices.
After invoices are reviewed and posted according to company policy, the payment process can use the resulting vendor liabilities and due dates to plan payments. Payment Approval provides a separate control point for authorizing disbursements, helping ensure that payment decisions follow the organization's approval rules.
Best Practices for Reliable Imports
Finance teams can improve import consistency by maintaining documented import definitions, standardizing source templates, and restricting changes to authorized users. Each definition should have a clear purpose, an identified owner, and a documented mapping of source columns to destination fields.
- Validate vendor numbers, invoice references, dates, amounts, and account codes before importing.
- Test new or modified import definitions with representative records before processing larger files.
- Compare source-file record counts and totals with the results in Sage 100.
- Review rejected records, correct the source data, and reprocess them using a controlled procedure.
- Maintain an audit trail of source files, import runs, corrections, approvals, and posting outcomes.
These practices help organizations reduce repetitive entry, improve traceability, and maintain more dependable AP reporting. Teams should consult the documentation for their specific Sage 100 release when configuring import fields or determining supported transaction structures.
Summary
Sage 100 AP Invoice Import Visual Integrator provides a structured way to import supplier invoice information into Sage 100 Accounts Payable. Its effectiveness depends on accurate source files, suitable field mappings, transaction validation, and controlled posting procedures. When integrated with invoice matching, approval workflows, and month-end reconciliation, it supports more consistent invoice records, stronger vendor management, and better visibility into liabilities and cash flow.