Articles in this section

Summer ’22 Release Notes

  • Updated
Follow

Overview

Accounting Seed is delighted to inform you of our Summer ’22 release. This article presents information about the new features and enhancements available in the Summer ’22 release, including steps for Configuration changes, where necessary.         

To best understand how to use these new features and enhancements within your business it is important that you first test the Summer ’22 release in your sandbox environment. Follow the links below to learn more about each update. For more information on best practices with testing sandboxes, refer to Sandboxes: Staging Environments for Customizing and Testing and Considerations for Creating Sandboxes with Accounting Seed Data.

To print a copy of the Summer ’22 Release Notes, right-click and select Print. In the Destination drop-down list, select a specific printer name or select Save as PDF. Then, click Save.

Summer ’22 Schedule

Our Summer ’22 release has been deployed to all sandbox environments. To benefit from Summer ’22 in your production environment sooner, please contact Support by creating a case in our Customer Support Community to request the installation link. 

Summer ’22 Contents

New Features

Enhancements

Summer ’22 Software Corrections

Return to top

New Features 

Foreign Currency Translation

The Summer ’22 release includes Foreign Currency Translation capabilities. Foreign Currency Translation is used to convert the subsidiary in a foreign currency (Ledger currency) into the currency of the parent company (Presentation currency). At Accounting Seed, running Foreign Currency Translation is an automatic background process that is completed as part of Run Consolidations using exchange rates created in the Exchange Rates tab. After running Consolidations, you will be able to generate Standard Financial Reports and/or Custom Financial Reports in the base currency of the Ledger, as well as in the Reporting currency (parent currency).

In order to utilize Foreign Currency Translation in Accounting Seed, there are some Configuration Setups that need to be completed. Once the setups are completed, Exchange Rates information should be added. When translating foreign currency balances, the appropriate exchange rate will be used to translate from Ledger currency to parent currency. The Exchange Rates tab can be used to add and update exchange rates that will be used when translating balances. 

CTA (Cumulative Translation Adjustment) GL Account

As part of the Foreign Currency Translation process, a new CTA (Cumulative Translation Adjustment) GL Account field has been added to the Default GL Accounts screen. A CTA GL Account is used as a plug to balance the Trial Balance after translating using various exchange rates. Using a CTA GL Account is a common practice for any business doing Foreign Currency Translation. For more information, refer to the Foreign Currency Translation Configuration Setup article. 

Issue a Refund  

Issue a Refund from a Cash Receipt

Issue a Refund from a Cash Receipt

The process to create a refund for an overpayment or duplicate payment from beginning to end can conveniently be completed directly from a Cash Receipt. The system will automatically create, behind the scenes, the appropriate records for tracking this process. Additionally, this includes being able to print a check as part of this process (if necessary), as well as view refund information on the customer’s Activity Statement. 

Configuration Changes/Requirements:

Add the Refund button

Existing users will need to add the Refund button onto the Cash Receipt page layout.

  1. Click the Setup icon and select Object Manager.
  2. From the Quick Find textbox, enter Cash Receipt. Then, select the Cash Receipt object.
  3. Click Page Layouts and select the Cash Receipt layout.
  4. Click Mobile & Lightning Actions.
  5. Drag and drop the Refund button onto the page layout in the Salesforce Mobile and Lightning Experience Actions section.  
  6. Click Save.
    Note: The new Refund button will be available on the Cash Receipt screen when you display a Cash Receipt. 

Add the Print Check button

Existing users who require check printing will need to add the Print Check button onto the Cash Receipt page layout.

  1. Click the Setup icon and select Object Manager.
  2. From the Quick Find textbox, enter Cash Receipt. Then, select the Cash Receipt object.
  3. Click Page Layouts and select the Cash Receipt layout.
  4. Click Mobile & Lightning Actions.
  5. Drag and drop the Print Check button onto the page layout in the Salesforce Mobile and Lightning Experience Actions section. 
  6. Click Save.
    Note: The new Print Check button will be available on the Cash Receipt screen when you display a Cash Receipt.

Deactivate Validation Rules

