Criteria
Committed Book for both one time and recurring.with One Time or Recurring Charge Type
Lease Revenue for one time
...
with One-Time Charge Type
Home Water creates a Salesforce Invoice from a Salesforce Order and
...
charges the customer the full amount using a credit card.
Salesforce Invoice Line Views
Use Salesforce Invoice Line view to create GoldFinch Invoices to record revenue . Do not deduct without deducting inventory again.
For Order with Record Type = Tech Install/Self Install - Upfront Payments
...
//Product Family of Product on Salesforce Invoice Line != FRP
Ignore this one because of Order Record Type contains Upfront
FPR Invoices do not have Order
...
Non Lease w/o GL Entry
When Account Posting Group = Committed Book
Charge Type = One Time and Invoice Payment Status = Paid, OR
Charge Type = Recurring and Invoice Status = Posted
Order Record Type != blank
When Account Posting Group = Lease Revenue, and with the following conditions:
Charge Type = One -Time and Time
Order Record Type contains Upfront
Invoice Payment Status = Paid
Posted = false (will check this after GL Entries are created)
Product Family != ‘FRP’
Non Lease with GL Entry
When Account Posting Group = Committed Book
Charge Type= One-Time and Order Record Type contains Upfront and Invoice Payment Status = Paid, OR
Charge Type = Recurring Order Record Type contains Rental and Invoice Status = Posted
GF Invoice on Invoice is blank
Populate GoldFinch Invoice on the Salesforce Invoice Header.
Look at the Account Posting Group setup and Sales Tax setup.
Results
On the Salesforce Invoice page GoldFinch will add a button (and also an hourly scheduled routine) to create and post GoldFinch Sales Invoices:
DR Accounts Receivable
CR Revenue
- No future recurring invoices.
When Account Posting Group = Lease Revenue:
Order Record Type contains Upfront
Invoice Payment Status = Paid
Posted = true
Product Family != ‘FRP’
Manual Post GL Entries
Navigate to Salesforce Invoice Line - Non Lease w/o GL Entry view
Select the lines you want to post GL Entrie.
Click the Non-Lease Post button
You can only one line each time.
Use Country (Invoice__r.Currency), Account Posting Group (from Account), Charge Type, and Filter Replace Plan to look for Account Posting Setup to get these GL Accounts
Write-off GL Account
Revenue GL Account
Sales Tax GL Account
Manual Unpost GL Entries
Navigate to Salesforce Invoice Line - Non Lease with GL Entry view
Select the lines you want to unpost GL Entrie.
Click the Non-Lease Unpost button
Automatic Post GL Entries
Use the Hourly routine configured on the Job Scheduler, with Job name = “Post Non Lease GL Entries” and Class name GF_PostNoneLeaseSFInvoiceLineSched
All errors will be displayed in the field Error Message.
Batch size = 1
Need to create a view to display the error.
Result
DR - AR
CR - Revenue
CR - Sales Tax