Product Improvements - Bank Reconciliation

72821 

• A provision is made for Contra voucher created from Auto BRS screen to behave as payment voucher: When you click C: Create Voucher option in Bank Reconciliation screen to record a withdrawal entry shown under Amount Not Reflected in Company Books and change the voucher type to Contra, it will behave like a payment transaction rather than a cash receipt entry.

74643

• Receipt voucher created from unlinked transactions was not reflecting in Bank Reconciliation screen, resolved: When the option Use Default for Bank Allocations was enabled in F12: Configure of a receipt voucher, the receipt voucher created from unlinked transactions was not appearing in the Bank Reconciliation screen, when it was viewed/generated again.

  Now, the receipt voucher created from unlinked transactions appears in Bank Reconciliation screen.

86067

• The transaction created by duplication was not appearing in Bank Reconciliation after changing the voucher type, resolved: When a payment/receipt/journal/contra transaction in single or double entry mode was duplicated, and the voucher type was altered, it was not appearing in Bank Reconciliation screen  when:

• The option Use Default for Bank Allocations was enabled, and voucher type was changed.

• The option Use Default for Bank Allocations was disabled, and details in Bank Allocations screen were altered.

  Now, the transaction created by duplication appears in Bank Reconciliation screen even when voucher type is altered.

76981

• Error was displayed in the Calculator panel when a payment voucher was being converted to Contra voucher in Bank Reconciliation screen, resolved: You can now convert a payment voucher created using the option C: Create Voucher in Bank Reconciliation screen to Contra by clicking on F4: Contra button without any error being displayed in the Calculator panel.

79433

• In the Bank Reconciliation screen, Forex Details were not appearing formatted, resolved: When the option Show Forex details also was enabled, the Forex details displayed in the Bank Reconciliation screen was extending to the Date column if the amount was large.

  Now, the details are aligned to be displayed appropriately under the Particulars field and is not extended to the Date field.

71622

• Printing Configuration screen was not being displayed when the option Print after saving Voucher was  enabled in the payment voucher creation screen, resolved: In Bank Reconciliation screen, when a payment transaction was created to record withdrawals for balancing amounts not reflected in company books, the voucher printing screen was not being displayed on saving such a voucher, though the option Print after saving Voucher was enabled in the voucher type.

  The printing configuration screen is now displayed when the Print after saving Voucher is enabled in the voucher creation screen.

74639

• Unreconciled transactions description field text was not being clearly displayed, resolved: In the Bank Reconciliation screen, the text in the description field under Amount not reflected in Company Books was appearing unclear. This was occurring when the bank statement was being imported for Auto BRS. As a result, when the option Show Payment Favouring/Received From was enabled in the configuration screen, it was difficult to read the text in the Description field.

  Now, irrespective of whether the option Show Payment Favouring/Received From is enabled, the text in the description field is clearly visible, and extends only till the Vch Type column.

68047

• Balance as per Bank in the Bank Reconciliation report was displaying incorrect sum total, resolved: The Balance as per Bank field in the Bank Reconciliation report was displaying incorrect amount as it was considering the sum total of the entries made prior to the From period.

  This was occurring when the From date in the Change Period screen was changed to a date prior to the first transaction listed, and the F12: Configure option Show all Unreconciled Transactions Till Date was set to No.

  Now, the Balance as per Bank will display the amount for only those transactions that are created within the specified period.

71623

• Bank transactions with bank date greater than the reconciliation period were getting listed for reconciliation, resolved: While reconciling transactions using R: Reconcile Unlinked option from Amounts not reflected in Company Books, the transactions already created, with bank dates greater than the period defined, were getting listed in the Unreconciled Transaction screen.

  Now, bank transactions which are not in the defined period are not getting listed for reconciliation.

72082

• The issue with printing formal receipts, resolved: You can now print formal receipts from the receipt voucher opened in display mode from the Bank Reconciliation screen.

  Bank details specified in the Bank Allocations screen also get printed in the formal receipts.

70311

• The Enter: Display button in Bank Reconciliation screen appears as active for user logins that are disallowed complete access to vouchers, resolved: When a user without full access for vouchers opens Bank Reconciliation report, the Enter: Display button which is used to open selected voucher, appears active. The message No Access allowed was displayed on clicking this button.

  The user logins for which full access is disallowed to vouchers will not be able to create, alter or view vouchers from any screen. However, in Bank Reconciliation screen the option Enter: Display provided to view vouchers from the report was active for such users. And the message No access allowed was displayed on clicking the button. Now, the button Enter: Display will be displayed in inactive mode and no message will be displayed on clicking the inactive button.

