Unable to Dispatch Requisition using ReqEntry Adapter

Epicor ERP 10
, ,
1

Hey guys, was really hoping I would be able to get this knocked out yesterday but didn’t have much luck.
What I want to accomplish is just to dispatch a requisition on an event or a field change. I’m following the trace, and trying to replicate it but I’m not sure where I’m going wrong.

I did notice the .Update and .CheckToDo method is returning false.

Here is a snippet of the code I’m working with:

		{
		ReqAdapter adapterReq = new ReqAdapter(Script.oTrans);
		adapterReq.BOConnect();

		// Declare and Initialize Variables
		// TODO: You may need to replace the default initialization with valid values as required for the BL method call.

		int intId = 1;
		int reqNum = 1;
		string reqUserId = "Aaron";
		bool resetDispatch = true;
		bool dispatchReq = false;
		string dispatchId = "Aaron";
		string nextActionID = "PO";
		string dispIDList = string.Empty;
		string dispNmList = string.Empty;

		// Call Adapter method

		bool idresult = adapterReq.GetByID(intId);
		MessageBox.Show(idresult.ToString());

		bool bndresult = adapterReq.BuildNextDispatcher(nextActionID, out dispIDList, out dispNmList);
		MessageBox.Show(bndresult.ToString());

		bool updresult = adapterReq.Update();
		MessageBox.Show(updresult.ToString());

		bool chkresult = adapterReq.CheckToDo(dispatchId);
		MessageBox.Show(chkresult.ToString());

		adapterReq.RDMenuFlags(reqNum, reqUserId, out resetDispatch, out dispatchReq);

		// Cleanup Adapter Reference
		adapterReq.Dispose();
	}

And then (what I believe) are the relevant bits of the trace, of dispatching a requisition manually in the UI. I removed some of the GetList, IMPL, etc

