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...
ARInvoice Closed Da...
 
Notifications
Clear all

Questions ARInvoice Closed Date

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 6 years ago
2 Posts
2 Users
0 Reactions
2,166 Views
RSS
FamousMortimer
Posts: 19
 FamousMortimer
Topic starter
July 11, 2019 2:33 pm
(@famousmortimer)
Eminent Member
Joined: 5 years ago

Hi All,

I am a newbie to Acumatica- as in, this is my first week; so I apologize in advance for my ignorance.

I need to create a GI to view AR Invoices and compare the terms (e.g. NET30) against the actual time in days they paid.  I can't seem to find the date that the invoices are closed (paid in full).  I looked in ARInvoice, ARTran, and ARRegister.  It looks like it can be derived from ARTran but I am sure that I am missing something.

Any help is greatly appreciated!


Topic Tags
Generic Inquiry AR Invoice AR
1 Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
July 31, 2019 9:49 am
(@timrodman)
Famed Member
Joined: 10 years ago

Hey Jeremy,

No apologies necessary, newbies welcome here.

Checkout this post and see if it gets you headed in the right direction:

https://www.augforums.com/augforums/acumatica-generic-inquiries/designing-a-generic-inquiry-that-i-can-find-average-days-before-payment-is-received-by-customer-with


Reply
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Unable to Add Field "Unapplied Balance" to Generic Inquiry "Payments and Applications"
    6 months ago
  • Equivalent to Excel Post-Special, "transpose"
    1 year ago
  • Generic Inquiry - Last Modified On Date Change
    1 year ago
  • Generic Inquiry, pulling data from two unrelated sources
    1 year ago
  • Adding Override Contact Info to GI Results
    1 year ago
Topic Tags:  Generic Inquiry (41) , AR Invoice (2) , AR (3) ,
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.

‹›×

    ‹›×