I need to add a Resource Group Description column to a Job Entry form. I need to create it in BPM, but which ERP.BO file should I use? Please help me

[teeraphongw]

@GabeFranco

Did you add the BPM on to ERP.BO.JobEntry GetRows Post?

I copied the code and pasted it into GetRow, but when I previewed it, it still didn’t display any data.

[GabeFranco (Gabriel Franco)]

Job Entry is one that does not preview well, because it checks to see what the name of the menu you launched from was (Job Entry vs. Job Tracker - or Service Job Entry)

Instead of application studio preview, try in real job entry.

[teeraphongw]

Thank You

[teeraphongw]

It’s very difficult to retrieve and display the data.

[GabeFranco (Gabriel Franco)]

As usual! It is Epicor

[teeraphongw]

GabeFranco

Is there another way to retrieve and display Resource information in JobEntry?

[GabeFranco (Gabriel Franco)]

The way i showed you works on my system (What version are you, I am 2025.1.15), it looked like you have everything in place correct.
Erp.BO.JobEntry / GetRows (Post)

foreach (var r in result.JobHead) {
  string rg = "";
  foreach (var jo in Db.JobOpDtl.Where(x => x.Company == r.Company && x.JobNum == r.JobNum)) {
    string rgd = Db.ResourceGroup.FirstOrDefault(x => x.Company == r.Company && x.ResourceGrpID == jo.ResourceGrpID).Description;
    if (!String.IsNullOrEmpty(rgd)) {
      if (String.IsNullOrEmpty(rg)) {
        rg = $"[{rgd}]";
      } else {
        rg += $", [{rgd}]";
      }
    }
  }
  r["ResourceGroupDesc"] = rg;
}

Now, check in F12 dev tools when you go to job entry from the menu,.

Here, I did not put it on the grid yet. But you showed earlier in your preview that you had put it on the grid, so you know how.

Put it on the grid, then publish your layer with the cloud.

Then, go to menu maintenance, find job entry, Copy to Current Company. and put your layer on job entry.

Now, finally reload the web page with Refresh Icon / F5 - then go to Job Entry from your modified menu item with the Customized Layer added.

[teeraphongw]

I’m using version…

[teeraphongw]

There is no information like yours.

[teeraphongw]

That’s strange, or maybe the program is faulty.

[Aman_Khan]

Please use this code to retrieve the Resource Group description from the JobHead table within the Data Directive method.

string company = this.Company;

foreach (var jobHeadRow in ttJobHead.Where(r =>
string.Equals(r.RowMod, IceRow.ROWSTATE_ADDED, StringComparison.OrdinalIgnoreCase) ||
string.Equals(r.RowMod, IceRow.ROWSTATE_UPDATED, StringComparison.OrdinalIgnoreCase)))
{
var jobOpDtlRow = Db.JobOpDtl.FirstOrDefault(r =>string.Equals(r.Company, company, StringComparison.OrdinalIgnoreCase) && r.PONum == jobHeadRow.PONum);

if (jobOpDtlRow != null)
{
  
    var resourceGroup = Db.ResourceGroup.FirstOrDefault(r =>string.Equals(r.Company, company, StringComparison.OrdinalIgnoreCase) &&
            r.ResourceGrpID == jobOpDtlRow.ResourceGrpID);

    if (resourceGroup != null)
    {
        jobHeadRow.ResourceDesc_c = resourceGroup.Description;
    }
}
}

[teeraphongw]

@Aman_Khan

string company = this.Company;

foreach (var jobHeadRow in ttJobHead.Where(r =>
string.Equals(r.RowMod, IceRow.ROWSTATE_ADDED, StringComparison.OrdinalIgnoreCase) ||
string.Equals(r.RowMod, IceRow.ROWSTATE_UPDATED, StringComparison.OrdinalIgnoreCase)))
{
var jobOpDtlRow = Db.JobOpDtl.FirstOrDefault(r =>string.Equals(r.Company, company, StringComparison.OrdinalIgnoreCase) && r.PONum == jobHeadRow.PONum);

if (jobOpDtlRow != null)
{
  
    var resourceGroup = Db.ResourceGroup.FirstOrDefault(r =>string.Equals(r.Company, company, StringComparison.OrdinalIgnoreCase) &&
            r.ResourceGrpID == jobOpDtlRow.ResourceGrpID);

    if (resourceGroup != null)
    {
        jobHeadRow.ResourceDesc_c = resourceGroup.Description;
    }
}
}

I’ve entered the code, but I’m getting an error, or maybe I did something wrong.

[teeraphongw]

Or do I have to choose here?

[Aman_Khan]

Change the table as per your requirement.

[teeraphongw]

I do not understand

[Aman_Khan]

string Company = callContextClient.CurrentCompany;
string JobNum = "";

var jobHead = ds.JobHead.Where(r => r.RowMod == "A" || r.RowMod == "U").FirstOrDefault();

Company = jobHead.Company;
JobNum  = jobHead.JobNum;

var jobOpr = Db.JobOpDtl.Where(r => r.Company == Company && r.JobNum == JobNum).FirstOrDefault();

if (jobOpr == null)
{
    InfoMessage.Publish("No Job Operation found for Job: " + JobNum);
    return;
}
var resourceGroup = Db.ResourceGroup.Where(r => r.Company == Company && r.ResourceGrpID == jobOpr.ResourceGrpID).FirstOrDefault();
//InfoMessage.Publish("Resource Group Description: " + resourceGroup.Description);
jobHead.ResourceGroupDesc = resourceGroup.Description;

“Use this code in a Method Directive. In Maintenance, select Erp.BO.JobEntry.Update and apply the following code.

[teeraphongw]

@Aman_Khan

string Company = callContextClient.CurrentCompany;
string JobNum = "";

var jobHead = ds.JobHead.Where(r => r.RowMod == "A" || r.RowMod == "U").FirstOrDefault();

Company = jobHead.Company;
JobNum  = jobHead.JobNum;

var jobOpr = Db.JobOpDtl.Where(r => r.Company == Company && r.JobNum == JobNum).FirstOrDefault();

if (jobOpr == null)
{
    InfoMessage.Publish("No Job Operation found for Job: " + JobNum);
    return;
}
var resourceGroup = Db.ResourceGroup.Where(r => r.Company == Company && r.ResourceGrpID == jobOpr.ResourceGrpID).FirstOrDefault();
//InfoMessage.Publish("Resource Group Description: " + resourceGroup.Description);
jobHead.ResourceGroupDesc = resourceGroup.Description;

Thank you for the fix, but I’m still getting this error.

[Aman_Khan]

1. Identify the field where you need to display the description (for example, the JobHead Description field).

2. If you need the description from the Resource Group, use the following field:

   • resourceGroup.Description
     This field returns the description from the ResourceGroup table.

3. To store this description in the JobHead table, use the custom field:

   • jobHeadRow.ResourceDesc_c

4. Assign the value as shown below:

   jobHeadRow.ResourceDesc_c = resourceGroup.Description;
   
   

5. You can change or map this value to any other required JobHead field based on your business requirement.

[teeraphongw]

It’s as if there’s no ‘jobHeadRow’, is there?

[Aman_Khan]

@Aman_Khan

Use this
jobHead.ResourceDesc_c = resourceGroup.Description;

Regards,
Aman Khan
Mo: +91 7510019357
Epicor Technical Consultant