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

Questions Days Past Due

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Leanne Manley 5 years ago
2 Posts
2 Users
1 Reactions
2,910 Views
RSS
lrains
Posts: 8
 lrains
Topic starter
July 25, 2021 10:54 am
(@lrains)
Active Member
Joined: 6 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 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,533 Topics
  • 11 K Posts
  • 46 Online
  • 2,438 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.

‹›×

    ‹›×