Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
dimension aportionment in NAVSION 2009
anish
Member Posts: 4
hi all,
i need some help on this scenario.I have to apportion single posting into more than one dimension value.Illustration:
Suppose i have a sales invoice and i have a dimension Sales Respresnatives (namely Tom & Ben for example)
Now i have to apportion 20% of my value odf the invoice to Tom and 80% to Ben.Some times it might happen that this apportionment is to more than even two dimension values.
Basically i want to undersatnd that is apportionment in dimension values possible in NAV DX 2009 possible?
If not can anyone help me how to get this analytical information on my Sales Resp.There is no commission in my scenario its just i want to know how what % of my sale my sale representative are giving.
regards
anish kapoor
i need some help on this scenario.I have to apportion single posting into more than one dimension value.Illustration:
Suppose i have a sales invoice and i have a dimension Sales Respresnatives (namely Tom & Ben for example)
Now i have to apportion 20% of my value odf the invoice to Tom and 80% to Ben.Some times it might happen that this apportionment is to more than even two dimension values.
Basically i want to undersatnd that is apportionment in dimension values possible in NAV DX 2009 possible?
If not can anyone help me how to get this analytical information on my Sales Resp.There is no commission in my scenario its just i want to know how what % of my sale my sale representative are giving.
regards
anish kapoor
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Firstly you can not have the same dimension on the line or header without modification.
I had an organisation which had 5-10 sales people I created matching dimensions for each sales person and then created dimension values of 1-100% for the salesperson dimensions.
That way i could have multple dimension against a header or line. These lines had to be manually entered as the system won't know the percentage by any inbuilt functionality.
Since these dimensions were lightly used the impact on performance was not visible.
i appreciate your effort to reply on my scenario.but your solution needs lot of manual calculation.Is there any other way i can automate this analysis.I think Navsion lags in this a lot.
APPORTIONMENT is very important , requisiste i belive.Can anyone please help me on my scenario.
regards
anish kapoor
You say you have a single portion to sell EG you might sell a package or large contracts etc
Is this based on the effort of each sales person or ?
To answer you outright no you can't apportion to the dimension in the way u want in the standard version.
You can't have more then 1 dimension value from the same dimension code and in this case if you put 1 sales person in the header and 1 in line you will get a posting error.
You will have to modify