Hi Everyone,Apologies if this question has been answered - not too sure of the search term to look for within the forum.We are looking to amend the automated functionality within IFS to print an additional document template in IFS9 from the customer order - driven by the status of the order. I believe this is controlled from the following check boxes on the document information tab. (please see screenshot below)We would like to print multiple copies of the customer invoice and we also have another output document template within the same invoice report definition.Order History shown below - invoice and delivery note are created automatically. Is it possible to add another document to the automated output? Please let me know if I need to provide any additional information.Many Thanks,Dan
We have quick report that takes excessively long to execute and return results. Any ideas on increasing performance?There’s only 5 rows in the result set (see below).select pm.Part_Main_Group as Trademark,l1p.contract,l1p.part_no,ip.description,l1f.ms_set as MS_Set,trunc(l1f.ms_date) as Forecast_Date,extract( MONTH from to_date(l1f.ms_date)) as Month,to_char(l1f.ms_date,'yyyymm') as YearMonth,l1f.forecast_lev0 as Forecast_Qty,NVL((select sum(rega1app.Customer_Order_API.Get_Ord_Gross_Amount(ORDER_NO))from rega1app.customer_info_cfv cicleft join rega1app.cust_ord_invo_stat col on l1p.contract = col.contract and l1p.part_no = col.part_no and cic.customer_id = col.customer_no and ( extract( YEAR from to_date(col.invoice_date)) = extract( YEAR from to_date(l1f.ms_date)) ) and ( extract( MONTH from to_date(col.invoice_date)) = extract( MONTH from to_date(l1f.ms_date)) ) where ( l1p.contract = 'W' and l1f.ms_set = cic.cf$_ms_set or l1p.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
