Hi
is there a way to pull out the sales commission amount LCY & profit commission LCY using jet express.
I can pull out sales and profit LCY (sum) but cant get the figures from the table can anyone point me in the right direction to find the right table.
the info is similar to report 115 in NAV salespeople commission report
thanks
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi sliderxb,
The commission % is stored in the Salesperson/Purchaser table. I believe the standard NAV report simply multiplies the sales and commission amounts by that percentage to get the sales and profit commission amounts. Since you are using Jet Express, you will be able to bring in the commission amounts but you won't be able to do the math to perform the calculations. You will need Jet Professional to do that part.
Please sign in to leave a comment.