I am a new convert (went live 01/02/08) on Vantage 803.403C. It's
going fairly well, but have lots of requests for Barcode labels and
reports.
We need to calculate our sales commissions based on each line item
we sell. Our commission grid consists of SalesPerson,
CustomerGroup, ProductGroup and Campaign. So, I have created a
UserDefined table with each of these 4 fields as key fields, and
each record has a percent for the correct commission percent. We
feel this is too complex to enter at Order entry time which Vantage
says is the correct path.
I now want to populate the InvcDtl file with the required info.
ProductGroup is already there, so I need to add: SalesPerson (from
InvcHead.SalesRepList (we will only
have 1 salesrep)), CustomerGroup (from Customer.GroupCode), Campaign
(from OrderDtl.MktgCampaignID) and the commission percent (from
UD01.Number01).
Questions:
1. Which tool do I use? BPM, Service Connect, Progress, or other?
2. I would like to see some sample VB code (I assuming here) to make
the above happen.
3. What else am I missing to get commision percent by line item?
Semi-related question: How can I get some simple training in writing
Progress code if I want to fix the existing sales from Jan 2 until
present? Or is there a better way to to that?
Denton Yoder
Bil-Jax, Inc.
going fairly well, but have lots of requests for Barcode labels and
reports.
We need to calculate our sales commissions based on each line item
we sell. Our commission grid consists of SalesPerson,
CustomerGroup, ProductGroup and Campaign. So, I have created a
UserDefined table with each of these 4 fields as key fields, and
each record has a percent for the correct commission percent. We
feel this is too complex to enter at Order entry time which Vantage
says is the correct path.
I now want to populate the InvcDtl file with the required info.
ProductGroup is already there, so I need to add: SalesPerson (from
InvcHead.SalesRepList (we will only
have 1 salesrep)), CustomerGroup (from Customer.GroupCode), Campaign
(from OrderDtl.MktgCampaignID) and the commission percent (from
UD01.Number01).
Questions:
1. Which tool do I use? BPM, Service Connect, Progress, or other?
2. I would like to see some sample VB code (I assuming here) to make
the above happen.
3. What else am I missing to get commision percent by line item?
Semi-related question: How can I get some simple training in writing
Progress code if I want to fix the existing sales from Jan 2 until
present? Or is there a better way to to that?
Denton Yoder
Bil-Jax, Inc.