By using this website, you agree to our Terms of Use (click here)
ARTRAN has a field for Commission % and Commission Amount. Neither one appears to get populated.
We pay commissions based off of GM $$'s. If it would populate the %, I could use it in GI's to make my calculations. I went so far as to Calculate Commissions and close every period for the last two years. Thought maybe closing the commission periods would update the table.
Anyone know where the commission % gets stored for each invoice? Other than here..... ARSPCommnDocResult : IBqlTable
I'm noticing the same thing. I can see the ARTran.CommnAmt field, but I'm not sure how to populate it.
You can see the commission amounts though in the ARSalesPerTran.CommnAmt field. Note that you might have multiple lines involved per Invoice.
Personally, I see a lot of people calculate commissions outside of the ERP since ERP commission calculations are limited and rigid.
We calculate outside as well, but here's the problem. To somewhat automate the process I need to get a % from somewhere. I have to link to the customer record and pull the "current" commission %. I pull the date into Excel via ODATA and have Excel use the % to calculate commission based on GM$. Problem is that I am pulling the current %, not the % at the time of the invoice. If I could get a historical view, I wouldn't have to manually track special orders and manually change the calculation.
Just need a little help from Acumatica to tame the bear of commissions.
You could use the ARSalesPerTran.CommnPct field as long as you know that there is only one Salesperson per invoice.
But it's risky because, if there ever is more than one Salesperson per invoice, you will get duplicate records and overpay your Salespeople. You would just need to verify in your commission calculation routine that the same invoice number isn't listed multiple times in the Generic Inquiry before you rely on the results.