Skip to Content
author's profile photo Former Member
Former Member

Scales

good morning to all 😊

I'm trying to find a way of entering a scale with "From" and "To" quantities.

My goal is the following: A discount should be applied whenever multiple quantities of 1000 is ordered.

for a quantity inferior to 1000 no discount should be made

For 1000bags a discount of 10€ per bag should be made

For 2000bags a discount of 10€ should be made

The problem is that the requirement is if, for example, the order quantity is 1500 the disccount applied should be done ONLY for 1000 pieces. If the quantity is greater than 1000 and less than 2000 then the discount of 10€ per bag should be applied only to the 1000 bags and not for the remaining 500.

Does any one knows if this can be done?

I tried the scale type "D - graduated -to interval scale, but this is not working the way we want.

Many thanks!

Fátima Pereira

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 10:53 AM

    Hello,

    I think this is possible by writing a routine mentioning you requirement in that (Multiple of 1000 qty of bags), in VOFM.

    And assign this routine in the filed "Scale Formula" in the defination of the discount condition type next to "Scale basis". (V/06).

    Hope this helps.

    Regards,

    Sudarshan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sudarshan!

      Which Scale type do you recomment to use? "B"?

      I was planing to insert the following condition records:

      to 999 KG 0,00 EUR 1KG

      1,000 10.00

      2,000 10.00

      In the routine I should compare the sales order line quantity with the first condition record. If it is greater than 999 and equal 1000 and less than 2000 apply the 10 EUR discount only to 1000 Kg.

      If it isgreater than 2000 and less than 3000 then the 10,00 EUR discount should be applied only for 2000.

      Do you think this is feasible to do in the routine?

      Many thanks!

      Fátima

  • Posted on Aug 23, 2011 at 06:48 AM

    Hello,

    have you been able to work it out? I have the same requirement, but it doesn't seem to work using scales.

    Best regards,

    Andrea

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2011 at 07:39 AM

    HI,

    Can you please give me more clarity because i think it is possible through Material Rebate

    Revert

    Regards,

    Prasanna

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2011 at 10:17 AM

    Hi,

    In free goods condition record(VBN1) at line item level maintain the calculatiomn rule as "2"(unit reference) which may meet your requirement,because this routine will check for the specific unit i.e for 1000 bags-20 bags free,if you enter 1600 it will consider only 1000 and offer the discount only 20%.

    Thanks

    siva.k

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.