16

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....

Read more...

2 Comments

Read more... 2 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator
This has been delivered with Wave 2, 2021 release (October), so you should see it soon.

Business Central Team
16

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.

Read more...

1 Comments

Read more... 1 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator
This will be available in Wave 2, 2021 (April 2021)

Best regards,
Brian Nielsen, Program Manager
15

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...

Read more...

6 Comments

Read more... 6 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator
An update to the Bank Statement report will be available in Wave 1, 2022 (April)

The Bank Statement report will carry over the Outstanding Payment and Outstanding Check amounts as of when the bank reconciliation is posted.

Best regards,
Brian Nielsen, Program Manager
Business Central Team
15

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...

Read more...

0 Comments

Read more... 0 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator
Many-to 1 matching was delivered in wave 2, 2021 release (October)


Best regards,
Business Central Team


14

Remittance Advice email facility

Hi when printing a remittance advice, the abiltiy to email it directly from financials like other reports, would be excellent

Read more...

1 Comments

Read more... 1 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator

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 

12

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...

Read more...

0 Comments

Read more... 0 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator
The Bank Statement report (for posted bank reconciliation) have been updated to carry over the outstanding bank payments and checks as of when the bank rec has been posted.

Neither the test report nor the bank statement report include any non-posted entries (journal entries or deposit entries) - but it's a good idea we'll look at for a future release.

Best regards,
Brian Nielsen, Program Manager
Business Central Team

 

12

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...

Read more...

1 Comments

Read more... 1 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator
This has been delivered with the Wave 2, 2021 (October) release

Best regards, Business Central Team
12

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...

Read more...

0 Comments

Read more... 0 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your feedback. We released this feature as part of the functionality in Block VAT and General Posting Setups.

Please refer to the following link for more information:

Sincerely,
Business Central Team
12

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...

Read more...

0 Comments

Read more... 0 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator

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


12

'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

Read more...

1 Comments

Read more... 1 Comments

Category: Financial Management (892)

STATUS DETAILS
Completed
Ideas Administrator

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