Coins ERP+ offers different methods of handling subcontract variations for house builders within VAP. The three main methods are:
Method 1: Without the use of variation orders
Under this method, a variation line is included on each subcontract matrix such that when variations are made there is no requirement to amend the order or subcontract in Coins ERP+. The payment of the variation is recorded in detail on the subcontract payment certificate.
This method is suitable for clients for whom efficiency of transaction processing is paramount. The system does not provide automated control over the amount of variations paid on each subcontract although it does provide visibility of all variation payments at the point of payment authorisation. If all payment certificates are authorised by suitable individuals within the organisation then this can provide appropriate control on this expenditure while minimising the input requirements.
PO Subcontract Order
A subcontract order is raised and when this is committed the header of the SC subcontract is automatically created. The subcontract order will not normally include any detailed breakdown of the order value.Variation orders will not normally be input.
SC Subcontract (with VAP Matrix)
Once the subcontract order has been committed, the user inputs the VAP Matrix details to support the total value of the order. As well as the various measured works lines (which would normally use payment methods L (lump sum) or C (capped)), each matrix would include a line for variations using payment method D (detail) and may also include a line for dayworks using payment method D (detail). These variation and/or dayworks lines would have zero value in the subcontract matrix.SC Payment Certificates (with VAP Matrix)
As variations arise, these are input against the variation line on the relevant plot (which may be a dummy non-sellable plot). For each variation being certified the description (which may include a reference number) and amount are input. These descriptions and amounts can be printed on the payment certificate in place of the normal line description and amount.Method 2: Using variation orders
Under this method a variation order is raised for each variation or group of variations and these are added to the subcontract matrix as and when they occur. Payment of these is then controlled against these when processing subcontract payment certificates in much the same way as for the original measured work items.This method is suitable for clients for whom a greater degree of system-enforced control over the payment of subcontract variations is required. It also has the benefit of making sure that the committed value of subcontract orders in the CVR can include all agreed variations.
PO Subcontract Order
A subcontract order is raised and when this is committed the header of the SC subcontract is automatically created. The subcontract order will not normally include any detailed breakdown of the order value.As variations are required, variation orders are input. These will increase the order value and when the variation order is committed the current order value on the header of the SC subcontract is automatically adjusted.
SC Subcontract (with VAP Matrix)
Once the subcontract order has been committed, the user inputs the VAP Matrix details to support the total value of the order. The measured works lines (which would normally use payment methods L (lump sum) or C (capped)) are input so that they add up to the original order value (no additional zero value lines for variations etc are included).As variation orders are committed, the user adds a line to the VAP matrix for each variation item. These lines would use an appropriate cost head and payment stage but the description can be overridden to show the necessary details of the variation including any reference number. These variation lines can use whichever payment method is required to give the appropriate level of control ? normally either L (Lump Sum) or C (Capped) but potentially P (Provisional) if users need to be able to pay more than the order value for a variation item. The amounts of the individual variation items are input to the matrix so that the matrix always adds up to the current value of the subcontract order.
SC Payment Certificates (with VAP Matrix)
Once the variation items have been added to the subcontract they can be certified in exactly the same way as normal measured work items. The description input in the subcontract matrix will be printed on the payment certificate against the payment amount.Method 3: Using variation orders with detailed payments
Under this method a variation order is raised for each variation or group of variations and the values of these are added to the subcontract matrix as and when they occur. The payment of the variation is recorded in detail on the subcontract payment certificate and validated to ensure that the total cumulative value of these variation payments does not exceed the order value for variations on each plot.
This method has the same benefits as Method 2, with the added benefits that the maintenance of the subcontract matrix is simpler and less time-consuming and that detailed text can be recorded against individual variation payment items.
PO Subcontract Order
A subcontract order is raised and when this is committed the header of the SC subcontract is automatically created. The subcontract order will not normally include any detailed breakdown of the order value.As variations are required, variation orders are input. These will increase the order value and when the variation order is committed the current order value on the header of the SC subcontract is automatically adjusted.
SC Subcontract (with VAP Matrix)
Once the subcontract order has been committed, the user inputs the VAP Matrix details to support the total value of the order. The measured works lines (which would normally use payment methods L (lump sum) or C (capped)) are input so that they add up to the original order value (no additional zero value lines for variations etc are included). Additionally, each matrix would include a line for variations using payment method D (detail). This variation line would initially have zero value in the subcontract matrix.As variation orders are committed, the user adds the values to the appropriate cells in the variation line in the VAP matrix so that the matrix always adds up to the current value of the subcontract order.
SC Payment Certificates (with VAP Matrix)
When variations are to be paid, these are input against the variation line on the relevant plot (which may be a dummy non-sellable plot). For each variation being certified the description (which may include a reference number) and amount are input. These descriptions and amounts can be printed on the payment certificate in place of the normal line description and amount. Coins ERP+ will validate that the cumulative total payments against each cell on the variation line does not exceed the order value for that cell.
Recommended Settings
Module | Parameter | Setting: Method 1 | Setting: Method 2 | Setting: Method 3 | Notes |
SC | CAPCOV | N | N | N | To allow variations to increase the order value |
VP | DWKOPAY | Blank - No message | Blank - No message | ERROR | To validate the total cumulative value of payments made on a cell of payment method ?D? against the order value for that cell |
VP | LOCKCOV | Y | Y | Y | To ensure the total of the matrix detail exactly equals the current order value |
VP | METHPAY | To include L,C,D and exclude any unused methods | To include L,C and exclude D and any other unused methods | To include L,C,D and exclude any unused methods | To stop users from using inappropriate payment methods on subcontract matrices |
VP | SCVALLOC | Y | Y | Y | To ensure order value is consistent between PO and SC modules |
Parameters
SC/CAPCOV - Cap Current Order Value to Original Value
VP/DWKOPAY - Allow overpayment on dayworks stages? (COINS ERP+)
VP/LOCKCOV - Lock current order value to matrix value
VP/METHPAY - Permitted methods of payment for SC orders
VP/SCVALLOC - Lock SC order value to procurement order
