Hello, we’re having an issue with inventory and I was wondering if anyone has run into this and found a solution that makes sense.
We have a hi temp fab shop and our material inventories are technically correct, but unusable for certain projects… For certain parts our system will show that we have 3 sheets in stock, but they are just a bunch of sizes that equal a total of 3 sheets. We have considered lot tracking and using the PO number, but we might get 15 sheets in 1 PO. Is there any way within epicor or anyway to link something externally to help us track the actual sizes we have? We usually cost entire sheets to jobs, but when we have a half sheet left it doesn’t always make sense to scrap it. Just wondering if anyone else had this issue and found a solution that makes sense.
Yes, this is a common problem with raw materials in sheet, bar, rolls, etc…
As far as I know, a clean solution does not exist in standard modules but…
I do remember a related discussion topic with some interesting ideas put forth by Jose and others.
so the stock is always held in “area”
but I understand what you mean I could end up with 5 M2 but the sheets cutup are all less size for your job but surly with lot control each lot purchased as 1 sheet if broken down to less than 1 it would give you
an approximation of size (not an expert just a user)
we have a ‘somewhat’ similar situation where we have left over material, returned to stock after use.
Our stock is in bar lengths of 6’ rd bars. A work around that we use is that I created a specific bin for cut-offs.
For ex. Part 1234 shows 100" in stock in Time Phase, but in part advisor, it will show 80" in the main bin and 20" in the cut off bin.
This allows the planner to see if there is enough material in the main bin to run the job or order more material.