Looking for a way to create an updatable sequence for Job Mtl

Kinetic ERP
, ,
1

Hi All,

My company wants a way to have a grid based resource scheduling dashboard. We want to set the sequence for each material on a job individually based off which resource it needs for machine scheduling to create priorities per machine.

I cannot get this to work with a UBAQ because I can’t modify the jobmtl tables records after the job has been firmed and engineered and it needs tied to that record to sequence each record individually.

Does anyone know of anything I can try to get this to work or is this just not possible?

Thank you!

2

You could use a UD table, with the Key values referring to JobNum, AssemblySeq, MtlSeq. You would be able to update it at any time regardless of the status of the job.

Also, I’ve seen several people recommend adding a UD field to a UD table, so it can be properly named, rather than using one of the generic fields.

2 Likes