<tracePacket>
  <businessObject>Erp.Proxy.BO.ReqImpl</businessObject>
  <methodName>BuildNextDispatcher</methodName>
  <appServerUri></appServerUri>
  <returnType>System.Void</returnType>
  <localTime>2/28/2021 07:35:53:9185525 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="13" roundTrip="11" channel="0" bpm="0" other="2" />
  <retries>0</retries>
  <parameters>
    <parameter name="nextActionID" type="System.String"><![CDATA[PO]]></parameter>
    <parameter name="dispIDList" type="System.String"><![CDATA[]]></parameter>
    <parameter name="dispNmList" type="System.String"><![CDATA[]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.BO.ReqImpl</businessObject>
  <methodName>Update</methodName>
  <appServerUri></appServerUri>
  <returnType>System.Void</returnType>
  <localTime>2/28/2021 07:35:57:2698876 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="333" roundTrip="283" channel="0" bpm="0" other="50" />
  <retries>0</retries>
  <parameters>
    <parameter name="ds" type="Erp.BO.ReqDataSet">
      <ReqDataSet xmlns="http://www.epicor.com/Ice/300/BO/Req/Req" />
    </parameter>
  </parameters>
  <paramDataSetChanges>
    <paramDataSet name="ds" useDataSetNbr="0">
      <changedValue tableName="ReqHead" rowState="Modified" rowNum="0" colName="NextActionDesc"><![CDATA[Create PO]]></changedValue>
      <changedValue tableName="ReqHead" rowState="Modified" rowNum="0" colName="NextActionID"><![CDATA[PO]]></changedValue>
      <changedValue tableName="ReqHead" rowState="Modified" rowNum="0" colName="ReplyOption"><![CDATA[A]]></changedValue>
      <changedValue tableName="ReqHead" rowState="Modified" rowNum="0" colName="ReqUserId"><![CDATA[Aaron]]></changedValue>
      <changedValue tableName="ReqHead" rowState="Modified" rowNum="0" colName="UD_SysRevID"><![CDATA[System.Byte[]]]></changedValue>
    </paramDataSet>
  </paramDataSetChanges>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.BO.ReqImpl</businessObject>
  <methodName>CheckToDo</methodName>
  <appServerUri></appServerUri>
  <returnType>System.Boolean</returnType>
  <localTime>2/28/2021 07:35:57:7559362 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="13" roundTrip="7" channel="0" bpm="0" other="6" />
  <retries>0</retries>
  <parameters>
    <parameter name="dispatchId" type="System.String"><![CDATA[Aaron]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.BO.ReqImpl</businessObject>
  <methodName>RDMenuFlags</methodName>
  <appServerUri></appServerUri>
  <returnType>System.Void</returnType>
  <localTime>2/28/2021 07:35:57:8219428 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="43" roundTrip="42" channel="0" bpm="0" other="1" />
  <retries>0</retries>
  <parameters>
    <parameter name="reqNum" type="System.Int32"><![CDATA[1]]></parameter>
    <parameter name="reqUserId" type="System.String"><![CDATA[Aaron]]></parameter>
    <parameter name="resetDispatch" type="System.Boolean"><![CDATA[False]]></parameter>
    <parameter name="dispatchReq" type="System.Boolean"><![CDATA[False]]></parameter>
  </parameters>
</tracePacket>

I was able to call the ResetDispatch method without problem. I tried using an EpiDataView to update those fields and setting RowMod = “U”, with no dice. I’m also not entirely sure if I need to use .GetByID here, because at this point the data is already returned to the UI.

2

Keep in mind instantiating an adapter is now a separate class than the one existing in the ui/form.

3

Would I be able to call the methods I need in the form, without instantiating another Adapter? How would I do that?

I figured worst case I could just use GetByID to pull the dataset, but I’m still going over the Customization User Guide and trying to learn.

Worst case I may be able to do it in a BPM, but I had hoped to do it on the UI and refresh it there.

4

I think there are some examples here of tapping into a form adapter, but I’m not at my computer atm so I can’t show you. I will try if I get to one.

Example:

//Access a forms natively available adapter(s)
//you can find the name of the native adapter in a form by using the Form Event Wizard>Before Adapter Method to return a list of adapters in that form
var adapterInsp = ((InspProcessingAdapter)(this.csm.TransAdaptersHT["oTrans_inspAdapter"]));
5

So it looks like it is just calling the Update method on the reqAdapter, on the requisition screen,
but the Update method doesn’t allow me to pass anything into the method according to the adapter wizard. How would I go about updating those values?

6

You’ll update the dataset, which is carried by the adapter. This is different than passing in variables into a method

7

So here’s what I have attempted so far, I’m now getting the object reference is not set to an instance of an object. Am I even relatively close?

try
{
ReqAdapter adapterReq = (ReqAdapter)csm.TransAdaptersHT[“oTrans_adapter”];
adapterReq.BOConnect();
adapterReq.GetByID(“1”);
adapterReq.ReqData.ReqHead[0][“RowMod”] = “U”;
adapterReq.ReqData.ReqHead[0][“NextActionDesc”] = “Create PO”;
adapterReq.ReqData.ReqHead[0][“NextActionID”] = “PO”;
adapterReq.ReqData.ReqHead[0][“ReplyOption”] = “A”;
adapterReq.ReqData.ReqHead[0][“ReqUserId”] = “A”;
adapterReq.ReqData.ReqHead[0][“UD_SysRevID”] = string.Empty;

adapterReq.Update();
adapterReq.Dispose();

} catch (System.Exception ex)
{
ExceptionBox.Show(ex);
}

}

8

is that the name of the adapter in that form? I am curious, I am unfamiliar with the requisition BO entirely, but you’ll want to make sure the adapter is reference by name as it appears.

Secondly, I believe the adapter in the form is already connected, no need to call connect again.
GetByID looks correct, it’s really exactly the same as any other adapter after you make your reference to it. Also, don’t dispose of the adapter, since it’s being managed by the transaction object.

Here’s some example code where I used the native adapter, alongside custom ones that I instantiated.

private void InspectionProcessingEntryForm_BeforeToolClick(object sender, Ice.Lib.Framework.BeforeToolClickEventArgs args)
	{
		if(args.Tool.Key == "Disposition Misc. Receipt")
		{
			//launch special search to retrieve pending PO receipts by Donor Number
			object ret = ProcessCaller.InvokeAdapterMethod
						(oTrans.EpiBaseForm, "QuickSearchAdapter", "ShowQuickSearchForm", new object[] 
						{oTrans.EpiBaseForm, "SearchByDonor", true/* multi-select */, new DataTable() });
			  
			// user cancelled
			if (ret == null) return;			
			ArrayList list = (ArrayList)ret;			
			
			//Return type is a calculated field, which is PackNum + ~ + VendorID
			
			//Handle Multiple Pack Slips
			for(int i = 0; i<list.Count; i++)
			{
				string  pcPurPoint = string.Empty; 
				string pcPackSlip = string.Empty;
				int piVendorNum = 0;
				
				string value = list[i].ToString();
				char delimiter = '~';
				string[] substrings = value.Split(delimiter);
				//set variables, first index is pack slip, second index is vendor num
				pcPackSlip = substrings[0];
				piVendorNum = Convert.ToInt32(substrings[1]);				

				//Find PO Receipt Data by Donor Number as Pack Slip			
				adapterReceipt = new ReceiptAdapter(oTrans);
				adapterReceipt.BOConnect();
				
				var adapterInsp = ((InspProcessingAdapter)(this.csm.TransAdaptersHT["oTrans_inspAdapter"]));			
				
				//call a get by ID method and return all dtl within a specific pack slip
				bool result = adapterReceipt.GetByID(piVendorNum, "", pcPackSlip);
				if(result)
				{	
					//Find RcvDtl records that haven't been received yet (InspectionPending = false)
					
					//create list to store InspectionPending records line numbers
					List<int> inspPending = new List<int>();
					//Find RcvDtl records that haven't been received yet (InspectionPending = true)
					int index = 0;
					foreach(DataRow row in adapterReceipt.ReceiptData.RcvDtl)
					{
						if(adapterReceipt.ReceiptData.RcvDtl[index].InspectionPending)
						{
							inspPending.Add(adapterReceipt.ReceiptData.RcvDtl[index].PackLine);
						}
						index++;
					}
					//if no records waiting to be inspected, exit method
					if(inspPending.Count==0)
					{
						MessageBox.Show(string.Format("Pack {0} has no Inspection Pending Receipt Detail records.", pcPackSlip));
						return;
					}

					//copy list to array for easy index crawling
					int piPackLine = 0;
					int[] array = new int[inspPending.Count];
					inspPending.CopyTo(array);
					
					foreach(int line in array)
					{
						piPackLine = line;
						adapterInsp.GetReceiptByID(piVendorNum, "",pcPackSlip,piPackLine); 
						oTrans.NotifyAll();			
					}
		
					oTrans.NotifyAll();
					oTrans.NotifyAll(EpiTransaction.NotifyType.Initialize, edvporView);
					Erp.UI.Controls.Combos.InspectrCombo cmb = (Erp.UI.Controls.Combos.InspectrCombo)csm.GetNativeControlReference("fd9fe6a9-c62e-4a1e-86cf-57f55bb73815");
					cmb.Focus();
				}
				else 
					MessageBox.Show("Unable to find Pack Slip...");
				adapterReceipt.Dispose();
			}
		}
		if(args.Tool.Key == "Disposition Inventory Non-Conformance")
		{
		
			//launch special search by Donor Number to retreive any non-conformance lots associated. Return value is NonConf.TranID
			object ret = ProcessCaller.InvokeAdapterMethod
						(oTrans.EpiBaseForm, "QuickSearchAdapter", "ShowQuickSearchForm", new object[] 
						{oTrans.EpiBaseForm, "SearchNonConformByDonor", true/* multi-select */, new DataTable() });
			// user cancelled
			if (ret == null) return;		
			
			ArrayList list = (ArrayList)ret;		
			//Return value is NonConf.TranID
			//Add each returned value from list into a real adapter, then will pass dataset into a native adapter method			
			var adapterInsp = ((InspProcessingAdapter)(this.csm.TransAdaptersHT["oTrans_inspAdapter"])); //native adapter

			for(int i=0;i<list.Count;i++)
			{
				string value = list[i].ToString();
				int convertValue = Convert.ToInt32(value);

				adapterInsp.GetByID(convertValue);

				oTrans.NotifyAll();
				oTrans.NotifyAll(EpiTransaction.NotifyType.Initialize, edvinvView);
			}		
			oTrans.NotifyAll();
			oTrans.NotifyAll(EpiTransaction.NotifyType.Initialize, edvinvView);	
			Erp.UI.Controls.Combos.InspectrCombo cmb = (Erp.UI.Controls.Combos.InspectrCombo)csm.GetNativeControlReference("69eac31b-3e9c-4e3f-9962-45220b10f738");
			cmb.Focus();
		}
	}

It would also be good to know where your exception is being triggered. Try a MessageBox, not ExceptionBox. I don’t know if that’s even in there aynmore

9

I’ll check out some of your code and maybe figure out what’s happening with mine.
Right now I’m firing on a click event, but would like to fire it after a specific field change.

It runs, but seems like it clears some of the menu data, and doesn’t actually dispatch the requisition.

try
{

ReqAdapter adapterReq = ((ReqAdapter)(csm.TransAdaptersHT[“oTrans_reqAdapter”]));
adapterReq.BOConnect();
adapterReq.GetByID(1);
adapterReq.ReqData.ReqHead[0][“RowMod”] = “U”;
adapterReq.ReqData.ReqHead[0][“NextActionDesc”] = “Create PO”;
adapterReq.ReqData.ReqHead[0][“NextActionID”] = “PO”;
adapterReq.ReqData.ReqHead[0][“ReplyOption”] = “A”;
adapterReq.ReqData.ReqHead[0][“ReqUserId”] = “Aaron”;
//adapterReq.ReqData.ReqHead[0][“UD_SysRevID”] = “”;

bool updresult = adapterReq.Update();
MessageBox.Show("Update " + updresult.ToString());
adapterReq.Dispose();

} catch (System.Exception ex)
{
ExceptionBox.Show(ex);
}

}
10

