Baq

[RC2020 (Miguel Lopez)]

Hello Everyone,

I need to create a BAQ that will show the total received quantity and the total PO quantity. Then compare the totals that don’t match. I can pull the PO order quantity but I can find where I can pull the total recieved quantity to compare on the dashboard.

I would appreciate if someone can guide me to a resolution.

Thanks in Advance.

Miguel Lopez

[TrevorLenten]

I think that’ll be in RcvDtl.

[DaveOlender]

Mr. Miguel: try PORel.RecievedQty

DaveO

[RC2020 (Miguel Lopez)]

Hello Trevor,
I am using this on my test: See below:

The problem I am having is Rcv.Dtl.Our.Qty is per part and the PO Detail Order Qty is for the PO complete. I want to compare in total the total amount recieved against the total amount the purchase was for. So I can display the PO’s that don’t match.

Thank you.

[gpayne (Greg Payne)]

In 9 make RcvDtl an aggregate table.

[RC2020 (Miguel Lopez)]

Hello Greg,
How to create a aggregate table?

Thank you.

Miguel

[gpayne (Greg Payne)]

There is a Sigma button in the tool bar that in E9 made the table a summary table. It will be (I think) green after that is checked.

[RC2020 (Miguel Lopez)]

Hello Greg,
I have never used this summary function.
below is my setup.

Here is my data I want to see.

This the error I receive.

Thanks in Advance.