Accounting Date

Choose the Accounting Date method that is used to capture the Accounting Date used to post exported invoices. Choose to use the Entry Date, Received Date or Invoice Date field entry. Or, choose None to be prompted at the time of export to enter the Accounting Date that should be used.

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 greyed out and cannot be changed.

If you select True, the GL Account field becomes active and you can override the Sage 300 default General Ledger account number.

If you select False, the GL Account field is read-only and cannot be modified.

Allow Invoice Import from A/P

If set to True, the Import button is enabled and does not check duplicates.

If set to False, the Import button is disabled and duplicates are not checked.

Allow Unit Price Override

If set to True, the user can override the unit price.

If set to False, the unit price is read-only.

Auto Route To PM

If set to True, routing rules to project manager from bridged company is enabled.

If set to False, routing rules to project manager from bridge company is disabled.

Breakout GL

If set to True, the GL account lookup is broking into prefix ABC and base account on the Invoice Entry screen.

If set to False, the GL account lookup is the master chart of accounts.

Check Table Name

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.
Example, if using current.cmt instead of register.cmt, enter CMT_CURRENT_TRANSACTION

Clear Default Tax Code on Non Taxed PO / Subcontract Lines

If set to True and bringing in PO or Subcontract lines, if there is no tax code on the line, the default tax code is cleared.

If set to False 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

None = No prompt/No issue
Warning = The recipient can still approve.
Error = The recipient must address the error before continuing.

Compliance Checklist for PO

If set to True, commitment checklist items for Purchase Orders are included during compliance checking.

If set to False, commitment checklist items for Purchase Orders are not included during compliance checking.

Compliance Checklist Sub

If set to True, commitment checklist items for Subcontracts are included during compliance checking.

If set to False, commitment checklist items for Subcontracts are not included during compliance checking.

Cost Codes on the Fly

Important: This functionality requires additional setup to prevent import errors.

If set to True, cost codes can be entered that are not currently on the job.

If set to False, cost codes cannot be entered that are not currently on the job.

Disable Custom Invoice Validation

If you select True, custom invoice validation rules in APFlow is disabled.

If you select False, custom invoice validation rules in APFlow work as expected.

Disable Invoice Routing

Important: This is an all or nothing setting.

If you select True, invoice routing functionality is disabled and the Invoice Routing icon in the Invoice Entry toolbar does not display.

If you select False, invoice routing functionality works as expected.

Disable Invoiced To Date Calculations for Receiving

For use by clients who are experiencing time out errors for these queries.

When True, additional queries that calculate invoiced-to-date amounts for receiving tickets no longer run.

When False, additional queries that calculate invoiced-to-date amounts for receiving tickets run as expected.

Discount at Invoice Level

When True and discounts are configured at the invoice level in the Sage 300 accounting system, discounts are entered on the invoice header rather than on the line level.

When False, discounts are entered on the line level.

Note: This Advanced Bridge Setting is only visible if Invoice Level is set in the Sage 300 accounting system.

Display Draw Number

This is a free-form field in Sage.

If set to True, Display draw number field in Distribution Lines is visible.

If set to False, the Display draw number field in Distribution Lines is not visible.

Distribution Code Field Name

If set to True, the distribution code on the Invoice Entry screen is enabled when the value is not blank. The value entered becomes the label associated with the entry field.

If set to False, the distribution code on the Invoice Entry screen is not enabled when the value is not blank.

Document Match - Retrieve potential matching POs in APFlow™

Click True to enable the retrieval of potential matches for POs in Document Match.

 
Click False to turn off the retrieval of potential matches for PO documents.

Enable AP Account

If set to True, the AP Account field in the APFlow system is enabled.

If set to False, the AP Account field in the APFlow system is disabled.

Enabled AP Account Defaulting

Important: For this Advanced Bridge setting to be active, the Enable AP Account Advanced Bridge setting must be set to True.

If set to True, the defaulting of the AP Account field in the APFlow system is enabled.

If set to False, the defaulting of the AP Account field in the APFlow system is disabled.

Enable Approve Invoices Job Filters

If set to True, Reviewers can filter invoices by job so that only those invoices coded to the filtered job--for a particular status--display.

If set to False, all invoices for a particular status displays.

Enable Approve Invoices Property Code Filters

If set to True, Reviewers can group invoices by property.

If set to False, Reviewers cannot group invoices by property.

Equipment Cost Code Format

If set to True, formatting for the equipment cost code is enabled. For example: ##-###

If set to False, formatting for the equipment cost code is disabled.

Equipment Format

If set to True, formatting for the equipment number is enabled. For example: ###-##

