Skip to main content
Solved

Raw Material usage by Work Center

  • January 27, 2021
  • 2 replies
  • 240 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.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Björn Hultgren
Hero (Employee)
Forum|alt.badge.img+24
  • Hero (Employee)
  • 991 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)
  • 224 replies
  • February 1, 2021

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings