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 Generic I...
Days Past Due
 
Notifications
Clear all

Questions Days Past Due

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Leanne Manley 4 years ago
2 Posts
2 Users
1 Reactions
2,497 Views
RSS
lrains
Posts: 8
 lrains
Topic starter
July 25, 2021 9:54 am
(@lrains)
Active Member
Joined: 5 years ago

I am trying to write I GI that will feed a business event to take certain sales orders off hold.  One of the criteria I need to evaluate is the customers current Days Past Due.  I see where the Days Past Due limit is set on the Customer but I don't see anywhere that the current past due days is stored in a table.

Any ideas?

Or do I have to calculate it on the fly from the oldest open invoice due date? (Which will be problematic in the GI since I will need to avoid grouping - because of the Business Event)


1 Reply
Leanne Manley
Posts: 30
 Leanne Manley
August 11, 2021 7:58 pm
(@myobadvanced)
Trusted Member
Joined: 6 years ago

In ARBalances table there is OldInvoiceDate which is the fist due date (oldest invoice due)


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 43 Online
  • 2,411 Members
Our newest member: thollings
Latest Post: Generic inquiry with information from Audit history(CT301000)
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

 No online members at the moment

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.

‹›×

    ‹›×