price condition for delay in picking goods

[former_member213871]

Hi all,
I would like to ask you for help in this scenario.

We would like to surcharge customers which do not pick up their goods intime. It should work like this. I have a date of goods confirmation in sales order item. And there is second date - date of issue in delivery. Difference between this is the delay. So in So in invoice for item should be something like this. New price condition should be used as surcharge with scales:

customer A
delay 0 - 30 no surcharge
delay 31 - 60 surcharge 1 USD / PC
delay 61 - 999 surcharge 10 USD / PC

customer B
delay 0 - 15 no surcharge
delay 16 - 25 surcharge 1 USD / PC
delay 26 - 999 surcharge 5 USD / PC

So I prepared new condition to pricing procedure and to access sequence added new field "Delay". This field is calculated correctly in invoice item, but I do not know how to use it properly.

If I have access sequence:
Sales organization / Customer / Delay, the value for delay is used as criteria and there cannot be scales.
e.g. I set scales
0 - 30
31 - 60 and if delay was 45, condition wasn't found, because I didn't hit the proper value

I know that I would like to use scales (for delay days) based on customers. But I do not know how to set it up. How should be set up price condition in this scenario?

Please, advise.

Thank you,
David

[VeselinaPeykova]

I am not sure, that I understood how exactly your condition is set up at the moment and how the new custom field works - a few screenshots of V/06, VK13 and the condition determination in the document (with z-field values displayed), could be useful.

[VeselinaPeykova]

Sorry about the delayed response, David. We get no notifications when you post your clarifications as an answer.
It is possible that convert your answer to comment, which would make it easier for other forum members to read the complete information (if somebody else comes to help out).
I have not worked on a similar requirement myself, but I think, that you need a custom formula for scale base value (RV62A*), which would read zzdelay and calculate the correct base for the scale. The routine, which you are currently using, does not look suitable to me.

[former_member213871]

Hi,

I put there this formula to test what happen. I tried to debug it and force some values, but without success. There is an other solution - use Z table for conditions and own formula to calculate it own way.

Thank you,

David

[former_member213871]

Hi,

I just set up new price condition and try different settings to make it working. So for now, there is no useful settings, I would like someone to help me with.

There is new field in strukcture komp named zzdelay. This field is calculated in RV60AFZZ - form USEREXIT_PRICING_PREPARE_TKOMP.

So I have this field available in VK11.

How it is customized right now:

And in VK12:

This is how I would like to use it. But I do have a problem to tell the system, that the field zzdelay should be used for scales.

So the result should be like this example. There will be quantity 20 PC

If there will be delay 20 days - nothing happen, no surcharge.

If there will be delay 35, so surcharge should be calculated: 10 USD * 20 PC = 200 USD.

Something like that.

Thank you,

David