Existing users will need to deactivate two validation rules on the Cash Receipt object. 

  1. Click the Setup icon and select Object Manager.
  2. From the Quick Find textbox, enter Cash Receipt. Then, select the Cash Receipt object.
  3. From the left panel, scroll down and select Validation Rules.
  4. Click Balance_Must_Be_Positive. Then, click Edit. 
  5. To deactivate this rule, deselect the Active checkbox. Then, click Save.
  6. Select Validation Rules again. 
  7. Click Cash_Receipt_Can_Not_be_Negative. Then, click Edit. 
  8. To deactivate this rule, deselect the Active checkbox.
  9. Click Save.

Return to top

Issue a Refund from a Credit Memo

Issue a Refund from a Credit Memo

The process to create a refund for a balance on a Credit Memo from beginning to end can conveniently be completed directly from a Credit Memo. The system will automatically create, behind the scenes, the appropriate records for tracking this process. Additionally, this includes being able to print a check as part of this process (if necessary), as well as view refund information on the customer’s Activity Statement. 

Configuration Changes/Requirements:

Add the Refund button

Existing users will need to add the Refund button onto the Billing page layout.

  1. Click the Setup icon and select Object Manager.
  2. From the Quick Find textbox, enter Billing. Then, select the Billing object.
  3. Click Page Layouts and select the Billing layout.
  4. Click Mobile & Lightning Actions.
  5. Drag and drop the Refund button onto the page layout in the Salesforce Mobile and Lightning Experience Actions section. 
  6. Click Save.
    Note: The new Refund button will be available on the Billings screen when you display a Billing.

Add the Print Check button

Existing users who require check printing will need to add the Print Check button onto the Cash Receipt page layout.

  1. Click the Setup icon and select Object Manager.
  2. From the Quick Find textbox, enter Cash Receipt. Then, select the Cash Receipt object.
  3. Click Page Layouts and select the Cash Receipt layout.
  4. Click Mobile & Lightning Actions.
  5. Drag and drop the Print Check button onto the page layout in the Salesforce Mobile and Lightning Experience Actions section. 
  6. Click Save.
    Note: The new Print Check button will be available on the Cash Receipt screen when you display a Cash Receipt.

Deactivate Validation Rules

Existing users will need to deactivate two validation rules on the Cash Receipt object. 

  1. Click the Setup icon and select Object Manager.
  2. From the Quick Find textbox, enter Cash Receipt. Then, select the Cash Receipt object.
  3. From the left panel, scroll down and select Validation Rules.
  4. Click Balance_Must_Be_Positive. Then, click Edit. 
  5. To deactivate this rule, deselect the Active checkbox. Then, click Save.
  6. Select Validation Rules again. 
  7. Click Cash_Receipt_Can_Not_be_Negative. Then, click Edit. 
  8. To deactivate this rule, deselect the Active checkbox.
  9. Click Save.

Customer Refund Information

As part of issuing a refund, a Customer Refund Information section should be included on the Cash Receipt page layout that contains fields such as Alternate Payee, Payment Type, Check Number, and Payee address information. This information is relevant for printing on the refund check, if a check is required. The related fields and descriptions have been added to the Receive and Apply Cash article. 

Note: The Customer Refund information will be auto-populated on a completed Refund Cash Receipt. However, when you create a new Cash Receipt, these fields will remain blank. 

Configuration Changes/Requirements:

Existing users will need to add a new Customer Refund Information section to the Cash Receipt page layout, along with the related field names. 

Best Practice: We recommend adding this new section directly below the last current section.  For example, if “Banking Information,” is the last section on your Cash Receipt page layout, drag and drop the Section field directly after Banking Information. 

  1. Click the Setup icon and select Object Manager.
  2. From the Quick Find textbox, enter Cash Receipt. Then, select the Cash Receipt object.
  3. Click Page Layouts and select the Cash Receipt layout.
  4. Drag and drop the Section field after the last section onto the page layout. The Section Properties dialog box will display.
  5. Enter Customer Refund Information in the New Section textbox. 
  6. Click OK. The new section displays on the page layout. 
  7. Drag and drop the following fields into the new Customer Refund Information section:
    • Alternate Payee Name
    • Payment Type
    • Check Number
    • Memo
    • Payee Street
    • Payee City
    • Payee State
    • Payee Postal Code
    • Payee Country
  8. Click Save. This new section will be available on Cash Receipt records to work in conjunction with issuing refunds. 

