Accounting Seed is pleased to inform you of our Winter ’23 release. This article presents information about the new features and enhancements available in the Winter ‘23 release.
To best understand how to use these new features and enhancements within your business it is important that you first test the Winter ‘23 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.
The Winter ‘23 release includes the features from the Summer ‘22 early access releases (R2 and R3) along with other enhancements.
To print a copy of the Winter ‘23 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.
Winter '23 Schedule
Our Winter ‘23 release was deployed to all sandbox environments on Sunday, October 2, 2022. To benefit from the Winter ‘23 release in your production environment sooner, click here to access the installation links.
Winter '23 Configuration Changes
The Winter ‘23 release includes several configuration setups, which existing Accounting Seed users will need to perform. For more information, refer to the Winter '23 Configuration Changes article.
There are also several optional configuration changes that can be performed by existing and/or new Accounting Seed users, such as add Import Templates picklist values, add additional picklist values to the Type and Source fields, and/or modify the in-app prompt settings.
Winter '23 Contents
- Multi-Ledger Support for Tax
- Import Templates
- Advanced Line Manager
- Release Component added to Accounting Seed Homepage
- Customer Requested Enhancements
- Rerun Reports from the Report Viewer
- Currency Field displays selected Ledger Currency
- Recurring Objects - Clone w/Lines
- Recurring Objects - End Date Formula Change
- Bank Direct Connect - Match Refund Cash Receipts
- Bank Transaction ID - Increase Characters
- Clearer Validation Rule Messages on the Product
- Journal Entry and Recurring Journal Entry - new Fields
- Additional Enhancements
Multi-Ledger Support for Tax
The Winter '23 release includes the ability to configure Tax Settings at the Ledger level instead of only at the org (organization) level. This new configuration at the Ledger level is available for both Avalara’s AvaTax and Accounting Seed’s Native Tax.
Note: If you are using Avalara’s VAT Reporting, this change is not applicable. For more information, refer to the VAT Reporting Settings article.
With this release, a new Tax Settings object has been added, which allows you to create as many Tax Setting records as needed for your business processes. For example, you may have one Ledger where you need to assign a Sales Tax Calculation Mode of Shipment, and another Ledger where you need to assign a Sales Tax Calculation Mode of Point of Sale. Using this example, a Tax Settings record can be created for each Sales Tax Calculation Mode and then associated with the appropriate Ledger.
Selecting the appropriate Tax Setting record from a Ledger record can be performed in one of two ways. The Tax Settings record can be selected from the Multi Ledger Defaults screen or directly from the Ledger screen. If using the Ledger screen, refer to the Edit Tax Settings on a Ledger article for more information. If using AvaTax as your tax method, in addition to selecting the appropriate Tax Setting record, the Sales Tax Company Code for the selected Ledger will need to be included on the Ledger screen or from the Multi Ledger Defaults screen.
In addition to the new Tax Settings object, we have also added a new AvaTax License object. In Accounting Seed, you can now create an AvaTax License record for each of your Avalara Account. Therefore, when creating a new Tax Setting record, an AvaTax License field is available to enter a different license for each record. If you have multiple AvaTax Licenses, a custom tab can be created for the new AvaTax License object. For more information, refer to the Create a Custom Tab article.
AvaTax Exception Report
The Tax Exception Report for AvaTax that allows you to view discrepancies between transactions that were posted in Accounting Seed versus those committed into AvaTax has been updated to include a Ledger drop-down list. Therefore, if you have more than one Transactional Ledger, you can select the appropriate one to run the report to view exceptions.
Tax Settings Record added during Migration
As part of the installation of the Winter '23 release, your existing tax settings will automatically be configured to the new process that is available with this release. Therefore, after the installation of this release, there will be no interruption to your ability to calculate taxes. Once the installation completes, review your Tax Settings records to verify that all values migrated correctly. To review this information, refer to the Review the Tax Settings Record added during Migration section in the Tax Settings article.
Important: The information in the “Review the Tax Settings Record added during Migration” section is only applicable for existing Accounting Seed users. If you are a new user, please refer to the instructions for creating a new Tax Settings record in the Tax Settings article. Existing users can also use this information to create additional new Tax Settings records.
With the Winter '23 release, we added a “Configure Tax on Ledgers” in-app guidance prompt, which will display on the following pages:
- Accounting Seed Homepage
- Billings List View
- Opportunities List View
- Payables List View
The information in the prompt includes a link to the Tax Settings article. Once the prompt displays, it can be minimized, maximized, or closed by clicking X.
A new Import Templates tool is included with our Winter '23 release. This import tool provides the ability to import both the header and lines at the same time, using a single file.
The Import Templates tool allows you to import any of the standard Salesforce objects, any standard Accounting Seed objects, as well as any custom objects.
For each type of object you would like to import records, the main steps include performing a one-time setup and mapping process. Once a file has been imported and mapped to the related fields on the record, the file can be selected and reused, as needed, without having to re-map fields. If the mapping changes or if columns need to be added or removed, you have the option to clone or create a new import template record, re-map the columns, and then import.
Only .CSV files can be imported into the Import Templates tool.
Best Practice: To avoid issues with special characters creating error messages when importing files, we recommend that you save import files using .CSV UTF-8 as the extension instead of only saving as a .CSV file extension.
Import files with up to 200 lines of data can be imported using the Import Templates tool.
Important: For large volume data imports with more than 200 lines, use the Salesforce Data Loader app or the web-based Data Import Wizard tool. For more information, refer to the Import Templates using the Data Loader App and Data Import Wizard article.
The Import Templates tool is available on the Accounting Seed Homepage from Setup | Utilities | Import Templates.
Advanced Line Manager
The Advanced Line Manager functionality has been added to all three Recurring objects (Recurring Billing, Recurring Payables, and Recurring Journal Entries). This new functionality includes a data grid with the expandable and collapsible drawer capabilities, which we have included in other parts of our application, such as Bank Direct Connect. The new data grid for the Recurring Lines provides the ability to create the line data directly from the Recurring record detail page. Thus, saving time from switching between pages.
With this new feature, two new field sets have been added. The Advanced Line Manager Columns field set relates to the top section of the data grid, which displays when the drawer is expanded and also when it’s collapsed. The Advanced Line Manager Drawer field set relates to the section of the data grid that displays when the drawer is expanded. The fields that display on the data grid are configured in these new field sets and can be modified based upon the requirements of your organization. For more information, refer to the Edit a Field Set article.
Features on the new Advanced Line Manager include the ability to clone Recurring Lines, undo/redo the last action or any action prior to saving, as well as the ability to refresh the data grid. Additional rows can easily be added, edited, and/or deleted from the data grid.
A new Lightning Record Page has been created for each of the Recurring objects. The new page will automatically be available on these objects for new Accounting Seed users and also for existing users who are currently using our standard Lightning Record Page for the Recurring objects. If you are an existing Accounting Seed user who is using your own Lightning Record Page for the Recurring objects, you will need to activate the new Lightning Record Page for each Recurring object. For more information, refer to the steps to “Activate the new Lightning page” in the Winter '23 Configuration Changes article.
The new page has been configured as the Org Default for Desktop. The new page label name for each object is listed below:
- Recurring Billing Record Home - Summer ‘22
- Recurring Payable Record Home - Summer ‘22
- Recurring General Entry Record Home - Summer ‘22
Advance Line Manager - Import Line Items into a Recurring Record
The Advanced Line Manager includes an Import button for all three Recurring objects. The Import button in the Advanced Line Manager is similar to the Import Templates tool. The Import process in the Advanced Line Manager provides a quick and easy way to add additional lines into an existing Recurring record. The name of the Recurring record or the Salesforce ID number must be used to import the new lines directly into an existing Recurring record.
The main steps for importing include performing a one-time creation and mapping process. Once a file has been imported and mapped to the related fields on the record, the file can be selected and reused, as needed, without having to re-map fields.
Only .CSV files can be imported using the Import button in the Advanced Line Manager.
Best Practice: To avoid issues with special characters creating error messages when importing files, we recommend that you save import files using .CSV UTF-8 as the extension instead of only saving as a .CSV file extension.
Import files with up to 200 lines of data can be imported using the Import button in the Advanced Line Manager.
Advanced Line Manager - Export Lines on a Recurring Record
The Advanced Line Manager includes an Export button for all three Recurring objects. Export provides the ability to export all of the Recurring Lines into a .CSV file for reviewing and/or updating the data. For example, you might have a large number of lines on a Recurring Billing, exporting the data would make it easier to review all lines in one file, without having to paginate on the screen.
For Recurring Billings and Recurring Payables, up to 250 lines can be exported into a .CSV file, and up to 1,000 lines can be exported for a Recurring Journal Entry. Additionally, since the exported file includes a Salesforce Record ID for each line, you can make changes to the exported file and then, import the file to include the changes. For more information, refer to the Update Existing Recurring Lines (Recurring Objects - Import Templates) article.
Important: Since the Import process handles low volume imports that are up to 200 lines, if you export more than 200 lines and want to re-import, you may need to split up the file so that only 200 lines are imported at a time.
Dynamic Actions on Recurring Objects
Dynamic Actions help to declutter content, such as buttons on a page to make them visible based upon specific criteria. With the Winter '23 release, we have included the ability to add Dynamic Action filters to the Create Billing, Create Payable, and Create Journal Entry buttons. The Dynamic Action filters will automatically be included with the new Lightning Record Page for each of the Recurring objects.
With the Winter '23 release, all three Recurring objects (Recurring Billing, Recurring Payables, and Recurring Journal Entries) will include an in-app prompt.
The in-app prompt is configured to display three times a day for each user on each of the three Recurring pages, without an End Date. Once the prompt displays, it can be minimized, maximized, or closed by clicking X. Additionally, the settings for this prompt can be modified. For more information, refer to the Winter ‘23 Configuration Changes article.
Release Component added to the Accounting Seed Homepage
The Accounting Seed homepage has been revised to add a new Release Component information section. This section points you to information about the main features that are included in the latest installed release. Links to these release notes and links to the features with changes in our Knowledge Base are included directly from the Accounting Seed homepage.
Customer Requested Enhancements
Rerun Reports from the Report Viewer
A new Rerun button has been added to the available options on the Report Viewer. The Report Viewer displays when you click the hyperlink of a generated report to display the report data. By simply clicking the Rerun button from the Report Viewer, the report will be re-generated with the same filters, but will include the updated information, such as data for additional posted transactions. This is a timesaving way to see updated report data without setting up the same filter information.
The new Rerun button is available for Standard Reports (except Ledger Inquiry) and Custom Reports.
For existing Accounting Seed users, if the Rerun button is clicked for a report that was generated prior to the Winter ‘23 release upgrade, any optional settings (Include Subtype 1, Include Subtype 2, Suppress Opening Balance and Period Columns, Suppress Zero Amount Rows, Show all Periods, and/or Report Subtitle) that were included on the initial report will not be stored on the Financial Report Result. Therefore, these optional settings will be ignored when such a report is rerun.
Best Practice: Click Run from Reports screen to generate the report. Then, after this initial run, the Rerun button can be used to re-generate the report with the selected optional settings.
Currency Field displays selected Ledger Currency
When you initially access a Standard Report, the Currency field defaults to the currency of the selected Ledger. If you change the Ledger, the Currency field will automatically change based upon the selected Ledger. For example, if you select a GBP Ledger, the Currency field would automatically populate with GBP. Having the Currency field default to the Ledger currency will save extra keystrokes when running reports.
For Custom Reports, when you initially access a report, the Currency field defaults to the currency of the user’s default Ledger. However, a different or the same currency can be selected.
Recurring Objects - Clone w/Lines
The Recurring objects Clone with Lines feature provides an efficient way to manage the Recurring Billing, Recurring Payable, and Recurring Journal Entry records. This is a quick and easy way to duplicate a Recurring record without having to create one from scratch. Once the clone has been created, information can be updated to reflect the new Recurring record, as necessary.
Recurring Objects - End Date Formula Change
The formula that sets the Status to “Inactive” based upon the End Date field on a Recurring Billing has been updated. If the Next Billing Date is equal to or greater than the End Date, the Status on the Recurring Billing will automatically be set to “Inactive.”
The formula that sets the Status to “Inactive” based upon the End Date field on a Recurring Payable has been updated. If the Next Payable Date is equal to or greater than the End Date, the Status on the Recurring Payable will automatically be set to “Inactive.”
The formula that sets the Status to “Inactive” based upon the End Date field on a Recurring Journal Entry has been updated. If the Next Journal Entry Date is equal to or greater than the End Date, the Status on the Recurring Journal Entry will automatically be set to “Inactive.”
Bank Direct Connect - Match Refund Cash Receipts
Bank Direct Connect - Unmatched Bank Transactions
With the Winter '23 release, a Refund Cash Receipt (negative Cash Receipt) can now be matched in the Bank Direct Connect - Unmatched Bank Transactions screen. This includes Cash-Out Bank transactions that are imported through Bank Direct Connect and Financial File import. A Refund Cash Receipt can be manually matched or auto-matched if you have the "Enable Global Automated Match" setting selected in the BDC - Bank Settings screen. An auto-match will process based upon the Cash-Out Default Matching Setting for the number of days entered in the BDC - Bank Settings screen.
Once a Refund Cash Receipt has been matched, it will automatically move to the BDC - All Bank Transactions screen with a Status of "Matched," and a link to the source record will be available under the Source Link column.
Bank Transaction ID - Increase Characters
The length of the Bank Trx Name field (Bank Transaction ID) that displays on the BDC - All Bank Transactions and BDC - Unmatched Bank Transactions screens has been extended from 50 to 100 characters. This field length has been extended for transactions from both a BDC import and a Financial File import.
Clearer Validation Rule Messages on the Product
When saving a new Inventory Product record, the validation messages that display for the Revenue GL Account, Expense GL Account, Inventory GL Account, and Inventory Type have been updated for clarification. The new error messages now specify the object and field with the issue.
Journal Entry and Recurring Journal Entry - new Fields
Two new fields (Type and Source) have been added to the Journal Entry and Recurring Journal Entry objects. The Type field includes the following values “out of the box.”
- Bank Transfer
- EOM Adjustment
- Sub-ledger Adjustment
The Source field includes the following values “out of the box,” which will display based upon the origin of the Journal Entry:
- Recurring Journal Entry
- Bank Direct Connect
Note: You can add additional picklist values to both the Type and Source fields, if necessary. For more information, refer to the Winter ’23 Configuration Changes article.
Custom Reports - Starting and Ending Accounting Period
With the Winter '23 release, on Custom Reports, the Starting Accounting Period and Ending Accounting Period in the More Information section on Profit & Loss Reports and on Balance Sheet Reports now displays the same as the Starting and Ending Periods on the actual report. This is true for Standard Reports that you cloned as Custom Reports, as well as Custom Reports that you manually create.
Payable Line and Recurring Payable Line - Unit Cost and Total
With the Winter '23 release, the Unit Cost and the Total on a Payable Line and/or Recurring Payable Line can be entered simultaneously, if the Total equals the equation that makes up the Total. The equation is Total = Quantity x Unit Cost + Tax Amount.
Payroll File Import - Aura Enabled Apex Class Change
The Accounting Seed Payroll File Import Aura Enabled Apex class has been updated to now be a Lightning Web Component. This change does not affect the existing Payroll File Import functionality.
Consolidations Run Routine in Progress Message Change
For clarification, the message that displays if you attempt to edit a Ledger within a Ledger Hierarchy when a Consolidations Run routine is in progress has been updated. The message clarifies the validation that prevents you from attempting to reset the Status on a Ledger Hierarchy to anything other than “None,” while the Run routine is in progress.
Default Bank Account Help Text
For clarification, the help text that displays when you hover over the Default Bank Account field on the Ledger page has been updated to remove the reference to the “Cash Disbursement Batch.”
Winter '23 Software Corrections
Cash Receipt Apply Screen
“The Cash Receipt balance cannot be less than zero” error message that was shown on the Cash Receipt screen when a Received Amount that was the same as the Balance was manually entered, has been corrected.
Cash Flow Report Drill Down
On the Cash Flow Report drill down page, the Source column was displaying only the source record for the first transaction. This has now been corrected to display source records for all transactions.
Recurring Payable Line - Advanced Line Manager
Prior to the Winter ‘23 release, an error message displayed when cloning a Recurring Payable Line on the Advanced Line Manager, which was caused by a pre-existing System Business Rule (You cannot enter Unit Cost and Total at the same time). This rule has been modified to allow the Unit Cost and Total to be entered simultaneously as long as the calculation equals the equation that makes up the Total. The equation is Total = Quantity x Unit Cost + Tax Amount.
Cash Disbursement Check
A Salesforce SOQL limit error was shown when trying to pay a Payable and using a Bank GL Account that had 50000+ existing Cash Disbursements. This has been corrected.
Time Zone and Payment Link
A time zone discrepancy caused specific Payment Link payments to set the Receipt Date on a Cash Receipt to the next day from when the payments were actually made. This has been corrected so that the Payment Link now uses the time zone on the org from the Company Information section in Setup.
Sort Ledger Inquiry by Date
The ascending/descending sorting of values in the Date column for the Ledger Inquiry report has been fixed in this release.
Enhanced Related Lists
In our Summer ‘22 R2 (3.116) release, the three new Lightning record pages added for the Recurring objects had related lists that were mistakenly set to default. This has been corrected so that all three pages now have enhanced related lists.
Permission Set Update
The Accounting Seed ERP Administrator permission set was missing permissions that prevented a user with this permission set from being able to create or send the Purchase Order PDF. This has now been addressed by enabling “Read” access to the Automated Email Delivery, Org-Wide Email Address, and VAT Identification Number fields on the PDF Format object.
Software Patch ERP Summer ‘22 (Version 3.53)
This patch has corrected a defect that caused the currency on the Purchase Order PDF to display based upon the user’s currency rather than the currency on the PDF.
Accounting Periods not resetting on Multiple Amortizations
An issue that did not reset the Accounting Periods when performing multiple Amortizations in a single attempt, has now been resolved. The incorrect error message will no longer display and the Amortization calculations are based upon the Accounting Periods supplied for each Amortization.
AmortizationOptions Class not Visible in the API
The issue with the AmortizationOptions class not being visible has been corrected so that you can now create an instance of it for use with the Amortization API.
Salesforce Classic users unable to use Deprecated Visualforce Pages
With the deprecation of the older Visualforce Credit Memo and Cash Receipt Apply screens, Salesforce Classic users were unable to use them because the new Lightning version of the screens were set to open the screens incorrectly. The two screens have now been corrected to open in a new window
Uncategorized Subtotals not Displaying
An issue with uncategorized subtotals not displaying on the Profit & Loss Report has been rectified.