Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...
Field Name | Help | ||
---|---|---|---|
Ready for Amortization Calculation | Formula:
|
...
Navigate to Salesforce Invoice Line - First SF Invoice Lines w/o AMT Lines view
Select the lines you want to create Amortization Entries for.
Click the Create Amortization Entries button
Use Country (Invoice__r.Currency), Account Posting Group (from Account), Charge Type, and Filter Replace Plan to look for Account Posting Setup, then populate these fields on the Amortization Schedule:
Account Posting Setup
Write-off GL Account (from Account Posting Setup)
Revenue GL Account (from Account Posting Setup)
Sales Tax GL Account (from Account Posting Setup)
...
Navigate to theLease First SF Invoice Lines with AMT Lineslist view.
Click on the Salesforce Invoice record to view the amortization entries generated for the invoice in the Lease Amortizations section.
...
When processing the invoice lines, the system sorts them by the Start Date and then processes them sequentially.
The system will create at least two Lease Amortization Lines entries from First Invoice Line:
Initial Entry
Lease Receivable = LR Booked Amount
Monthly Entry
It will calculate the Remaining Principal Amount = LR Booked Amount - Total LR Amount Paid
Interest Amount = Remaining Principal Amount * Interest Rate / 100 / 12
Lease Receivable = MRR Amount - Interest Amount
Tax = Salesforce Invoice Line Tax Amount
Invoice Amount = Salesforce Invoice Line Total Amount
...
When processing the invoice lines, the system sorts them by the Start Date and then processes them sequentially.
It will calculate the Remaining Principal Amount = LR Booked Amount - Total LR Amount Paid
Monthly Entry
Interest Amount = Remaining Principal Amount * Interest Rate / 100 / 12
Lease Receivable = MRR Amount - Interest Amount
Create Amortizations Automatically
Use the Hourly routine configured on the Job Scheduler, with Job name = “Create Lease Amortizations” and Class name GF_CreateLeaseAmortizationSched
All errors will be displayed in the field Error Message.
Batch size = 1
Need to create a view to display the error.
Cancel an Amortization
Navigate to the Lease Amortization record that you want to cancel.
Click the Cancel Lease button to initiate the process.
A cancellation entry will be inserted into the amortization schedule.
Lease Receivable = LR Booked Amount - Total LR Amount Paid
Invoice Date = Today()
The system will flag the amortization as canceled.
...