Miscellaneous material request

Kinetic ERP
1

Hi everybody!

We have a request from warehouse area, they want the staff to request miscellaneous material (gloves, tow, glasses, etc) through the system.
Does anyone know if that is possible in epicor?

2

Have you tried going through Requisition Entry? We ask our employee to request stuff they want and it goes through approval process including manager, finance review and then purchasing. A buyer then generates a PO against that requisition.

3

It’s not so much a purchase order, it’s more for the warehouse to deliver consumable materials to production workers. Safety gloves, safety glasses, a purchase order requisition would not be necessary.

4

I thought was to buy those things. Apologies for the oversight.

Not sure, if there are any built-in options for this.

Creating a new UD form with UD table would help. You can generate a Part Number for those consumable materials. Then under UD form, provide selection for Part-Number, quantities and employee dropdown, so that you can know who requested it…
Then with a checkbox, you can generate material request(I have the code, might require some tweaking based on your need). And then warehouse worker can process it.

Thank you.

5

My company uses Move Inventory Request for transferring stocked parts, but I believe that requires Advanced Material Management license. The part can be consumed through Issue Material or Issue Miscellaneous Material.

6

That’s what I was thinking, making a UD that is like a consumable requisition. Could you share your code with me? To base myself on it and be able to create one that helps us?

Thanks for your help!!!

7

That’s another good idea and that option is already in MES. I’m going to try that option too to see which is better.

Thanks for helping!

8

My company uses it to request material when there is any shortage prior starting the job, so this is related to Job Entry and is placed at Job-Mtl data directive/in-trans.

Erp.Contracts.MoveRequestSvcContract moveRec = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.MoveRequestSvcContract>(Db);

        {
            Erp.Tablesets.MoveRequestTableset mrds = new Erp.Tablesets.MoveRequestTableset();
            moveRec.GetNewMoveRequest("MI", ref mrds);
            moveRec.CheckEmployee(empID, out verifiedID);
            string empName = "";
            moveRec.CheckEmployee(empID, out empName);
            mrds.MoveRequest[0].EmpId = empID;
            mrds.MoveRequest[0].JobNum = ttJobMtlRow.JobNum;
            string warehouseList;
            moveRec.OnChangePartNum(ttJobMtlRow.PartNum, ref mrds, out 
            warehouseList);
            moveRec.OnChangeToWhse(ToWhse, ref mrds);
            moveRec.OnChangeToBin(Bin1, ref mrds);
            moveRec.OnChangeFromWhse(FromWHCode, ref mrds);
            moveRec.OnChangeFromBin(Bin2, ref mrds);
            mrds.MoveRequest[0].RequestQty = RequestedQty;
            moveRec.ProcessRequest(ref mrds);
        }

Have a look at this, I queried few tables to base my requirements, in your case you can default some values.

Let me know how this goes…

1 Like
9

We made a generic UD10 screen for engineering parts. This screen just writes UD10 record. Then a bpm makes a STK-STK queue. The problem we ran into is that on hand builds up. If the consumables are an on hand quantity then you want to make something that will do a STK-UNK and clear the quantity being delivered. I don’t know if that is possible with a material queue. But you could just use the UD record as your own queue and build an updatable dashboard that was the consumable queue and did a stock adjustment and set a checkbox when it was processed.

image
image710×279 42.1 KB

1 Like
10

Yes!! that’s right, we plan to use a material adjustment after making the warehouse transfer.

11

Thanks!!! I’ll work on it, and let you know my comments!!