2

Report Quantity Customization – Epicor ERP Custom Software Solution

  • 5 November 2013
  • cre8
  • 2 comment
Categories: Epicor

Tags: , , ,

Some users use the Report Quantity MES screen to report their production hours and quantities. This screen, however, includes limited information and there might come the need to have visibility of additional fields/pieces of information for the comfort and efficiency of the employees. A custom software solution was designed to display additional fields and display information that offers more Job Related facts to the user. The following fields are now shown:

  • Running Total: Running total, in thousands, for production reported for the operation (Sum of LaborDtl.LaborQty for the Job/Assembly multiplied by 1,000). The field can’t be modified by the user.

  • Part: JobHead.PartNum. The field can’t be modified by the user.

  • Job Quantity: JobHead.ProdQty. The field can’t be modified by the user.

  • Required Date: JobHead.ReqDueDate. The field can’t be modified by the user.

The following job has been created for the testing:

166

Values from JobHead to consider:

167

Values from LaborDtl to consider at this point:

168

Launch MES, Launch Report Qty. Enter the Job 2236 and after selecting the operation 10 the correct values are displayed:

169

Compare the Queries:

170

Enter a Qty of 10.00 and hit OK button:

171

Report Qty again:

172

Pick the same Job number 2236 and operation 10:
The fields display the correct values (Qty previously reported (10) * 1000, Part manufactured, Job Total and Required date).

173

2 responses to “Report Quantity Customization – Epicor ERP Custom Software Solution”

  1. Hi I was wondering if someone could tel what table does the “Current” quantity write out to?

    Thanks, Mike.

  2. Chris Conn says:

    Current qty gets written to the PartTran table => PartTran.TranQty

Leave a Reply

Your email address will not be published.