Skip to main content
Solved

Raw Material usage by Work Center

  • January 27, 2021
  • 2 replies
  • 245 views

Forum|alt.badge.img+17

Hello, 

I have been trying to find a way to view all raw material that is used at a given work center. Ideally, I have reviewed material usage, component where used, but there does not appear to be a way to search by Work Center. I am hoping that there is an area within the system where this data can be viewed. Any help would be greatly appreciated!

Best answer by Björn Hultgren

There’s no direct link between the work center and the material consumption on the shop order but I guess it should be possible to add work center as a custom field to like the Inventory Transaction history, or Manufacturing Material History pages . 

Both these pages contains the keys for a shop order material line /Order No, Release No, Sequence No and Line  Item No). From that you can fetch the Operation No which to the material line was connected. And from the order keys 0 the operation no you can fetch the work center which that operation is connected to.

This topic has been closed for replies.

2 replies

Björn Hultgren
Hero (Employee)
Forum|alt.badge.img+25
  • Hero (Employee)
  • 1061 replies
  • Answer
  • January 27, 2021

There’s no direct link between the work center and the material consumption on the shop order but I guess it should be possible to add work center as a custom field to like the Inventory Transaction history, or Manufacturing Material History pages . 

Both these pages contains the keys for a shop order material line /Order No, Release No, Sequence No and Line  Item No). From that you can fetch the Operation No which to the material line was connected. And from the order keys 0 the operation no you can fetch the work center which that operation is connected to.


Forum|alt.badge.img+17
  • Author
  • Superhero (Customer)
  • 232 replies
  • February 1, 2021

@Björn Hultgren Thank you! I believe I will go in that direction.