web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / FRX is not showing las...
Microsoft Dynamics GP (Archived)

FRX is not showing last year opening balance

(0) ShareShare
ReportReport
Posted on by Rashed Alhakimi 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... 46,633 Moderator on at

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

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at

    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... 46,633 Moderator on at

    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

    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... 46,633 Moderator on at

    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

    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... 46,633 Moderator on at

    Happy to help Rashed!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans