Jump to content

Line items file


This topic is 5702 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi, Hope you can point me in the right direction....

I want to display in my line items file the commission % based on the criteria of - Employee and Type.

I have setup the types (Product 10%, Services 15%) on the employees table. At present it displays on the line items table the employees name and the type (Both via Calcs from the appointments table) - what i need to do (I think) is build up a case statement....

But how would that work if you add a new employee???

If i can get the % number in a field in the line items table, it should be easy to calc a employees commissions based on what they have sold? (Is this the best way to go about this?)

Thanks in advance,

Roy

Link to comment
Share on other sites

This topic is 5702 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.