BPM - Post Process GetNewPORel LockQty=true 10.0.700.4

Yahoo Archive
1
2

Hey,

I want to conditionally set the territory and sales rep fields on a new ship-to record based on the value of the customer ID. I entered a new post-process method directive for Erp.ShipTo.GetNewShipTo and dragged in a condition.

The post-process directive doesn't show a "The specified field of the changed row is equal...." as it does in pre-process.

So I tried "The custom code condition is valid." and entered "return ttShipTo.CustNumCustID == 1;"

When I enable and save it, I get:

"Server Side Exception
There is at least one compilation error.
Exception caught in: Epicor.ServiceModel
Error Detail ============Description:  There is at least one compilation error.Details:  Error CS1061: 'Erp.Tablesets.ShipToTable' does not contain a definition for 'CustNumCustID' and no extension method 'CustNumCustID' accepting a first argument of type 'Erp.Tablesets.ShipToTable' could be found (are you missing a using directive or an assembly reference?) ..."

I can install a setter and reference ttShipTo.CustNumCustID, and I can refer to it in a pre-process directive condition.

The ICETools users guide didn't provide much illumination.

Am I on the wrong track?

--

Joe D. Trent

Bigham Ag Equipment


3
ttShipTo is a table so you need to loop into it. You can't just return ttShipTo.Field

On Wednesday, March 2, 2016, jdtrent@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Hey,</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">I want to conditionally set the territory and sales rep fields on a new ship-to record based on the value of the customer ID. I entered a <span style="margin:0px;padding:0px;outline:0px;vertical-align:baseline;">new </span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;">post-process</span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;"> method directive for </span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;">Erp.ShipTo.GetNewShipTo and dragged in a condition.</span></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">The post-process directive doesn&#39;t show a &quot;The specified field of the changed row is equal....&quot; as it does in pre-process.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">So I tried &quot;The custom code condition is valid.&quot; and entered &quot;return ttShipTo.CustNumCustID == 1;&quot;</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">When I enable and save it, I get:</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">&quot;Server Side Exception<br>There is at least one compilation error.<br>Exception caught in: Epicor.ServiceModel<br>Error Detail ============Description:  There is at least one compilation error.Details:  Error CS1061: &#39;Erp.Tablesets.ShipToTable&#39; does not contain a definition for &#39;CustNumCustID&#39; and no extension method &#39;CustNumCustID&#39; accepting a first argument of type &#39;Erp.Tablesets.ShipToTable&#39; could be found (are you missing a using directive or an assembly reference?) ...&quot;</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">I can install a setter and reference ttShipTo.CustNumCustID, and I can refer to it in a pre-process directive condition.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">The ICETools users guide didn&#39;t provide much illumination.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Am I on the wrong track?</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">--</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Joe D. Trent</p><p><span></span></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Bigham Ag Equipment</p><p><span><br></span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>


--

Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

4
Okay, thanks. I'll give it a shot.

Joe

On Wed, Mar 2, 2016 at 4:51 PM, Jose Gomez jose@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>ttShipTo is a table so you need to loop into it. You can&#39;t just return ttShipTo.Field<span class="ygrps-yiv-450760902"><span></span><br><br>On Wednesday, March 2, 2016, <a rel="nofollow" target="_blank" href="mailto:jdtrent@...">jdtrent@...</a> [vantage] &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt; wrote:<br></span></p><blockquote class="ygrps-yiv-450760902gmail_quote" style="border-left:1px #ccc solid;">

 
<div>
  
  
  <p></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Hey,</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">I want to conditionally set the territory and sales rep fields on a new ship-to record based on the value of the customer ID. I entered a <span style="margin:0px;padding:0px;outline:0px;vertical-align:baseline;">new </span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;">post-process</span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;"> method directive for </span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;">Erp.ShipTo.GetNewShipTo and dragged in a condition.</span></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">The post-process directive doesn&#39;t show a &quot;The specified field of the changed row is equal....&quot; as it does in pre-process.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">So I tried &quot;The custom code condition is valid.&quot; and entered &quot;return ttShipTo.CustNumCustID == 1;&quot;</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">When I enable and save it, I get:</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">&quot;Server Side Exception<br>There is at least one compilation error.<br>Exception caught in: Epicor.ServiceModel<br>Error Detail ============Description:  There is at least one compilation error.Details:  Error CS1061: &#39;Erp.Tablesets.ShipToTable&#39; does not contain a definition for &#39;CustNumCustID&#39; and no extension method &#39;CustNumCustID&#39; accepting a first argument of type &#39;Erp.Tablesets.ShipToTable&#39; could be found (are you missing a using directive or an assembly reference?) ...&quot;</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">I can install a setter and reference ttShipTo.CustNumCustID, and I can refer to it in a pre-process directive condition.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">The ICETools users guide didn&#39;t provide much illumination.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Am I on the wrong track?</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">--</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Joe D. Trent</p><p><span></span></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Bigham Ag Equipment</p><p><span><br></span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>


