Content Comparison

Criteria

• Lease Revenue with Recurring

...

For Order with Record Type = Tech Install/Self Install - Rental

• Product Family for the Product on Salesforce Invoice Line != FRP

• Accounting Posting Group for the Account = Lease Revenue

• Order Record Type contains Rental. // better to use this filter to separate records from Upfront

• Charge Type = ‘Recurring' OR Product.Sub Category = ‘DISCOUNT’ OR 'DOWN_PAYMENT'

• Amortization Line is not blank

• Invoice Status = Posted

Populate Amortization Line on Invoice Lines

Look at the Account Posting Group setup and Sales Tax setup, based on Country,

Use Account__r.Currency ISO Code, and Account__r.Account Posting Group, and Charge Type = Recurring to look for the correct Accounting Posting Group.

...

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

...

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

...

1. Work with Umair to create and test different test cases:

   1. Salesforce Invoice with one product

   2. Salesforce Invoice with multiple products.

   3. Salesforce Invoice with discount

   4. Salesforce Invoice with sales tax (Texas charges Sales Tax on the first invoice?)

      1. SW: Please send some examples.

   5. Salesforce invoice with downpayment

      1. SW: Need the Home Water team to create test invoices with a down payment line

   6. Excel Sheet with Examples

      1. https://microdatanet1988.sharepoint.com/:x:/s/Clients/ES-9cKPQSJtKjv2iacvcnsoBie47orn_Gk8W_rOBTOMsPw?e=shJ7lo

2. GL Accounts for Posting?

   1. GL Ledger - Should go to Salesforce Invoice__r.Salesforce Order__r.Warehouse__r.GL_Ledger__c

   2. Should add GL Ledger to the Amortization Schedule

   3. SW: Currently, the System is assigning GL Ledger to GL Entry by CurrencyCode.

3. Go Live, how should we handle open invoices?

   1. if we mass-create GF invoices and Amortization entries for existing Salesforce Invoices will it cause GL issues? such as double count?

4. The current First Invoice flag does not work on Renewed subscriptions, it does not flag the First Invoice of the renewed subscription!!!

...