Sales return scenario

[Former Member]

hai gurus,

We have a return scenario with reference to invoice document. The data from invoice flows to return order through copy control settings. But I have a difficulty here like one validation is missing.

For example.

In the invoice to customer the quantity was 1000 nos.

While making return order with respect to invoice system allows to process with 1001 nos.

So here the validation for the quantity is missing.Please suggest me whether we can put any validity for the same( user exits)

I feel it is a standard functionality.Please comment

[Former Member · Accepted solution]

HI,

Go To,

Sales and Distribution > Sales > Sales Documents > Define Variable Messages

select V4 : 229 message and go to right most column.

set the indicator to E.

With this setting system will not allow the user to enter Ret qty > Billed Qty.

Regards,

Rajesh

[Former Member]

Hi,

Its a SAP standard behavior wherein it will allow to enter more quantity than that was in original reference outgoing invoice. But your requirement is that system should not allow this to happen.

You need to do following:

Goto SE38 & enter the include "MV45AFZZ".

In this go to user exit "USEREXIT_SAVE_DOCUMENT"

In this user exit, you need to write an ABAP code which compares the entered qty in sales order with that of the parent invoice quantity.

When you try to save such an order system will give an error & order saving will not be possible.

And let me tell you this is very simple & easy to achieve.

Hope this helps you.

Regards,

Dhananjay

[Former Member]

Hi there,

In Copy control from invoice to sales order, VTAF, check 'Comeplete Reference' field.

If you check that, system will copy the entire quantiry into the returns. If the user tries to change the quantity, system will throw a message.

Regards,

Sivanand.

[Former Member]

Hi,

This is normal system behavior wherein you can enter more quantity than that in the outgoing invoice.

Additionaly this canot be prevented by any kind of config & strictly you will have to write an user exit only.

For this goto SE38 & enter program "MV45AFZZ"

In this find user exit "USEREXIT_SAVE_DOCUMENT", here you enter you rlogic of comparing the invoice quantity with the quantity entered in returns order with help of ABAPer.

Finally you will get results when you try to save such returns order, & system will not allow you to save returns order where quantity is more than parent outgoing invoice quantity.

Hope this helps you.

Regards,

Dhananjay

[Former Member]

Hello Saju,

This can be done through appropriate settings in copying control. For ex. say its F2 to RE.

The probable settings at item level in VTFA, are:

copying requirements: 303.

DataT: 153.

DataT: 104

DataT: 004.

If in case, the above is not meeting your reqmnt then you'll have to create an appropriate copying requirement( 9xx) via t-code VOFM>copying requirements>Orders.

Rgds,

Raghu.

[Lakshmipathi]

Dear Saju

Yes you can manipulate the quantity in return sale order but system will not allow you to do PGR in excess of quantity originally despatched.

[Former Member]

Hai lakshmi pathi,

System is allow you to do PGR also even if return order quantity is manipulated.So no such restirction is there.

regards

[Lakshmipathi]

Dear Saju

Then in that case, the problem lies with your copy control. Go to VTLA, select your return order type and delivery type and select the item category. There check whether you have maintained the following:-

Order requirements::::::::::::::101

Item data:::::::::::::::::::::::::::::101

thanks

G. Lakshmipathi

[Former Member]

Hai Lakshmipathi,

The following requirements has been maintained.

in Order requirements 101 is maintained

in Item data 101 is maintained.

Still the problem persists.

I feel in standard Sap there is no such functinality to restrict the same.

Regards