4.10.4 Asset Billing Rate Setup - File upload
The data in Asset Billing Rate screen can also be created and updated from an external file through SET-IFP input file upload process. While doing so, ensure that the file format of Header and Details record are maintained in required order and the input file is placed in upload area.
During the scheduled batch job run, the asset billing batch job picks-up the data in input file and loads on to the system to create Asset Billing Rate setup records.
However, before processing the details, system performs the following validations:
- If Name of the record is unique and duplicate record is not being updated.
- For Tiered Rate, the details are added only if the Calc Method = Tiered Rate. If not, system displays an error indicating Tiered Rate Details are not required for <Calc Method> and the record is added in bad file.
- For update to existing record details, only Enable/Disable option is supported. If there is a mismatch in the name of the record, batch job errors out with message Record not found and the record is added in bad file.
- For new records, all the fields are mandatory and default values are applicable.
- Values provided in fields which are of lookup type are validated with lookup code. In case of mismatch, batch job errors out with message Lookup value not matching and the record is added in bad file.
- Negative values is not added for number fields.
- Base Point's field does not contain negative, 0, or decimal values.
Parent topic: Asset Billing Rate