Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community

Item Hirarchy level

rated by 0 users
This post has 8 Replies | 3 Followers

Top 500 Contributor
Posts 40
Points 905
Member since 09-07-2007
austin Posted: 01-05-2008 15:53

Hi experts,

Just Navision supporting two level item Hirarchy that is Item category code, product group code.

But some companies mainting 6 level item hirarchy. Then how can we define in Navision.

Experts could throw some valuable suggestions. Brick wall Brick wall Brick wall

Thanks and regards

  • Filed under:
  • | Post Points: 70
Top 10 Contributor
Male
Posts 1,124
Points 37,826
Member since 11-03-2000
DynamicsNAVMVP
Moderator

 

The obvious questions would be why and do they still need them. The only sort of achievable way is to flag the item with dimensions, but this many has its own drawbacks. It really depends if it is truly a hierarchical structure, or not, if it is it maybe better to adapt an existing categorisation to achieve this.
The art of teaching is clarity and the art of learning is to listen
  • | Post Points: 20
Top 150 Contributor
Male
Posts 153
Points 2,490
Member since 12-06-2005
Modris Ivans replied on 01-11-2008 17:18

You may also suggest using Item Variants - its not hierarhical, of course, but in some business widely used to eliminate amount of Items and keeping almost similar items "together", for example, sizing, coloring, patterns etc

Modris Ivans
MCP - Dynamics NAV Application

If you find yourself in a hole, the best thing to do is stop digging

  • | Post Points: 70
Not Ranked
Male
Posts 13
Points 565
Member since 01-10-2008

Is it possible to price items (for purchasing and/or sales) by item category, product group, or item variant?

 

TIA

_________________________ NA 4.00 SP1 (4.0 SP3) SQL Running via Citrix
Top 150 Contributor
Male
Posts 153
Points 2,490
Member since 12-06-2005
Modris Ivans replied on 01-11-2008 18:13

Items can be priced (and discounted) by all possible combinations of Customer, Customer Price Group, Campaign(time period), Variant, Qty ordered(several steps, say 1-3 for $10.00, 4-5 for $9.75, 5-10 for $9.00, over 100 - for $5.00)

Look at ItemCard / Sales / Prices (or Line Disounts). The same applies to Purchases.

The only drawback - someone has to set it all up, and that may be a HUGE job Big Smile 

Modris Ivans
MCP - Dynamics NAV Application

If you find yourself in a hole, the best thing to do is stop digging

  • | Post Points: 70
Not Ranked
Male
Posts 13
Points 565
Member since 01-10-2008

Modris Ivans:

The only drawback - someone has to set it all up, and that may be a HUGE job Big Smile 

Is the set up of pricing something that we can import from .xls or.csv?

_________________________ NA 4.00 SP1 (4.0 SP3) SQL Running via Citrix
  • | Post Points: 20
Top 150 Contributor
Male
Posts 153
Points 2,490
Member since 12-06-2005

RBlazei:

Is the set up of pricing something that we can import from .xls or.csv?

As our BigBoss Cool here Erik says - everything is possible in Navision, it can even make, say, a capuccino for you, too Wink

Preparing the import procedure for xml/csv may be somehow difficult for enduser, but your implementators can help.

BTW in previous post I forgot to mention an important feature - if prices/discounts setup is done so, that for given situation several conditions aplly (and they will, if used extensively), the price suggestion alghoritm will choose "best price for customer", that is, the lowest possible.

Modris Ivans
MCP - Dynamics NAV Application

If you find yourself in a hole, the best thing to do is stop digging

  • | Post Points: 20
Not Ranked
Male
Posts 13
Points 565
Member since 01-10-2008

Modris Ivans:

the price suggestion alghoritm will choose "best price for customer", that is, the lowest possible.

Is there a standard way to set the override the condition priority or manually assign condition priority, for situations when the lowest price is not the price we want selected?

 I greatly appreciate the help!

_________________________ NA 4.00 SP1 (4.0 SP3) SQL Running via Citrix
  • | Post Points: 20
Top 150 Contributor
Male
Posts 153
Points 2,490
Member since 12-06-2005

There is no definable priorities - already without them the alghorithm is heavy enough... Smile

But - if you don't like the suggested price, in Sales Order under Functions there is Get Price & Get Discount - these bring up a form showing all defined prices (discounts) for given Item for you to choose from.

Automatic "Best price" works in situations, when the salesman has to prepare large amount of SOs and simply hasn't time to explore all possible combinations, even check if exists any. Second, in most situations different employees set up pricing/discounting policy and do prepare the SOs.

Modris Ivans
MCP - Dynamics NAV Application

If you find yourself in a hole, the best thing to do is stop digging

  • | Post Points: 5
Page 1 of 1 (9 items) | RSS


Copyright Dynamics User Group, 1995-2009, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.