Length of Service and Tenure

jjconn13
Occasional Contributor

Length of Service and Tenure

Hi, I'm currently having trouble figuring out the Length of Service List and Tenure columns in the SYS08 Sales Reps Details module. There is a Length of service module already built, but it is blank. So I am unsure what to base the population of this column on. Also, I built a Reps tenure range module to calculate the the tenure of each sales rep but I am struggling on how pull this back into the SYS08 Reps Details module. Any guidance would be greatly appreciated!

 

(SYS08 Sales Reps Details module)

jjconn13_1-1618815236938.png

(Length of service pre-built module)

jjconn13_3-1618815384079.png

(Sales Rep tenure range module)

jjconn13_4-1618815483159.png

 

 

 

 

 

4 REPLIES 4
ChrisHeathcote
Community Boss

Re: Length of Service and Tenure

@jjconn13 

A few steps need to pull this data across into SYS08.

  1. Update the summary settings in QU08 Sales Reps Tenure.Tenure Band to LASTNONBLANK.
  2. Use the following formula in SYS08 Sales Rep Details.Length of Service List; =QU08 Sales Reps Tenure.Tenure Band[SELECT:TenureBandList.All]

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
jjconn13
Occasional Contributor

Re: Length of Service and Tenure

Thank you for the response, Chris. I have managed to solve the issue. 

kunal_311
Frequent Contributor

Re: Length of Service and Tenure

Hi,@jjconn13 @ChrisHeathcote,

 

Can you please help me to clarify few doubts:

 

1) Significance of QUO05 Module, How to get Code and number line item.

2) QUO06 Module -  Do we need to compare the QUO05 Number line item with QUO04 Low and High tenure?

3) SYS07 Module - I calculated the completed years as the difference between the current period and the start date. I think it needs to be calculated in days. How to calculate the same?

 

 

ssicefox
Frequent Contributor

Re: Length of Service and Tenure

Hi @ChrisHeathcote ,

How are you?

I have a question for calculating the redistribution factor using TAR02 and TAR03 modules.  I want to know how to calculate the sum of all accounts except the account that was overridden or held.

I have a question about Held or Revised too. Does this item contain only Hold or Override Value? What is the item "To Change" in the TAR02 Account Review module. What is the "Check" in the TAR03 Module?

 

Any hint/clue is much Appreciated.

 

Thanks in advance!

 

I am looking forward to hearing from you soon.

Best regards.

Wei