How to Customize standard report - 'Print Receivables Transactions Report '

 

1. Print Receivables Transactions Data Model Customization to Add New Fields and Amount in Words Field And Address Lexical References
2. How to Change Default Template of 'Print Receivables Transactions' Process

Print Receivables Transactions Data Model Customization to Add New Fields and  Amount in Words Field And Address Lexical References  1. In the DB there is a function IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words that gets the amount in words. -- Parameters:  -- p_amount: the amount to be converted to text  -- p_currency_code: the currency of the amount  -- p_precision: required for some cases such as JEES_NTW  -- p_country_code: used for cases where a global country specific conversion  FUNCTION IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words(p_amount IN NUMBER,   p_currency_code IN VARCHAR2 := NULL,   p_precision IN NUMBER := NULL,   p_country_code IN VARCHAR2 := NULL)  If this doesn't work, please follow reference-> https://docs.oracle.com/cd/E28271_01/bi.1111/e22254/extend_func.htm#CIHDFGGB Chapter B.1.1 Number-To-Word Conversion and use the available extended functions in RTF template. E.g. <br?> 2. Regarding the Header and Line Data Set modification: To modify G_Header Data set from Invoice Print Data model, for the lexical references you can provide following the values so that you can save the modification:  &P_DYNAMIC_FROM_CLAUSE: , dual  &P_DYNAMIC_WHERE_CLAUSE: 1=1 and  &P_DYNAMIC_WHERE_CLAUSE1: 1=1 and  &P_DYNAMIC_ORDER_BY_CLAUSE: order by 1  For G_Line Data Set:  &WHERE_LINE_TYPE: and 1=1 How to Change Default Template of 'Print Receivables Transactions' Process We have 2 options to customize. Option 1: To use BI Publisher. 1. Login to BI Publisher.   URL of would be http://<host_name>:/xmlpserver.   where host_name and port values can be taken from url of Reports and Analytics page. 2. Click Catalog. 3. Select Shared Folders -> Financials -> Receivables -> Bill Presentment -> Invoice Print Template 4. Click More -> Customize   When Customize is clicked, a custom copy is created in Shared Folders -> Custom -> Financials -> Receivables -> Bill Presentment folder. 5. Select report in custom -> Financials -> Receivables -> Bill Presentment folder 6. Click Edit. 7. Click "View a list" link to list layouts. 8. Rename seeded layout from "Default Invoice Template" to "Default Invoice Template1". 9. Rename or upload your custom layout with "Default Invoice Template" name. 10. Save your changes. 11. Close. Option 2: If you dont find Customize option, you can also use BI Reports and Analytics 1. Navigator -> Reports and Analytics 2. Click Catalog. 3. Select Shared Folders -> Financials -> Receivables -> Bill Presentment -> Invoice Print Template 4. Click More -> Copy 5. Then, create a folder structure if doesnt exist, Shared Folders -> custom -> Financials -> Receivables -> Bill Presentment 6. Go to Shared Folders -> custom -> Financials -> Receivables -> Bill Presentment folder and paste the report. 7. Click Edit. 8. Click "View a list" link to list layouts. 9. Rename seeded layout from "Default Invoice Template" to "Default Invoice Template1". 10. Rename or upload your custom layout with "Default Invoice Template" name. 11. Save your changes. 12. Close. To Bottom