Hi Gurus,
I have a scenario where needed to modify the Payment Amount for a lease record in the middle of the months, but i am not able to find a way to do that. Below is the scenarios and steps:
- Assumption:
- Payment Amount: $100000
- Lease Term: 6
- Initial Payment Schedule:
- January: $10000
- February: $10000
- March: $10000
- April: $10000
- May: $10000
- June: $10000
- Assuming payment has made + interest rate has recorded and paid until March.
- Landlord message me and said "Due to some reason, start from April, we will need to increase the rental rate to $12000".
- The new Payment Schedule should now become:
- January: $10000
- February: $10000
- March: $10000
- April: $12000
- May: $12000
- June: $12000
But, there's seems like no way to edit the Payment Amount from April until June (although payment amount and interest rate have not yet recorded from April until June).
Does anyone know is there a standard NetSuite way / alternative way to cater this issue?
Thank you very much!