How Sage 100 Vendor Inquiry Works
Vendor Inquiry typically begins with selecting a vendor from the supplier records available in Sage 100. Depending on the installed version, configuration, user permissions, and inquiry screen, users can review vendor identification details and navigate to related transaction information. This may include open invoices, payment activity, credits, and historical entries.
The inquiry is most useful when users connect a vendor's overall account position with individual transactions. For example, an outstanding balance can be investigated by reviewing invoice amounts, due dates, applied payments, and available credit memos. Users should confirm the relevant accounting period and transaction status before using the information to make a payment or reporting decision.
Vendor records also support wider vendor management activities, including maintaining supplier details, coordinating account queries, and keeping vendor information aligned with purchasing and accounts payable processes.
Information Finance Teams Can Review
The precise fields available depend on the Sage 100 version and the inquiry screen being used. Commonly relevant information includes vendor number and name, invoice references, transaction dates, due dates, amounts, payment references, and outstanding balances. Users can use these details to trace the movement from an invoice entry to its settlement or identify items that need further investigation.
- Vendor details: Confirm the supplier account associated with an invoice, credit, or payment.
- Invoice activity: Review recorded invoices, transaction dates, amounts, and payment status where available.
- Payment history: Check recorded disbursements and connect them with the relevant vendor transactions.
- Open balances: Identify outstanding items that may require payment scheduling, follow-up, or reconciliation.
- Historical activity: Investigate prior-period transactions when responding to supplier questions or reviewing account movements.
These details help distinguish an unpaid invoice from one that has been paid but still needs its transaction history reviewed. When additional documentation is required, users can follow the transaction reference to the appropriate Sage 100 record or supporting report.
Using Vendor Inquiry Across AP Workflows
Vendor Inquiry is a useful reference point throughout the procure-to-pay cycle. A purchasing team may check a supplier account while following up on procurement activity, while an AP specialist may use the inquiry to confirm whether a supplier invoice appears in the accounting system. The inquiry itself provides visibility into recorded information; related screens and workflow controls perform the underlying transaction entry, approval, and posting.
During invoice processing, staff can use vendor and transaction details to investigate invoice references, verify the supplier account, and understand whether an item appears in the ledger. The broader process described in Vendor Invoice Processing 2025: AI Supplier Workflow Guide includes invoice capture, extraction, validation, approval, and posting, which create the transaction information finance teams subsequently review.
Where invoice data is extracted and checked against supporting documents, invoice matching helps compare invoice details with purchase orders, receipts, or other relevant records. Invoice Matching Verification describes the checks used to establish whether those records agree before the invoice advances through the applicable workflow.
Similarly, invoice capture brings supplier invoice information into the processing workflow, while AP Automation Software can connect invoice processing and payment planning with controlled accounts payable operations. The inquiry remains valuable for looking up vendor-account activity after relevant transactions have been recorded.
Vendor Inquiry, Payments, and Reconciliation
Before responding to a supplier about a payment, staff can review the vendor account and locate the transaction details needed to investigate the status. Recorded information can help teams distinguish an outstanding invoice from a payment entry and prepare a clear explanation for the supplier. Payment Approval is the separate control step in which an authorized person or workflow confirms that a proposed payment meets applicable policies.
Once a payment has been recorded, finance teams may compare the vendor transaction with bank activity as part of Bank Reconciliation. This helps establish whether accounting entries align with bank statement transactions. Reviewing the vendor account alongside payment records can also support follow-up on payments and identify items that need additional verification before accounts are considered settled.
When suppliers request updates about an order or invoice, Purchase Order Vendor Communication covers the exchange of purchasing-related information between the buyer and supplier. For invoice status visibility, How Vendor Portals Improve Invoice Transparency discusses how sharing invoice progress can help suppliers understand where an invoice stands in the workflow.
Best Practices for Accurate Vendor Reviews
Use a consistent review process so vendor inquiry results support reliable financial decisions. First, confirm the vendor number and account name to avoid reviewing a similarly named supplier. Next, identify the relevant invoice or payment reference, then check the transaction date, amount, and status against supporting records. If the account balance does not agree with an invoice or supplier statement, trace the individual transactions before making adjustments.
Keep user access aligned with job responsibilities, and use authorized transaction screens for corrections rather than treating an inquiry display as a substitute for posting or approval. For recurring supplier questions, retain the invoice number, payment reference, date, and investigation outcome so another team member can follow the same trail. These practices improve consistency in account reviews and help controllers support timely financial reporting.
Summary
Sage 100 Vendor Inquiry helps accounts payable teams examine supplier records and related transaction activity, including invoices, payments, credits, and balances where supported by the selected screen. Its practical value comes from connecting account-level information with individual transactions so staff can answer vendor questions, investigate outstanding items, support reconciliation, and prepare accurate reports. Used alongside appropriate approval, invoice-processing, and payment controls, it provides a clearer view of vendor activity for everyday finance operations.