Sage 300 CRE Settings

<< Click to Display Table of Contents >>

You are here:  APFlow™ Module > Setup > Manage APFlow™ > Advanced Tab > Advanced Bridge Settings >

Sage 300 CRE Settings

In addition to the Sage Paperless Construction Universal settings (Universal Settings), the following settings are specific to Sage 300 CRE bridged APFlow™ systems.

 

Accounting Date

Accounting date used when exporting invoices and performing budget checks.
When "None", the user will be prompted for an accounting date at the time of export and budget checking will not be performed.

Allow GL Override on Invoice

Allows overriding of GL accounts on the Invoice Entry screen.

Allow Invoice Import from A/P

Enables import button and does not check duplicates.

Allow Unit Price Override

Allow the user to override the unit price.

Auto Route To PM

Enable routing rules to project manager from bridged company.

Breakout GL

When True the GL account lookup is broken into prefix ABC and base account on the Invoice Entry screen
Otherwise the GL account lookup is the master chart of accounts.

Check Table Name

Blank if check table is not overridden.
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

When bringing in PO or Subcontract lines, if there is no tax code on the line, should the default tax code be cleared?

Closed Jobs Warning

Type of warning message when entering an invoice against a closed job.

Compliance Checklist for PO

Include commitment checklist items for POs during compliance checking.

Compliance Checklist Sub

Include commitment checklist items for Subs during compliance checking.

Cost Codes on the Fly

Allow cost codes to be entered that are not currently on the job.
WARNING: This requires additional setup to prevent import errors.

Disable Custom Invoice Validation

Turns off custom invoice validation rules in APFlow™.

Disable Invoice Routing

Turns off invoice routing in APFlow™.

Disable Invoiced To Date Calculations for Receiving

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

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

Discount at Invoice Level

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

When False, discounts will be 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

Display draw number field in distribution lines.

Distribution Code Field Name

Enables distribution code on Invoice Entry screen when the value is not blank.
The value entered becomes the label associated with the entry field.

Document Match - Retrieve potential matching POs in APFlow™

True to retrieve potential matches for POs in Document Match.
False will turn off the retrieval of potential matches for PO documents.

Enable AP Account

Turns on the AP Account field in the APFlow™ system.
This Advanced Bridge setting must be set to True for the Enabled AP Account Defaulting Advanced Bridge setting to be enabled.

Enabled AP Account Defaulting

Turns on defaulting of the AP Account field in the APFlow™ system. Requires AP Account to be enabled.

Enable Approve Invoices Job Filters

Enable reviewers to group invoices by job.

Enable Approve Invoices Property Code Filters

Enable reviewers to group invoices by property.

Equipment Cost Code Format

Formatting for the equipment cost code.

Equipment Format

Formatting for the equipment number.

Export Path

UNC path where export files will be saved.

GL Budget Name

When this entry has a valid value budget checking is turned on during invoice entry and review using the accounting date setting as the budget period.
When blank, budget checking is not performed.

GL Format

Used to select the format for the GL account number.

Include Closed Jobs

Allow closed jobs to 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.
A True setting will include taxes, typically GST, in commitment invoiced totals and in commitment checks.

Invalid GL Period / Budget Reviewer Warning

Overrides invalid GL Warning for a reviewer.

Invalid GL Period / Budget Warning

Type of warning message when an invoice is keyed to an invalid GL period.
Posting closed periods will be blocked when this setting is set to "Error".
Posting to future periods will always initiate a warning when set to "Warn" 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 becomes the label associated with the entry field.

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

True = The speed improvement hotfix (KB 97482) provided by Sage is installed.
False = The hotfix is not installed.

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

Job Budget $0 Warning

If enabled, then the job budget warning will be applied when the budgeted amount is $0.

Job Budget Reviewer Warning

Overrides job budget warning for a reviewer.

Job Budget Tolerance

Tolerance amount to exceed before enforcing the job budget warning.

Job Budget Warning

Type of warning message when the amount for a job exceeds the budgeted amount.

Job Format

Used to select the format for the job code.

Launch AP Export Detail Report

Launch AP export detail report after exporting.

P. O. Reviewer Warning

Overrides P.O. warning for a reviewer.

P. O. Tolerance Dollar Amount

Tolerance amount to exceed before enforcing the purchase order warning.

P. O. Tolerance Percentage

Tolerance amount percentage to exceed before enforcing the purchase order warning.

P. O. Tolerance Type

Determines whether to allow P. O. tolerance up to the P. O. Tolerance Dollar value, the percentage value, or both.

If Both is selected, dollar and percentage tolerances must be met. If one is met and the other is exceeded, the purchase order warning will generate.

P.O. Warning

Type of warning message when purchase order amount exceeds the committed amount.

Phase Format

Used to select the format for the phase code.

PO Description From Item

Pull description from PO item instead of header.

Processor Compliance Warnings

Warns Processor if vendor/subcontract compliance items are out of compliance.

Purchasing Module Interface

Use the Sage 300 CRE Purchasing Module interface for PO receiving operations.

Require Invoice Reset to Pending Notes

Require user to supply notes when resetting an invoice to "Pending".

Reviewer Compliance Warning

Warns reviewer if vendor / subcontract compliance items are out of compliance.

Reviewer Sequence Threshold

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

Sales Tax Override to Liability

True = Moves adjusted sales tax balance to Liability Tax.
False = Manual adjustment of Liability.

Service Module Interface

Use the Sage 300 Service module interface for service work order operations.

Subcontract Reviewer Warning

Overrides subcontract warning for a reviewer.

Subcontract Tolerance Dollar Amount

Tolerance amount to exceed before enforcing the subcontract warning.

Subcontract Tolerance Percentage

Tolerance amount percentage to exceed before enforcing the subcontract warning.

Subcontract Tolerance Type

Determines whether to allow Subcontract tolerance up to the Tolerance Dollar value, the percentage value, or both.

If Both is selected, dollar and percentage tolerances must be met. If one is met and the other is exceeded, the subcontract warning will generate.

Subcontract Warning

Type of warning message when subcontract exceeds the committed amount.

Use AP Invoice Push

Use the push functionality for AP invoice exporting.

Use Billing

Use standard billing item.

Use Property Management Module

Turns on the Property Management line type and applies PM GL formatting instead of standard formatting.