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
Acumatica Forums

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

Forums
AUG Forums
Acumatica Generic I...
GLHistory Dates vs ...
 
Notifications
Clear all

Questions [Solved] GLHistory Dates vs period

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by SQLRunner 2 years ago
1 Posts
1 Users
1 Reactions
1,271 Views
RSS
SQLRunner
Posts: 45
 SQLRunner
Topic starter
February 14, 2024 5:12 pm
(@sqlrunner)
Trusted Member
Joined: 8 years ago

Is there a way to get GLHistory data dates?  The GLHistory DAC only has the period.  Does this data exist on a transactional table by chance?  User wants the data split out by weeks and not period.  We would need the date of occurrence for this request and not just the period.

 

In the example below, we want to target the ending balance and split it across the weeks of a month that the payments occur.  The DAC being used is GLHistory, which does not have a full date, just a period.

 

image

Tim Rodman reacted
Topic Tags
glhistory periods DAC
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Primary key list for each DAC Table
    7 years ago
Topic Tags:  glhistory (1) , periods (1) , DAC (4) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 36 Online
  • 2,420 Members
Our newest member: Katerina Pawlowski
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
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

  • Tim Rodman
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×