I was wondering if someone could help with an issue.
I’m trying to see if it’s possible to change a job quantity depending on a part description. For example if a job has a quantity of 40 to be made and the part description has ‘ABC’, it’ll add 1 to the job quantity so it’ll become 41. If the job quantity is 60, and the part description is the same (‘ABC’), it’ll add 2 so it’ll become 62; and if the job quantity is 203, and the part description is the same again (‘ABC’), it’ll add 3 so it’’ become 206. The thresholds of the additional is if jobs have a quantity of 50 or less, it’ll add 1, if it has a quantity of 100 or less, it’ll add 2, and if it has a quantity of 101 or more, it’ll add 3.
MRP is run overnight that creates all the relevant jobs, and we’re running Epicor 9.05. The reasoning to why the additional quantity is added is quality assurance, as we test the added quantity to see if they’re up to standard and safe, depending on how many the job is calling for, will depend on if the additional quantity will be 1, 2, or 3.
I’ve done some research into it and I’m thinking a Data Directive would be the way to go, but I’m struggling with the ‘conditions’ and ‘actions’ section of it as I’ve not done many data or method directives before.
sorry interrupted
UDT per part and qty combination
at 200 and an additional 1
at 400 add 2
at 700 add 3
Now… if the initial demand was coming from a Sales Order for 200, or 400, or 700
I presume you’d be increasing the job-qty with a make-to-stock demand???
@jadecorp if you are talking about user defined table or user defined field - i am not sure how this could be implemented to incorporate MRP. You could quite happily do this in a BPM. You could probably write an update-able dashboard to update the existing jobs (bringing you up to date) and then seperately build a bpm on job update (or a more apt method) for new jobs being input. once you are up to date, the dashboard could be incorporated into your process for failures or managing static data but the bpm would take care of daily operations.
@kjavid Can you help me understand how this can be processed through a BPM? Would it be done through a Method Directive or Data Directive? If the Method Directive, am I right in thinking it would be Pre-Processing?
Looking at it a little bit closer, it seems like you need to allocate the material to the B.O.M and then issue it, inorder to create the Sales Order Demand Link. I believe you will probably need to add the part to the B.O.M of the job. I maybe slightly off-target as it has been a while since I looked into MRP (a complicated enough process in itself) but I would then create an updateable dashboard to update the existing jobs with the Assembly BOM sequence, with the required qty adjusted as above. This logic can then be replicated via a BPM when the material is added to the job. You can use trace logging to find out the correct method. As I said, it has been a while since looking into MRP and demand linking, so will review my slides and get back to you.
I think you can do this by setting the scrap field on JobOper and Jobmtl. Use fixed quantity scrap and add to the materials and operations for these assemblies. Since they will be tested, I assume they will not make it to inventory, so the jobprod quantity stays 50, but you have material and operations to make 51.
You can set the JobAsmbl.Overrun quantity if the finished pieces should go to inventory.
If MRP is making firm jobs and releasing then a DD would do this, but you could also do it on the release of the job on JobEntry.ChangeJobHeadJobReleased.
You can test the scrap process manually in job entry and if it looks like it will work, i will dig up some abl code to get you started.
Just curious… Is the original poster doing this to build in extras, for destructive testing?
If not. How do others handle that? I don’t like the thought of building in extra scrap on the materials part of the BOM. Seems there should be a way to designate a qty (for testing), that won’t be part of the final count.
For example, any lot of qty <=50, requires 1 piece to be tested. If I enter the job for 50, it only assumes components for 50 are required. If I enter the job Qty as 51, only 50 will end up in stock. So I need to complete 51, but only receive 50 to stock.
Is this done with multiple demand links? Demand link A is 50 pc’s to stock, and Demand link B is 1 pc to ???
Thanks for everyone’s reply on this matter, I’m still currently trying to figure this out.
In response to everyone’s questions, it is a destructive test, so if the job demand is for 50, an additional part will be added, taking the total to 51 in order for that one to be tested. @ckrusen
@gpayne Do you think the Data Directive is a better option than the Method Directive if an MRP is run every night?
@kjavid Would the updatable dashboard be similar to doing a dashboard with a BAQ? Or is there some other type of dashboard?
Hi Edward - yes this would be a dashboard that is based on an updatable baq. how you would issue the material would be another process. updating required qty not so hard.
@kjavid Hi there, I’ve made a BAQ consisting of the Part Master table and the Job Head table, with the relevant Part Description criteria and if the ProdQty is under 40, 60, and 90. And I’ve made it into a dashboard. Would I still need to use a BPM? If so, which one?
Hi - sorry about the late reply! I have been away. you would need an updateable BAQ based on your sepdcoific requirements. you can then attach this to a dbd assembly to do your updates.
