Lauren, good afternoon.
That is the only field with the SalesReps to work with (in 8.03 that I can remember). It is an array-field, with elements separated by a tilde, from which you need to extract the 5 potential Sales Reps. This extraction can be done in Crystal and then tied to the proper Sales Rep Commission (combination of RepRate1-5 and RepSplit1-5 fields either at OrderHed or OrderDtl levels); so, you can calculate the commission for each of the Reps in an Order, but the problem is tying them to a SalesRep Name.
Let me dig into my notes on Crystal to extract these elements from the array and will let you know if I find anything. Crystal Reports forums (BusinessObjects) should also have information on this. Sorry if I am too vague, but wanted at least to give you some start-up information on it.
Regards.
Roel Martinez
ERP Analyst
SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705
[Non-text portions of this message have been removed]
That is the only field with the SalesReps to work with (in 8.03 that I can remember). It is an array-field, with elements separated by a tilde, from which you need to extract the 5 potential Sales Reps. This extraction can be done in Crystal and then tied to the proper Sales Rep Commission (combination of RepRate1-5 and RepSplit1-5 fields either at OrderHed or OrderDtl levels); so, you can calculate the commission for each of the Reps in an Order, but the problem is tying them to a SalesRep Name.
Let me dig into my notes on Crystal to extract these elements from the array and will let you know if I find anything. Crystal Reports forums (BusinessObjects) should also have information on this. Sorry if I am too vague, but wanted at least to give you some start-up information on it.
Regards.
Roel Martinez
ERP Analyst
SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705
[Non-text portions of this message have been removed]