How to mass extract data
Hello everyone.
I am a sr production buyer and I have about 300 plus part number that I manage. Of course I don’t purchase all these components everyday but I go based off what the purchase request are in me5a for my purchasing group. What makes it difficult is that the production schedule is changing on the fly. The lead time for the components is 4 days. So stuff moves really quickly. I am on md04 a lot. Is there a way to mass export the part numbers I manage and have me see what md04 shows me but on an excel file. That way I don’t have to be going through every pn through md04? I don’t order per depreq but I order per ordres. On some I do on some I don’t. What I was thinking is having a file that shows me each part number with one row showing me ordres, another order showing me depreq, and one row showing me my purchase orders. From that I would have the file show me in red where I am short based off of on hand inventory and my actual POs in the system. Please help me