Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

COA Report Not printing

Posted on by Microsoft Employee

Hi,

Having a weird issue where COA Reports is not generating.  

The other reports off the Accounts page generates.   These two do not work reports:

Reports - > Financial - Accounts -> Fix Allocation

Reports - > Financial - Accounts -> Variable Allocation

Test I done, logged in as SA

-Production server - actual co

-Production server - different co

-Production server - test co (restore from prod)

-Production server - Fabrikam

-Production server - use default reports.dic

-Test server - copy of the production co

-Test server - different co

-Test server - Fabrikam

-Test server - use default reports.dic

I have the sql activity manager open, the other reports that is working, I can see the select statement being run at the time but with these two, its as if nothing is being transmitted into when I run the reports

I also check sql profiler, I see command issue on other reports but not when I print the fix allocation, it only generate this select statement

SELECT TOP 25 FINRPTCH,RTCFGWIN,RTGRSBIN,PRINTED,fileName,DEX_ROW_ID FROM ##1712146 ORDER BY FINRPTCH ASC  

Out of ideas.. does this report require special modules ?

Thanks

*This post is locked for comments

  • Suggested answer
    Mike Bufano Profile Picture
    Mike Bufano 1,480 on at
    RE: COA Report Not printing

    Please share what the report looks like for results.  You don't actually describe your problem.  

    Do you get an error message?

    Do you get a blank report?

    Are there titles on your blank report?

    the two reports that you reference are based on whether your accounting group has setup any Fixed Allocation and Variable allocation accounts.  If they are not setup, then those reports would be blank.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: COA Report Not printing

    FYI,  I have been test everything including building new server.    I'm also ESX/MCSE admin.

    I tested new server with different service packs, upgrades to 2018 from 2016, etc.

    I was able to spin up new server for testing.   Interestingly restoring Dynamics & issue Company to new server produces the same can't generate report problem.

    Restoring CompanyDB WITHOUT Dynamics DB does not produce the same issue.   I was able to print the report without restoring Dynamics.   So something in Dynamics DB is blocking this report

    Now I need to figure out whats not in Dynamics that is in the original server that is causing this report not to generate.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans