Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have attached my sample data.
In my data base I have some products with same product code which have different selling prices and different commission patterns in the range of "Personal Product".
What i did in my commission calculation,
I introduced extended product codes to my commission rate(COMRATES.XLS) file and to the product mater file (BS-MF.xls). And also renamed the product codes in the data base through the script.
But the calculation dose not give the expected answer. As per my observation renaming in the script dose not works.
Can anyone help me to change the script to have proper result.
Regards,
Priyantha
Hi,
Can you explain with some sample example and your expected output?
Regards,
Jagan.
BCOD | ORC_CODE | CLA_CODE | PRD_CODE | REF_NO | GL_CODE | PREMUM | BRO_ORC | AGE_ORC | GRO_ORC | DIRECT_ME | ORC_COM | EXCESS |
---|---|---|---|---|---|---|---|---|---|---|---|---|
WW00 | 54042 | PP | SE | WW0014D0004846 | 70740 | 1201 | 0 | 0 | 0 | 108 | 130 | -22 |
WW0014D0004847 | 70740 | 1201 | 0 | 0 | 0 | 108 | 130 | -22 | ||||
WW0014D0004858 | 70740 | 1201 | 0 | 0 | 0 | 108 | 130 | -22 | ||||
WW0014D0004859 | 70740 | 1201 | 0 | 0 | 0 | 108 | 130 | -22 | ||||
54945 | PP | SE | WW0014D0004831 | 70740 | 1201 | 0 | 0 | 0 | 108 | 130 | -22 | |
WW0014D0004832 | 70740 | 1201 | 0 | 0 | 0 | 108 | 130 | -22 | ||||
WW0014D0004834 | 70740 | 1201 | 0 | 0 | 0 | 108 | 130 | -22 | ||||
WW0014D0004850 | 70740 | 1201 | 0 | 0 | 0 | 108 | 130 | -22 | ||||
WW0014D0004865 | 70740 | 557 | 0 | 0 | 0 | 50 | 30 | 20 | ||||
54997 | PP | SE | WW0014D0004835 | 70740 | 557 | 0 | 0 | 0 | 50 | 50 | 0 | |
WW0014D0004852 | 70740 | 557 | 0 | 0 | 0 | 50 | 50 | 0 | ||||
WW0014D0004866 | 70740 | 1201 | 0 | 0 | 0 | 108 | 120 | -12 | ||||
WW0014D0004867 | 70740 | 858 | 0 | 0 | 0 | 77 | 30 | 47 |
Dear Jagan,
In the above table there are three "PREMIUMS" available with same "CLA_CODE"and "PRD_CODE" with different commission structures. The calculation should be done in "DIRECT_ME" colomn. Expexted results should be like below.
PREMIUM DIRECT_ME
557 50
858 90
1201 | 130 |
If you see my script i have renamed the 'PRD_CODE' and introduced the same to the product master file and the commission rate master file.
Please help,
Regards,
Priyantha