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

Questions ARInvoice Closed Date

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 7 years ago
2 Posts
2 Users
0 Reactions
2,652 Views
RSS
FamousMortimer
Posts: 19
 FamousMortimer
Topic starter
July 11, 2019 2:33 pm
(@famousmortimer)
Eminent Member
Joined: 6 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: 3204
 Tim Rodman
Admin
July 31, 2019 9:49 am
(@timrodman)
Famed Member
Joined: 11 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"
    1 year ago
  • Equivalent to Excel Post-Special, "transpose"
    2 years ago
  • Generic Inquiry - Last Modified On Date Change
    2 years ago
  • Generic Inquiry, pulling data from two unrelated sources
    2 years ago
  • Adding Override Contact Info to GI Results
    2 years ago
Topic Tags:  Generic Inquiry (41) , AR Invoice (2) , AR (3) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 57 Online
  • 2,437 Members
Our newest member: Matt Butler
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.

‹›×

    ‹›×