Claim Portal

Select type of claim

Process Claim

Upload your claim input file and optionally provide a Status Year to include in the output filename. Click Process Claim to run the report.

Status Year (optional)

Used in the output filename when provided.

Input file (required)

Excel (.xls/.xlsx) with warranty claim records.

Required columns (input file)

type_of_claim repair_order_no. sub-dealer_code job_order_start_date vin total_mileage basic_labor_hours labor_hour_amount sundry_expenses_total_amount application_form_status authorized_personnel date_of_approval spare_parts_code quantity claim_application_form amount_of_spare_parts

Dates: job_order_start_date, date_of_approval should be YYYY-MM-DD format.

Update Reference Data

Upload new master files. The system will upsert records by primary key.

Supported: .xlsx, .xls

VIN Master

Upserts by vin

Required columns

vinmodel_name

Optional: model_code

Dealer Master

Upserts by dealer_code

Required columns

dealer_code

Optional: dms_dealer_code, dealer_name, company_name_th

Delivery Date

Upserts by vin

Required columns

vindelivery_date

Paid Warranty

Upserts by claim_no + vin

Required columns

claim_novin

Other columns may be provided (dealer_code, model, costs, statuses, ...)

Warranty Price

Upserts by spare_part_code + valid_from + valid_to

Required columns

spare_part_codevalid_fromvalid_to

Optional: price, unit, uom, percent_dlr_claim, ...

Package Master

Upserts by package_name + valid_from + valid_to

Required columns

package_namevalid_fromvalid_to

Optional: package_code, distance, model_code, labour_hours, labour_hours_amount

Part Master

Upserts by part_code + valid_from + valid_to + package_name

Required columns

part_codevalid_fromvalid_to

Optional: part_name, price, percent_dlr_claim, distance, unit, quantity, uom, model, ...

CRM Special Case

Upserts by vin_no + package_distance

Required columns

vin_nopackage_distance

Optional: crm_memo_no, model, customer_full_name, benefit_type, delivery_date, valid_to, ...