View transaction discrepancies

You can use the Discrepancies tool to identify and resolve data mismatches between Sage Construction Management and Sage 100 Contractor.

About transaction discrepancies

• 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.

View discrepancies

1. Go to Accounting Link and select Posting > Discrepancies.

   The discrepancies page displays the following information for each type of transaction:

   • 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, you can go to Accounting Link, select the Accounts Payable (AP) tab, and select one of the following options:

   • View POs - Discrepancies
   • View Subcontracts - Discrepancies
   • View Bills - Discrepancies
   • View Sub Invoices - Discrepancies
2. Optionally, update the From Date and To Date as needed.
3. Optionally, to remove a transaction from the list permanently, select it from the list and select Remove From List Permanently.
4. Optionally, to export all transactions with discrepancies to an Excel file, select Export To Excel.