AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
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,587 Views
RSS
Jake Hickey
Posts: 38
 Jake Hickey
Topic starter
January 9, 2020 4:30 pm
(@jake-hickey)
Trusted Member
Joined: 8 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: 3204
 Tim Rodman
Admin
January 31, 2020 11:12 pm
(@timrodman)
Famed Member
Joined: 11 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,533 Topics
  • 11 K Posts
  • 61 Online
  • 2,438 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×