Insert NeedByDate Into Job Manager (Demand)

Kinetic ERP
, , ,
1

Hi,

I am trying to pull NeedByDate into our JMDemand grid within Job Manager. Since Job Manager is a prebuilt app, we are unable to simply place it within the view.

I am trying to write a BPM within Erp.BO.JobManager.GetMatrix that cross checks with the OrderRel/JobProd table and pulls in the matching NeedByDate.

The following is the custom code widget being used.

image
image705×730 31.3 KB

I placed a new column in application studio so the new variable has a home ot sit in.

image
image392×940 6.67 KB

I have double-checked my logic, but the NeedDate column is still not populating for the visual.

image
image206×446 1.19 KB

I appreciate any help with this, or insight to what I may have missed.

2

First thing, have you checked the network tab and seen if your data is there?

3

So I noticed you’re setting row["NeedDate"] and not row.NeedDate, is that because the field doesn’t exist in the result.JMDemand table?

4

Yeah he’s adding a column on the fly but we need more context.

5

I was able to get this working.

image
image606×973 40.3 KB

My original logic was was doing this taking the JobNum from the current JMDemand row, searching JobProd for that job, joining JobProd to OrderRel, and returning the FIRST matching OrderRel.

I think this was casuing problems since a single job can have multiple sales orders, multiple lines, and multiple releases in the JobProd table

This new solution looked at just the OrderRel since JMDemand contains OrderNum, OrderLine, and OrderRelNum.