Exclude Sales order lines when back to back process is executed (Automatic Purchase Order creation)

Exclude Sales order lines when back to back process is executed (Automatic Purchase Order creation)

Posted by
  1. When users want to skip any sales order line for which the purchase order should be created when back to back process is run, then we can avoid it by using entry point based on criteria
  2. “TRTACHCDE1 “ is the standard process which will raise action “CTMFILTSOQ” when back to back process is executed
  3. “CTMFILTSOQ”, the purpose of this action is to give the possibility to exclude certain sales order lines to avoid generating the purchase order line.
  4. The following variable must be modified to influence the back-to-back order processing:

WCDTSTA

Flag to exclude the sales order line in progress

([F:SOQ]SOHNUM+[F:SOQ]SOPLIN+[F:SOQ]SOQSEQ)

0 = No exclusion

1 = The sales order line in process will not be converted to a purchase order line.

Example:

Here one field was added in SORDERQ table called YB2B, and data type Local menu”1” (Yes/No) and added same field in SOH4 screen in line level.

Created entry point and added one specific process “YCTMFILTSOQ” (it could be any code) as showing in following screen shot.

1

After adding entry point, then we have to write the piece of code in “YCTMFILTSOQ” specific process

2

The following two tabs change content below.
Abubakr Asif

Abubakr Asif

President at Panni
Abubakr has over ten years of experience implementing business solutions in the Calgary Energy marketplace. His experience spans implementing of ERP systems, workflow and systems integration and Business Intelligence solutions. He started his own company, Panni, in 2009, which help companies automate their business processes by leveraging the Microsoft based Toolset such as SharePoint and BizTalk. Since 2009, the company has grown at a rate of more than 100% every year. Abubakr has a undergraduate in engineering as well as an MBA from the University of Victoria. Previous to founding Panni, he was working for a big four consulting firm in Calgary.

Leave a Reply