AccountingLink for Sage 300 Construction and Real Estate - Discrepancies Function

Transactions are typically locked in Sage Construction Management after being exported to Sage 300 Construction and Real Estate. However, these transactions can still be modified in Sage 300 Construction and Real Estate which could potentially cause a discrepancy. To maintain consistency between the two systems, Sage Construction Management provides a discrepancy function in the Posting tab that analyzes totals for posted transactions. At the end of the process, a list of transactions that don't have matching totals is provided. You can correct this discrepancy as needed. The AccountingLink utility doesn’t rectify the discrepancy as it isn't possible to know which transaction or value (i.e., Sage Construction Management Total or Sage 300 Construction and Real Estate Total) is correct and why the discrepancy occurred.

Transactions checked by the Discrepancies function

The following transactions are checked by the Discrepancies function:

  • Posted POs with Discrepancy
  • Posted Subcontracts with Discrepancy
  • Posted Bills with Discrepancy
  • Posted Sub Invoices with Discrepancy
  • Posted COs with Discrepancy
  • Posted Prime Invoices with Discrepancy

You can now remove selected transactions with discrepancies or export them to Excel.

Lock transactions in Sage Construction Management after export

  1. Log in to Sage Construction Management as an Admin.
  2. Click the gear icon on the top right to open the settings.
  3. Go to Company Settings > Global Settings.
  4. In the General Settings section, select Lock Exported Transactions from the Transaction Locking dropdown.
  5. Click Save.

Related topics