Sage Paperless Construction Help

Sage 300 CRE Service User Account

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.

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 300 CRE is installed.

SQL User Account

No

This user account is only necessary if your company uses the optional SQL replicator.

Accounting Date

Choose the Accounting Date method that is used to capture the accounting date used to post exported invoices.

Choose to use the EntryDate, ReceivedDate or InvoiceDate field entry. Or, choose None to be prompted at the time of export to enter the Accounting Date that should be used.

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

Allow Unit Price Override

With the check box in the Value column selected, the user can override the unit price.

With the check box in the Value column blank, the unit price field is read-only.

Breakout GL

With the check box in the Value column selected, the GL account lookup is broken into prefix ABC and base account in Invoice Entry.

With the check box in the Value column blank, the GL account lookup is the master chart of accounts.

Check Table Name

Leave the field in the Value column blank if check table is not overridden. This is the default.

If using named files for CM transaction file, enter the database file name using standard descriptions syntax set on the ODBC DSN.

Clear Default Tax Code on Non Taxed PO / Subcontract Lines

With the check box in the Value column selected and bringing in PO or Subcontract lines, if there is no tax code on the line, the default tax code is cleared.

With the check box in the Value column blank, and bringing in PO or Subcontract lines, if there is no tax code on the line, the default tax code is not cleared.

Closed Jobs Warning

Determine what type of prompt generates when entering an invoice against a closed job.

Prompt Types:

Compliance Checklist for PO

With the check box in the Value column selected, commitment checklist items for Purchase Orders are included during compliance checking.

With the check box in the Value column blank, commitment checklist items for Purchase Orders are not included during compliance checking.

Compliance Checklist Sub

With the check box in the Value column selected, commitment checklist items for Subcontracts are included during compliance checking.

With the check box in the Value column blank, commitment checklist items for Subcontracts are not included during compliance checking.

Cost Codes on the Fly

With the check box in the Value column selected, cost codes and categories that are not currently on the job can be added to the job in Sage 300 CRE from Invoice Entry and then entered on a job line. In the Cost Code and Category fields, click the Add icon to add a new cost code or category.

With the check box in the Value column blank, only cost codes and categories that already exist on the job can be entered on a job line.

Display Draw Number

This is a free-form field in Sage.

With the check box in the Value column selected, Display Draw Number field in Distribution Lines is visible.

With the check box in the Value column blank, the Display Draw Number field in Distribution Lines is not visible.

Distribution Code Field Name

With the check box in the Value column selected, the distribution code in Invoice Entry is enabled when the value is not blank. The value entered becomes the label associated with the entry field.

With the check box in the Value column blank, the distribution code in Invoice Entry is not enabled when the value is not blank.

Enable AP Account

With the check box in the Value column selected, the AP Account field in the APFlow™ system is enabled.

With the check box in the Value column blank, the AP Account field in the APFlow™ system is disabled.

Enable AP Account Defaulting

With the check box in the Value column selected, the defaulting of the AP Account field in the APFlow™ system is enabled.

With the check box in the Value column blank, the defaulting of the AP Account field in the APFlow™ system is disabled.

Equipment Cost Code Format

Use the field to set the formatting for the equipment cost code as it is configured in Sage 300 CRE. For example: ##-###

If the field is blank, formatting for the equipment cost code is disabled.

Equipment Format

Use the field to set the formatting for the equipment number as it is configured in Sage 300 CRE. For example: ##-####

If the field is blank, formatting for the equipment number is disabled.

Export "On Hold" Invoices

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

GL Budget Name

When this entry has a valid value, budget checking is active during Invoice Entry and a review using the accounting date setting as the budget period occurs.

When this entry is blank, budget checking is not performed.

GL Format

Identify the format for the GL account number. For example: ##-##-#####.##

Include Closed Jobs

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

With the check box in the Value column blank, closed jobs do not display in the Lookup list.

Include Tax not posted to JC

Tax rates excluded from posting to JC are not included in commitment invoiced totals and commitment checks by default.

With the check box in the Value column selected, taxes are included, typically GST, in commitment invoiced totals and in commitment checks.

With the check box in the Value column blank, taxes are not included in commitment invoiced totals and in commitment checks.

Invalid GL Period / Budget Reviewer Warning

Determine what type of prompt generates to the Reviewer with an invalid GL period/budget. None is the default.

Prompt Types:

Invalid GL Period / Budget Warning

Determine what type of prompt generates for the Processor when an invoice is keyed to an invalid GL period.

Prompt Types:

Invoice Code 1 Field Name

Enables "Invoice Code 1" field in Invoice Entry when the value is not blank.

The value entered here becomes the label associated with the entry field.

This value corresponds to the invoice code 1 field in Sage and is included in the export.

Invoice Code 2 Field Name

Enables "Invoice Code 2" field in Invoice Entry when the value is not blank.

The value entered becomes the label associated with the entry field.

Is Sage Export Hotfix Installed

With the check box in the Value column selected, the speed improvement hotfix (KB 97482) provided by Sage is installed.

With the check box in the Value column blank, the hotfix is not installed.

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:

Job Format

Identify the format for the job code. For example: ##-####

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:

Phase Format

Identify the format for the phase code. For example: ##-##-###

PO Description From Item

With the check box in the Value column selected, use the description from PO item instead of header description.

With the check box in the Value column blank, use the header description.

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:

Purchasing Module Interface

With the check box in the Value column selected, use the Sage 300 CRE Purchasing Module interface for PO receiving operations. The PO Receiving Line Type displays in the New Line Quicklist.

With the check box in the Value column blank, the Sage 300 CRE Purchasing Module interface for PO receiving operations is not used.

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.

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.

Sales Tax Override to Liability

With the check box in the Value column selected, the adjusted sales tax balance is systematically moved to Liability Tax.

With the check box in the Value column blank, the adjusted sales tax balance must be manually moved to Liability tax.

Service Module Interface

With the check box in the Value column selected, use the Sage 300 Service module interface for service work order operations.

With the check box in the Value column blank, the Sage 300 Service module interface for service work order operations is not used.

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:

Use Billing

With the check box in the Value column selected, use standard billing item. This is the BL Std Item field on the invoice detailed lines. It is equivalent to the Add Column (Standard Item) in Invoice Entry in Sage 300.

With the check box in the Value column blank, the standard billing item is not active.

Use Property Management Module

If set to True, the Property Management line type is enabled and applies PM GL formatting instead of standard formatting.

With the check box in the Value column blank, the Property Management line type is not enabled and the standard formatting is used.