AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
General Ledger
 
Notifications
Clear all

Questions General Ledger

 
Acumatica Report Designer
Last Post by Tim Rodman 6 years ago
2 Posts
2 Users
0 Reactions
1,181 Views
RSS
Jake Hickey
Posts: 38
 Jake Hickey
Topic starter
January 9, 2020 4:30 pm
(@jake-hickey)
Trusted Member
Joined: 7 years ago

I am trying to build a general ledger by tweaking the Transactions for Account report. All I really did was add a range for the accounts instead of having it pull just one account. Along with a little bit of other stuff, I essentially got to where I need to be except for one problem. Only the first account gets a beginning balance, and every other account starts off with zero. I believe this issue is arising from the $BegBalance variable, but I'm not sure how to get around it. Currently the code for this variable (which was already in the system) looks like

                =$BegBalance +
                IIF
                ( CStr($PrevBranchID) + CStr($PrevSubID) + CStr($PrevFinPeriodID) <>
                CStr([GLHistoryByPeriod.BranchID]) + CStr([GLHistoryByPeriod.SubID]) + CStr([GLHistoryByPeriod.FinPeriodID])
                And [GLHistoryByPeriod.FinPeriodID] = [@StartPeriod],
                IIF
                ( (([Account.Type] = 'I' Or [Account.Type] = 'E') And Payments.ArePeriodsInSameYear([GLHistoryByPeriod.FinPeriodID.Raw], 
                [GLHistoryByPeriod.LastActivityPeriod.Raw]))
                Or ([Account.Type] = 'A' Or [Account.Type] = 'L'), IIF
                ( [GLHistoryByPeriod.FinPeriodID] = [GLHistoryByPeriod.LastActivityPeriod],
                IsNull([HistoryLast.FinBegBalance], 0),
                IsNull([HistoryLast.FinYtdBalance], 0)
                ),
                0
                )
                , 0
                )

I'm not great at coding, so I'm not sure if there is something in here prohibiting two accounts from getting a beginning balance, or maybe there is something I could add to allow it. I already tried resetting the variable after every account, but that seemed to just make every account, even the first one, have a beginning balance of zero.


1 Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
January 31, 2020 11:12 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Can you attach your .rpx file? Part of what I want to see is where in the report the variable is calculated.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 52 Online
  • 2,389 Members
Our newest member: Dan Hunting
Latest Post: Generic Inquiry Screenid changes to ScreenId=00000000
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Julie Baker
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×