Skip to Content
avatar image
Former Member

Need assistance in writing a query on FIFO layers.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers