Bank Reconciliation, Transfer to General Journal losts the description
Hello, When using the Bank Reconciliation process, you usually use the function Transfer to General Journal to post missing transaction. The General Journal Batch is usually setup with a balancing account sets to the bank account. It allows the user to just type the Account Type and Account No....
Ability to import Bank Reconciliation values from Excel Spreadsheet
As a backup to Yodlee and ADP, we have a request to have a basic Excel Format to allow import of Bank Reconciliation information if needed.
Posted Bank Rec Reconcile Report
We need to show Statement Plus and Minus bank's outstanding transactions is equal to month end GL balance for the cash account Linked to the bank. We need a *posted* bank reconciliation report that can be used during financial audit. The report has to be able to be printed after the bank rec is...
Bank Reconciliation Auto Matching Function - 1
Current Path: Bank reconciliations auto matches only one to one, and can match one Bank Statement Line to many Bank Account Ledger Entries manually. Happy Path: Auto matching and manual matching can occur based on following basis: a. One to one (exists for both auto and manual) b. One Bank State...
Remittance Advice email facility
Hi when printing a remittance advice, the abiltiy to email it directly from financials like other reports, would be excellent
Thank you for your feedback. We released this feature as part of the functionality in April 2019 release of Business Central.
Please refer to the following link for more information:
Sincerely,
Business Central Team
Bank reconciliation and outstanding transaction reports and ability to reprint them for non-North American bank reconciliation method
I have a few clients who do not use the North American bank reconciliation as they need to import a bank statement, and they would like a traditional bank reconciliation report that shows the bank balance, subtracts outstanding checks and payments and adds in deposits in transit. Also, they would...
Allow different columns in a column layout to filter data from different budgets
Client would like different columns in the column layout to be filtered by different budgets ... It's been awhile, but I believe Management Reporter has this capability native. For example, client has typical budget called "BUDGET". When they run account schedule, they will choose the "BUDGET" G...
Mark VAT posting setup as blocked
Because BC does not allow "valid from" and "valid to" dates in VAT rates, users may end up having VAT posting setups that should be kept for historcial purposes but not used with new transactions. It would be very helpful if a VAT setup line could be marked as "Blocked" or "Inactive" to prevent u...
Payment Reconciliation vs. Bank Reconciliation
Dear All, Working with D365 Business Central, it seems that Cash Management requires a thorough review. Currently, it is possible to import bank statement transactions using Bank Reconciliation journal, Payment Reconciliation Journal and General Journal. While bank payment files are created in P...
UPDATE: the past few releases we've made improvement to both bank rec and payment rec journals. - including fixes for some of the docs content has also undergone a few revisions and the sections on Overview of Tasks to Manage Accounts Payable - Business Central | Microsoft Docs and Overview of Tasks to Manage Receivables - Business Central | Microsoft Docs should provide you with a good overview of the two areas as well as linking to related content.
Few pain points, like duplicate entries, Posting Only... in Pmt Rec Journal, etc.., will be addressed in a coming release, so keep an eye on the release plans: Dynamics 365 and Microsoft Power Platform release plans | Microsoft Docs
A few ideas mentioned in your feedback would be better suited as separate Ideas (if you feel like promoting these specifically), but I have noted the feedback and will of course consider it for future releases.
Best regards,
Brian Nielsen, Program Manager
Business Central team
'Limit Totals To' filters - Chart of Accounts
Would be great to have the ability (as in standard NAV) to set 'Date Filters' on the Chart Of Accounts using something like the 'Limit Totals To' functionality.
Regards,
Ben
Thank you for your feedback. This is now available for Business Central on premises or the Business Central October '18 cloud update, in your browser or Windows desktop app.
Learn more about filtering.
Learn more about this and other productivity features in the October '18 update.
Try it out immediately on your Chart of Accounts.
Thanks for your efforts in shaping Business Central,
Mike Borg Cardona
Program Manager, Microsoft
Administrator