Sage Paperless Construction Help

Accounting System Service User Account in Sage 100 Contractor Database

Yes

You must have an administrator account configured to serve as a dedicated, non-person account to use to set up the bridge integration with Sage Paperless Construction.

Windows Domain Service Account

Yes

You must have a username and password for a domain service account that is a local admin to the server where Sage 100 Contractor is installed.

Allow $0 Invoices

With the check box in the Value column selected, this bridge setting is active and invoices may be approved with an invoice total set to $0 (zero).

With the check box in the Value column blank, invoices set to $0 (zero) cannot be approved.

Allow Additional Line Types on PO/Sub Invoices

With the check box in the Value column selected, the user can add an expense or job line to an invoice entry already containing PO/Subcontract lines.

Allow Change Processor on Exported

Usually, no changes are made to invoices that are exported. This setting allows you to change only the name of the Processor associated with a specific exported invoice.

With the check box in the Value column selected, this bridge setting is active and the change processor options are available in Invoice Manager for exported invoices. This also applies to Processors with the dropdown in Invoice Entry.

With the check box in the Value column blank, change processor options are not available in Invoice Manager for exported invoices.

Allow Coding Override on PO Lines

With the check box in the Value column selected, the user is allowed to override the coding applied from the Purchase Order.

Allow GL Override on Invoice

In Invoice Entry, on non-Expense line type entries (Job, Equipment, Purchase Order, Subcontract), the populated GL Account field reflects the Sage 100 General Ledger account default. This field is read-only and cannot be modified.

With the check box in the Value column selected, the GL Account field becomes active and you can override the Sage 300 default General Ledger account number.

Allow Invoice Save with No Vendor

With the check box in the Value column selected, this bridge setting is active and you can save an invoice without a vendor number.

With the check box in the Value column blank, you cannot save an invoice without a vendor number.

Auto Vendor Hold

With the check box in the Value column selected, the system defaults the vendor hold status based on the vendor's default Invoice Status in Sage 100 Contractor.

If the Invoice Status or Status fields are set to 2 - Review in the accounting system, the Hold check box is systematically selected on the Invoice Entry page in Sage Paperless Construction.

CCM Integration - Use Line Description

With the check box in the Value column selected, importing credit card invoices to Sage 100 Credit Card Management uses the line description provided on the line detail instead of the invoice description in the header when creating the journal entries.

Default PO GL Account

Enter the GL Account to use at the time of export on PO Lines not included on the invoice in Sage Paperless Construction. Sage 100 Contractor requires all PO lines to be sent over via the API so any PO lines not included on the invoice go over as zero amount lines with this default GL Account.

If you do not provide a value, the system uses the GL Accounts designated for O/H Cost for Freight and Variance found under 1-8 General Ledger Setup on the Posting Accounts tab.

Default PO Sub Account

Enter the Sub Account to use at the time of export on PO Lines not included on the invoice in Sage Paperless Construction. Sage 100 Contractor requires all PO lines to be sent over via the API so any PO lines not included on the invoice go over as zero amount lines with this default Sub Account.

If you do not provide a value, the system uses the GL Accounts designated for O/H Cost for Freight and Variance found under 1-8 General Ledger Setup on the Posting Accounts tab.

Enable Credit Card Management Integration

With the check box in the Value column selected, credit card invoices are imported to Sage 100 Credit Card Management instead of AP Invoices. See Credit Card Management (Sage 100 Contractor) for more information.

With the check box in the Value column blank, credit card invoices are not imported to Sage 100 Credit Card Management but are imported to AP Invoices instead.

Export "On Hold" Invoices

Allow invoices in an On Hold status to export.

With the check box in the Value column selected, this bridge setting is active and invoices On Hold are allowed to export. This allows an invoice to display in the Ready for Export page.

With the check box in the Value column blank, invoices On Hold are not allowed to export.

Export Job Header

With the check box in the Value column selected, if no job number is entered in the header, export the first job number identified on the invoice line item details.

Import Notes

With the check box in the Value column selected, invoice notes are systematically copied to Sage 100.

Include Closed Jobs

With the check box in the Value column selected, closed jobs display in the Lookup list.

Job Budget $0 Warning

With the check box in the Value column selected, the job budget warning is active and generates if a budgeted amount is zero ($0).

Job Budget Reviewer Warning

Determine what type of prompt generates to the Reviewer when a job type/job cost entry exceeds the budget.

Prompt Types:

Job Budget Tolerance

