IFS 10 UPD15 - PL/SQL advice needed to start background job for Batch_Create_Coll_Invoices__

Hi,

I don’t fully understand why you would want to have two schedules?

The intended way to run this is just to run the standard “Batch Create Collective Customer Invoices” once per day. That job will then scan all delivered order lines (or similar) and check against customers collective invoicing setup. If a customer is set up with cycle interval 7, and there was 7 or more days since last invoice date, then a collective invoice will be created for that customer. If 7 days have not passed yet, that customer will be skipped. If another customer is set up with 30 days cycle interval that will be used. One run of the background job can handle any number of cycle days setups and setups using specified days of month.

For each customer matching above criteria a new background job will be created to create that specific collective invoice.

If you really want to have your own search for which customers should get collective invoice generated I suggest using the same standard ways that IFS uses internally. As I kind of mentioned Batch_Create_Coll_Invoices___ is just a job that finds candidate customers (and invoice variants), and then creates a new background job for each. If you don’t want to use that IFS standard method of scanning all customer you co replace that with your own search, and then generate the second background job call to INVOICE_CUSTOMER_ORDER_API.Create_Collective_Invoice__ yourself for exactly those customers you want to be invoiced.

Hi @anttik 

I agree with @jaw about dig more into standard IFS functionality to handle your requirement.

On the technical side, Invoice_Customer_Order_API.Batch_Create_Coll_Invoices__ uses IFS Message as input, and if you really want to make your own background execution of this job, here’s how to do it.

-- Created by DSJ
declare
msg_ VARCHAR2(32000) := Message_SYS.Construct('');

BEGIN
   Message_SYS.Add_Attribute(msg_, 'COMPANY', 'xx');
   Message_SYS.Add_Attribute(msg_, 'CONTRACT', 'xx');
   Message_SYS.Add_Attribute(msg_, 'CUSTOMER_NO', 'xx');
   Message_SYS.Add_Attribute(msg_, 'CURRENCY_CODE', 'xx');
   Message_SYS.Add_Attribute(msg_, 'PAY_TERM_ID', 'xx');
   Message_SYS.Add_Attribute(msg_, 'PLANNED_INVOICE_DATE_OFFSET','xx');
   Message_SYS.Add_Attribute(msg_, 'IVC_UNCONCT_CHG_SEPERATLY','xx');

   Transaction_SYS.Deferred_Call(
                                  'Invoice_Customer_Order_API.Batch_Create_Coll_Invoices__', 
                                  'MESSAGE', 
                                  msg_, 
                                  'Batch Create Invoices xx'
                                  ); 

END;

Hope it helps!

Damith