Method Community



Community Webinar 33: Scenario - Editing the Invoice Screen

On Wednesday, September 15th @ 1:00pm EST, Ryan Bell will take you through a customization scenario on editing the invoice screen.  He will be adding fields to calculate commission, create a duplicate button from scratch and end with creating a dropdown list to select alternate billing information. 

This webinar will take place live but will also be recorded and posted as a comment on the Method Blog and on the complete list of webinars on the Method Forum. 

Complete List of Method Recorded Webinars:

To register for this webinar, click the following link:


Danny Do Couto
Method Integration 




Method_Danny said:

This webinar has now been uploaded and added to the Method Community Webinar page.


September 17, 2010 8:33 AM

jnoneiliv1 said:

Webinar 33 shows the example of adding calculation for a Commission on an Invoice.  The Webinar demonstrates adding a field "Commission" to the Employee Table to store the Commission Rate.  To lookup this value the Action Sequence must first lookup the Sales Rep name in the Sales Rep table based on the Sales Rep Initials stored on the Sales Order and Invoice THEN lookup the Commission in the Employee List.

This implementation would appear to be a bad idea for several reasons.  First, the Sales Rep must also be an Employee.  Secondly, for the lookup to work the Sales Rep name and the Employee name must be IDENTICAL, unless the Action lookup allows for partial string searches.  As far as I can tell there would be nothing to prevent the user from spelling the Sales Rep names and Employee Names differently.

Would it not be a better solution to store the Commission Rate in the Sales Rep table?  Then Commission Rate is just a one step lookup from Sales Rep Initials as stored on Sales Order and Invoice Headers.

If an Employee is also a Sales Rep, the Employee List table could have a lookup field into the Sales Rep table based on Sales Rep initials.  Data integrity would hold since Sales Rep and Employee List records are related, ideally one to one, but not necessarily.

Furthermore you could also create a lookup between Vendors and the Sales Rep table in case the sales person is not also an employee.  Subsequent sales reports could be created that determine monthly commission checks to Sales Reps who are Vendors.

November 6, 2010 1:31 PM

Method_Danny said:

Hi jnoneiliv1,

I think it is important to note that the webinar wasn't meant to give the most optimal way to setup commission but more on creating a simple example that could be taught in a 30 minute webinar.  Most users getting started would be lost if they were trying to create it using the outline you provided.  Sounds like you are ahead of the curve.  :)

November 9, 2010 5:13 PM