You’ll want to follow the trace pretty closely especially on a form adapter. You’re on the right track

11

I feel like I’m getting close, but still no dice. Everything seems to run, but the Req still doesn’t seem to be dispatched, following based on the trace I initially posted.

try
{

//var adapterInsp = ((InspProcessingAdapter)(this.csm.TransAdaptersHT[“oTrans_inspAdapter”]));
ReqAdapter adapterReq = ((ReqAdapter)(csm.TransAdaptersHT[“oTrans_reqAdapter”]));
adapterReq.GetByID(1);

  int intId = 1;
  int reqNum = 1;
  string reqUserId = "Aaron";
  bool resetDispatch = true;
  bool dispatchReq = false;
  string dispatchId = "Aaron";
  string nextActionID = "PO";
  string dispIDList = string.Empty;
  string dispNmList = string.Empty;

  bool bndresult = adapterReq.BuildNextDispatcher(nextActionID, out dispIDList, out dispNmList);
  MessageBox.Show("Build next dispatch: "+bndresult.ToString());

adapterReq.ReqData.ReqHead[0][“RowMod”] = “U”;
adapterReq.ReqData.ReqHead[0][“NextActionDesc”] = “Create PO”;
adapterReq.ReqData.ReqHead[0][“NextActionID”] = “PO”;
adapterReq.ReqData.ReqHead[0][“ReplyOption”] = “A”;
adapterReq.ReqData.ReqHead[0][“ReqUserId”] = “Aaron”;
//adapterReq.ReqData.ReqHead[0][“UD_SysRevID”] = “”;

bool updresult = adapterReq.Update();
MessageBox.Show("Update " + updresult.ToString());

bool chkresult = adapterReq.CheckToDo(dispatchId);
MessageBox.Show("Check to do: "+chkresult.ToString());

adapterReq.RDMenuFlags(reqNum, reqUserId, out resetDispatch, out dispatchReq);

MessageBox.Show(“Ran!”);
oTrans.NotifyAll();

} catch (System.Exception ex)
{
ExceptionBox.Show(ex);
}

}