Issue a Refund from a Cash Receipt and/or Credit Memo API

The ability to issue a refund from a Cash Receipt and/or Credit Memo is also available via the API (Application Programming Interface). For more information, refer to the Accounting Seed API Documentation.

Return to top

Enhancements

Revenues

Amortize Revenue

Amortize Revenue for a Billing

In addition to the Straight Line - Full Month and Straight Line - Daily Amortization methods that were already in our Amortization wizard with the previous release, the Summer ’22 release includes Straight Line - Prorated Monthly for amortizing revenue amounts.

Note: A minor change was made to the name of the existing two Amortization methods. The name of Monthly Amortization is now Straight Line - Full Month. The name of Daily Amortization is now Straight Line - Daily. The functionality for these existing methods remains the same.

Straight Line - Prorated Monthly is the default Amortization method, which is a hybrid of the Full Month and Daily Amortizations. The first and last months will be prorated based upon the remaining days in the first month and the amount still remaining during the last month. The amount for each month between the first and last months will be the same (straight line).

Configuration Changes/Requirements:

Existing users will need to select the Is Active checkbox for the Straight Line - Prorated Monthly Label in the Custom Metadata Types.  

  1. Click the Setup icon.
  2. From the Quick Find textbox, search for Custom Metadata Types. 
  3. Click the Manage Records link for the Binding Label, Accounting Seed Financial Suite Installed Package. 
  4. Click Edit to edit the Straight Line - Prorated Monthly Label. 
  5. Select the Is Active checkbox.
  6. Click Save.

Business Rules

System Business Rules

As part of the Amortization changes, the System Business Rules have been updated to include the following: the Debit and Credit GL Account fields in the Amortization section of the Default GL Accounts screen cannot be set to:

  • Currency Gain/Loss GL Account
  • CTA (Cumulative Translation Adjustment) GL Account
  • Retained Earnings GL Account

Billing from an Opportunity
New Setting to choose the Current Date or the Close Date

Create a Billing from an Opportunity

On the Enablements page, a new section has been added called "Default Billing Date from an Opportunity.” In this section, if the “Set Billing Date to Current Date” Swipe button is turned "On," the Billing Date and Date on the Billing Line(s) will display today’s date when a Billing is created from an Opportunity. If the setting is left “Off,” which is the default, the dates will be the same as the Close Date on the Opportunity.

Note: This new functionality is available when creating a single Billing from the Opportunity record detail page or multiple Billings from the Opportunity list view.

Recurring Billing from an Opportunity
New Setting to choose the Current Date or the Close Date

Set up a Recurring Billing from an Opportunity

On the Enablements page, a new section has been added called "Default Billing Date from an Opportunity.” In this section, if the “Set Billing Date to Current Date” Swipe button is turned "On," the Next Billing Date and Date on the Recurring Billing Line(s) will display today’s date when a Recurring Billing is created from an Opportunity. If the setting is left “Off,” which is the default, the dates will be the same as the Close Date on the Opportunity.

Enablements

Enablements

A new section has been added to the Enablements screen, which is entitled “Default Billing Date from an Opportunity.” This relates to the Billing Date when creating a Billing or a Recurring Billing from an Opportunity. When the ”Set Billing Date to Current Date” Swipe button is turned “On,” and the Create Billing button on the Opportunity page is clicked, the Billing Date and Date on the Billing Line(s) will default to today’s date. Additionally, if the button is set to “On,” and the Create Recurring Billing button is clicked on the Opportunity page, the Next Billing Date and the Date on the Recurring Billing Line(s) will default to today’s date. If this button is set to “Off,” which is the default, the system will use the Close Date on the Opportunity instead of today’s date.

Override Default Address

Calculate Tax on a Billing with Avalara’s AvaTax

With the Summer ’22 release, you can override the default address that is used to determine the appropriate rate of tax to be applied to a Billing. If Shipment is your current Sales Tax Calculation Mode, and you want to override the address, both the Destination Address Override field and the Origin Address Override field on the Billing must be entered. If Point of Sale is your current Sales Tax Calculation Mode, and you want to override the address, the new address must be entered in the Origin Address Override field on the Billing. If Point of Destination is your current Sales Tax Calculation Mode, and you want to override the address, the new address must be entered in the Destination Address Override field on the Billing. 

