Sage CM Bills

View bills that aren't posted or failed

Approved bills that are unlinked to Sage 300 Construction and Real Estate projects or failed to post appear in the Not Posted or Failed list and are available for posting in the post wizard.

Select Accounting Link > Accounts Payable (AP).
Select View Bills - Not Posted or Failed in the Sage CM Bills section.
The Bills Not Posted or Failed page displays including the following details:

Type: The item type.
Project #: The name of the project.
Prime Contract #: The number of the prime contract.
Issue Date: The date that the bill was issued.
Document Number: The number of the document.
Subject: The bill description.
Bill Type: The type of bill.
Vendor: The vendor's name.
Amount: The bill amount.

Select a From Date and a To Date to filter the results if needed.

You can now mark selected bills as posted.

Mark selected bills as posted

Select Accounting Link > Accounts Payable.
Select View Bills - Not Posted in the Sage CM Bills section.
Select the checkbox for the required Bills.
Select Mark Selected Bills as Posted > OK.

View posted bills

Bills that have been posted can be unlinked.

Select Accounting Link > Accounts Payable (AP).
Select View Bills - Posted in the Sage CM Bills section.
The Bills - Posted page displays including the following details:

Type: The type of item.
Project #: The name of the project.
Prime Contract #: The number of the prime contract.
Issue Date: The date that the PO was issued.
Document Number: The number of the document.
Subject: The PO description.
PO Type: The type of PO.
Vendor: The vendor's name.
Amount: The PO amount.
Posted Date: The date that the PO was Posted.
Sage Link ID: The ID of the Sage link.

Select a From Date and a To Date to filter the results if needed.

You can now select bills and unlink them.

Unlink a bill

Posted Bills can be unlinked in case a Bill has been manually linked to the wrong project.
Posted Bills are also unlinked if significant changes need to be made to the transaction, which should be then reposted to Sage 300 Construction and Real Estate. This also requires deleting the original transaction in Sage 300 Construction and Real Estate to prevent duplicates.

To unlink bills:

Select Accounting Link > Accounts Payable (AP).
Select View Bills - Posted in the Sage CM Bills section.
Select the checkbox for the Bill to be unlinked.
Select Unlink Selected Bills.

The following warning message appears in the Accounting Status section of transactions that have been unlinked:

Warning: Transaction has been unlinked so be sure to delete the corresponding record in the accounting system prior to reposting to avoid any duplicates.

View bill discrepancies

Transactions are typically locked in Sage Construction Management after being posted 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 global and transaction specific discrepancy tools in the Posting and AP tabs respectively. These discrepancy tools analyze posted transactions and at the end of the process, a list of transactions where totals don't match is provided. You can rectify this discrepancy as needed, as AccountingLink does not identify which value, i.e., Sage Construction Management Total, or Sage 300 Construction and Real Estate, is correct.

Posted bills with discrepancies can be permanently removed from the list.

To view discrepancies:

Select Accounting Link > Accounts Payable (AP).
Select View Bills - Discrepancies in the Sage CM Bills section.
The Bills - Discrepancies page displays including the following details:

Issue Date: The date that the bill was issued.
Invoice #: The number of the invoice.
Subject: The bill description.
Vendor: The vendor's name.
Sage CM Amount: The Sage CM bill amount.
Sage Amount: The Sage bill amount.

You can now remove bills permanently.

Remove bills permanently

You can remove posted bills with discrepancy.

Select Accounting Link > Accounts Payable (AP).
Select View Bills - Discrepancy in the Sage CM Bills section.
Select the checkboxes for the Bills you need to remove and select Remove From List Permanently.

View bills that are in queue

Bills that have been in queue for more than one day can be deleted.

Select Accounting Link > Accounts Payable (AP).
Select View Bills - In Queue in the Sage CM Bills section.
The Bills - Marked Posted page displays including the following details:

Type: The item type.
Project #: The name of the project.
Prime Contract #: The number of the prime contract.
Issue Date: The date that the PO was issued.
Document #: The number of the document.
Subject: The PO description.
PO Type: The type of PO.
Vendor: The vendor's name.
Amount: The PO amount.

View bills with status in queue (in progress)

Bills that have been in queue for more than one day can be deleted.

Select Accounting Link > Accounts Payable (AP).
Select View Bills - In Queue (In Progress) in the Sage CM Bills section.
The Bills - In Queue (In Progress) page displays including the following details:

Project #: The name of the project.
Prime Contract #: The number of the prime contract.
Issue Date: The date that the bill was issued.
Document #: The number of the document.
Subject: The Bill description.
Amount: The Bill amount.
Status: The Bill status.

You can now delete all bills that have been In queue for more than one day.

Delete bills

Bills that have been in queue for more than one day can be deleted.

Select Accounting Link > Accounts Payable (AP).
Select View Bills - In Queue in the Sage CM Bills section.
Select Delete All > OK.

View bills that are marked as posted

Bills that are marked as posted will not appear in the posting wizard along with their corresponding transactions. This function is applicable when test or old projects are entered in Sage Construction Management and should not be sent to the accounting system.

Select Accounting Link > Accounts Payable (AP).
Select View Bills - Marked as Posted in the Sage CM Bills section.
The Bills - Marked as Posted page displays including the following details:

Type: The item type.
Project #: The name of the project.
Prime Contract #: The number of the prime contract.
Issue Date: The date that the PO was issued.
Document #: The number of the document.
Subject: The PO description.
PO Type: The type of PO.
Vendor: The vendor's name.
Amount: The PO amount.
Marked Posted On: The date that the PO was posted.

You can now mark the required bills as available for post.

Mark bills as available for post

Select Accounting Link > Accounts Payable (AP).
Select View Bills - Marked as Posted in the Sage CM Bills section.
Select the checkboxes for the required bills.
Select Mark Selected Bills as Available for Post.

Sage Construction Management bills