How to zero a BOQ item on a Works Order via CIM ?


 Product(s):Exor Maintenance Manager
 Version(s):04.05.00.00
 Environment:N\A
 Area:Interface
 Subarea:N\A

Problem

I am not able to zero a boq item via interfaces if it has a min value defined as anything above zero in Standard Items form. I get the error message: “Bill Item quantity does not fall between the min and max values for this item”.

 
See this example that explains:
 
The contractor is generating WC and WI files to complete work orders through CIM and we have encountered some rejected files due to an issue with the bill item quantities not being between the min and max values for this item.
 
We use different bandings as part of our SoR items. For example we have an item to carry out a “temporary repair to concrete carriageway…” The range of items is 2222.01 to 2222.03.
The min and max values for item 2222.01 is 0.00 and 5.00.
The min and max values for item 2222.02 is 5.01 and 10.00.
The min and max values for item 2222.03 is 10.01 and 999999.00.
 
An example is with item code 2222. 02. The min and max values are 5.00 and 10.00. The estimate value was 8.00. The contractor completed the work but the actual value was 4.00 so the item code required was 2222.01 as the min and max values for this item are 0.00 to 4.99. The process they have done for this when completing the defect previously through Exor is to put an actual quantity for 2222.02 of 0.00 and add an additional item which in this case would be 2601.01 with a quantity of 4.00. The interface process generates a failure for the 2222.02 item as 0.00 is outside the min and max values: “Bill Item quantity does not fall between the min and max values for this item”.

Solution

BOQ item can be zeroed by simply omitting it in the incoming WI file. See the suggested workflow below:
 
  1. Create a works order with a boq 2222.02 on it, instruct and do a WO extract
  2. Send in the WC file, then the WI file with boq 2222.03 (boq_id = -1 for it) and WITHOUT boq 2222.02 in the file (even though it exists on the works order). Claim value for the works order line in the file should ignore the cost of item 2222.02.
 
Doing the above will zero item 2222.02 and will only leave item 2222.03 priced.


 Original Author:Kristijonas Nalivaika