Configuration Changes/Requirements:

Note: This information is only applicable if you use Avalara Sales Tax. This does not apply if using AS Native Tax. 

If using Shipment as the Sales Tax Calculation Mode for Avalara, new and existing users will need to add both the Origin Address Override and the Destination Address Override fields onto the Billing page layout. If using Point of Sale as the Sales Tax Calculation Mode, new and existing users will only need to add the Origin Address Override field onto the page layout. If using Point of Destination as the Sales Tax Calculation Mode, new and existing users will need to add the Destination Address Override field onto the page layout. 

  1. Click the Setup icon and select Object Manager.
  2. From the Quick Find textbox, enter Billing. Then, select the Billing object.
  3. Click Page Layouts and select the Billing layout.
  4. From the Fields option, drag and drop one of the following fields onto the page layout in the Address Information section.
    Note: Remember that adding these fields is based upon your tax calculation mode, as mentioned above. If you need to add both of these fields, repeat step 4 to add the second field. 
    • Destination Address Override
    • Origin Address Override
  5. Click Save.

Pay Billing - Future Accounting Period

Pay a Billing in a Future Accounting Period

When using the Payment Link in Stripe to pay a Billing, you now have the ability to pay a Billing that is in a future Accounting Period. Once the payment process is completed, a Billing Cash Receipt will be created with the Applied Date that is the same as the Billing Date (not the Payment Date).

Visualforce Page Removals

The BillingApplyCreditMemo and the CashReceiptApplyBillings Visualforce pages have been removed. For Salesforce Classic users, this means that the “Apply Credit Memo” button on the Billing and “Apply” button on the Cash Receipt pages will no longer function. These buttons should be removed from the Billing and Cash Receipt page layouts. The “Apply/Unapply” button should be added to these page layouts.

Note: The “Apply/Unapply” button only functions when using the Salesforce Lightning interface.

Return to top

Expenses

Amortize Expenses

Amortize Expense for a Payable

In addition to the Straight Line - Full Month and Straight Line - Daily Amortization methods that were already in our Amortization wizard with the previous release, the Summer ’22 release includes Straight Line - Prorated Monthly for amortizing revenue amounts.

Note: A minor change was made to the name of the existing two Amortization methods. The name of Monthly Amortization is now Straight Line - Full Month. The name of Daily Amortization is now Straight Line - Daily. The functionality for these existing methods remains the same.

Straight Line - Prorated Monthly is the default Amortization method, which is a hybrid of the Full Month and Daily Amortizations. The first and last months will be prorated based upon the remaining days in the first month and the amount still remaining during the last month. The amount for each month between the first and last months will be the same (straight line).

Configuration Changes/Requirements:

Existing users will need to select the Is Active checkbox for the Straight Line - Prorated Monthly Label in the Custom Metadata Types.  

  1. Click the Setup icon.
  2. From the Quick Find textbox, search for Custom Metadata Types. 
  3. Click the Manage Records link for the Binding Label, Accounting Seed Financial Suite Installed Package. 
  4. Click Edit to edit the Straight Line - Prorated Monthly Label. 
  5. Select the Is Active checkbox.
  6. Click Save.

Business Rules

System Business Rules

As part of the Amortization changes, the System Business Rules have been updated to include the following: the Debit and Credit GL Account fields in the Amortization section of the Default GL Accounts screen cannot be set to:

  • Currency Gain/Loss GL Account
  • CTA (Cumulative Translation Adjustment) GL Account
  • Retained Earnings GL Account

Pay Batch - Discount Amount

Create a Batch Payment Payable

From the Payable list view, on the Pay Batch intermediate screen, the Discount Amount field will be editable when the Aggregate by Payee checkbox is not selected AND no prior payments or cash applications have been made, and the Payable is eligible for a discount. Additionally, the Discount Amount field will also be editable when there is a partial Credit Memo application, but no payments (cash applications) have been made. In other words, the Credit Memo Applied Amount is greater than zero AND the Balance is greater than zero, and the Already Paid Amount is equal to zero. 

Partial Pay - Discount Amount

