Adding a field to Quantity Adjustment that totals your adjustment

Kinetic ERP
1

Has anyone added a field in Quantity Adjustment to total the dollars you are about to adjust? How would you go about doing that??

2

I haven’t done it, but I feel a good place to start is:

  1. Create a UD column, type decimal. to store the value
  2. Create a BAQ that links between Part and where the Part’s value is stored (I’m not sure where that is)
  3. In Application studio, create the currency field and map it to your UD column
  4. Create a new BAQ dataset and use your created BAQ to populate the dataset
  5. Create an event that occurs after you have the Part Number and quantity enter into the fields that takes the part number and looks it up in the BAQ, and returns the part value. Have the Part Value multiplied by the quantity and do a row-update to your UD column field.

This is all hypothetical because I’m not sure where you’d get the Part value from, and I haven’t done calculations within an application studio layer. But if you want values to appear BEFORE saving and hitting the database, you would have to find a way to do it in App Studio, from my experience anyway

3

You would have to look at PartCost table, depends if you’re FIFO or Standard cost, but the part costs are in there.

4

For a FIFO quantity adjustment, it passes those parts in as 0 cost and then you have to do a cost adjustment to adjust the FIFO layer. FYI

5

Write a BPM that pops up a BPM display if the value is greater than $1,000 (for example)
The slide out (pop up) would prompt you,
“Your transaction is $12,050.33 do you want to continue”
Yes No

6

Thank you for the detailed explanation Mackenzie. I appreciate you taking the time to respond.

7

Larson this is a good idea as well. I am quite new to the BPM process though so I hadnt thought of this one. Good thinking!