AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Generic I...
Unable to Add Field...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Unable to Add Field "Unapplied Balance" to Generic Inquiry "Payments and Applications"

Acumatica Generic Inquiries & Pivot Tables
Last Post by Nicholas Scyoc 1 month ago
1 Posts
1 Users
1 Likes
51 Views
RSS
Nicholas Scyoc
Posts: 2
 Nicholas Scyoc
Topic starter
December 22, 2022 2:46 pm
(@nscyoc)
Member
Joined: 3 months ago

Our Billing department hit me with a GI request last night and I've been pulling my hair out over this for the past 12 hours 😥. Yesterday evening I was asked to pull the "unapplied balance" field into our Payments and Applications GI, and after a couple failed attempts + some forum surfing I found that this field "APPayment.CuryUnappliedBal" is simply not going to give me this information (because this is a calculation field).   

b37d29c6 aa67 41a5 9938 c99615afe9ca

I then stumbled across the post below, where this individual seems to be encountering the exact same issue. Naturally I was very excited to see the "best answer" providing a different route to accomplish what I'm after... but I have since attempted to use the fix provided in this thread, to no avail. Much like the "APPayment.CuryUnappliedBal" field, "APRegisterReport.DocBal" is also pulling a blank column into my GI.  

https://community.acumatica.com/reports-and-generic-inquires-115/add-field-unapplied-balance-on-ap302000-to-generic-ap3020pl-12349?postid=47232#post47232

"Instead of using APPayment.CuryUnappliedBal, join APRegisterReport with APPayement and using field APPayment.CuryDocBal, schema field is APRegisterReport.DocBal It will show the amount of unapplied"

c704e93e15de12d9fd270494c3ba1452

 

I'm at a loss and I'm very much hoping that someone in the AUG community has an answer to this problem. 

Thank You,

 

Tim Rodman reacted
Topic Tags
Generic Inquiry CuryUnappliedBal Unapplied Balance Help Question
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Novice Question - Adding Invoice # field to Sales Orders GI?
    2 years ago
  • Opportunity Screen - Relation to Sales Order Number
    2 years ago
  • Modifying Generic Inquiries in Self-Serve Portal
    2 years ago
  • Opportunity and Sales Order Join - Missing Data
    2 years ago
  • List of invoices and payments for a customer
    3 years ago
Topic Tags:  Generic Inquiry (22) , CuryUnappliedBal (1) , Unapplied Balance (1) , Help (1) , Question (1) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,236 Topics
  • 9,868 Posts
  • 8 Online
  • 1,812 Members
Our newest member: Heather Jones
Latest Post: Sales Order Comment Lines / Memo / Note Lines
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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×