Skip to main content

Notifications

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 forum (Archive) / Exclude beginning bala...
Microsoft Dynamics GP forum (Archive)
Answered

Exclude beginning balance from YTD columns

(2) ShareShare
ReportReport
Posted on by JGarcia123 1,336

Is it possible to exclude the beginning balance from a year to date column.  We are trying to create a YTD trial balance with a beginning balance (YTD\BB), debit (YTD), credit(YTD), and ending balance(YTD) column.  The report works, but we noticed that the beginning balances are included in the  (debit and credit) activity columns.  Without doing a series of calculated columns, is there an easy way to exclude the YTD component in the two activity columns?  Please advise.  Look forward to a response.

This is MR CU16

Just a quick update, we resolved the issue by creating non printing YTD/BB and YTD columns for both the debit and credit.  Then did a calculated column to subtract out the YTD/BB from the YTD column..  

JG.  

Categories:
Financial Management
Management Reporter
  • Community member Profile Picture
    Community member 6 on at
    Exclude beginning balance from YTD columns
    Just wanted to say thank you for having the same question I had and updating your post to include your solution. Truly a GOAT of the Dynamics forums. 
  • Verified answer
    Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Exclude beginning balance from YTD columns

    Hi JG,

    Unfortunately, there is a not a way to exclude the beginning balance from a YTD column.  YTD columns will include the beginning balance.  You can do like you did and create a calculation and subtract out the beginning balance.  Or, you could add a Periodic column and then set the Period to 1:BASE.  That would pull in amounts from Period 1 to the base period (the period in the report), and would not include the BBF.  

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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard > Microsoft Dynamics GP forum (Archive)

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans