If an amortization schedule was changed after your lease complete conversion you are unable to rewrite the lease if this lease was from the original conversion. The reason for this is because the amortization schedule will only have the remaining lease payments (not the full schedule). If this lease was entered through lease complete, you are able to rewrite the lease an will not have to follow the these steps.
You can manually update the database using Microsoft SQL Server. In this example, I will be fixing the amortization schedule due to a change in payment terms.
Lease Amortization Schedule
Using Microsoft SQL Server run the following code
SELECT * FROM AmortizationSchedules WHERE (amortLeaseID = 291113)
Copy and paste the existing amortization schedule into Microsoft Excel. We will need to do some calculations before re-entering the data in Microsoft SQL Server.
Ensure you reconcile your numbers to the lease amortization schedule.
Lease Payments Schedule
SELECT * FROM LeasePaymentSchedules WHERE (paysLeaseID = 291113)
If a payment schedule was create from conversion, you will have to update the amount of the payment by changing the value in the paysPaymentAmt field.
Lease Billing History
SELECT * FROM LeaseBillingHistory WHERE (leasebhLeaseID = 291113)
If changes are required update the lease billing history tables. In this case, the update only affected future payments.
In addition to the steps above, you will also be required to update balances.
Current Balance = Sum of all lease payments less total lease payments collected
Unearned Interest = total interest less total balance portion collected
Accruing Balance = total balance less total balance portion collected
Continue reading: Update asset values.