Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Management Report

Posted on by 15
I am preparing month wise TB and I Need Difference b/w each month as percentage. Following way I prepared the column definition and in Report I am not getting the correct percentage especially when we have "0' Amount in one of the month. could you Please let me know is there any other way to prepare it. In Row Definition I Just copy all Chart of account. 
    JANUARY JANUARY JANUARY FEB FEB FEB   JAN-FEB-%
DATE VOUCHER DR CR CB DR CR CB    
                   
ATTR ATTR FD FD CALC FD FD CALC CALC CALC
Transaction Date Voucher Actual Actual   Actual Actual      
    BASE BASE   BASE BASE      
    1 1   2 2      
    PERIODIC PERIODIC   PERIODIC PERIODIC      
        E+F     (H+I) (J-G) (K/G)*100
AutoFit AutoFit AutoFit AutoFit AutoFit AutoFit AutoFit AutoFit AutoFit AutoFit
                   
                   
    NP NP   NP NP   NP  
    DR CR   DR CR      
 
 
Categories:
  • CU28091606-0 Profile Picture
    CU28091606-0 15 on at
    Management Report
    Dear I have updated same as mentioned above but the percentage is gone wrong when January is Zero and February having Transaction. How could correct this 
  • Verified answer
    Burley Profile Picture
    Burley 16 on at
    Management Report
    I don't think the columns with column restriction for debit and credit are needed or doing the calculation of net change since the debit and credit are NP (non-printing) anyway. Remove the column restriction with Periods Covered as Periodic, and it shows the month's net amount. Then do the calculation for the difference and then another calculation for the % change. For the % change, there needs to be a format/currency override so that it shows as a percentage rather than multiply by 100.
      F G H I
      September October September to October difference % Change
             
    Column Type FD FD CALC CALC
    Book Code Actual Actual    
    Fiscal year BASE BASE    
    Period 9 10    
    Periods Covered PERIODIC PERIODIC    
    Formula     G-F H/F
    Column Width AutoFit AutoFit AutoFit AutoFit
             
    Format/Currency Override       ###0.00%;(###0.00%)
     
    Results:
     

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,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans