Starting Exor v4.5.0.0 fix12 a new Product Option appeared. It is CIMMULTIF option (you can set it on HIG9130 form). CIM has been enhanced to allow for the processing of multiple Final Invoice files, depending on product option CIMMULTIF.
CIMMULTIF = ‘Y’: Final Invoices will be processed, even though a Final Invoice file has subsequently been processed.
CIMMULTIF = ‘N’: Processing will be performed as it is currently i.e. only a single Final Invoice is permitted
The following rules apply, for multiple Final invoice processing:
- If CIMMULTIF = ‘Y’, the Final invoices will be treated similar to the Interims. So a Final sequence number will need to be specified in the Record Type 5 (earlier it was null for Final invoices) so that the Finals are processed in the correct order;
- For each Final invoice received the Work Order line completion date will be updated according to the Date Completed on the 10 record;
- The Completion Date on a Work Order will be the latest completion date received on a Final Invoice for a Work Order Line;
So, you need to specify a sequence number for Final invoice on ‘05’ record (the same way as for Interim invoice). This sequence number must be unique for each (Final or Interim) type.
See an example how these sequences can be used:
(load_1)
WI000033.005 file:
00,005,900014,29102013,09:58:1605,I,1,WO78/I1,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,2.0,,(05,I,sec,uniqueID,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,2.0,,)10,509209,,,2.00,,,2910201315,KN01,1,,,1,2.00,2.00,,,543841,,,,20,3,2.00
00,005,900014,29102013,09:58:16
05,I,1,WO78/I1,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,2.0,,
(05,I,sec,uniqueID,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,2.0,,)
10,509209,,,2.00,,,29102013
15,KN01,1,,,1,2.00,2.00,,,543841,,,,
20,3,2.00
(load_2)
…..
05,I,2,WO78/I2,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,4.0,,10,509209,,,4.00,,,2910201315,KN01,2,,,2,2.00,4.00,,,543841,,,,20,3,4.00
05,I,2,WO78/I2,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,4.0,,
10,509209,,,4.00,,,29102013
15,KN01,2,,,2,2.00,4.00,,,543841,,,,
20,3,4.00
(load_3)
…..05,F,1,WO78/F1,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,10.0,,10,509209,,,10.00,,,2910201315,KN01,5,,,5,2.00,10.00,,,543841,,,,20,3,10.00
05,F,1,WO78/F1,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,10.0,,
10,509209,,,10.00,,,29102013
15,KN01,5,,,5,2.00,10.00,,,543841,,,,
20,3,10.00
(load_4)
…..05,F,2,WO78/F2,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,2.0,,10,509209,,,2.00,,,2910201315,KN01,1,,,1,2.00,2.00,,,543841,,,,20,3,2.00
05,F,2,WO78/F2,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEMADMINISTRATOR,,,2.0,,
It is ok.
But if you try to load following record(s) on load_4 you will get an error:
…..05,F,2,WO78/F1,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEM ADMINISTRATOR,,,2.0,,
05,F,2,WO78/F1,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEM ADMINISTRATOR,,,2.0,,
Or
05,F,1,WO78/F2,29102013,WO_NUMBER/78,CONTRACTOR,SYSTEM ADMINISTRATOR,,,2.0,,