--

Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

</div>
 


<div style="color:#fff;min-height:0;"></div>

5
Dang. Well, I reused some code from another BPM to read the table, and it saved okay, but just never fired the exception. I've created two BPMs for use in creating and updating a ship-to record, and neither will fire a message or exception, even if I wire the message/exception box directly to the Start object.

I'm using these method directives:

Erp.ShipTo.GetNewShipTo/post-process/enabled

Erp.ShipTo.Update/pre-process/enabled

I looked at Erp.CustShip, but that looks like Customer Shipment to me.

I'm using similar BPMs on Erp.Customer.GetNewCustomer/post-process and Erp.Customer.Update/pre-process, and they work just fine.

Stumped. Is there another Ship-To object I'm not seeing?

Thanks,

Joe


On Wed, Mar 2, 2016 at 5:04 PM, Joe Douglas Trent <jdtrent@...> wrote:
Okay, thanks. I'll give it a shot.

Joe

On Wed, Mar 2, 2016 at 4:51 PM, Jose Gomez jose@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>ttShipTo is a table so you need to loop into it. You can&#39;t just return ttShipTo.Field<span><span></span><br><br>On Wednesday, March 2, 2016, <a rel="nofollow" target="_blank" href="mailto:jdtrent@...">jdtrent@...</a> [vantage] &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt; wrote:<br></span></p><blockquote class="ygrps-yiv-2117995373gmail_quote" style="border-left:1px #ccc solid;">

 
<div>
  
  
  <p></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Hey,</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">I want to conditionally set the territory and sales rep fields on a new ship-to record based on the value of the customer ID. I entered a <span style="margin:0px;padding:0px;outline:0px;vertical-align:baseline;">new </span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;">post-process</span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;"> method directive for </span><span style="margin:0px;padding:0px;outline:0px;font-weight:inherit;font-style:inherit;font-family:inherit;vertical-align:baseline;background:transparent;">Erp.ShipTo.GetNewShipTo and dragged in a condition.</span></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">The post-process directive doesn&#39;t show a &quot;The specified field of the changed row is equal....&quot; as it does in pre-process.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">So I tried &quot;The custom code condition is valid.&quot; and entered &quot;return ttShipTo.CustNumCustID == 1;&quot;</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">When I enable and save it, I get:</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">&quot;Server Side Exception<br>There is at least one compilation error.<br>Exception caught in: Epicor.ServiceModel<br>Error Detail ============Description:  There is at least one compilation error.Details:  Error CS1061: &#39;Erp.Tablesets.ShipToTable&#39; does not contain a definition for &#39;CustNumCustID&#39; and no extension method &#39;CustNumCustID&#39; accepting a first argument of type &#39;Erp.Tablesets.ShipToTable&#39; could be found (are you missing a using directive or an assembly reference?) ...&quot;</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">I can install a setter and reference ttShipTo.CustNumCustID, and I can refer to it in a pre-process directive condition.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">The ICETools users guide didn&#39;t provide much illumination.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Am I on the wrong track?</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">--</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Joe D. Trent</p><p><span></span></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Bigham Ag Equipment</p><p><span><br></span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>


--

Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

</div>
 


<div style="color:#fff;min-height:0;"></div>


6

The GetNewPORel method post-process directive does not set the PO Release LockQty to true. When I add another release, the checkbox gets checked on the second release but never on the first release. This is true for PO’s generated from the new PO suggestions program also.

In E10.0.700.4 data directives the PORel.LockQty field does not exists otherwise that would have worked probably.

Any help will be greatly appreciated.

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

