Sales Commissions

Our commissions are not a % but we haven't found a way to enter these on the sales order that doesn't convert them to a %. Ideally we would put them on a card on the work order - but go to the expense GL - and we're not having any luck with that either.

Anyone have a work around that they're using for sales commissions?

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

judy

We have a customizable user defined field that was created for the Sales Order. It appears on the header of the sales order along the same tabs as Ship To/sold To, Contact, etc. Sales enters the Commission Due amount in the field, since it is a not the same percentage for each order. I have a report that I run that pulls that amount each month for the sales orders that have shipped.

unknown

So we would be able to put a flat $$ amount in there? Does that go to the commission expense GL when the order ships?

If so, that might work.

judy

Yes, you can put a flat $$ amount in there. It does not tie to a GL expense account. I have not tried to link it to an expense account. I have enter manually, therefore the need for a SQL report.

unknown

Okay, thank you. We're doing the manual entry now, I'll have to think about that if it would help or not.

unknown

If you're entering it manually for each order anyway, you could just calculate what the percentage would be and enter that instead of the $ value. Another option would be to write an On Save macro that would do that for you using the User Defined field as mentioned by Judy. But you would then have to hit the macro button after you enter the $ amount in the UDF.

unknown

Unfortunately, I can't because we do an original calculation and then a final. We tried doing that for quite a while but it was always off from what we actually would pay out.

Copyright © 2025 Infor. All rights reserved.