Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
printablefalse

...

Field Name

Help

Ready for Amortization Calculation

Formula:

  1. Account Posting Group = Lease Revenue

  2. Order Record Type contains Rental

  3. Invoice Status = ‘Posted’

  4. Order Product != ''

  5. Lease Amortization Line = ''

  6. (Charge Type = ‘Recurring' OR Product.Sub Category = ‘DISCOUNT’ OR 'DOWN_PAYMENT')

Code Block
ISPICKVAL( blng__InvoiceLineStatus__c ,'Posted') 
&& NOT(ISBLANK( blng__OrderProduct__c ))
&& ISBLANK( Lease_Amortization_Line__c ) 
&& (
ISPICKVAL(blng__ChargeType__c,'Recurring') 
|| ISPICKVAL( blng__Product__r.Sub_Category__c, 'DISCOUNT') 
|| ISPICKVAL(blng__Product__r.Sub_Category__c, 'DOWN_PAYMENT')
)

...

  • 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.

    image-20240313-212249.png

...

  • 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.

    image-20240306-225454.png
  • 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.

...