Search results

as you know it is really complicateted..imagine how it is for me :) The things i am focusesing now is when somethign chag en the sctrucutre. You says it is automatically archived ok But data are still available if igo to query the time when the structure was not changed right? And at the same...

it is a real big job MajP, compliments! Now the problem is for me to understand the whole thing in case i wanto to do some modifucation ...and also i don'k know if i have enough skill to understan! :) Anyway..back to your last eit regarding the changing in structure.. Before i start digging in...

i have done some test and it seems all fine so it looks really good Few thinking Would be nice to have some kind of report for a single sale to see what are the shares. As it is now, it is in the big list (and can be really big) and could be difficult to find the single sales and related...

yes i think the solution is to archive the datas when i would need to make som estructural change to the tree

did a quick test (don't have time now) and the process when an agent is inactive seems working now one question Why in the agent list there is iNACTIVE? do i really need it?

just giving a look..at glance i see calculations seems fine It's not really clear for me, how you determine the tree who is afiliated to who....by the sale code? Also the agent query..what do i use it for? the commission can anyway be changed in the table if is needed..right?

As i said...in that case start a new instance of the db...:)

i said it before to CJ LOndon..they will not get replaced from a new supervisor..i don't know what is real word, this is not my area..this is how i have been told it should be...but i suspect they don't know yet all the possible scenarios as it seems the first time doing this kind of...

if F and G have assigned let's say 15%..they will always get 15% even if C leave and what was supposed to go to C go to main..right

the supervisor for everyone is the MAIN AGENT, eventually they all can refer to them..being a little structure with few agents

o as i said before..IF ANY AGENT LEAVE IT WILL NOT BE REPLACED ALl his royalties will be transfered to the main agent If you did not already..check my post 55 I have tried to make a better exaplantion of the system Look...for what i see there is no even a real need to automate the process...

i don't know if i do something wrong but to me there is still trouble I tried a sale from a 3 level tree If i put inactive an agent level 2, for example, and i have a sale made from agent 3..the royalties scheme change to a different schme while it should not Also in processed royalties appear...

i am going to test.. but i agree woth your previous post when you say that somehting like permanent table is needed

you are going far beyond my request.. :) as i said there is no product to buy/sale The final customer, let's Call him PAUL YOUNG will buy a subscription For this the SELLER COMPANY who sell the subscription, give us a commision, and every month there will be a royaltie as long as that PAUL YOUNG...

If i can match a code that i use in db and the code cistomer uses when buying in the site can be better....any way of coding would be fine for me anyway

If someone leave is not replaced.his royalties goes to main agent. For the code itnis something i am not consider for now as i can manage in whatever way, as when i go to db i ll need to insert sale and agent name and this could be enough

i am trying this new function but it seems to do nott work properly i created only 3 agent a.b and c so a relate to ma, b to a and c to b...3 levels...so scheme i MA=0,4 - A=0,3 B=0,2 and C=0,1 Now B leaves scheme don't change, only thing is that the 0,3 of B should go to MA, SO MA=0,4 -...

i have answered in the other forum! Agents will not go up or down In case one agent will leave will not be replace and his royaltes will be given to the main organization ANyway in this db there is 1 point of concern There is no a kind of history I mean..if i change for example the...

so this solve the problem of some agent leaving right? i haven't checked yet, i ll do tomorrow did you just "tranbsfer" the percentage of the agent leaving to thje MA? There is no recalculate of royalties...if the agent leaving is on 2 level and he is supposed to earn example 20% in a...

so in case agent, of any level, leave what can i do?rewrite the structure for that line to mache the new structure?