Recent content by sbg2

Thanks, that looks like it works. I had to add the following to the start of the formula to account for Salspersons where 'Number of Commission Rates' = 1. IF {ARSAP.SALESBASE1} = 0 THEN {ARSAP.SALESRATE1} ELSE I had tried to use multi-criteria IF statements (and/or) but kept getting errors...

Allow Commissions is not checked under I/C Setup>Categories. The Accpac software was setup by a third party provider. I am going to have to go under the assumption that there is a good reason they setup the system this way. All I really want to get at is how to format the formula.

The Track Commissions checkbox is checked under O/E Options and Commision By is set to Sales. However, the Salesperson Commissions report brings up a 0 value (Sales, Cost, Margin and Commission Earned) for every shipment. So that report is not going to work. Any help with the original question?

We are using a report so we can send each broker a breakdown of their sales for a given period (month). Plus the owner of the comopany wants a breakdown by broker for each period. Is there a module in Accpac that shows this information without the need for the report?

Using Crystal Reports - I am having trouble assigning the correct ARSAP.SALESRATE for any given shipment. For example I have a Sales Person setup as follows: ARSAP.SALESRATE1 = 15%, from $0000 to ARSAP>SALESBASE1 = $0,999.99 ARSAP.SALESRATE2 = 10%, from $1000 to ARSAP.SALESBASE2 = $2,499.99...