Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

FRX is not showing last year opening balance

Posted on by 2,095
Dear All ,
 
I will appriciate if you can help me to solve small issue on FRX , the report once generated is not showing the opening balance for the previouse year . its only showing for the current year .
 
how to include the opening balance in the current report from the previouse fiscal year .

Thank you and B. Regards

Rashed

*This post is locked for comments

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Re: Re: Re: Re: Re: Re: FRX is not showing last year opening balance

    Happy to help Rashed!

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: Re: Re: Re: Re: FRX is not showing last year opening balance

    Dear Frank ,

     Thank you very much for your help .. it works this way . Appriciates your kind support .

    Thank you 

     Rashed

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Re: Re: Re: Re: FRX is not showing last year opening balance

    Rashed,

    The fix for this is either add another column in your column layout that with 'Cur' as the period ID and hide it, or change the level of detail in the report to 'Financial' or 'Financial and Account'. 

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: Re: Re: FRX is not showing last year opening balance

    Dear Mr. Frank ,

     Thank you for your reply . i tried the YTD option only and error msg comes (link shows the print screen of the error message)

    http://felixairways.com/gp/frx.JPG

     

    Thank you

    Rashed

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Re: Re: FRX is not showing last year opening balance

    Rashed, change the setting in the Current Per/YTD field to be YTD.  That should do it for you.  Current Period will return only Current Period activity, YTD/BB will return only the Beginning Balance for the current year.  YTD returns the Beginning Balance plus all activity up through the current period.

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: FRX is not showing last year opening balance

    Hi Frank ,

     Thank you for reply. actually the fiscal year is closed . the column of GL was designed in this way :

                                       GL

    Book Code               Actual

    Fiscal year               Base

    period code              Base

    Current per/YTD      CUR

    using this design i was not able to see the opening balance.

    so i tried to do some modifications in this design i am not sure weather its totaly true or not. i added another GL column

    and added the current per/YTD to be YTD/BB and this shows only the opening not the current ..

    it becomes confusy for me ..

    note : the default base period is choosen as c

    thank you for ur kind.

    Rashed

     

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: FRX is not showing last year opening balance

    Is the previous fiscal year closed? If not, FRx will not reflect it in the reports unitl it is.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans