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 Barker 4 years ago
2 Posts
2 Users
1 Reactions
2,302 Views
RSS
lrains
Posts: 8
 lrains
Topic starter
July 25, 2021 10: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 Barker
Posts: 30
 Leanne Barker
August 11, 2021 8: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
  • 32 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
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.

‹›×

    ‹›×