AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Excel Talk
    • Blog
    • Forums
  • Courses
  • Consulting
  • Login
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Velixo Reports for ...
ACCOUNTENDINGBALANC...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions ACCOUNTENDINGBALANCE difference

    Last Post
RSS

Daniel Lehn
Posts: 21
 Daniel Lehn
Topic starter
July 9, 2018 1:01 pm
(@daniel-lehn)
Member
Joined: 4 years ago

Hello! I'm comparing the result of a Velixo ACCOUNTENDINGBALANCE formula with what Acumatica is saying the ending balance for that account is on screen GL404000, and I'm seeing a small difference. Does anyone know if they should be the same value, or what may cause a difference?

4 Replies
Gabriel Michaud
Posts: 55
 Gabriel Michaud
July 10, 2018 11:55 am
(@gabriel)
51-100 Posts
Joined: 2 years ago

Hi Daniel,

The balance should be the same. Please double check that the companies, branch, financial period and account list is the same. If you want to send me your spreadsheet by e-mail with temporary credentials I can also take a look and verify why it's different (e-mail: gabriel at velixo.com). 

Velixo Reports Pro has a new feature called drill-down which is especially useful to help identify differences like that. Here's an example:  http://recordit.co/Ro4YQeLjt8

Gabriel

Reply
Tim Rodman liked
Daniel Lehn
Posts: 21
 Daniel Lehn
Topic starter
July 12, 2018 4:33 pm
(@daniel-lehn)
Member
Joined: 4 years ago

Thanks Gabriel, I'll take you up on that offer for review. 

I'm excited to start using Pro. Thanks for your work on this, it's a good product.

Daniel

Reply
Gabriel Michaud
Posts: 55
 Gabriel Michaud
July 14, 2018 9:52 am
(@gabriel)
51-100 Posts
Joined: 2 years ago

For the benefit of other forum members - Daniel sent me his spreadsheet and I investigated the problem. It turns out that the balance in Velixo Reports matches what is displayed in Acumatica Analytical Reports, as well as the Account Summary screen. There's a slight discrepancy in the Account Details screen caused by an integrity issue in the GL History tables. It can be resolved by running the Validate Account History (GL509900) process. I think it's the first time in almost 9 years of using Acumatica that I see this.

Daniel, thanks for your feedback on Velixo Reports!

Gabriel

Reply
Daniel Lehn
Posts: 21
 Daniel Lehn
Topic starter
July 14, 2018 11:26 am
(@daniel-lehn)
Member
Joined: 4 years ago

I'm glad to have provided a rare error, for what it's worth. I'll further explore this Validate Account History function. Thanks for taking the time to look at this, Gabriel!

Reply
Tim Rodman liked
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
2,145 Topics
9,532 Posts
7 Online
1,679 Members

Latest Post: Want to create a Generic Inquiry to manage files that are attached to sales orders Our newest member: Lynn Slottke Recent Posts Unread Posts

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×