OE Mystery field 1

[vbajock]

In the order line item file OEORDLIN, there is a field COMM_CALC_TYPE, which seem to always have a value of P or A, which I assume is for Percentage or Amount. My question is, where is OEORDLIN pulling this from? I can't find a field that looks like that in either ARCUST or ARSLMFIL.

Thanks for helping!

 

[kscheeler]

The commission at the line level is based on the item setting. The value is coming from IMITMIDX.

Kevin Scheeler

 

[vbajock]

The value of what? The commission? What field are your refering to? I am looking for the values P and A.

 

[maccrystal]

See Item Master maintenance, Page 2:
Values are:
A= Amount (fixed amount)
C= percent of cost
P= percent of price
M= percent of margin

http://www.appstratinc.com

 

[dgillz]

What Kevin is saying is that the values A, C, P or M ar defined in the IMITMIDX_SQL table. The field name is COMM_CALC_TYPE as well, I believe. Whatever value is placed in this field in the item master defaults to the OEORDLIN_SQL table.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[vbajock]

Thanks you both for your help. So far, I am concluding that the field has no affect on the commission calculation if the sale is to a salesman that exists in the ARSLMFIL_SQL. Am I correct?

 

[kscheeler]

In the item master, there are two fields that really work together. Commission method which is the one discussed earlier and commission amt/pct. If that field is 0 then it's not having any effect on the commision calculated on the sales order. If some items have the amt/pct field filled in with a value, it will change the commission calculated.

Kevin Scheeler

 

[MacolaHelp]

Commissions is actually fairly complex in Macola. Remember, this is a package that goes from specific to general. So, the more information you give the program, the more targeted your output will be. This can be good or bad depending on your desired level of accuracy . . .


That said, you must set the flags in the item master to calculate on either percentage or amount, then set the OECTLFIL to calculate on Sale, Margin, or Item Pct/Amt (the most specific) & then you must tie a specific salesperson to a specific customer type. Works great if you understand the underlying logic. This is not enough for some customers. Peak has added to macola's commission program in their Best of OE & Flaum's commission calc can handle most anything you throw at it as long as you are an Excel whiz kid, like most accountants.

The field OEORDLIN references is copied from IMITMIDX at the point of order entry. Then it goes through the program heirarchy to determine what/where/when to apply commission information.

 

[vbajock]

MacolaHelp, thank you for the detailed explanation. What's odd in what I am working with is that when the order is entered, Macola is placing the value from the Item master into the order, and many time it is "A", however the order is for an account whose rep is paid a percentage commission. I had expected Macola to reflect that in the data, but apparently it handles that further down the line when the order is invoiced.

 

[MacolaHelp]

Tho I haven't checked w/the programming gurus @ macola, I believe the info written into the oeordlin would be used to calculate commission if you elected the item %/amt option in oesetup. If you have chosen another method in oesetup based on sales or margin, then commissions are calculated (after looking up the salesperson information related to arcusfil & applying the commission amt you identified there which seems to be what you are seeing) & placed in slspsn_comm_amt in oeordhdr, so it would in effect ignore what is in the oeordlin for commissions on sales/margins in oesetup rather than item%/amt. After posting, this info goes into arcomdue in order to pay salespeople based on invoices or cash receipts for the customer type for that salesperson. The program would need the item %/amt in the oeordlin file in order to calculate the correct commission for the salesperson if you choose that method in oesetup. You could test it out & let us know if I've figured it out correctly. I generally find it easier to create my own scenario & test looking at the file changes than to try to get a straight answer from the experts. Hope this helps your endeavor.