Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Cary West]

Hi –

Is there a way to pull bank balances from GP into Management Reporter?

We’re looking at Nolan Group’s product ABR to handle our numerous GL cash accounts that are pooled into one bank account. Getting the bank balances into Management Reporter will allow us to compare our book balances (in detail by individual GL cash accounts) to the bank balances. 

We’re a government entity with several funds which each having their own chart of accounts. Our account segment is such (####-$$$$$$) where #### is the fund number and $$$$$$ is the GL account number. 

Thank you,

Cary

——————————
Cary West
Treasury Operations Manager
Grant County PUD
Ephrata WA
——————————

[Rob Klaproth]

Management reporter is designed to only report off the GL.  So as long as all your cash account balances are up to date you should be able to see it.  You can see the Reference field from your subledgers that post to the GL by adding another column to the column layout.  The column type is called attr and once you select it you’ll be able to pick from things such as originating reference number or originating description.  

Sent from my iPhone

——Original Message——

Hi –

Is there a way to pull bank balances from GP into Management Reporter?

We’re looking at Nolan Group’s product ABR to handle our numerous GL cash accounts that are pooled into one bank account. Getting the bank balances into Management Reporter will allow us to compare our book balances (in detail by individual GL cash accounts) to the bank balances. 

We’re a government entity with several funds which each having their own chart of accounts. Our account segment is such (####-$$$$$$) where #### is the fund number and $$$$$$ is the GL account number. 

Thank you,

Cary

——————————
Cary West
Treasury Operations Manager
Grant County PUD
Ephrata WA
——————————

[Cary West]

Hi Rob,

Thank you for your reply. I was hoping MR could run a detail GL balance report and compare to the bank balances brought into GP from a BAI file daily feed. Since MR is really used for GL reporting, then it’s probably not set up to pull from another table in GP that would have our bank balances from the BAI file.

Thanks again!

Cary 

——————————
Cary West
Treasury Operations Manager
Grant County PUD
Ephrata WA
——————————
——————————————-

[Rob Klaproth]

Cary,

If you are importing the bank balances directly to your GL then Management Reporter can report on them, you just need to create a balance sheet report, and add those accounts to the balance sheet.  

If you are pulling ALL of your bank account balances into a single GL, and you were hoping to see the balances separated, you can link an Excel worksheet to MR and pull the balances in that way.

Please note the biggest technical issue I have seen:

Management Reporter runs as a “Service” on your GP terminal or SQL server (depending on how you have it deployed).     The account under services that MR runs under needs to have permission to the workbook you link MR to, or it will fail to generate a report.

So, if your service account is GPService or MRService, make sure you give that account full control to the folder where the Excel Workbook is.  Do not link to a file on your PC, make sure you copy it either directly to the GP server where MR is installed and link locally, or copy it to a network folder and make sure your MR service account has access.

To find out what account MR is running under either launch the configuration console and you will see the account in the format of domainaccount 

Or go to services in administrative tools – and go down to the Management Reporter application service and review the “login” name.

Here are the instructions:

http://www.interdynbmi.com/blog/how-link-external-spreadsheet-management-reporter-report

Rob

Rob Klaproth

Sr. Consultant II – Dynamics GP

rob.klaproth@amllp.com

 

Armanino^LLP

11512 El Camino Real Suite 311 | San Diego, CA 92130

858 794 9401 main |  858 207 5137 direct | 619 243 4939  mobile

LinkedIn | amllp.com

——Original Message——

Hi Rob,

Thank you for your reply. I was hoping MR could run a detail GL balance report and compare to the bank balances brought into GP from a BAI file daily feed. Since MR is really used for GL reporting, then it’s probably not set up to pull from another table in GP that would have our bank balances from the BAI file.

Thanks again!

Cary 

——————————
Cary West
Treasury Operations Manager
Grant County PUD
Ephrata WA
——————————