25
We have 40 legal entities, client have to submit daily bank reconciliation statement for all companies, they are asking bank closing balances everyday across all legal entities in single report.
in D365 we can't run TB across all legal entities, also we can't generate same in Management reporter.
please suggest is any why to get this done.
Akkati Suresh
Hi Akkati,
What is the posting process at this company, because for this you could also just create a pretty simple setup (so not the setup I linked before) based on the Year to Date transactions.
So Row definition would be:
Bank account A
Bank account B
Bank account C
etc...
Column definition would be:
Legal Entity A | Legal Entity B | Legal Entity C | etc | Sum of all Legal Entities
Column setup for Periods Covered is YTD, and Legal Entity A to XYZ is set to NP for Print Control. In Sum of all Legal entities a range sum is added which would show all bank balances neatly in one column.
Depending on run time of the report (should not be too long) I would schedule the report to run at 23:45 daily. This would give you the closing balance of that day of the listed accounts (off course you could run it in the middle of the night as well, but it kind of feels more like an opening balance then :D).
Best regards,
Ties
Thank Lundwing,
I have tried this, in this feature some limitation are there, it is considering only specific day transactions, it doesn't gives as on day closing balance.
so i have to add two more columns to get the closing balance as on specific day, i have to set up this for 365 days.
We require a tool or any report to generate closing balances of 40 legal entities bank accounts.
Hi Akkati
Like Ludwig said, there is ample documentation for this. An example;
Best regards
Ties
Hello Akkati,
In the MR you have the option to define a start and end date for each of the columns that hold financial values. This allows you getting a 'daily' trial balance. Note: Those from and to date values do not have to be defined in an absolute manner but can also be defined relative so that you do not have to design the column structure new for each month. Would be great if you could give it a try and let us know if any other help is needed.
Many thanks and best regards,
Ludwig
In management reporters it doesn't allow me to run daywise balances, if I'm missing please share me the steps to get this done
In the management report it is don't allow me to run daywise balances, if it possible please share any documents
Hi Akkati,
I agree with Ties.
Why do you doubt that you cannot achieve this with the management reporter?
Best regards,
Ludwig
Hi Akkati,
You should be able to achieve this with management reporter ( or financial reporter nowadays), could you please tell us what problems you are running into when setting this up in MR?
Best regards
Ties
Share
Report
All responses (
Answers (
