The specline must be Source of data must be P – Purchase Batch (So O - outside order lines will not be updated)
The specline must NOT already have an actual cost.
The Option Code must match (Product Reference)
Parameters in CS 00 confg file
VSB_ESTCOST_ALLOW_ZERO – This allows a specline to be updated that has 0 estimated cost on the line. So if staff are not entering an estimated cost but you want existing lines to be updated.
VSB_ESTCOST_OVER_PERCENTAGE – This is the percentage the actual cost can vary from your estimated cost – example $100 estimated cost – parameter set to 20% - This line will be updated if the Invoice is between $100 - $120 (otherwise a new line will be created)
VSB_ESTCOST_UNDER_PERCENTAGE - This is the percentage the actual cost can vary from your estimated cost – example $100 estimated cost – parameter set to 20% - This line will be updated if the Invoice is between $80 - $100 (otherwise a new line will be created)
A combination of these parameters can be used – if both were set to 20% then if estimated was $100 an invoice between $80 - $120 will update the existing line.
IMPORTANT – the % variance allowed is the variance to the estimated cost entered – not the variance to the value of the invoice being imported. Example 20% variance set and estimated cost = $80 and actual invoice = $100
$80 + 20% = $96
Not $100 – 20% = $80
So this invoice would not update the existing specline.
When updating an existing specline – the description is NOT updated with the <TextOverride> Value from the XML – This value is only used to update the description when a new specline is added to the vehicle.
WARNING The same Product reference (Option Code) can be on multiple Non Recoverable lines – so the first one that matches the criteria will be updated.