After Sales Order Loads

Yahoo Archive
1
OOOOH! All you are trying to do is bring info from "Other Customer"

Use a ForeignKeyView (FKW)

In Customization Mode go to Tools (or Action) Data Tools  there you can set the Like field of each of the UD fields to Customer.CustID, then bring in a FKW (foreign key view) with the data for each

here you go



Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Oct 15, 2014 at 4:25 PM, jps@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p>Jose,</p><p><br></p><p>  As I stated before, our sales orders have two more customers assigned as Owner and Engineer and their CustID&#39;s are stored in UD fields.  I also have the SalesRep names stored in UD fields.  But the rest of the information for the Owner and Engineer such as Company Name, State and City could be populated as display fields and not stored.  I don&#39;t see how to do that in a BPM.   Would you add two views to the customer table for each and bind the controls to those fields?  I&#39;m not sure how to do that but it sounds possible.</p><p><br></p><p>JPS</p><p></p>

</div><span class="ygrps-yiv-1938332138">
 


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


2

Epicor 9.05.603


I want to run some VB.Net code after a valid Sales Order has finished loading.  This seems like it would be simple but the solution escapes me.  I've tried AfterFieldChange, AfterAdapterMethod, ListChanged, AfterRowChanged,  and EpiViewNotification.   I cannot get consistent results.   Any help would be greatly appreciated.


Thanks,

JPS

3
Why not a postprocessing on the method update.



*Amélie Pelletier*

*Analyste Programmeur / Program analyst*



[image: cid:image001.jpg@01CD5525.2091A820]



*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2390*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*





*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 15 octobre 2014 14:08
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] After Sales Order Loads





Epicor 9.05.603



I want to run some VB.Net code after a valid Sales Order has finished
loading. This seems like it would be simple but the solution escapes me.
I've tried AfterFieldChange, AfterAdapterMethod, ListChanged,
AfterRowChanged, and EpiViewNotification. I cannot get consistent
results. Any help would be greatly appreciated.



Thanks,

JPS




[Non-text portions of this message have been removed]
4
What exactly are you trying to do (full story) sometimes there is more than one way to skin the cat :-D


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Oct 15, 2014 at 2:14 PM, Amélie Pelletier amelie.pelletier@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Why not a postprocessing on the method update.<br>

*Amélie Pelletier*

*Analyste Programmeur / Program analyst*

[image: cid:image001.jpg@01CD5525.2091A820]

*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2390*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*

*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 15 octobre 2014 14:08
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] After Sales Order Loads

Epicor 9.05.603

I want to run some VB.Net code after a valid Sales Order has finished
loading. This seems like it would be simple but the solution escapes me.
I've tried AfterFieldChange, AfterAdapterMethod, ListChanged,
AfterRowChanged, and EpiViewNotification. I cannot get consistent
results. Any help would be greatly appreciated.

Thanks,

JPS

 [Non-text portions of this message have been removed]

</div>
 


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

5

  Basically, to save on UD fields, we want to run calculations on existing UD fields and populate NumericEdit boxes to display the values on the fly.  For example, we have Estimated Gross Profit and Estimated Labor.  We calculate ThroughPut based on these two values.  After the Sales Order loads we want to calculate ThroughPut and display it in the edit box.


They have about seven different things they want to do like this.


Also, we not only have a Customer on a Sales Order, we have a Owner and Engineer.  The Owner and Engineer are customers in Epicor, which could match the customer but could be different.   Each of these three have their own sales reps and their own commission percentages.  Epicor is not built to handle this so we had to customize it.  With most of this data stored in UD fields, we are running out.  


Why store this in UD fields?  Our sales department is worried if a company, owner, or engineer change their sales reps in the future, the old orders will not report the correct sales rep if we use Epicor fields. I hope this makes sense.


We cannot use Epicor to calculate commissions because they do not want to pay commission on freight and they do not want to pay commission on commission.  They calculate the commission by estimating the commission and freight and remove it from the commission calculation.  ??  I know.


With most of this data stored in UD fields, we are running low.  I probably should use UD tables for the Owner and Engineer but I want to avoid that due to upgrading issues.  


So, as I originally stated, after the Sales Order loads, I want to run some custom code, but I cannot find a consistent "Sales Order Loaded" event.


JPS

6
I don't think there is an Update method when you load a sales order.
7
What you need is to set a field as mandatory? So if the user hit save , or
if he change of screen, there is an update and then the orderheld checkbox
will flag it with the bpm no?



*Amélie Pelletier*

*Analyste Programmeur / Program analyst*



[image: cid:image001.jpg@01CD5525.2091A820]



*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2390*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*





*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 15 octobre 2014 15:37
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] Re: After Sales Order Loads





I don't think there is an Update method when you load a sales order.




[Non-text portions of this message have been removed]
8
If these are values that will not be stored but rather just displayed I would run a PostProcessing on GetByID and populate the CallContextFields (Number01, 02 03) (these are volatile) and then bind the textbox to those.

You can also use Notify (Event) Initialize


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Oct 15, 2014 at 3:36 PM, jps@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>I don&#39;t think there is an Update method when you load a sales order.</p>

</div><span class="ygrps-yiv-1636227381">
 


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


9
Hey! I’m sorry!



I replied to another request at the same time as yours!



To have something after the load, I would not go through a BPM, but more
with a change in the script editor (customisation) of the screen... There,
you can do a change in the load of the sheet... I have done something like
this... I’ll come back with what I find.



*Amélie Pelletier*

*Analyste Programmeur / Program analyst*



[image: cid:image001.jpg@01CD5525.2091A820]



*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2390*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*





*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 15 octobre 2014 15:37
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] Re: After Sales Order Loads





I don't think there is an Update method when you load a sales order.




[Non-text portions of this message have been removed]
10

Sounds like an interesting idea Jose.


Thanks!


JPS

11

Jose,


  As I stated before, our sales orders have two more customers assigned as Owner and Engineer and their CustID's are stored in UD fields.  I also have the SalesRep names stored in UD fields.  But the rest of the information for the Owner and Engineer such as Company Name, State and City could be populated as display fields and not stored.  I don't see how to do that in a BPM.   Would you add two views to the customer table for each and bind the controls to those fields?  I'm not sure how to do that but it sounds possible.


JPS