topic Re: Sales order Validations before save in Application Development and Automation Discussions

Sales order Validations before save

Former Member — Tue, 06 Aug 2013 04:58:45 GMT

Hi ,

I need to check the customer of the sales order and for the particular customer,only certain materials are allowed.If other materials are entered,then I need to give an error message.I have written the code in USEREXIT_SAVE_DOCUMENT_PREPARE and it is working fine.But now i need to do the same validation after entering the items and before clicking save.Is there a way to do the validations before clicking save (any user exit that will be triggered at item level).

Thanks and Regards,

Rohini

Re: Sales order Validations before save

Sougata — Tue, 06 Aug 2013 07:35:25 GMT

What will you be clicking on instead of the save button? I don't understand what difference does it make when the check is already working correctly on save?

Re: Sales order Validations before save

Former Member — Tue, 06 Aug 2013 08:07:09 GMT

Hi,

use the same userexit form.

You have access to vbap, eg:

loop at xvbap.

.....

endloop.

USEREXIT_MOVE_FIELD_TO_VBAP .

Re: Sales order Validations before save

Former Member — Tue, 06 Aug 2013 08:52:20 GMT

HI,

If the user clicks "Enter" after typing the material number,then my logic should be executed.This is required otherwise the user will enter everything(for example after entering 10 materials) and then find that the order cannot be saved.

Thanks,

Rohini

Re: Sales order Validations before save

madhu_vadlamani — Tue, 06 Aug 2013 10:18:10 GMT

Hi Rohini,

You can try in MV45AFZZ,USEREXIT_SAVE_DOCUMENT.

In the loop of xvbap read with key posex. Append those lines to final. Display messages depending on your criteria.

Regards,

Madhu.

Re: Sales order Validations before save

former_member585060 — Tue, 06 Aug 2013 16:15:34 GMT

Hi,

Try the User Exit 'USEREXIT_CHECK_VBAP' in the Include MV45AFZB. You will have Item detail in VBAP and all items in XVBAP[].

Thanks & Regards

Bala Krishna

Re: Sales order Validations before save

Former Member — Wed, 07 Aug 2013 03:35:28 GMT

Hi Rohini,

I dont think you need to use any User Exits for Blocking the Materials based on the Customer.

All you can do is to use the Material Inclusion/Exclusion rule based on the Customer in VB01/VB02/VB03 transaction for Create/Change and Display.

Steps

1) Enter the List/Excl Type as Listing in VB01 and Enter

2) Enter the Customer Code and the validity period and enter all the list of materials that the customer is allowed and save the entries

3) On creation of the SO, only these materials will be allowed for the Customer.

Note : System checks for the Exclusion List first and then checks for the Listing (Inclusion List)

Rewards points if helpful.

Regards,

AyyamPerumal