77061

• In Opening Bank Allocations screen, cheque number entered was not being retained if it was from an existing cheque range, resolved: If the Opening Bank Allocations was updated by providing cheque number from the cheque range defined for the same bank, the cheque numbers appeared reshuffled when Opening BRS was viewed again.

  Opening BRS helps to update unreconciled transactions and opening balance for a bank ledger. If cheque numbers from cheque range of the same bank were recorded for this process, then on viewing the Opening BRS again the cheque numbers were not being retained as recorded and appeared re-shuffled.

  Now, cheque number entered from an existing cheque range will be retained.

80049

• Debit balance of forex transactions was appearing as credit balance with a negative sign in Bank Reconciliation, resolved: The Bank Reconciliation screen was displaying debit balance of forex transactions in the credit column when the option Show Forex Transactions only is enabled in F12: Configure. This was occurring when the bank ledger had credit balance.

  Debit balance of forex transactions will now appear in debit column if the option Show Forex Transactions only is enabled in F12: Configure even when bank ledger has credit balance.

81822

• Error was occurring while importing bank statements in Remote Client, resolved: Error was occurring while importing bank statement in the client machine by clicking B: Bank Statement, and selecting the required file type. Also, if the path of the bank statement folder was provided, the files were not being displayed.

  Now, by clicking B: Bank Statement, and selecting the required file type, the bank statement’s name appears in the List of Files sub-screen. You can select the required bank statement and import it.

94178

• Transaction Type selected for a transaction in Opening BRS was not being retained when the same was disabled, resolved: The Transaction Type assigned to a transaction using Alt+U: Opening BRS was not retained when the screen was saved and opened again after disabling the transaction type in Banking Features of F11: Accounting Features.

  Now, Transaction Type stored already will be retained even when the same is disabled.

89003

• Memorandum vouchers were being displayed for Opening BRS after splitting company data, resolved: Memorandum vouchers are not regular vouchers, and hence do not participate in bank reconciliation, unless regularised. When a company was split, the memorandum vouchers were getting regularized, and displayed in the Opening BRS of the newly formed company.

  Now, Memorandum vouchers are not displayed for Opening BRS after splitting company data.

80200

• Bank values were not updated in Bank Reconciliation screen when bank dates were provided for unreconciled transactions, resolved: The values in Amounts not reflected in Bank and Balance as per Bank fields were not being updated when Bank Dates were provided for unreconciled transactions.

  This was occurring when BRS screen was opened from Display > Accounts Book > Cash/Bank Book(s) >  Bank Ledger, and when the From and To fields in the F2: Period were blank. However, the values were updated if Bank Reconciliation was accessed from Banking menu.

  Now, the values in Amounts not reflected in Bank and Balance as per Bank fields are updated when Bank Dates are provided.

85113

• Payroll transactions were not grouped in batches in the Bank Reconciliation screen of Kotak Mahindra Bank, resolved: In the Bank Reconciliation screen of Kotak Mahindra bank, payroll transactions were not getting grouped into batches even when the option Enable Batches for Payments Generation was enabled in the bank master of Kotak Mahindra Bank, and when Generate Batches on in banking features was set to Export.

  Now, Payroll transactions are grouped in batches in the Bank Reconciliation screen of Kotak Mahindra Bank.

65743

• Appearance of names in Bank Reconciliation screen did not change on selecting a different Display Name Style, resolved: When a different Display Name Style was selected in Appearance of Names field of F12: Configuration screen, the names in the particulars column of Bank Reconciliation screen did not appear as per the changed settings. However, the changes were getting affected when the report was regenerated.

  Now, the appearance of names in the particulars column of Bank Reconciliation screen changes immediately after saving the settings in F12: Configuration.

72078

• Error message was appearing in calculator panel when linking unlinked transactions, resolved: After importing a bank statement, when linking unlinked transaction, the following error messages were displayed in the calculator panel:

• FUNCTION: ‘AutoBRSUnReconListEnter’ LABEL: 0042: Variable ‘Is AutoBRSLinked’ could not be found!

• FUNCTION: ‘AutoBRSUnReconListEnter’ LABEL: 0042: Action execution failed!

  Now, error message is not displayed in the calculator panel when linking unlinked transactions.

