Price & Variant

navuser1

Hi all,

Is there any provision to set the Item Sales Price in combination with
multiple Values of variant codes?

I'm using Nav5.0 SP1

Deep

Use the sales prices functionality. It already has got pricing with reference to variants.

navuser1

Deep wrote:

Use the sales prices functionality. It already has got pricing with reference to variants.

Dear Deep.

I know it. But Suppose Item XXX has two or more Variant (Var1, Var2...VarN)

Var1 has some special specification(Values) Var1 Spec1, Var1 Spec2..
Var2 has some special specification(Values) Var12Spec1, Var12Spec2..

Sales Price will be specified with combination of Var1 and Var2....

Is it available in Nav5.0 Sp1 ???

Deep

You cannot have anything like Variant 1 with Spec 1 and Variant 1 with Spec 2.
You can setup the items as-

Item | Variant | Description
A | 1a | Variant 1 with spec- a
A | 1b | variant 1 with spec- b
A | 2a | variant 2 with spec- a
A | 2b | variant 2 with spec- v
....
....
.... and so on.

It may serve your purpose.

navuser1

Deep wrote:

You cannot have anything like Variant 1 with Spec 1 and Variant 1 with Spec 2.
You can setup the items as-

Item | Variant | Description
A | 1a | Variant 1 with spec- a
A | 1b | variant 1 with spec- b
A | 2a | variant 2 with spec- a
A | 2b | variant 2 with spec- v
....
....
.... and so on.

It may serve your purpose.

Dear Deep,

I know it.But it does not resolve my problem.
I think you can understand my problem.
I describe it again.

Suppose Item XXX has two variants

1. Type (Normal,Standard,ultimate )
2. Length (4/6 , 6/7, 8/10)

Scenario

Item | Variant/Variant specification | Price

XXX | Normal and 4/6 | 100
XXX | Normal and 6/7 | 200
XXX | Normal and 8/10 | 300
XXX | Standard and 4/6 | 150
. . .
. . .
. . .
. . .
. . .

Is it available in Navision ?

DenSter

No, not available, that would have to be done with new custom development. You should reconsider Deep's suggestion, that is what I would do as well. Pricing mods always sound easy when you start, but always turn out to be MUCH more work in the end.

navuser1

DenSter wrote:

No, not available, that would have to be done with new custom development. You should reconsider Deep's suggestion, that is what I would do as well. Pricing mods always sound easy when you start, but always turn out to be MUCH more work in the end.

Thanks Daniel,

This is our client requirement and we have already done this requirement in
their previous Software.

We always consider your suggestions and deep's suggestion for the new customization.

Thanks to both.

DenSter

navuser1 wrote:

We always consider your suggestions and deep's suggestion for the new customization.

If you are dead set on writing custom pricing logic (which I think is the wrong decision, creating new variants for each specification is much easier to do, and it is without any customization), then I would suggest you create it from scratch completely, and leave existing pricing logic in place. Put a flag in some setup and wherever you need to make a change to the pricing logic, add a condition to the pricing and call your custom logic instead when that is turned on.

Changing standard NAV pricing can be done of course, but in my experience it is always a lot more work than you think from the start.

Deep

DenSter wrote:

Changing standard NAV pricing can be done of course, but in my experience it is always a lot more work than you think from the start.

to add something to it-
With substantial work, it needs substantial amount of testing, and you never know at which logic permutation and combination it fails... I have seen this realtime over a project. The users kept on selling without price verification (totally assured about the sales price functionality) and lost a good money.

navuser1

Deep wrote:

DenSter wrote:

Changing standard NAV pricing can be done of course, but in my experience it is always a lot more work than you think from the start.

to add something to it-
With substantial work, it needs substantial amount of testing, and you never know at which logic permutation and combination it fails... I have seen this realtime over a project. The users kept on selling without price verification (totally assured about the sales price functionality) and lost a good money.

Dear deep,

This work had done by our VB team in their previous software.
And they used more than 10 numbers of Tables and thousand lines of coding.


Thanks !