Customer and PO number combination check in sales order

[alvin_aquino]

Dear SD Gurus,

Apart from the config within VOV8, is there a further check that can be done during sales order creation that can trigger an error message (not just warning) if a particular customer and PO number combination is entered?

Thanks in advance,

Alvin

[Former Member · Accepted solution]

Hi,

In VOV8 you can only Check whether the purchase order number already exists or not.

If you want to do any other check like you said based on customer & PO number combination then follow steps below:

Ask your ABAPER to

1: Create a Z-table where you can store the required Customer No & PO No combinations.

2: Write a code to check the PO no & Customer No entered in Sales order with the entries in the Z-table & throw an error if there is no match.

This code needs to be written in the User exit Save_document_prepare by your ABAPER.

3: This will work at time of Save & not a point of entry. The result will be same "error msg will be thrown"

regards

Edited by: Innovation is key on Feb 28, 2011 6:08 PM

[madhu_vadlamani]

Hi Alvin,

The third thread will solve your problem. Please ask if you need more hep on this. If it is done please close the thread.

Regards,

Madhu.

Edited by: madhurao123 on Mar 1, 2011 6:35 AM

[Shiva_Ram]

You need to use USEREXIT_SAVE_DOCUMENT_PREPARE in program MV45AFZZ to fulfill the requirement.

Regards,

[alvin_aquino]

Thanks for the prompt reply!

Will this provide an error message during order entry or after saving? We need the message to appear upon entering the customer and PO number during order entry not during save.