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
Everything Else
How to get calculat...
 
Notifications
Clear all

Questions How to get calculation in column in Document Details tab in Sales Quotes

 
Everything Else
Last Post by jerrykurtz 5 years ago
2 Posts
2 Users
1 Reactions
1,229 Views
RSS
b-co
Posts: 12
 b-co
Topic starter
September 1, 2020 2:07 am
(@b-co)
Eminent Member
Joined: 6 years ago

I am wanting to create a new column on the Sales Quotes screen, on the Document Details tab that is the nett each price, for when there is more than one quantity of each item.  So basically I can create a column, but I want it to calculate =CROpportunityProducts.CuryAmount/CROpportunityProducts.Quantity

I have a fair knowledge of customisation projects, however, this is a bit beyond my experience. 

How can I do this?  I also have several other columns I want to add calculations into, so the answer on how to do this will assist greatly.

Thanks.


1 Reply
jerrykurtz
Posts: 4
 jerrykurtz
September 2, 2020 12:44 pm
(@jerrykurtz)
Active Member
Joined: 6 years ago

Have you tried using adding a PXFormula attribute to your new field?

I think it would be something to the effect of:

[PXFormula(typeof(Div<CROpportunityProducts.curyAmount,CROpportunityProducts.quantity>)]

If you can't do it in a [Formula] attribute, then you may need to do it with some C# code.


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
  • 40 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

  • Julie Baker
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.

‹›×

    ‹›×