_________________________________________________________________________________ Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements. _________________________________________________________________________________
7
Hi Mike,

Lock qty and lock date is stored ComXref table. You can directly update it .

Regards,
Arul

Sent from my iPhone

On 5 Mar 2016, at 9:18 AM, Mike Tonoyan mtonoyan@... [vantage] <vantage@yahoogroups.com> wrote:

 

<div id="ygrps-yiv-2147347015ygrp-text">
  
  
  <p>

The GetNewPORel method post-process directive does not set the PO Release LockQty to true. When I add another release, the checkbox gets checked on the second release but never on the first release. This is true for PO’s generated from the new PO suggestions program also.

In E10.0.700.4 data directives the PORel.LockQty field does not exists otherwise that would have worked probably.

Any help will be greatly appreciated.

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

_________________________________________________________________________________ Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements. _________________________________________________________________________________ 

</div>
8

In 10.1 they have finally moved the lock fields to the PORel table

 

This is how we do it in 10.0……

 

In Transaction Data Directive:

Condition: There is at least one added row in the PORel table

On true Execute Custom Code:

bool foundComxRefRecord = false;

string setLockDate = "No";

string setLockQty = "Yes";

Erp.Tables.COMXref COMXref;

foreach (var ttPORel_iterator in (from ttPORel_Row in ttPORel

                                  where ttPORel_Row.PORelNum != 0

                                  select ttPORel_Row))

{

    var ttPORelRow = ttPORel_iterator;

                                string strPO = ttPORelRow.PONum.ToString();

                                string strPOL = ttPORelRow.POLine.ToString();

                                string strPOR = ttPORelRow.PORelNum.ToString();

     COMXref = (from COMXref_Row in Db.COMXref

                where string.Compare(COMXref_Row.Company, ttPORelRow.Company, true) == 0

                && string.Compare(COMXref_Row.File, "PORel_Mapping", true) == 0

                && COMXref_Row.Key1 == strPO

                && COMXref_Row.Key2 == strPOL

                && COMXref_Row.Key3 == strPOR

                select COMXref_Row).FirstOrDefault();

     if (COMXref != null)

     {

         COMXref.foreignKey1 = setLockDate;

         COMXref.foreignKey2 = setLockQty;

         foundComxRefRecord = true;

         Db.Release(ref COMXref);

     }

     if (!foundComxRefRecord)

     {

         COMXref = new Erp.Tables.COMXref();

         Db.COMXref.Insert(COMXref);

         COMXref.Company = ttPORelRow.Company;

         COMXref.File = "PORel_Mapping";

         COMXref.Key1 = System.Convert.ToString(ttPORelRow.PONum);

         COMXref.Key2 = System.Convert.ToString(ttPORelRow.POLine);

         COMXref.Key3 = System.Convert.ToString(ttPORelRow.PORelNum);

         COMXref.foreignKey1 = setLockDate;

         COMXref.foreignKey2 = setLockQty;

                                                                Db.Validate();

     }

}

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 04, 2016 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM - Post Process GetNewPORel LockQty=true 10.0.700.4

 




The GetNewPORel method post-process directive does not set the PO Release LockQty to true. When I add another release, the checkbox gets checked on the second release but never on the first release. This is true for PO’s generated from the new PO suggestions program also.

In E10.0.700.4 data directives the PORel.LockQty field does not exists otherwise that would have worked probably.

Any help will be greatly appreciated.

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

_________________________________________________________________________________ Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements. _________________________________________________________________________________


1 Like
9

Thanks Arul!

 

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 04, 2016 4:34 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM - Post Process GetNewPORel LockQty=true 10.0.700.4

 

 

Hi Mike,

 

Lock qty and lock date is stored ComXref table. You can directly update it .

 

Regards,

Arul

Sent from my iPhone


On 5 Mar 2016, at 9:18 AM, Mike Tonoyan mtonoyan@... [vantage] <vantage@yahoogroups.com> wrote:

 

The GetNewPORel method post-process directive does not set the PO Release LockQty to true. When I add another release, the checkbox gets checked on the second release but never on the first release. This is true for PO’s generated from the new PO suggestions program also.

In E10.0.700.4 data directives the PORel.LockQty field does not exists otherwise that would have worked probably.

Any help will be greatly appreciated.

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