If set to False, formatting for the equipment number is disabled.

Export Path

This UNC path is the location where you want fully approved files to be stored. Determine a designated, default folder so all files are saved in a single place.

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

If set to True, closed jobs display in the Lookup list.

If set to False, 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.

 
If set to True, taxes are included, typically GST, in commitment invoiced totals and in commitment checks.

If set to False, 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

None = No prompt/No issue
Warning = The Reviewer can still approve.
Error = The Reviewer must address the error before continuing.

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

None = No prompt/No issue
Warning = The Processor can still approve.
Error = The Processor must address the error before continuing.

Important: Posting closed periods are blocked when this setting is set to Error.
Posting to future periods always initiates a warning when set to Warning or Error.

Invoice Code 1 Field Name

Enables "Invoice Code 1" field on Invoice Entry screen 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 on Invoice Entry screen when the value is not blank.
The value entered becomes the label associated with the entry field.

Is Sage Export Hotfix Installed

If set to True, the speed improvement hotfix (KB 97482) provided by Sage is installed.

If set to False, the hotfix is not installed.

Warning: Setting this field to True without having the hotfix installed prevents users from exporting invoices.

Job Budget $0 Warning

If True, the job budget waring is active and generates if a budgeted amount is zero ($0).

If False, no job budget warning generates if a budgeted amount is zero ($0).

Note: With a Warning, the recipient can still approve.

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

None = No prompt/No issue
Warning = The recipient can still approve.
Error = The recipient must address the error before continuing.

Job Budget Tolerance

This is the dollar 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.

Note: With a Warning, the recipient can still approve.

Job Budget Warning

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

Prompt Types

None = No prompt/No issue
Warning = The Processor can still approve.
Error = The Processor must address the error before continuing.

Job Format

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

Launch AP Export Detail Report

If set to True, after the export is successful, the AP Export Detail report is systematically generated. This is the default.

If set to False, the AP Export Detail report is not systematically generated.

Important: This report can be reproduced through the Retrieve | Report menu at any time. Click here for details.

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

None = No prompt/No issue
Warning = The Reviewer can still approve.
Error = The Reviewer must address the error before continuing.

P. O. Tolerance Dollar Amount

This is the dollar 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.

Note: With a Warning, the recipient can still approve.

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.

Note: With a Warning, the recipient can still approve.

P. O. Tolerance Type

Identify a dollar value, a percentage value or both for the P.O. Tolerance Type.
This is the dollar 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 dollar and percentage tolerances must be met. If only one is met and the other is exceeded, the purchase order warning generates.

Note: With a Warning, the recipient can still approve.

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

None = No prompt/No issue
Warning = The Reviewer can still approve.
Error = The Reviewer must address the error before continuing.

Phase Format

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

PO Description From Item

If set to True, use the description from PO item instead of header description.

If set to False, 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

None = No prompt/No issue
Warning = The Processor can still approve.
Error = The Processor must address the error before continuing.

Purchasing Module Interface

If set to True, use the Sage 300 CRE Purchasing Module interface for PO receiving operations. The PO Receiving Line Type displays in the New Line Quicklist.

If set to False, the Sage 300 CRE Purchasing Module interface for PO receiving operations is not used.

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

None = No prompt/No issue
Warning = The Reviewer can still approve.
Error = The Reviewer must address the error before continuing.

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 seque3nce threshold set here (such as 1) are required to fully code the invoice before approval is allowed.

Sales Tax Override to Liability

If set to True, the adjusted sales tax balance is systematically moved to Liability Tax.

 
If set to False, the adjusted sales tax balance must be manually moved to Liability tax.

Service Module Interface

If set to True, use the Sage 300 Service module interface for service work order operations.

If set to False, 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

None = No prompt/No issue
Warning = The Reviewer can still approve.
Error = The Reviewer must address the error before continuing.

Subcontract Tolerance Dollar Amount

This is the dollar 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.

Note: With a Warning, the recipient can still approve.

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.

Note: With a Warning, the recipient can still approve.

Subcontract Tolerance Type

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

This is the dollar 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 dollar and percentage tolerances must be met. If only one is met and the other is exceeded, the subcontract warning generates.

Note: With a Warning, the recipient can still approve.

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

None = No prompt/No issue
Warning = The Processor can still approve.
Error = The Processor must address the error before continuing.

Use AP Invoice Push

If set to True, use the push functionality for AP invoice exporting.

If set to False, do not use the AP Invoice Push functionality.

Use Billing

If set to True, 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) to the Invoice Entry screen in Sage 300.

If set to False, 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.

If set to False, the Property Management line type is not enabled and the standard formatting is used.