Skip to Content
0

Need assistance in writing a query on FIFO layers.

Jan 26, 2017 at 04:22 PM

33

avatar image
Former Member

I need to come up with a query that I can run by item group. It needs to look at all BOM's within the selected item group and return an average cost of the last 10 FIFO layers on each of the child items of each BOM, however if 10 FIFO layers for any of the child items do not exist I would want an average cost of the total amount of layers available for that item. I would like the results to be grouped by the parent item part number.

This query is definitely beyond my capabilities so any help would be greatly appreciated.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers