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 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,508 Views
RSS
SQLRunner
Posts: 45
 SQLRunner
Topic starter
February 14, 2024 5:12 pm
(@sqlrunner)
Trusted Member
Joined: 9 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,533 Topics
  • 11 K Posts
  • 144 Online
  • 2,439 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.

‹›×

    ‹›×