This is the amount beyond the established budget amount that is still considered acceptable. Any amount above the entered figure triggers the generation of a budget warning. 0 is the default.

Job Budget Warning

Determine if a prompt generates to the Processor that a job type/job cost entry exceeds the budget.

Prompt Types:

P. O. Reviewer Warning

Determine what type of prompt generates to the Reviewer when a purchase order amount exceeds the committed amount. None is the default.

Prompt Types:

P. O. Tolerance Amount

This is the amount beyond the established purchase order amount that is still considered acceptable. Any amount above the entered figure triggers the generation of a purchase order amount warning. $0 is the default.

P. O. Tolerance Percentage

This is the percentage beyond the established purchase order amount that is still considered acceptable. Any percentage above the entered figure triggers the generation of a purchase order percentage warning. 0% is the default.

P. O. Tolerance Type

Identify an amount value, a percentage value or both for the P.O. Tolerance Type.

This is the amount or percentage beyond an established purchase order amount or percentage that is still considered acceptable. Any amount or percentage above the entered figure triggers the generation of a purchase order amount or percentage warning. $0 is the default.

If Both is selected, both the amount and percentage tolerances must be met. If only one is met and the other is exceeded, the purchase order generates a warning.

P. O. Warning

Determine what type of prompt generates to the Processor when a purchase order amount exceeds the committed amount. None is the default.

Prompt Types:

Processor Compliance Warnings

Determine what type of prompt generates to the Processor when vendor or subcontract items are out of compliance. None is the default.

Prompt Types:

Require Invoice "Do Not Pay" Notes

With the check box in the Value column selected, this bridge setting is active and you are required to enter a note when marking an invoice for Do Not Pay.

With the check box in the Value column blank, no note is required if you mark an invoice for Do Not Pay.

Require Invoice Approval Alert Notes

With the check box in the Value column selected, this bridge setting is active and you are required to enter a note when marking an invoice for Approval Alert.

With the check box in the Value column blank, no note is required if you mark an invoice for Approval Alert.

Require Invoice On Hold Notes

With the check box in the Value column selected, this bridge setting is active and you are required to enter a note when marking an invoice as On Hold.

With the check box in the Value column blank, no note is required if you mark an invoice as On Hold.

Require Invoice Reject Notes

With the check box in the Value column selected, this bridge setting is active and you are required to enter a note when marking an invoice Rejected.

With the check box in the Value column blank, no note is required if you mark an invoice for Rejected.

Require Invoice Reset to Pending Notes

With the check box in the Value column selected, this bridge setting is active and you are required to enter a note when marking an invoice Reset to Pending.

With the check box in the Value column blank, no note is required if you mark an invoice Reset to Pending.

Restrict Cost Codes

With the check box in the Value column selected, only cost codes which were set up with budgets on the job in Sage are available on the cost code list.

Reviewer Compliance Warning

Determine what type of prompt generates to the Reviewer when vendor or subcontract items are out of compliance. None is the default.

Prompt Types:

Reviewer Sequence Threshold

This is the Sequence level at which the reviewer must fully code the item being approved.

For example, if set to 0, the invoice must be fully coded before it can be approved. If set to 1, any Reviewer with a sequence 0 could approve the invoice even if not fully coded. Anyone above the sequence threshold set here (such as 1) are required to fully code the invoice before approval is allowed.

Subcontract Reviewer Warning

Determine what type of prompt generates to the Reviewer when a subcontract amount exceeds the committed amount. None is the default.

Prompt Types:

Subcontract Tolerance Amount

This is the amount beyond the established subcontract amount that is still considered acceptable. Any amount above the entered figure triggers the generation of a subcontract amount warning. $0 is the default.

Subcontract Tolerance Percentage

This is the percentage beyond the established subcontract amount that is still considered acceptable. Any percentage above the entered figure triggers the generation of a subcontract percentage warning. 0% is the default.

Subcontract Tolerance Type

Identify an amount value, a percentage value or both for the Subcontract Tolerance Type.

This is the amount or percentage beyond an established subcontract amount or percentage that is still considered acceptable. Any amount or percentage above the entered figure triggers a subcontract amount or percentage warning to generate. $0 is the default.

If Both is selected, both the amount and percentage tolerances must be met. If only one is met and the other is exceeded, the subcontract warning generates.

Subcontract Warning

Determine what type of prompt generates to the Processor when a subcontract amount exceeds the committed amount. None is the default.

Prompt Types:

Work Order Date Cutoff Years

Enter the number of years to limit the work orders retrieved.