BAQ field to hold parameter value

Epicor ERP 10
1

All -

I am trying to create a BAQ where the user enters a quantity and a part number and the query returns a list of materials, the quantity on hand, the quantity needed (calculation based on the quantity entered by user), and the difference between the quantity on hand and the quantity needed (calculation).

How do I create a calculated field to hold the value of the parameter entered by the user? I have tried the following (all of which gave me syntax errors)

  1. Created the parameter, created a calculated field and entered the expression = @QtyNeeded as the calculation of the field

  2. Created the calculated field and entered = 0 as the calculation of the field.

Not really sure where to go from here. Seems to me this should be pretty straightforward, but I can’t figure it out.

Thanks.

2

A simple calculated field with the value of @YourParam should work (no = sign)

3

Tried that. Get a syntax error of "Incorrect syntax near the keyword ‘where’.

All that’s in my Editor is @QuantityNeeded which I double-clicked from the parameter list. Didn’t event type so as not to introduce errors.

There is no ‘where’ anywhere

4

keyword where?.. can you send some screenshots of your BAQ setup?

5

It let me save the field, so let me see if it lets met use the field the way I want to. I am getting the message when I click the Check Syntax button, so maybe it’s just an errant message, rather than an actual problem.

Will send screenshots if this doesn’t work.

6

OK. This worked. I got hung up because I checked the syntax. If I had not checked, I would not have seen the error message…

Thanks.

7

Hello Sam,

Cool project and interesting development project. Separately, have you seen the Availability Report?

Production Management/Engineering/Reports?

Mark W.

8

I have not; will ask my production guys to check it out. Thanks for the tip.