Content Comparison

...

Salesforce Invoice Line

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')
)

Create Amortization from Salesforce Invoice Lines

...

• When processing the invoice lines, the system will sort them by the Start Date. Then, it’ll process the invoice lines 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 will sort them by the Start Date. Then, it’ll process the invoice lines 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

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.

...

• Lease Amortization Line Type = Initial Entry

  • Debit Lease Receivable Account

  • Credit Product Revenue Account

    

• Lease Amortization Line Type = Monthly Entry

  • Debit Cash Account (Invoice Amount $18.35)

  • Credit Lease Receivable Account (Lease Receivable $11.40)

  • Credit Interest Income Account (Interest Amount $5.55)

  • Credit Sales Tax Payable Account (Sales Tax $1.40)

    

• Lease Amortization Line Type = Cancellation

  • Debit Write-off Account

  • Credit Lease Receivable Account

    

• Lease Amortization Line Type = Discount

  • Debit What Account?

  • Credit What Account?

• Lease Amortization Line Type = Down Payment

  • Debit What Account?

  • Credit What Account?

...