Editing PO Matching Rules

1. Under Administration -> Construction click on Templates

2. Find the template you want to edit and click on edit



3. On the next screen click on Details for the Template Item you wish to change


4. From here expand PO Template Matches to edit PO Matching Rules


Reference, Allocate and Distribute:

If Reference is set to Y (true) then Supervisors will be able to see the PO References associated with matched tasks. If Distribute is also set to Y (true) then details of linked POs will also be visible to Supervisors and can be included in messages sent out to suppliers. If Allocate is set to Y (true) then the default Supplier will automatically be assigned to the matched task


Scaling:

This field allows the adjustment of the duration of tasks. How the duration is adjusted is impacted by other fields in PO Template Matches. Scale Type determines whether the scaling is determined by the Quantity of items ordered or the Value of items ordered. Scale Ratio determines the rate at which the duration is scaled in relation to the Comparison Amount (Cmp.Amt). If the Scale Ratio is set to 1 then a job with double the comparison amount will have double the standard duration or 100% more. A scale ratio of 0.5 however would result in the same task having a duration of 50% more.


Use the formula: Scaled Duration = Standard Duration x (1 + ((PO Amount - Comparison Amount)/Comparison Amount) x Scale Factor)


Approval:

If Approval is Y (true) then completing any tasks linked to a purchase order matched by this rule will update the approval proportional to the amount in the approve % column. If the partial payment is Y (true) then 50% or other partial completion of the task will be applied immediately to the purchase order. Carrying this percentage through to your accounting system will require integration work


Required and Inclusion:

If the inclusion column is Y (true) then when the purchase order loads are processed and either the contract scheduling status is marked as completed or a full purchase order load is run then the task linked to this rule will be added or removed to the job. If the required column is Y (true) then the task will be included if a purchase order is found to match this rule; if the required column is N (false) then the task will be included if the purchase is not found to match this rule.

If the inclusion column is N (false) the inclusion rule is not run


Search Pattern:

This is the pattern for matching Purchase Orders, ensure that all four fields are used. The format is:

Purchase Order Reference Number | Supplier Key | Cost Code | Inventory Item Code


* is a wildcard which will match everything


Rule Start and Rule End:

If Rule Start and Rule End are set PO matching will be restricted to only match tasks with a date within that range. If both are not set PO Matching will not be restricted.



Using the Tester

The PO tester will allow you to test your Purchase Order Matching before committing it to the system.


To open up the Tester click on TestPOMatch button.


By adding in the Contract Number and clicking Test it will show you how this rule will be applied.



A more detailed explanation of PO Matching can be found here: Technical - Purchase Order Task Matching