fixed amount dicount should be distributed

[former_member363844]

Hi All,

i have defined three condition types for discount in our system with different calculation types: percentage, quantity and fixed amount. i have problem with "fixed amount" one. i create a contract for an item with qty=3. unit price is 1000$ and i apply "fixed amount" discount for the line, say 300$. when i create a sales order with reference to contract for qty=1, the discount will be 300$ on sales order which is wrong. it should be distributed and show 100$. how can i resolve this issue?

setup for "fixed amount" discount:

[jobis]

Hi Nava,

If you use group condition with a requirement routine, created with proper logic, you may be able to achieve this.  Also with a routine in your pricing too.

Else not sure, if this is possible. The fixed price cal type is used for the purpose that it should not change basis quantity or any other element in pricing.

By using a condition type with calc type 'quantity' won't the business requirement be met..?

Regards

Jobi

[former_member363844]

Hi Jobi,

   i guess there should be a solution. when we copy from sales order to invoice (e.g sales order qty=3 and invoice qty=1) this distribution happens.

thanks,

Nava

[Former Member]

Hi Nava,

could this be possible in your scenario?

1.) Set Calculation Type to 'C' for quantity based calculation in the condition type config

2.) In the order pricing procedure enter ZD03 as 300$ / 3 PC (total item quantity)

Cheers,

Tomas

[jobis]

Hi Nava,

is it happening in sales order to invoice?  If so check VTFA(copy control) and see what is the pricing type assigned in item level. Use that one for your contract to sales order (VTAA) copy control pricing type.

See if there is a possibility with it.

Jobi

[Former Member]

Although its easily available on this great forum if you search. This topic is covered by many consultants

SOLUTION:

Tick Group condition

No need to tick Item condition

Thanks and Regards

AA Roshan

[former_member363844]

Dear Roshan,

  thanks for your answer. as i know, condition group is used to qualify a group of item for discount (for example). e.g. if there is sales order with three lines of same material group, pricing scale applies to sum of qty in three lines....

my requirement is distributing the value related to fixed price discount in a contract line, while copying part of qty to another sales document.

Thanks,

Nava

[Former Member]

Can you plzz give example

Scenario#1

Material     Quantity     Discount (50%)

Mat1          1               10% discount    

Mat2          2               20% discount

Mat3          3              70% discount

                                ---------

                                  50

Scenario#2

Material     Quantity     Discount (50%)

Mat1          1               16.66% discount    

Mat2          2               16.66% discount

Mat3          3               16.66% discount

                                 -------------

                                   50

Now which scenario you want?

Thanks and Regards

AA ROSHAN

[former_member363844]

Dear Roshan,

none!

my scenario is:

contract:

material     quantity     price          discount (fixed price)

mat1          3               1000$          300$

sales order: (with reference to contract)

material     quantity     price          discount (fixed price)

mat1          1               1000$          100$

discount in sales order must be 100$, but in my system it is 300$.

please consider calculate type dor discount is defined as "fixed price"

Thanks,

Nava

[Former Member]

Hi Nava,

Please check the condition record that has been maintained. If possible, paste the screenshot for our reference too.

Regards

SD

[anita_patil3]

Hi;

I do not see this as a fixed discount. Clearly it  seems qty distribution based on qty so you need to define it qty base.

Hope help you.

Regards;

Avinash

[former_member363844]

Hi Samir,

  there is no condition record, neither access sequence.... discount would be added manually

[former_member182378]

Nava,

As Avinash and other members have suggested, the characteristic you desire is Quantity and not Fixed. Change the calculation type and test the entire cycle.

TW

[Former Member]

Hi Nava,

Apologies, I didn't notice that in your screenshot.

The only option I see is that you need to change it manually after entering the condition type (checkbox 'Amount/Percentage' is checked in V/o6 as per your screenshot).

I still believe that instead of Calculation type 'B', you should use Calculation Type as 'C'. When you use fixed amount, the discount is 'fixed'.

Regards

SD

Message was edited by: Samier Danish

[former_member211108]

Hi Nava,

I would say the system behavior is correct. You need to understand the meaning of calculation type B- Fixed amount.

When you use this the discount will not be linked to any parameter like quantity, weight volume etc. The said amount is for that line item.

If you are willing to link it quantity then your condition type should be with calculation type 'C' and 'Qty conversion, at control data 2 should be flagged.

Hope this will help you.

Thanks and Regards

Atulkumar Dagade

[anita_patil3]

Hi;

I insist once again to analyse the requirement once again and consider it as quantity based. It will solve your problem.

Hope will help.

Regards;

Avinash

[former_member363844]

Hi All,

thanks for your replies....

to explain the business requirement, please consider following example:

contract:

material     quantity     price   

mat1          3                  ZPR0=1001

                                        MWST(8%)=240

so:

net value=3003

tax= 240

total=3243

but for some business requirements, we need to change the total to 3200, so we have added ZD03 condition type below other condition types, so following will happen:

contract:

material     quantity     price   

mat1          3                  ZPR0=1001

                                        MWST(8%)=240

                                        ZD03=43

so:

net value=2960

tax= 240

total=3200

now the problem is:

when we copy sales contract to sales order for qty=1, following happens:

Sales order:

material     quantity     price   

mat1          1                  ZPR0=1001

                                        MWST(8%)=240

                                        ZD03=43

which is wrong. ZD03 should be divided to 3 and get 14.3 in sales order, not 43

[jobis]

Hi Nava,

So are you entering the value of ZD03 manually during the contract creation?

Have you looked at the possibilities of rounding off?

I think, as i suggested earlier, create and assign a routine "Alt Calc Type" for this condition type in your pricing procedure with proper logic to achieve this.

Dont think any std configuration will solve this.

Thanks

Jobi

[former_member363844]

Hi Jobi,

thanks for replying...

yes ZD03 is entered manually. as i know, round off is related to decimals, my currency has no decimals so i need to round the integer part.

Thanks

Nava

[jobis]

Ok.

Then A routine in ALT Cal Type will definitely work for you.  Check that.

Jobi