lowest price

[Former Member]

Dear All,

We have a requirment, that while invoicing system should pick up the lowest price between sales order and billing price.

Example 1 :-

while creating sales order - PR00 is 100 EUR on 10/09/2009 date

and while creating billing - PR00 is say 110 EUR on 11/10/2009, system should pick up 100 EUR.

Example 2 :-

While creating sales order PR00 is 110 EUR on 10/09/2009

While creating billing - PR00 is 100 EUR on 11/10/2009, system should pick up 100 EUR, this can done by copy controls to re determine the values. but it should consider both senerio's/

Please give your valuable suggestion.

Regards

Ramki

[Former Member]

Thanks

[Former Member]

hi ram

In VOFM routine for calculation type,

select sales order for your invoice from VBFA table, and fetch corresponding PR00 from VBAP/KONV tables.

Now compare these value

if KONV-PR00 < xkomv-kbetr

xkomv-kbetr = konv-pr00.

end if.

take ABAPers help.

try and revert.

Edited by: Yadav on Oct 21, 2009 12:35 PM

[Former Member]

I have a possible solution, but i have not verified it.

Create a price procedure with a new condition type PRZ1. The condition type is like PR00.

Create a calculation formula for this condition, in the formula you get the price from sales order.

Then you can maintain a exclusion group to determine the lowest price.

Flex Yang

Edited by: flex yang on Oct 21, 2009 9:39 AM

Edited by: flex yang on Oct 21, 2009 9:39 AM

[Former Member]

Hi Ram

This can be done by routines. Take help of your ABAPer and write routine to calculate lowest price.

[Former Member]

Dear Yadav,

Coudl you please give me the logic for the same, Thanks

[Former Member]

Dear Ramki,

Try with condition exclusion.

Regards,

Nithin.

[Former Member]

Dear Nithin,

Thanks but here same condition PR00 at sales order level and billing level.

Regards

Ramakrishna.P