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

Discount values ​​/ Product Types and Forms

Hi all,

below I will briefly explain my concern, I am looking for a solution to this:

given

Articles> discount true, according to payment terms (PT) (14 days 2%, 30 days net) deposited at BP

Work> discount false, net immediately.

Travel> dscount false, net immediately.

Below I am referring for simplicity reasons only to sales reports (quotation / order / invoice).

Case 1: Article

Here, the PT according to GP be printed, but also the value in EUR may be deducted as discount on form.

Case 2: Work

Here, the PT according to BP be printed, but also to note: Services are not skontierbar (mutatis mutandis)

Case 3: Business + Item

Here, the PT according to GP be printed, but also the value in EUR, the discount may be deducted as

and Note: Services are not skontierbar (mutatis mutandis)

How do I get the discount clalulation including consideration of posibility of descount as SUM in the forms?

Am a little surprised that something like this is not in implanted into B1

Thanks for helping

greetings

MD

Link to german version: Skontowerte / Artikelarten und Formulare

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2011 at 02:48 PM

    Hi,

    The discount in payment term may not be logical in your case. Suppose all 3 conditions occurred in the same document, which rule would be true?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2011 at 09:35 PM

    It is not easy to give your solution because the request is not fully understandable. Hope a better translation version is available. Or you may explain by some examples.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Well Gordon,

      There are all 3 possible cases shown in my 1st. post of this threat.

      I need a function to get the SUM of all included item positions, excluded work and travel in the sales forms.

      The amount of discount in % is given by the payment terms of the specific BP.

      example1 (work+item):

      Pos 1 valve EUR 10,00

      Pos 2 valve EUR 10,00

      Pos 3 technican EUR 520,00

      10 days -2% (payable EUR 539,60), 30 days net. (EUR payable 540,00)*

      *work/travel is not discountable

      example2 (item):

      Pos 1 valve EUR 10,00

      Pos 2 valve EUR 10,00

      Pos 3 cabinet EUR 1000,00

      10 days -2% (payable EUR 999,60), 30 days net. (payable EUR 1020,00)

      example3 (work/travel):

      Pos 1 technican EUR 525,00

      Pos 2 technican EUR 1000,00

      Pos 3 technican EUR 1000,00

      10 days -2% (payable EUR 2525,00), 30 days net. (payable EUR 2525,00)*

      *work/travel is not discountable

      Edited by: Marc Dreffke on Dec 19, 2011 11:02 PM

      Edited by: Marc Dreffke on Dec 19, 2011 11:04 PM

      Edited by: Marc Dreffke on Dec 19, 2011 11:07 PM

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2011 at 04:15 PM

    I am afraid there is no easy solution for this goal. Payment term may only apply to document level, not item level. What you can do is separate them manually to different documents to apply proper discounts. Hope that is workable in your case.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gordon!

      Thanks for your suggestion above but this is not working.

      The missing option to exclude work and travel on item level from discounting is a shame in my opinion.

      Keeping software open to many directions of company needs is one thing but not implenting such basics to a programm

      keeps me speechless.

      With core suite installed there should be a way to get this done.

      count the amount of every line in the sales document that's "item" has the "true" true to "discountable" in item remarks.

      after that substract the before calulated amount from the total amount.

      I think such requierements like discount on item bases or working incoterms (and I can continue with a lot of such stuff)

      emerge on many companys, at least every producing or trading company, located in the EU.

      The solutions to this requirements are done in the back by the resellers and the other B1 buyers have to pay again and again.

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.