Application Studio (Quote Worksheet)

Kinetic ERP
, ,
1

I’m new to application studio so I thought I would ask the user group for some help. I am looking to add some calculated fields to the Quote Worksheet.

Here are my fields on the worksheet. They are all currency fields at this time.

image
image975×193 44.3 KB

Here is what I am trying to do.

EstVA = Total Quoted Price – Material

I’m trying to update Scrap from a BAQ to get the full cost of a sheet of material. Is this the best way?

EstNetVA = EstVA + Estimated Scrap
PC$ = EstNetVA – Labor and Burden – Commission

Should I use an event to populate the fields?

image
image975×262 56.8 KB

Is there a better or easier way to update my new fields?

Thanks

Mel

2

Yes.

Put them all in the same row-update call. You can add multiple columns.

1 Like
3

Thanks Hannah. I’ll work on consoldating the row-updates. Is there a chance you might have an example on how to use a BAQ to return a value into a column?

4

I’m sure there’s an example around here somewhere if you search for it.
In short–you create a new DataView of type BAQ and enter your BAQ ID, create an event that calls the erp-baq widget, set the view name in the properties to be that of the new DataView created, then use a row-update to set the value of the column.

5

Thanks!