12

Sounds like a good time to take a break :wink:
Can that requisition even be dispatched? Maybe that test data needs to be refreshed

13

Yeah, I’m going to take a step back for today. I’m able to dispatch without a problem through the UI.

1 Like
14

I might be wrong, but don’t you need to use BeginEdit and EndEdit when you are setting the field values?

15

I’ll try that shortly, and see how it goes. Doing some digging this morning, it looks like once the req is dispatched, it goes into the ReqLog table. I didn’t see any methods that would let me insert a row into it, so I think it happens on the update method. I can see in the customization where I’m able to return a RegLog dataset with a GetList, but I’m not seeing any adapters or methods to actually create one.

I’ll try the begin edit and end edit, and then probably revisit the trace again. I looked into the chm files for the tables and Business Objects. Maybe I’ll find something!

16

Hi Aaron,
Did you ever get this to work? I am trying to do the same, putting a button to call the Req dispatch form on click event. I will appreciate any help on this.

17

Hi Guys!
I am trying to do the same thing. I have a dashboard with a UBAQ and BPM inside. If the user click a part number from my dashboard, and click the button, then a req is automatically created. The req detail line is created, and then I try to dispatch it, but nothing happens. I am not trying to use custom code widgets, just the BOs and methods.
Part of my approach: UBAQ to Create Requisition

Did anyone resolve this?

18

Hey guys, same problem here, trying to dispatch with an Epicor Function.

Any progress ?

19

Yeah, it wants 2 lines in your dataset before the update: the initial one without any changes and RowMod=“” and the second one with the changes and RowMod=“U”.

First, call the GetByID to get the full req dataset (in this case tsReq). Then copy the header and set the fields:

// copy header
var currentRow = tsReq.ReqHead[0];
var newRow = tsReq.ReqHead.NewRow();
BufferCopy.CopyExceptFor(currentRow, newRow, "");

// set fields for the new header
newRow["NextDispatcherID"] = "ApproverIDHere";
newRow["NextActionID"] = "APPR";
newRow["ReplyOption"] = "A";
newRow["ReqUserId"] = "RequestorIDHere";
newRow["RowMod"] = "U";

// add new header to tableset
tsReq.ReqHead.Add(newRow);

Finally, call the Update. Worked for me.

20

@Dragos thx for your code,its work well.
i need to reject the po requsition with the same trick, could you please give any suggusstion