Create a Single or Partial Payment Payable

From a Payable record, on the Partial Pay intermediate screen, the Discount Amount field will be editable if no payments or cash applications have been made and the Payable is eligible for a discount. Additionally, the Discount Amount field will also be editable if a partial Credit Memo has been applied, but no payments have been made (the Credit Memo Application Amount is greater than zero and the Balance is greater than zero and the Already Paid Amount is equal to zero).  

Check Void

Void a Check

If a Cash Disbursement is voided, the Balance will be set to zero (0.00). 

Return to top

Automations

Scheduled Post Job

Schedule the Post Job(s)

The Scheduled Post automated job has been enhanced to allow users to schedule jobs by source type. Using the new "Select Scheduled Post Type(s)" dialog box, you are able to select one or more source objects and schedule a post job to run at a specific time. Multiple post jobs can be scheduled to run on those objects throughout the day or after business hours. 

The ability to select which source objects to post is also available as part of the Run on Demand job for immediate processing.

Banking

Bank Reconciliation - Ref Column

Perform a Bank Reconciliation

On a Bank Reconciliation, in the Ref column, for Cash Receipts, if the Check Number and the Reference fields are populated on the source record, both will display in the Ref column, respectively. The Reference field on Cash Receipts is a required field, so this will always display on the Bank Reconciliation in the Ref column. If the Check Number is not populated on the record, only the Reference field will display in the Ref column. The information in the Ref column for Cash Receipts, as well as for other source records, will also display in the CSV file. 

Consolidations

Set up Consolidations

Set up Consolidations

With the Summer ’22 release, when Multi-currency is enabled, the Ledger Hierarchy tree can include Ledgers with currencies that are different from the parent currency (Ledger at the topmost level of the tree). For example, the currency for the parent Ledger (topmost level) might be USD, and children Ledgers within this tree might include EUR and CAD.  

Set up Consolidations now includes the Save & New button, which makes for less keystrokes when creating a new Ledger Hierarchy or editing an existing one.

Run Consolidations Routine

Run Consolidations

When you run the Consolidations routine for a Ledger Hierarchy that has different currencies, the translation process will automatically run as a part of the routine. Financial Reports can be run based upon the data created from the Consolidations routine. 

Note: The Foreign Currency Translation Configuration Setup process, Exchange Rates information, and the Set up Consolidations must be completed before running the Consolidations routine.

Financial Reports

Standard Reports and Custom Reports

Financial Reports - Standard Reports
Financial Reports - Custom Reports

After running Consolidations, you will be able to run Standard Financial Reports and/or Custom Financial Reports in the base currency of the Ledger, as well as in the Reporting currency (parent currency). A new Currency drop-down list has been added to the Financial Reports, which allows you to select the same currency or one that is different from the Ledger currency for running a report. 

Note: The Currency drop-down list is only applicable if Multi-currency is enabled.

Standard Reports - GL Variables

Financial Reports - Standard Reports

In the Summer ’22 release, you are now able to view consolidated results across GL Accounting Variables.

Standard Reports - Suppress Opening Balance

Financial Reports - Standard Reports

The Suppress Opening Balance and Period Columns checkbox has been added to the Trial Balance Report. This provides the ability to only display amounts in the Year-to-Date column on the report when it is viewed. The Opening Balance column and the selected period(s) column will not display on the report when this checkbox is selected (enabled). Additionally, if Multi-currency is enabled, this checkbox defaults to selected.

Note: The Opening Balance will generally equal the Closing Balance from the previous period. However, if balances were translated in the prior period, the current period Opening Balance may be translated using a different rate and therefore may not equal the prior period Opening Balance.

Financial Reports - Salesforce Flow

Financial Report Flow Action

The ability for a System Administrator to declaratively leverage the same reports that are accessible in our Financial Reporter using Salesforce Flow is available with the Summer ’22 release. Supported reports include the following:

  • Profit and Loss
  • Profit and Loss versus Budget
  • Balance Sheet
  • Trial Balance
  • Cash Flow
  • Custom

Report Settings

Financial Reports - Report Settings

A new Default Report Display section has been added to the Report Settings page, which allows you to display rows on reports as automatically expanded or collapsed. Once selected, you can choose whether or not to duplicate the selection on all Ledgers.

