Backflush material on sub-contract operation

Epicor ERP 10
1

Hi guys,

I’d like to backflush a material that is consumed on a sub-contract operation but whichever way I try it will not backflush.

I’ve set the part up via Part Entry and ticked it as backflush before creating the job. I’ve then also verified that the backflush checkbox is ticked within the job material and that the material is linked to the sub-contract operation.

I create the PO for the supplier then reciept the sub-contract operation qty via “Receipt Entry”.

I can see via job tracker that the operation is complete as it’s got a nice green tick next to it but the material that is linked to the sub-con operation doesn’t show any movement from stock to job and remains un-issued.

I’ve even tried doing the backflush materials tick box via the Job Closing and completing process and it still wont issue the material even after getting the warning message.

The only way I can complete the process is by manually issuing the material.

Am I doing something wrong or is this how Epicor is designed to work?

Cheers,

Rob

2

We had the same issue as well. It does not backflush because it is not a standard operation (from my understanding). We have parts that we pull and send to a shop for electrical assembly & receive an assembled panel in return.

In the method of this part we have a standard operation prior to the subcontract that all of the materials are related to. We call this “Pick - Subcontract”, and it’s completed once the materials for the subcontract operation are pulled. The bin these parts are in and backflush from are tied to this pick operation. So upon completion of the pick operation, all material is backflushed out of that bin to the job.

Once the SubC PO receipt is received, you can complete, receipt to inv. (if needed) and close the job.

Hope this helps!

3

Appreciate the response Luke.

Yes that would work but if possible I’m trying to avoid a manual entry (which I’d need to carry out by booking via time and expense on the “Pick-Subcontract” operation). I’d be replacing a manual issueing of materials with a manual time and expense entry. 6 of one and half dozen of the other :slight_smile:

I do like your approach though as it allows the materials to be withdrawn from inventory and into your job at the moment before sub-con is carried out.

Cheers,

4

You can automate these processes. It’s a bit involved, especially if you arent versed in C# and epicor customization in general though. A consulting company would be able to knock this out for you. You can find many consultants on the forum here who you could inquire with.

You can see users marked as consultants here:

1 Like
5

We had to have customization for this, as standard Epicor will not backflush a sub-contract part automatically.,

Thanks,

Debbie

1 Like
6

Incase, anyone wants to get solution for this, I created a BPM on PORel level, once release is closed, it triggers a labor transaction for the related operation with material and marks it as complete. Once complete, it backflush the material. Below is the BPM working for me. Needs some changes but this cou

image
image772×750 26.5 KB

Code:

 Erp.Tables.JobOperJobOper;
Erp.Tables.LaborHedLaborHed;
Erp.Tables.LaborDtlLaborDtl;
Erp.Tables.UserFileUserFile;
Erp.Tables.EmpBasicEmpBasic;
Erp.Tables.PODetailPODetail;
Erp.Tables.PORelPORel;
stringempID=string.Empty;
stringOSPrepOprSeq="1";
varttPORelRow=(fromttPORel_RowinttPORel
wherettPORel_Row.RowMod=="U"||ttPORel_Row.RowMod=="A"
selectttPORel_Row).FirstOrDefault();
if(ttPORelRow!=null)
{
varshowOperations=(fromjobOperRowinDb.JobOper
wherejobOperRow.Company==ttPORelRow.Company&&
jobOperRow.JobNum==ttPORelRow.JobNum
selectjobOperRow).FirstOrDefault();
{
if(showOperations!=null)
{
/*this.PublishInfoMessage($"Joboperationsare:{showOperations.OpCode}anddescription{showOperations.OpDesc}",
Ice.Common.BusinessObjectMessageType.Information,Ice.Bpm.InfoMessageDisplayMode.Grid,"JobMtl","DataDirectiveIT");*/
}
varemp=(fromempBasicinDb.EmpBasic
joinuserFileinDb.UserFileonnew{empBasic.Name}equalsnew{userFile.Name}
whereempBasic.Company==Session.CompanyID&&callContextClient.CurrentUserId==userFile.DcdUserID
selectempBasic).FirstOrDefault();
if(emp!=null)
{
empID=emp.EmpID;
}
else
{
//empID="0583";
}
//CreateJobAdjustmentTablesetforLaborandconnecttoservicecontract
JobAdjustmentSvcContractlJobAdj=null;
JobAdjustmentTablesetJobAdjDataSetLabor=newJobAdjustmentTableset();
lJobAdj=Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.JobAdjustmentSvcContract>(Db);
//PopulateLaborDetailrecord
JobAdjDataSetLabor.JALaborDtl.Add(newJALaborDtlRow());
JobAdjDataSetLabor.JALaborDtl[0].ClockInDate=DateTime.Now;
JobAdjDataSetLabor.JALaborDtl[0].LaborNote="AutoCompleted";
JobAdjDataSetLabor.JALaborDtl[0].AssemblySeq=0;
JobAdjDataSetLabor.JALaborDtl[0].OprSeq=showOperations.OprSeq;
JobAdjDataSetLabor.JALaborDtl[0].QtyCompleted=0;
JobAdjDataSetLabor.JALaborDtl[0].ActProdHours=0;
JobAdjDataSetLabor.JALaborDtl[0].ActSetupHours=0;
JobAdjDataSetLabor.JALaborDtl[0].ActBurCost=0;
JobAdjDataSetLabor.JALaborDtl[0].ActLabCost=0;
JobAdjDataSetLabor.JALaborDtl[0].EmployeeNum=empID;
JobAdjDataSetLabor.JALaborDtl[0].EmployeeName=emp.Name;
//Adjustquantitiesjustincasetherewasanadjustmadewithoutopbeingcompleted
JobAdjDataSetLabor.JALaborDtl[0].LaborQty=showOperations.RunQty;
JobAdjDataSetLabor.JALaborDtl[0].LaborType="P";
JobAdjDataSetLabor.JALaborDtl[0].LaborHrs=0;
JobAdjDataSetLabor.JALaborDtl[0].LaborCost=0;
JobAdjDataSetLabor.JALaborDtl[0].BurdenHrs=0;
JobAdjDataSetLabor.JALaborDtl[0].BurdenCost=0;
JobAdjDataSetLabor.JALaborDtl[0].Complete=true;
JobAdjDataSetLabor.JALaborDtl[0].OpComplete=true;
JobAdjDataSetLabor.JALaborDtl[0].company=showOperations.Company;
JobAdjDataSetLabor.JALaborDtl[0].LaborHedSeq=1;
JobAdjDataSetLabor.JALaborDtl[0].LaborDtlSeq=1;
JobAdjDataSetLabor.JALaborDtl[0].OpCode=showOperations.OpCode;
JobAdjDataSetLabor.JALaborDtl[0].ResourceGrpID="";
//JobAdjDataSetLabor.JALaborDtl[0].JcDept=showOperations.;
JobAdjDataSetLabor.JALaborDtl[0].JobNum=showOperations.JobNum.ToString();
JobAdjDataSetLabor.JALaborDtl[0].SysRowID=newGuid();
JobAdjDataSetLabor.JALaborDtl[0].RowMod="A";
//CommitLaborrecord
lJobAdj.CommitLaborAdj(refJobAdjDataSetLabor);
}}
3 Likes