Loading
Feature Disruption - Service Cloud VoiceRead More
Feature degradation | Gmail Email delivery failureRead More
Manage Your Billing Processes with Salesforce Billing
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Create an As Of Date Balance Report with Finance Logging and Tableau

            You are here:

            1. Salesforce Help
            2. Docs
            3. Salesforce Billing

            Create an As Of Date Balance Report with Finance Logging and Tableau

            Create an As Of Date balance report in Tableau to allow finance users to review balances of top-level financial records by a date set by the user. The Tableau report uses finance balance snapshot data exported as a spreadsheet from Salesforce Billing. (Salesforce Billing Managed Package)

            Required Editions

            Available in: Salesforce Billing Winter ’21 and later

            In this example, you have already exported your finance balance snapshot data from Salesforce into an external spreadsheet file. You want to build a report that tracks Account, Reference Entity, Reference Entity Type, Currency ISO Code, Balance, Total Amount, and Transaction Date.

            1. In Tableau, open a new workbook.
            2. Bring in your finance balance snapshot data from an exported file.
              1. Go to Data, and then select New Data Source.
              2. Select your spreadsheet type and then open your file.
            3. Add the dimensions and measures for your report.
              1. Set Balance and Total Amount with Tax as discrete dimensions.
              2. Set Transaction Date as an exact date and a discrete dimension.
            4. Create an As of Date parameter that allows you to input a date value and return the latest record as of the entered date. Enter the following parameter values.
              • Name: Select Date
              • Data Type: Date & Time
              • Allowable Values: All
            5. On your parameter, select Show Parameter Control.
              This option lets you input values for the parameter.
            6. Create a calculated dimension field with logic that evaluates whether the record's transaction date falls before or after the As Of Date parameter. This setting allows you to filter for only records up to the As Of Date. The calculated dimension field has the following values.
              • Name: Is On or Before As Of Date
              • [Transaction Date] <= [As Of Date]
            7. Add your calculated dimension as a filter and set its value to True.
            8. Create a calculated dimension field with logic that evaluates whether a record on your reference entity is the latest record relative to the As Of Date. The calculated dimension has the following values.
              • Name: Is Latest Record
              • Logic:
                if([Transaction Date])=({fixed[Reference Entity],[Is On or Before As Of Date]: MAX([Transaction Date])})
   then
      true
   else
      false
   END
            9. Add the Is Latest Record field as a filter and set its value to True.

            You can now pass your As of Date input parameter and see the latest balance for a record of your reference entity as of that date. You can also filter out reference entities where the balance is already settled by filtering against balances of zero.

             
            Loading
            Salesforce Help | Article