Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Cara Gregory]

Hello,

I am struggling with a financial report that normally balances out to zero each month. In October it had a balance of six cents and in November is has a balance of seven cents. My G/L balances and ties out to the accounts on the report. The admin & management fees at the top come from a spreadsheet calculation – I have manually added the entire year’s spreadsheet and come up with the total on this report. I am wondering if something is funny in the Advanced Financial setup or if something went awry with the integration that we use for the admin/management fees. I’m not sure how else to troubleshoot my issue.  Attached is an image of the report. Thank you in advance.

——————————
Cara Gregory
Accountant
Alvarado Management Company
Albuquerque NM
——————————

[Frank Heslin]

Hi Cara,

In the past when I have run into similar situations, I ended up finding out the some transactions had been entered with more than two decimal places.  I would start with accounts like taxes, that are based on a calculation, to see if any totals have a number other than zero in the 3rd or 4th decimal place.  You may eventually need to look directly into the GP tables to find it. 

Hope this helps!

——————————
Frank Heslin
Financial Systems Administrator
ExamWorks, Inc.
Atlanta GA

Member, GPUG Advisory Committee
Chairman, Georgia Regional GPUG Chapter
Summit 2016 Track Leader

GP2015 R2
MR CU14

Follow me on Twitter: @Automate_It

GPUGGA – http://www.gpug.com/Atlanta

*** Help Us, Help You…provide enough info so that we don’t have to ask for more:) ***
*** If you solve your issue please share the solution to assist others! ***
————————————————————————-

[Cara Gregory]

Thank you Frank.

——————————
Cara Gregory
Accountant
Alvarado Management Company
Albuquerque NM
————————————————————————-

[Cara Gregory]

I finally found it. 🙂

——————————
Cara Gregory
Accountant
Alvarado Management Company
Albuquerque NM
————————————————————————-

[Frank Heslin]

Awesome!  Was that what happened?

——————————
Frank Heslin
Financial Systems Administrator
ExamWorks, Inc.
Atlanta GA

Member, GPUG Advisory Committee
Chairman, Georgia Regional GPUG Chapter
Summit 2016 Track Leader

GP2015 R2
MR CU14

Follow me on Twitter: @Automate_It

GPUGGA – http://www.gpug.com/Atlanta

*** Help Us, Help You…provide enough info so that we don’t have to ask for more:) ***
*** If you solve your issue please share the solution to assist others! ***
————————————————————————-