Dimension Code Setup – alpha vs numeric
-
Dimension Code Setup – alpha vs numeric
Posted by Noreen Fujita-Sacco on March 8, 2018 at 5:41 pm-
All demos seem to use two digit codes for global/advanced dimensions. Numeric codes seem to be recommended although the field is alpha-numeric.
Does anyone have best practices? Does anyone have a recommendation on which type of coding will allow easiest changes to dimensions after initial setup, ie, numeric with decimals to allow inserting codes later?
Thank you.
——————————
Noreen Fujita-Sacco
Applications Coordinator
Gear Aid Inc.
Bellingham WA
360-392-2703
noreen.fujitasacco@gearaid.com
—————————— -
Cynthia Priebe
MemberMarch 8, 2018 at 6:02 PM
Dimensions and Dimension Values can be whatever makes sense to your business. In the Cronus Demo database, for example, the Dimension AREA is defined with Dimension Value Codes of 10, 20, 30.. The BUSINESSGROUP Dimension is setup with Dimension Value Codes of HOME, INDUSTRIAL, etc.Remember, that depending how you setup defaulting for Dimensions, users may need to select the Dimension Values as they enter sales and purchase documents and/or create journal entries, etc. What you use for codes should make sense to your users. The Code is Alpha numeric for just this reason.
——————————
Cynthia Priebe, MCTS, DCP
Senior Business Analyst and Project Manager
Liberty Grove Software
——————————
——————————————- -
Thank you, Cynthia.
For small sets of dim values, I do see that alpha makes it easy to key. However, we have some dims with dozens of values. Do you have any feedback for those?
——————————
Noreen Fujita-Sacco
Applications Coordinator
Gear Aid Inc.
Bellingham WA
360-392-2703
noreen.fujitasacco@gearaid.com
——————————
——————————————- -
Cynthia Priebe
MemberMarch 8, 2018 at 8:17 PM
Noreen,When many values are involved for each dimension and possibly multiple dimensions, then I would suggest Dave Wiser’s advice makes sense. Remember that you may be able to set default dimensions on master data records making user selection on data entry less of an event.
Again, the great thing here is that with NAV you have options.
Good Luck!??
——————————
Cynthia Priebe, MCTS, DCP
Senior Business Analyst and Project Manager
Liberty Grove Software
——————————
——————————————- -
Our company uses mainly alpha characters for our dimension values. Numeric values can be preferred if you have someone doing a lot of manual keying of entries since it can be easier to key from the 10-key than from the keyboard. But we try to minimize the manual entry so its not that big of an issue. Another reason you might go numeric is for presentation purposes or for totaling in the dimension value page. It can look better to have your values lines up or be able to filter for ranges than for specific values. Really just depends on your company preference.
——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————- -
Thank you, Dave.
I’ll set up sample data and do some more analysis using alpha codes.
——————————
Noreen Fujita-Sacco
Applications Coordinator
Gear Aid Inc.
Bellingham WA
360-392-2703
noreen.fujitasacco@gearaid.com
——————————
——————————————- -
Val Gameiro
MemberMarch 9, 2018 at 9:33 AM
The only other thing I would add is if you want to total your dimension values, and your words don’t sort correctly alphabetically.
In other words, if you have several dimension values and you want to be able to sub-total them, like this:
Because of the alphabetical order of those values, PROD-WIDGET is outside of the totaling.
But if I use a numeric prefix, I can fix it easily, as in this image:——————————
Val Gameiro
Advanced Business Systems, LLC
Implementer/Project Manager
Austin, Texas
former NAVUG Austin Chapter Leader
——————————
——————————————- -
Naveen Jain
MemberMarch 8, 2018 at 7:56 PM
Agree with both Dave and Cynthia. You can setup either way it make sense for business, but more often it is easier to remember by name then by number specially for the keyboard users it is easier as alpha-numeric during the data entry.——————————
Naveen Jain
Director of IT
Symbex Companies
Santa Fe Springs CA
——————————
——————————————- -
Agree with Cynthia & Dave’s suggestions as well. in some cases, I have even used a combination of alpha numeric as well so that’s an option too if you want to review that.
Meenakshi
——————————
Meenakshi Singh
Manager of Business Applications
Home Market Foods, Inc.
Norwood MA
——————————
——————————————- -
Stephen Marsh
MemberMarch 9, 2018 at 10:45 AM
Something more to consider, when you bring a two digit numeric Dimension Code in to Excel it will strip off any leading zeros. We found this one the hard way.——————————
Stephen Marsh
Enterprise Services Manager
Axxess Logistics
Vaughan
Canada
——————————
——————————————- -
We use abbreviated names for our dimensions, and for the dimension that notes “business group” for our company, we have chosen a three-tiered dimension that allows us to slice the data more easily. The first letter is “W” for wholesale or “R” for retail, followed by a dash, the next three letters indicate the next level of segmentation, and the final section is one more level. So, for example, “R-DIR-WEBSITE is “Retail/Direct/Our website” , but “W-RES-ONLICAT” is “Wholesale/resellers/online and catalog”. This allows for reports to be run with “W*” or “R-DIR*” and will grab all of the subgroups within that category. Hope this helps!
——————————
Angela Dunnahoe
Marucci Sports
Baton Rouge LA
——————————
——————————————-
Noreen Fujita-Sacco replied 6 years, 2 months ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Dimension Code Setup – alpha vs numeric’ is closed to new replies.