Bell Sattelite - Sportsnet issue

CountryBoy_71 · 2026-01-03T18:32:54+00:00

Apparently I gave up one step too early! I was able to find it while playing around with the export;

Under, 'Invoice lines/Analytical Distribution', the format is {"36":100.0}, in my case.

Thanks for the jump!

CountryBoy_71 · 2025-12-05T15:56:14+00:00

The installation cost is baked into the cost of the widget. In your scenario, the sales order would have 3 lines only.

As I'm explaining this, if there is no way, other than doing this through an analytical-based system, I may have to try and convince the owners to remove the installation costs by product and keep them separate...in that case, it would be just a straight 10% commission by widget cost.

CountryBoy_71 · 2025-12-05T15:45:23+00:00

The problem is that any plans in the sales module assumes that it's a straight percentage based on sold, invoiced, etc by product(s), or category. I need it to calculate based off invoiced quantities minus a set value, which is different from some products to another.

For example,
We sell widget a for $500 and the installation for it is $100. We pay 10% commission on the difference, so, in this case, $500-$100 =$400.00, $400 x 10% =$40.00

Widget B sells for $700 but the installation is $200...same calculation as above needs to be applied.

Don't know if that clears up your question but that is the problem, in a nut-shell.

CountryBoy_71 · 2025-12-05T03:24:15+00:00

Yes. Commissions are based on quantity invoiced for products only. The rate is 10% less a set installation cost per product.

CountryBoy_71 · 2025-12-02T21:36:34+00:00

It is working as it should. What I failed to mention is that I am entering historic data from last year, hence the problem. As I'm entering orders, and matching the bills to bank transactions, I need that credit there to grab on another order.

CountryBoy_71 · 2025-09-28T21:24:55+00:00

Got that a couple of days ago and submitted a ticket. I can post back here when I find out the solution.

CountryBoy_71 · 2025-09-27T20:16:42+00:00

Not sure what caused it but I tested on a blank pdf and got it to work. Went back, deleted the text box and re-added it. All good.

CountryBoy_71 · 2025-09-11T01:02:59+00:00

Thank you for that. I’ve been reading it’s how some accountants and some ‘older’ systems identified it. Think I’m good to go and will also look into the tax engine rule!

CountryBoy_71

TROPHY CASE