View transaction discrepancies
You can use the Discrepancies tool to identify and resolve data mismatches between Sage Construction Management and Sage 100 Contractor.
- Purchase orders (POs), subcontracts, bills, and subcontract invoices are typically locked in Sage Construction Management after being posted to Sage 100 Contractor. However, these transactions can still be modified in Sage 100 Contractor, which can potentially cause a discrepancy. To maintain consistency between the systems, Sage Construction Management provides a global and transaction-specific Discrepancies tool under the Posting tab. This tool analyzes posted transactions and provides a list of transactions where totals do not match. You can rectify this discrepancy as needed, as the AccountingLink does not identify if the Sage Construction Management total or Sage 100 Contractor total is correct.
-
The Discrepancies tool checks only transaction subtotals, it does not validate individual transaction amounts or tax amounts.
- Posted POs, subcontracts, bills, and sub invoices with discrepancies can be permanently removed from the list.
- Go to Accounting Link and select Posting > Discrepancies.
The discrepancies page displays the following information for POs, subcontracts, bills, and sub invoices:
Issue Date: The date that the transaction was issued.
Invoice #: The number of the invoice.
Subcontract #: For subcontract invoices, the related subcontract number.
Subject: The transaction description.
Vendor: The vendor's name.
Sage CM Amount: The transaction amount in Sage Construction Management.
Sage 100 Contractor Amount: The transaction amount in Sage 100 Contractor.
Alternatively, select the Accounts Payable (AP) tab in the Accounting Link and select one of the following options:- View POs - Discrepancies
- View Subcontracts - Discrepancies
- View Bills - Discrepancies
- View Sub Invoices - Discrepancies
- Optionally, update the From Date and To Date as needed to filter the transactions by date.
- Go to Accounting Link and select Posting > Discrepancies.
- Optionally, update the From Date and To Date as needed to filter the transactions by date.
- Select the transaction to remove permanently from the appropriate list and select Remove From List Permanently.
- Go to Accounting Link and select Posting > Discrepancies.
- Optionally, update the From Date and To Date as needed to filter the transactions by date.
- Select Export To Excel in the appropriate section.