Discount values ​​/ Product Types and Forms

[Former Member]

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:

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Gordon,

Thank you for answering my request.

Case3 is the one consisting of work and item.

What i need is a function to show the amount

of possible (only item) in the sales form.

Work and travel are not discountable.

Regards

Marc

[Former Member · Accepted solution]

Have you tried FMS?

[Former Member · Accepted solution]

Hm not yet. I'm end user. So how would such a fms query look like?

[Former Member · Accepted solution]

There are quite a few FMS queries available here on the forum. You may check: http://forums.sdn.sap.com/search.jspa?threadID=&q=%22FMS+Query%22&objID=c44&dateRange=all&numResults...

[Former Member · Accepted solution]

Thanks Gordon for your help.

I'm sure I can't do this on my own ö

[Former Member]

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.

[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.

[Former Member]

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.

[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