Job Routing - Sage 300 CRE

<< Click to Display Table of Contents >>

You are here:  Advanced Integration > Sage 300 CRE >

Job Routing - Sage 300 CRE

In addition to setting up routing rules in Sage Paperless Construction, you can leverage your job configuration in your bridged accounting system to route to users designated on the job. Once configured, any invoice lines coded to a job are auto routed to the appropriate approvers assigned to your jobs in Sage 300.

 

To configure job routing in Sage Paperless Construction, the following steps must be complete:

 

Turn on Job Routing in Sage Paperless Construction

Configure users on your Jobs in Sage 300

Turn on Auto Route to PM Advanced Bridge Setting (optional)

Map your accounting system's Approver IDs to Sage Paperless Construction Reviewers

 

 

Turn On Job Routing in Sage Paperless Construction

 

1.From the ribbon toolbar, click Administration.

2.Click Vaults.
The Vaults dialog similar to the following displays:
 
VaultswindowSage300-mh
 

3.Click to highlight the Sage 300 vault, if not already highlighted.

4.Click Edit Vault.
The Vault Properties dialog similar to the following displays with the General tab active:
 
VaultPropertieswindowGeneraltabSage300-mh
 

5.Click the Bridge tab.
The dialog similar to the following displays:
 
VaultPropertiesBridgetabSage300-mh
 

6.Click to select the Use Sage 300 CRE Job Routing Rules check box.

7.Click OK to close the Vault Properties dialog.

8.Click Close to close the Vaults dialog.

9.Minimize or close Sage Paperless Construction.

 

 

Configure Users On Your Jobs in Sage 300

 

With Use Sage 300 CRE Job Routing Rules turned on in Sage Paperless Construction, invoices coded to the job are routed to the user designated in the Approval ID field on the job setup in Sage 300.
In addition, you can turn on the Advanced Bridge Setting, Auto Route to PM, to additionally route to the user designated in the Project Manager field.

 

1.Log in to Sage 300, Job Cost module.

2.From the toolbar, click Setup.
 
JobRoutingSage300JobCostmoduleSetupdropdown-mh
 

3.From the dropdown, click Jobs.
A Job Setup dialog similar to the following displays with the General pane open:
 
JobRoutingSage300JobCostmoduleJobSetupwindow-mh
 

4.In the Job field, click the ellipsis to access the Job lookup dialog similar to the following:
 
JobRoutingSage300JobCostmoduleJobSetupwindowJobfieldellipsislookup-mh
 

5.Click OK.
These field entries are associated to the job identified in the Job field.

6.In the left navigation bar, click AP and GL.
The following dialog displays:
 
JobRoutingSage300JobCostmoduleJobSetupAPandGL-mh
 

7.In the Approval ID field, click the ellipsis to access the Approval ID lookup dialog similar to the following:
 
JobRoutingSage300JobCostmoduleJobSetupAPandGLApprovalIDfieldlookup-mh
 

8.Click to highlight the appropriate name.
Important: This name may also display in the Project Manager field on the General pane. You can change these initials, as appropriate. If the Use Sage 300 CRE Job Routing Rules check box is selected (Sage Paperless Construction Properties dialog, Bridge tab), the individual selected in this lookup is the individual to whom the invoices are routed.
 

9.Click OK.
The Approval ID field resembles the following:
 
JobRoutingSage300JobCostmoduleJobSetupAPandGLApprovalIDfieldcomplete-mh
 

10. In the left navigation bar, click General.
The Project Manager field could resemble the following, based on your selection in the Approval ID field lookup:
 
JobRoutingSage300JobCostmoduleJobSetupGeneralProjectManagerfieldcomplete-mh
 
Note: This field can be modified.
 
Important: Do not change the Project Manager field label. If the Advanced Bridge setting, Auto Route to PM is set to True and this field label was changed, an error generates.
 

11. Click Save.

12. Click the X in the Job Setup dialog to close.

13. From the toolbar, click File.

14. From the dropdown, click Exit to close the screen and exit the Sage application.

 

 

Turn on Auto Route to PM Advanced Bridge Setting in Sage Paperless Construction (Optional)

 

1.In the ribbon toolbar, click APFlow™.

2.Click Manage APFlow.
 
The Manage APFlow dialog similar to the following displays with the General tab active:
 
ManageAPFlowGeneraltabSage300-mh
 

3.Click the Advanced tab.
The following dialog displays:
 
ManageAPFlowAdvancedtabSage300-mh
 

4.The following Advanced Bridge setting must have a Value of True:
 
Auto Route To PM
 

5.Click OK to close the Manage APFlow dialog.

 

 

Map your Accounting System's Approval IDs to Sage Paperless Construction

 

1.From the Sage Paperless Construction ribbon toolbar, click APFlow.

2.Click Manage APFlow.
 
The Manage APFlow screen similar to the following displays with the General tab active:
 
ManageAPFlowGeneraltabSage300-1-mh
 

3.Highlight a name in the grid with Reviewer permissions. This systematically associates in the Accounting System Mapping pane.

4.In the Accounting System Mapping pane, click the Reviewer Mapping field label.
The Reviewer lookup dialog similar to the following displays:
 
UserPropertiesAPFlowtabReviewerMappinglookupdialog3-mh
 

5.Click to highlight the same name that you highlighted in the Sage 300 Project Manager field.

6.Click OK.
The ReviewerID initials display in the Reviewer Mapping field similar to the following:
 
ManageAPFlowGeneraltabSage300-2-mh
 

7.Click OK to close the Manage APFlow dialog.