Return to top

Ledger

Payroll File Import

Payroll File Import

As a part of the Payroll File Import process, data can be included in three new columns for importing into Accounting Seed. The three new columns are:

  • Account
  • Project
  • Project Task

Note: If you include information in the new optional columns, existing records must already be set up in Accounting Seed. For example, if you include a specific Project and Project Task in the import file, the Project and Project Task must already exist in Accounting Seed. Otherwise, an error message will display when you attempt to create records from the uploaded file.

Orders and Inventory

Create Payable from Unreceived, Foreign Currency Purchase Order

Create a Purchase Order (Average Cost)
Create a Purchase Order (Std Cost)

If Multi-currency is enabled, when creating a Payable from a Purchase Order and there are no related Purchase Order Inventory Movement records (the Purchase Order has not yet been received), the Currency Conversion Rate will be pulled from the Dated Exchange Rate table (see the Add Currencies and Exchange Rates article) based upon the Issue Date of the Payable. This allows for the creation of a Payable before the Purchase Order has been received.

Accounting Home

Right-click Menu Option

Navigation Overview

From Accounting Home, you can now right-click an option on a menu to open it in a new tab. That way, you are able to continue to have the Accounting Home page open while viewing various pages within the application, such as Billings, Payables, etc.

PDF Formats

PDF Formats Naming Convention

Email a Billing
Create a Purchase Order (Average Cost)
Create a Purchase Order (Std Cost)
Pack and Ship (Average Cost)
Pack and Ship (Std Cost)

A more standardized PDF format naming convention is now available for the Billing, Purchase Order, and Shipment/Packing PDF files. For example, when you create a Billing PDF, the file format will include the customer’s Name, Invoice number, Billing number, as well as the current date and time. The date and time information will be based upon your locale.

Security Information

New Permission Sets

Assign User Permissions

The following two new permission sets have been added with the Summer ’22 release:

  • GL Accountant - Assign this permission set to users who require access to Financial Reports, Consolidations, and General Ledger related functionality.
  • GL Accountant - ERP (only available if the ERP package is installed) - Assign this permission set to users who require access to GL and Reporting related functionality.

Note: For additional information, refer to the related articles in our Security section.

Custom Fields

Custom Fields

A new Custom Fields article that contains a listing of all the new custom fields that were added as part of the Summer ’22 release has been included in the Security section of our Knowledge Base.

Return to top

Summer ’22 Software Corrections

Clone a Financial Report

A “String_too_long” exception that occurred when attempting to clone a Standard Financial Report has now been corrected.

Posting a Foreign Currency, manual Cash Disbursement

When a foreign currency Cash Disbursement (Source = Manual) was applied to a Payable before the Payable was posted, the Currency Gain/Loss was being duplicated. This has been corrected in the Summer '22 release.

Note: There is NO change to the posting of a Cash Disbursement with Source = Payable. When a Payable is paid and the Cash Disbursement is created as a result of this action, the Cash Disbursement continues to post to the Currency Gain/Loss GL Account.

Validation Rule on Inventory Quantity Available 

The validation rule “Outbound_Less_Than_Equal_Inbound on the Inventory Quantity Available object has been corrected so that a negative quantity available is no longer allowed. The new formula is:

(AcctSeedERP__Purchasing_Quantity__c + AcctSeedERP__Inbound_Quantity__c) < (AcctSeedERP__Manufacturing_Quantity__c + AcctSeedERP__Sales_Order_Quantity__c + AcctSeedERP__Outbound_Quantity__c)

Inventory Transfer Visualforce Page

The Inventory Transfer Visualforce page has been updated to support up to 1999 Locations.

Note: This is a temporary solution until this page is remade with Lightning Web Components in a future release.

Quantity Unreceived on a Purchase Order Line

The formula of the Quantity Unreceived field on the Purchase Order Line object has been updated. If a Purchase Order Line is over-received, the formula now sets Quantity Unreceived to 0 (not negative).

IF(AcctSeedERP__Quantity__c-AcctSeedERP__Quantity_Received__c >= 0, AcctSeedERP__Quantity__c-AcctSeedERP__Quantity_Received__c, 0)

Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.