Dear All
Regarding from shortfall amount for legal side issue. I already received shortfall calculation logic from accounting unit in each type as below;
Re-marketing Case:-
Total Installment Receivable Amount (1) + Less Future (2) + Late Charges (3) + Misc. Charges (4) + Overdue and Future Vat.on Net Rental (5) - Received Auction Amt. (6)
Insurance Claim (Stolen Case):-
Total Net Receivable from Customer (1) + Overdue Interest (2) + Misc.Charges With VAT (3) + Total Less Discount (4) - Insurance Claim amount (5)
Insurance Claim (Damaged Case):-
Total Net Receivable from Customer (1) + Overdue Interest (2) + Misc.Charges With VAT (3) + Total Less Discount (4) + Overdue and Future Vat.on Net Rental (5) - Insurance Claim amount (5)
Follow calculation logic above we can gather all data from CMS fields which i already mapped field as per attached file.