BAQ Help

Kinetic ERP
1

Trying to create a BAQ that includes BOM info with a twist. We call it the hammerlaunch report. Users are able to input up to 20 different end items with desired qty to run to generate a consolidated mtl listing of parts with a required qty needed then have QOH in another column with a variance in the next.

The below is my sample that takes 3 parts and desired qty to run but having trouble getting the parms part02 and part03 to show up in the parm to be able to select them in formulas. The BAQ - you may need to remove the link from Part_ud to customer in the below to run.
W-BOMMultiple.baq (80.8 KB)

2

Looks like you can’t put optional parameters into calculated fields.

image
image515Ă—321 7.84 KB

3

One I removed the skip if empty part of that, it runs fine for me.

image
image732Ă—272 7.22 KB

What’s the issue you’re having with it?

I don’t know what you mean by this.

4

Was trying to take the:

  1. take reqqty – QOH = variance
  2. Any options in showing what the master parts you selected with the qty you selected?

Note: Planning to add up to 20 parts with qty – users may input 1 part with qty and some may use all 20

5

That’s fine, you still don’t need the skip if empty because you are using “or” filters. If it’s doesn’t match (because it won’t) it won’t fail out.

You can just concat the parameters into a single field. Again, if they aren’t populated, you just would get a blank.

6

Can you shoot back your fix with sample of the concat? Thanks in advance

7

image
image849Ă—254 6.06 KB

image
image836Ă—480 26.7 KB

1 Like
8

Here’s a calculated field with part number and quantities.

image
image924Ă—193 6.08 KB

image
image723Ă—629 31 KB

1 Like
9

Updated version - Thanks now to add the other @Part & @Qty then publish as a dashboard and a BAQReport

BOMWhatIfMultiple.baq (81.5 KB)

Updated version with 20 and corrected some formulas to Max vs Sum