Sales order - auto enable of procurement in logistic

[Former Member]

Hi Experts

is there any setups available to enable automatically procurement document in logistic tab in sales order ? Or how it should be make it as mandatory selection?

Asupathy 

[kothandaraman_nagarajan · Accepted solution]

Hi,

NO. There is no setup for automatic selection of procurement document. You have to select as when required.

What type of business process? Why you need such a requirement?

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Ok thanks

Customer wants to procure material while post sales order if stock is not there.  Our concern is if end user forget to mark procurement document tick? so how to stop this?

therefore it is clear gap and we need to address it through SDK right?

Asu

[kothandaraman_nagarajan · Accepted solution]

Hi,

You can try with transaction notification to block user if the procurement document check box not selected while creating sales order.

Try this:

IF @transaction_type in ('A') AND (@OBJECT_TYPE='17')

BEGIN

If exists (select T0.DocEntry from ORDR  t0 where T0.DocEntry =  @list_of_cols_val_tab_del and T0.[PoPrss] <> 'Y')

Begin

SET @error = 10
SET @error_message = 'Please select procurement check box'

End
End

Thanks & Regards,

Nagarajan

[KennedyT21 · Accepted solution]

Hi Asupathy Raja,

You can Block the sales order using the Transaction Notification if there is no stock for the items involved in the sales order..

          IF @transaction_type in ('A') AND (@OBJECT_TYPE='17')

            BEGIN

                 If exists (select T0.DocEntry from ORDR  t0

                 inner join RDR1 t1 on t1.DocEntry=t0.DocEntry

                 inner join OITM t2 on t2.ItemCode=t1.ItemCode

                 where T0.DocEntry =  @list_of_cols_val_tab_del and T0.[PoPrss] <> 'Y' and t2.OnHand<='0')

                 Begin

                      SET @error = 10

                      SET @error_message = 'Stock not aviable Please select procurement check box'

                 End

       End

Hope helpful

Regards

Kennedy

[KennedyT21]

If you have got answer close the thread with the Correct or helpful answer..

Rgds,

Kennedy