_________________________________________________________________________________ Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements. _________________________________________________________________________________

10

Thanks Bernie!

 

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 04, 2016 4:37 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BPM - Post Process GetNewPORel LockQty=true 10.0.700.4

 

 

In 10.1 they have finally moved the lock fields to the PORel table

 

This is how we do it in 10.0……

 

In Transaction Data Directive:

Condition: There is at least one added row in the PORel table

On true Execute Custom Code:

bool foundComxRefRecord = false;

string setLockDate = "No";

string setLockQty = "Yes";

Erp.Tables.COMXref COMXref;

foreach (var ttPORel_iterator in (from ttPORel_Row in ttPORel

                                  where ttPORel_Row.PORelNum != 0

                                  select ttPORel_Row))

{

    var ttPORelRow = ttPORel_iterator;

                                string strPO = ttPORelRow.PONum.ToString();

                                string strPOL = ttPORelRow.POLine.ToString();

                                string strPOR = ttPORelRow.PORelNum.ToString();

     COMXref = (from COMXref_Row in Db.COMXref

                where string.Compare(COMXref_Row.Company, ttPORelRow.Company, true) == 0

                && string.Compare(COMXref_Row.File, "PORel_Mapping", true) == 0

                && COMXref_Row.Key1 == strPO

                && COMXref_Row.Key2 == strPOL

                && COMXref_Row.Key3 == strPOR

                select COMXref_Row).FirstOrDefault();

     if (COMXref != null)

     {

         COMXref.foreignKey1 = setLockDate;

         COMXref.foreignKey2 = setLockQty;

         foundComxRefRecord = true;

         Db.Release(ref COMXref);

     }

     if (!foundComxRefRecord)

     {

         COMXref = new Erp.Tables.COMXref();

         Db.COMXref.Insert(COMXref);

         COMXref.Company = ttPORelRow.Company;

         COMXref.File = "PORel_Mapping";

         COMXref.Key1 = System.Convert.ToString(ttPORelRow.PONum);

         COMXref.Key2 = System.Convert.ToString(ttPORelRow.POLine);

         COMXref.Key3 = System.Convert.ToString(ttPORelRow.PORelNum);

         COMXref.foreignKey1 = setLockDate;

         COMXref.foreignKey2 = setLockQty;

                                                                Db.Validate();

     }

}

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 04, 2016 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM - Post Process GetNewPORel LockQty=true 10.0.700.4

 





The GetNewPORel method post-process directive does not set the PO Release LockQty to true. When I add another release, the checkbox gets checked on the second release but never on the first release. This is true for PO’s generated from the new PO suggestions program also.

In E10.0.700.4 data directives the PORel.LockQty field does not exists otherwise that would have worked probably.

Any help will be greatly appreciated.

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

_________________________________________________________________________________ Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements. _________________________________________________________________________________



11
12

Yes, we use it for MRP to suggest new POs instead of suggesting to reduce or increase the existing POs qty’s. We run MRP once a week in regenerative mode and it works for us. Never tested to run generate PO suggestions in net change. You need to run MRP Recalc Needed if you are running MRP in net change mode.

 

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 07, 2016 11:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM - Post Process GetNewPORel LockQty=true 10.0.700.4

 

 

Mike,

Could you help clarify what you are using the PO Release LockQty for?  We are using it so that any new PO suggestions will be generated if this locked qty and date checkboxes are checked on any prior PO suggestions for that part.  Is this how you are using the functionality also?  It seems like when we check both the lock qty and date checkboxes, we run the Generate PO Suggestions as Net Change but do not receive any new PO suggestions even after reviewing our demand forecasting.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 04, 2016 4:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM - Post Process GetNewPORel LockQty=true 10.0.700.4

 

 

The GetNewPORel method post-process directive does not set the PO Release LockQty to true. When I add another release, the checkbox gets checked on the second release but never on the first release. This is true for PO’s generated from the new PO suggestions program also.

In E10.0.700.4 data directives the PORel.LockQty field does not exists otherwise that would have worked probably.

Any help will be greatly appreciated.

 

MIKE TONOYAN | IT Director

MTonoyan@...

Tel +1.818.734.6511  |  Cell +1.818.397.8515

 

_________________________________________________________________________________ Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements. _________________________________________________________________________________