| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...
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
...
Field Name | Help | |
|---|---|---|
Customer | blng_Account__c | |
First Invoice | Salesforce Invoice > First Invoice = True | |
Fully Paid | Formula(Total LR Amount Paid = LR Booked Amount) | |
Interest Income GL Account | ||
Lease Receivable GL Account | ||
Write-Off GL Account | ||
Revenue GL Account | ||
Interest Rate | Company Default > Default Loan Interest Rate, Can be overwritten by Product > GF_Interest_Rate__c | |
Item | Invoice Line > Product > ItemLease Receivable GL Account | |
LR Booked Amount | Calculated Principal Amount | |
MRR Amount | Invoice Line > Order Product > Billable Unit Price | |
Open Lines | Roll-Up Summary COUNT Lease Amortization Line (Post != True) | |
Order Product | Invoice Line > Order Product (One Order Product per Lease Amortization) | |
Original Ownership | Order Product > Original OwnershipRevenue G/L Account | |
Starting Date | Invoice Line > Start Date | |
Term | Invoice > Invoice Line > Product > Product_Contract_Term__c | |
Total Discount | Roll-Up Summary (SUM Lease Amortization Line Lease: Discount Amount) | |
Total Interest Paid | Roll-Up Summary (SUM Lease Amortization Line Lease: Interest Amount) | |
Total Invoice Amount | Roll-Up Summary (SUM Lease Amortization Line Lease: Invoice Amount) | |
Total Lines | Roll-Up Summary COUNT Lease Amortization Line | |
Total LR Amount Paid | Roll-Up Summary (SUM Lease Amortization Line: Lease Receivable), Line Type = Monthly Entry | |
Down Payment Amount | Roll-Up Summary (SUM Lease Amortization Line Lease: Down Payment Amount) | Write-Off GL Account|
Cancelled | True if Lease Amoritization is cancelled using the Cancel Lease button | |
Currency | ||
GL Ledger | From order’s Warehouse |
...
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.
...
Work with Umair to create and test different test cases:
Salesforce Invoice with one product
Salesforce Invoice with multiple products.
Salesforce Invoice with discount
Salesforce Invoice with sales tax (Texas charges Sales Tax on the first invoice?)
SW: Please send some examples.
Salesforce invoice with downpayment
SW: Need the Home Water team to create test invoices with a down payment line
Excel Sheet with Examples
GL Accounts for Posting?
GL Ledger - Should go to Salesforce Invoice__r.Salesforce Order__r.Warehouse__r.GL_Ledger__c
Should add GL Ledger to the Amortization Schedule
SW: Currently, the System is assigning GL Ledger to GL Entry by CurrencyCode.
Go Live, how should we handle open invoices?
if we mass-create GF invoices and Amortization entries for existing Salesforce Invoices will it cause GL issues? such as double count?
The current First Invoice flag does not work on Renewed subscriptions, it does not flag the First Invoice of the renewed subscription!!!
...