I have customized the MES screen with buttons to open some forms (Issue Material, Job Receipt to Inventory, Return Material. I have it working and opening the correct form but unable to get the form to load with the job number. I am able to capture the job number and throw up in a message box. (If I were able to purchase AMM then this would already be done but cost not approved to purchase)
I am a novice at best. Hoping one of you gurus out here can help me with the code.
Well I gave it a try but unfortunately a novice at best. I put the lfo.ValueIn=MyJob.Text; in the code below for button 1 click but no luck. I guess I am not grasping of what to put where. The Code does open the Issue Material Form but the Job is not populated. Any help would be appreciated. This code is on the MES screen. I did not follow the protected override void OnFormLoad
I broke out the E9 dllâs I can see its mostly the same (assuming I am looking at the right screen IssueMaterialEntry. When I dug a bit deeper I see that itâs looking for a MtlQueueRowID in E9, not a job,
That may not suit your fancy, but you can test it by getting the sysrow of some line in your queue to issue.
if you wanna write you own, go back to your original code, but in the Issue forms OnLoad event try:
If you wanna pass in both job and asm, you can make a class (needs to be in both caller and callee)
class MyStuff
{
string job;
string asm;
string whateva;
}
//then you create it in caller
var stuff = new MyStuff();
stuff.job = "MyJob#";
stuff.asm = "MyAsm";
now stuff that guy into the contextValue
lfo.ContextValue = stuff;
// --- in the callee, you are gonna get that object and unbox it:
MyStuff stuffInCallee = (MyStuff)lfo.ContextValue;
//now you can get all your dataz
loadSingleJob(stuffInCalee.job,stuffInCalle.asm);
With all that said, this was all written off the top of my head in this text editor with no checking/testing so no warranties Not to mention - Iâve never used E9.
One thing to add Is I do not have the (AMM - Advandced Material Management module) as the 20K is not an expenditure we can afford right now or it would work from the standard buttons. I am doing this to get us by as we are moving from KanBan to Jobs in manufacturing. Donât know if not having that module limits us or not.
Understandable. I dont think not having the AMM will limit you in this case as long as you arent needed any of the following:
Advanced Material Management (AMM) enables businesses to produce electronic requests for materials, dispatch those materials, and track inventory movements of all inventory including raw materials and work in process. Using wireless terminals and bar coding technology you are able to track inventory in real-time with complete control and visibility of raw materials and work in process as it travels throughout the enterprise.
Bar Coding on Demand and Scanning
Print tags on demand enabling employees to properly label containers or to create custom labels (via Seagull Scientific, Inc. BarTenderÂŽ) to meet customer requirements. Eliminate data entry mistakes and increase transaction speed by simply scanning a bar code tag to complete an entire transaction.
Handheld
Allows for the transaction of work either on a graphical touch screen station or via mobile Radio Frequency (RF) enabled device.
Material Handler Interface
Use an online queue of raw material and WIP parts to manage requests to locate and deliver the right parts to the correct resource at the appropriate time.
Material Movement
Different movement transactions are available for you to move a job to stock, move stocked material, or perform different returns to a job or stock.
Prioritizing Orders
Lets you treat your best customers with the highest priority by automatically allocating inventory to the highest priority orders first. Reserve or allocate materials from stock or directly from a linked job to make certain that you ensure your highest priority customers the greatest care.
Reserving Inventory and Sales Order Allocation
Reserve specific parts in inventory for designated orders. Manage sales order allocations with greater efficiency and create more effective picking and shipping.
From the other post this is certainly a stretch for me. How do I go about getting a consultant to help? Still going to try as it would be rewarding to figure it out but know the odds are stacked against me.
I am all for learning. As long as you have the free time and can avoid throwing things at your computer, itâs a great thing
One thing to note is that you can also get consultants for teaching as well. They can give you pointers, code snippets, explanations of whatâs happening in a given situation. Even without doing an outright learning session - looking at what a consultant delivers for your solution, and trying to make sense of it goes a long way.
Also have you checked out all of the programming docs at epicweb.epicor.com?
Re: your trace, hereâs the tasty stuff:
BO.JobEntry.GetList â whereClause = âJobNum = âTT063910ââ
This is a process that Iâve recently done with my companies MES program as well. Essentially there are two separate pieces of code that need to be entered. One for the MES customization and another for the resulting form that opens from it. Also, you need to make sure that you are utilizing the correct MES customization. It personally took me some time to figure out how exactly to go about that process. But, I have attached the general code for how this process works. Feel free to tell me if you have any problems understanding the code or process!
was going to try this but not sure how to change the VB to C#. Thanks. I have quite a few options. Just a matter of putting the right combination together.
Thereâs some online VB to C# conversion websites you can find that would help. You will most likely have to mess with the syntax a little afterwards for the more unique Epicor functions though if you went that route.
Okay I went back and took your instructions and did the code in VB for the MES and C# for the Issue Material. The MES form below and worked and the pop-up message âTestâ Worked. I then Clicked the Button and it did try to open the Issue Material form but had error which I guess I have the code wrong. Maybe it is the wrong DataView? Both code I have is below. Any help to figure out what is wrong would be appreciated.
' ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **
' Begin Wizard Added Module Level Variables **
' End Wizard Added Module Level Variables **
' Add Custom Module Level Variables Here **
Public Sub InitializeCustomCode()
' ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
' Begin Wizard Added Variable Initialization
' End Wizard Added Variable Initialization
' Begin Wizard Added Custom Method Calls
AddHandler Me.epiButtonC1.Click, AddressOf Me.epiButtonC1_Click
' End Wizard Added Custom Method Calls
End Sub
Public Sub DestroyCustomCode()
' ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines **
' Begin Wizard Added Object Disposal
RemoveHandler Me.epiButtonC1.Click, AddressOf Me.epiButtonC1_Click
' End Wizard Added Object Disposal
' Begin Custom Code Disposal
' End Custom Code Disposal
End Sub
Private Sub MESMenu_Load(ByVal sender As Object, ByVal args As EventArgs) Handles MESMenu.Load
' Add Event Handler Code
epiButtonC1 = CType(csm.GetNativeControlReference("25650da8-84c2-4a36-ab1e-a0d956fc9c40"), EpiButton)
epiButtonC1.ReadOnly = False
MessageBox.Show("Test")
End Sub
Private Sub epiButtonC1_Click(ByVal sender As Object, ByVal args As System.EventArgs)
' ** Place Event Handling Code Here **
Dim lfo As LaunchFormOptions = New LaunchFormOptions()
Dim edvSK As EpiDataView = CType(oTrans.EpiDataViews("LaborDtl"),EpiDataView)
Dim strPartNumber As String
If edvSK.DataView.Count() > 0 THEN
strPartNumber = edvSK.dataView(0)("JobNum").ToString()
lfo.ContextValue = strPartNumber
ProcessCaller.LaunchForm(oTrans, "IMGO3001", lfo)
Else
lfo.ContextValue = ""
ProcessCaller.LaunchForm(oTrans, "IMGO3001", lfo)
End IF
End Sub
End Class
Issue Material Code
// **************************************************
// Custom code for RcptToInvForm
// Created: 06/20/2018 9:43:54 PM
// **************************************************
using System;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Windows.Forms;
using Epicor.Mfg.BO;
using Epicor.Mfg.UI;
using Epicor.Mfg.UI.Adapters;
using Epicor.Mfg.UI.Customization;
using Epicor.Mfg.UI.ExtendedProps;
using Epicor.Mfg.UI.FormFunctions;
using Epicor.Mfg.UI.FrameWork;
using Epicor.Mfg.UI.Searches;
public class Script
{
// ** Wizard Insert Location - Do Not Remove âBegin/End Wizard Added Module Level Variablesâ Comments! **
// Begin Wizard Added Module Level Variables **
// End Wizard Added Module Level Variables **
// Add Custom Module Level Variables Here **
public void InitializeCustomCode()
{
// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
// Begin Wizard Added Variable Initialization
// End Wizard Added Variable Initialization
// Begin Wizard Added Custom Method Calls
// End Wizard Added Custom Method Calls
}
public void DestroyCustomCode()
{
// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines **
// Begin Wizard Added Object Disposal
// End Wizard Added Object Disposal
// Begin Custom Code Disposal
// End Custom Code Disposal
}
private void RcptToInvForm_Load(object sender, EventArgs args)
{
// Add Event Handler Code
if (RcptToInvForm.LaunchFormOptions != null)
{
EpiDataView edv = (EpiDataView)oTrans.EpiDataViews["SelectListView"];
edv.dataView[edv.Row]["field1"] = RcptToInvForm.LaunchFormOptions.ContextValue.ToString();
}
}
Well tried some other options from other suggestions here but still no luck. I even sought out some help and was told it would be 4 weeks before I could even get help. Very Sad. I will go back to some of your suggestions and see if I can get something to work. Both examples I am able to put a button on the MES and open up the Issue Material form but nothing ever loads in the Job, Assembly, or Operation field. Will keep trying.
In customize mode, open the Object explorer â Data Tab
Expand until you get into the selectListView (assuming thats really the name)
Find the correct field name (I assume Field1 is not a valid field).
Update this line accordingly _> edv.dataView[edv.Row][âfield1â] = RcptToInvForm.LaunchFormOptions.ContextValue.ToString(); }
and for good measure, at the end of that function, add oTrans,NotifyAll();
Btw - I see youâre a fellow southerner. I am just west of Nashville
Not to mention - Iâve never used E9.