Equipment Leasing Finalization

Purpose
The Equipment Lease Finalization screen allows a user to adjust the amount of the lease after the final invoices for the Equipment purchased is received.

Process
When Equipment is first purchased the original PO contains a buffer to account for the shipping and taxes. This puts the Equipment Lease in an Estimated status. When the invoice comes back and the 313 account is finalized the user would use the EL Finalize screen to make any adjustment to the lease's Assets value, positive or negative, to settle the account.


 * 1) The user would first pick the store, satellite and sequence they are interested in. If the store does not have any leases an error provider is shown to the user.
 * 2) The user would then select the lease they are interested in. Leases with an * at the end of the number represent leases in a Estimated or Finalized State
 * 3) The form then starts with zero Taxable Adjustment and Nontaxable Adjustment fields. This means the New Tax Assets and New Nontax Assets fields are the current values in the database.
 * 4) The user would then enter the adjustments in the Taxable Adjustment and Nontaxable Adjustment fields. Positive and negative values are allowed. This would update the fields New Tax Assets and New Nontax Assets to reflex the new payment amounts
 * 5) Upon Save the following actions occur:
 * 6) Data in ELFinalized table is either updated or inserted based upon the if a record for that Lease already exist
 * 7) ELMasterfile is update to reflect the new Total Tax Asset Amounts, Total Nontax Asset Amounts, Net Monthly Payments, Gross Monthly Payment, Balance Due, Tax Amount and the Lease Status updated to 'Finalized'
 * 8) If the number of Payments made on the lease is greater than 0 and the Original Amounts and New Amounts are different then an Invoice is created with up to two invoice items
 * 9) * One with the amount equal to the number of payments already made multiplied by the difference between the Original Payment and New Payment
 * 10) * One with the amount equal to the number of payments already made multiplied by the difference between the Original Tax Amount and New Tax Amount
 * 11) After Save the user can run a report to list the old values and new values of the Finalized Lease

Validations

 * The Equipment Lease Number must be greater than 0
 * The Equipment Lease Status must not be Brought Out

Report
Upon entering the numbers the user can generate a report after saving the information. This report, EL Finalize Report, will display on one line the old and new information for the lease currently selected on the screen. This report can be printed or saved to PDF or Excel.

Stored Procedure
Equipment Lease Maintenance uses the following procedures: