Sales Order Validity

[Former Member]

Is there any ways in customising or alternatively, such that one can set the "validity" for the sales order?

The background is that there are instances that the user creates an order, this blocks his item qty, but later often forgets / does not bother to search the old order and creates a new sales order. We are periodicaly running some BDC arrangements to search for such open orders older than a period and deleting them.

Seeking advise on any system standard means to set a period for sales orders to be valid. This would preferably be doc type specific.

Any clues on this please?

Regards,

Tariq

[Lakshmipathi · Accepted solution]

Through standard this is not possible. May be you can try with sale order User-Exits in program MV45AFZB - USEREXIT_CHECK_VBAK where you can define a logic in such a way that system should check for field ERDAT (sale order created on) and also check for field AUART (Sale Order type) from there say the order is valid till 90 or 120 days and after which, that sale order should not be processed.

Take the help of ABAPer who can address this requirement.

thanks

G. Lakshmipathi

[Former Member]

Just got a response which could be the ultimate solution. Hence the need to makr this as "unanswered"

[Former Member]

Dear Tariq,

there is a expiry date feild in sales order you can set this according to your requirement.

In Customizing, you choose "month" as date type. In the document, you enter '0204' as expiration date. The system sets the expiration date to be '20040229' (February 29, 2004).

Regards,

Nisar Ahmed

[Former Member]

Dear Nisar,

Thanks for the response, thats the kind of control we are seeking. Please do enaborate which field in customising are you referring to.

Thanks and regards,

Tariq

[Former Member]

In (VA01) sales tab -

---

Exp. Date feild

[Former Member]

Dear Nisar,

The field you are referrig to is relevant for the expiry date of the 'payment card', if mentioned alongside, in the order and hence the system would prompt with a warning message if the expiry date is in the past.

Regret to say I didnt find that field relevant for the Sales orde as such but only a date capturing field for the payment card and a warning if the date is in the past from the sales order date.

Would you like to recheck your advise, in light of the above please.

Regards,

Tariq

[Former Member]

Hi Tariq,

IMHO all sales orders are valid until a person with sales responsibility considers that the customer should not be served for what he asked

In that case the Sales user should reject all remaining items of the sales order; he should not delete the sales order, because that would make you lose information about customer orders not served.

So a possible solution would be to prepare a report listing old orders with open quantity required (check VBBE / VBBS tables) and let the user double-clock on each order to manually reject all items if he decides not to serve the customer.

Best Regards,

Franck

[Former Member]

Thanks thats what we are currently doing too but was seeking if there is any other way out too.

Thanks to all who responded.

Kind Regards,

Tariq