Batch create customer invoice database task for multiple customers

Hi, Unless you want to filter your customers based on their ID, you can use the wild card (%) as the customer identity and rely on other parameters such as Priority, Salesman etc to narrow down the selection.

Hope this helps

​@NAUBENF Have you found a solution for this? We have around 100 customers, 9 order types, and 40 companies. This would result in approximately 35,000 tasks being created, which I don't believe is a practical solution.

hi ​@untsrikanth 

 I do belive that the following options are worth to try.

Option 1: Grouping by Company & Order Type / Coordinator (No Code / Out-of-the-Box)

Instead of creating tasks per customer, create scheduled tasks per Company using additional parameter filters available in standard IFS:

• Use a Dedicated Order Type or Salesperson/Coordinator:
  • Assign the customer orders for these 110 customers to a dedicated Order Type (e.g., AUTO_INV) or specific Salesman / Coordinator Code.
• Task Setup:
  • Company: [Company ID]
  • Order Type / Order ID: AUTO_INV
  • Customer No: % (all customers under that Order Type)
• Result: You only need 1 creation task and 1 print task per Company (e.g., 10-15 tasks total instead of 220+).

Option 2: Custom PL/SQL Wrapper Task (Good Practice)

If the 110 customers cannot be distinguished by Order Type or Customer Group, the standard industry practice in IFS is to build a Custom Database Task.

1. Flag the Customers - Using a Custom Field or custom mapping table
2. Create a PL/SQL Wrapper Package -  invoke the standard API routines:
3. Register as a Scheduled Task:

regards,

Piyal