Changes in System Manager 5.4A

Product Name Change

• ACCPAC Advantage Series Enterprise Edition is now Sage 300 Premium.
• ACCPAC Advantage Series Corporate Edition is now Sage 300 Advanced.
• ACCPAC Advantage Series Small Business Edition is now Sage 300 Standard.

If you use Pervasive.SQL Databases

• System Manager now requires the use of ODBC Datasource Names (DSN) when adding or setting up companies. Databases and DSNs should be added using Pervasive.SQL Control Center. You must create an ODBC DSN for each database before you can open the database.

Bank Services

• Prior to upgrading and activating Bank Services, you must:
• Post any open Accounts Receivable receipt batches.
• Resolve, clear and post any deposits that had previously been cleared with a bank error and posted, if the error amounts remain in transit.
• Post reconciliations for any banks that have a reconcile statement in progress. (Specifically, reconcile statements with deposits marked "Cleared", "Cleared with Bank Error," or "Cleared with Write-off".)
• Create G/L batches.
• Print and purge the reconciliation posting journals.
• There are changes to reconciliation when importing OFX statements.
• G/L Integration now has its own form; the options are no longer part of Bank Setup, and have been removed from the Bank Options form.
• An updated Return Customer Checks form allows searches for receipts using information such as customer number, deposit number, check/receipt number, receipt amount or bank receipt amount. After search results are displayed, you can drill down to the underlying receipt.
• You can now set up approved credit cards for use in A/R and A/P transactions, using the new Credit Card Types form.
• A new bank security permission, “View Credit Card Information" has been added.
• Bank Services 5.4A is incompatible with Accounts Receivable 5.3A and earlier versions.
• After activating Bank Services 5.4A, you must activate Accounts Receivable 5.4A or later in order to continue working with Accounts Receivable data.

Changes to the Banks Form

• You can set a spread for credit cards, in the new Credit Card Charges Spread field on the Profile tab.
• A new field, Exchange Rate Difference Spread has been added on the Profile tab.
• A new tab, Account, has been added. Two fields from the Profile tab have been moved to this tab: Bank Account and Clearing Errors Account fields. A new field, Credit Card Charges Account has been added. Users select the G/L account that will be used to write off the credit card charges applied to a deposit. The charges will be written off during bank reconciliation in the same way that bank errors are currently written off.

Changes to Reconcile Statements

• A new menu item – Settings -- has been added with the following command: Save Settings as Defaults.

• Summary Tab:

  The Summary tab has two new fields: Deposit Bank Errors, and Withdrawal Bank Errors. These replace the former Bank Errors field.

  The Summary tab displays a new field, Credit Card Charges, to display the total amount of credit card charges for the bank.

• Entries Tab:

  You can now add comments (up to 250 characters) to Reconcile Statements entries, in a new column on the Entries tab.

• Withdrawals Tab:

  The following are now displayed in the bottom section of this tab: Withdrawals Total; Withdrawals Remaining Outstanding; Cleared Amount; Outstanding Amount; and Write-Off Amount.

  The field, From Check Number has been changed to From Withdrawal Number.

  New fields and buttons:

  • Document button
  • Payment Code
  • Outstanding Amount
  • Write-Off Amount
  • Payment Amount
  • Functional Currency
  • Credit Card Type
  • Cardholder Name
  • Credit Card Number
  • Authorization Code
  • Expiration
• Deposits Tab:

  The following are now displayed in the bottom section of this tab: Deposits Total; Deposits Remaining in Transit; Cleared Amount; In Transit Amount; and Write-Off Amount.

  Deposits can now have two new reconciliation statuses: Cleared With Credit Card Charges and Cleared With Exchange Rate Difference.

  New fields and buttons:

  • Details button
  • Credit Card Type
  • Credit Card Number
  • Cardholder Name
  • Authorization Code
  • Expiration

Changes to Existing Bank Reports

• Reconciliation Posting Journal

  • You can now print details of each individual receipt from a deposit
  • You can now print a summary of G/L transactions that were posted during reconciliation posting.
  • The report now displays deposit amounts that remain in transit and withdrawal amounts that remain outstanding.
  • The report now displays amounts of deposits and withdrawals that have been written off during bank reconciliation posting.

• Banks report

  • You can now print a range of banks.
  • The following new fields are included on the report:
  • Credit Card Charges Account
  • Credit Card Charges Spread
  • Exchange Rate Difference Spread.

• Deposits Status report

  • This report can now be printed for a range of banks.
  • A new option, Print Deposit Details, has been added.

• Withdrawals Status report

  • This report can now be printed for a range of banks.

New Bank Reports

• Bank Reconciliation report

  Displays the result of the last posted bank reconciliation of a bank from the range specified by users. This report explains the difference between the bank statement and company records.

• Transaction Listing report

  Allows users to compare book transactions to the bank statement when performing a reconciliation. It can be printed as a worksheet or as a report.

• Credit Card Types report

  Displays the credit card codes and descriptions entered in your system.

Enhancements to Retainage

• You now have the flexibility to specify when to report tax on retainage.
• Allows you to adjust a document, including calculating the tax amounts in A/R or A/P and posting correct amounts to General Ledger and Tax Services.
• Customer and vendor currencies, the functional currency, and the tax reporting currency are displayed in the Tax Tracking report.

Changes to the Tax Groups Form

• You can now report taxes in a currency (that is, a tax reporting currency) that is different than the customer/vendor currency or the functional currency.
• The Tax Groups form supports reporting of taxes on retainage at the time the retainage is invoiced.

Changes to the Tax Authorities Form

• Tax Authorities supports reporting of taxes on retainage at the time the retainage is invoiced.
• The Source Currency field label has been changed to "Reporting Currency".
• The Maximum Tax Allowable and the No Tax Charged Below values are displayed in the reporting currency.

Changes to Importing and Exporting

You can now view and print a list of the fields that are available for importing and for exporting.

Other Changes

• File Import now checks keys in CSV detail records. If you import transaction files created by other systems, you should test file importing in version 5.4 to ensure that importing still works properly. This is because the 5.4 import functions perform some file checks more rigorously than in previous versions. For example, file import now checks that the key values for details in CSV flat files match the header keys, where, previously, the program did not check the detail keys if they were in the same CSV file as the transaction headers.
• In the Currency Rates form, the Functional Currency field label has been changed to "To Currency." The currency specified can be the functional currency or another currency.
• The Sage Common Desktop is included in this release.