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).
GI to calculate a price
I am trying to create a GI to calculate the price of the 2 items provided by the parameters. The formula in the attached files is just to clarify what I wish to do. The question: is it possible? If yes, I will be grateful if I can get an answer.
Thanks in advance
It's possible through a self join, but I would recommend using the Quote or Sales Order form to really simplify the process. You don't even have to save the record to get a quick estimate and it can support discounts and customer/price class pricing.
Attached are some pictures for a quick example.
=([Article1.BasePrice] * [Qty1]) + ([Article2.BasePrice]*[Qty2])
='Item total: ' + CSTR(CDBL(([Article1.BasePrice] * [Qty1]) + ([Article2.BasePrice]*[Qty2])))