Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

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

Categories:
  • 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans