...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Criteria
Committed Book with One Time or Recurring Charge Type
Lease Revenue 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 inventory again
For Order with Record Type = Tech Install/Self Install - Upfront Payments
...
Product Family != FRP
without deducting inventory again.
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:
Charge Type = One - Time
Order Record Type contains Upfront
Invoice Payment Status = Paid
OR Account Type 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 not blank
GF invoice Line on Invoice Line is not blank
Should use the Invoice Line to look for the invoice, then create a GoldFinch for all lines on the invoice.
Populate GoldFinch Invoice on header and GoldFinch Sales Invoice on Line
Look at Account Posting Group setup and Sales Tax setup.
The following process needs to be changed.
Home Water routine will create a Salesforce Invoice and use a credit card to charge the full amount to the customer.
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