77511

• Error message in calculator panel when bank date lower than instrument date, resolved: When saving the bank reconciliation statement by pressing ALT+C, ALT+U or ALT+F12, and if the bank date was lower than the instrument date, then the following error messages were displayed in the calculator panel:

FUNCTION: ‘EBankRecon RangeSave’ LABEL: 0035 : Action execution failed!

FUNCTION: ‘EBankRecon RangeSave’ LABEL: : Action execution failed!

FUNCTION: ‘EBankRecon RangeSave’ LABEL: : Action execution failed!

FUNCTION: ‘EBankRecon RangeSave’ LABEL: : Action execution failed!

The error messages appeared even though the option Allow back dated reconciliation was disabled.

93238

• Bank Reconciliation screen in second child company was showing Balance as per Bank of previous year after split, resolved: When a company with multiple years data was split, the Bank Reconciliation screen in second child company was displaying Balance as per Bank of the year in which transactions were reconciled.

  Now, reconciled transaction values from the parent company will not be carried forward to the second child company.  Thus reconciled data from previous years is not displayed in the second child company’s Balances as per Bank field.

85078

• In e-Payments report, reimporting of intermediate files was not being validated, resolved: In e-Payments report, if an intermediate file was reimported, message stating that the file is already imported or the file name is duplicate was not displayed. This was occurring because the imported files were not archived for future validation.

  Now, when an intermediate file is imported in e-Payments report, a suffix .imp is added to the file name and moved to the configured location. Further, the importing process will check the archived file names during new imports for duplicates, and display appropriate message.

77592

• Bank date for last transaction was not saved when a transaction was altered from the Bank Reconciliation screen, resolved: When a transaction was opened from Bank Reconciliation screen using Ctrl+Enter: Alter option and saved, then the last transaction was not reconciled. This was occurring when bank dates were recorded manually or by using S: Set Bank Date option.

  Now, the bank date for last transaction is saved even when a transaction is altered from the Bank Reconciliation screen.

86151

• Error message was being displayed in calculator panel when transaction under Amount not reflected in the company book was reconciled using R: Reconcile Unlinked option, resolved: In Bank Reconciliation screen, if bank statement is imported, and the transaction under Amount not reflected in the company book section is reconciled using R: Reconcile Unlinked option, the following events occurred:

• The message Reconciled successfully was displayed but the transaction being displayed as unreconciled, and bank date was not updated.

• An error was displayed in the calculator panel.

•  The cheque number from the transaction in imported bank statement was replaced with the cheque number in the transaction under company books.

  Now, the issues are resolved, and the error message is not displayed in calculator panel.

77861

• POS invoice created by duplicating a reconciled transaction was appearing as reconciled, resolved: When a POS invoice was created by duplicating reconciled transaction, the newly created voucher was marked as reconciled, and was not appearing in the Bank Reconciliation screen.

  Now, POS invoice created by duplicating a reconciled transaction is treated as new transaction, and is displayed in the Bank Reconciliation screen.

80163

• Reconciled Opening BRS details were not being displayed in the Bank Reconciliation screen, resolved: Reconciled Opening BRS details were not displayed in the Bank Reconciliation screen even when the option Show Reconciled Transactions was enabled in the F12: Configure screen. But these details were displayed when the option Show All Unreconciled Transactions Till Date was enabled.

  Now, the Bank Reconciliation screen displays all reconciled transactions when the option Show Reconciled Transactions also is enabled. It displays all unreconciled transaction till date from the beginning of the period when the option Show All Unreconciled Transactions Till Date is enabled.

72075

• Credit/Debit card number recorded in POS Invoice was displayed being against cheque in the Bank Reconciliation, resolved: This was occurring when both card and cheque payment modes are selected in POS invoice. The card number was being displayed in the Instrument No. column of Bank Reconciliation screen against both credit/debit card, and cheque transaction types.

  Now the Instrument No. column will be blank if cheque number is not recorded in POS invoice with multiple payment modes.

 66887

• Auto Bank Reconciliation was failing when opening BRS was recorded manually, resolved: Auto Bank Reconciliation failed when bank statement was imported when,

• Opening BRS was recorded manually.

• Auto reconciliation was executed in second child company containing unreconciled transactions carried forward from the parent company.

  Now, Auto Bank Reconciliation is working when opening BRS is recorded manually.

   

See also: