Questions GI to calculate a price

Acumatica Generic Inquiries & Pivot Tables

Last Post by Jabran Ouni 3 years ago

3 Posts

2 Users

2 Reactions

1,456 Views

RSS

Posts: 2

Jabran Ouni

Topic starter

November 22, 2022 9:18 am

(@jabran-ouni)

New Member

Joined: 3 years ago

Hi there,

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

2 Replies

Posts: 24

ncantral

November 23, 2022 2:05 pm

(@ncantral)

Eminent Member

Joined: 6 years ago

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])))