@pknight This should work now.[&select 'INV_6302_IFS'||'[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]'||'_'||'[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]'||'_'||to_char(to_date('[@CUSTOMER_ORDER_IVC_REP/INVOICE_DATE]', 'YYYY-MM-DD"T"HH24:MI:SS'), 'YYYYMMDD')||'.pdf' from dual] The date was coming in as a string like this: 2009-06-29T00:00:00So, we need to convert that to a date and then we can format it as YYYYMMDD.to_char(to_date('2009-06-29T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS'), 'YYYYMMDD')
@pknight You could format the file name using SQL. This would allow to you create any date format you need and convert it to a string.[&SELECT 'INV_6302_IFS'||'[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]'||'_'||'[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]'||'_'||to_char(trunc('[@CUSTOMER_ORDER_IVC_REP/INVOICE_DATE]'), 'YYYYDDMM')||'.pdf' FROM dual]
@msurasky-price There is no real difference between your approach and using the add_to_attr method, so this should not have an impact on your code. PROCEDURE Add_To_Attr ( name_ IN VARCHAR2, value_ IN VARCHAR2, attr_ IN OUT NOCOPY VARCHAR2 )ISBEGIN attr_ := attr_||name_||field_separator_||value_||record_separator_;END Add_To_Attr;I do it this way because I like cleaner code and I think it is easier to maintain this way. For one value it would not matter, but if you had twenty it could become harder to maintain/update. I want to make sure when I come back to it six or twelve months later it is easy for me to read, understand, and update. It matters even more if I have additional API calls to pull the value. This is a bad example because we would not need Payment Terms in Inventory Part Planning, but I think you will get what I am doing here: FOR rec_ IN get_data_ LOOP info_ := null; client_sys.clear_attr(attr_ => attr_); client_sys.add_to_attr(name_ =>
See if something like this works: DECLARE info_ VARCHAR2(32000); attr_ VARCHAR2(32000); CURSOR get_data_ IS SELECT ip.part_no, ip.objid, ip.objversion FROM prd_08 p INNER JOIN inventory_part_planning ip ON p.part_no = ip.part_no WHERE p.contract = 'ABCD' AND p.part_no IN ('[a_bunch_of_Part_Numbers]') ORDER BY ip.part_no;BEGIN client_sys.add_to_attr(name_ => 'SAFETY_LEAD_TIME', value_ => 5, attr_ => attr_); FOR rec_ IN get_data_ LOOP info_ := null; inventory_part_planning_api.modify__(info_ => info_, objid_ => rec_.objid, objversion_ => rec_.objversion, attr_ => attr_, action_ => 'DO'); COMMIT; END LOOP;END;
Try this and let me know if it doesn’t work for you: page/PostingProposals/List?$filter=MessageIdDb eq IfsApp.PostingProposalsHandling.PostingProposalMsgs'CostInvoice'
Thanks @MatthewConk it works! I just have two additional questions: Is it possible to get the Customer Name only? The [@CUSTOMER_ORDER_IVC_REP/CUST_NUMBER_NAME] gives me the customer number followed by the customer name but I do not need the customer number, I just need the name. Or are there any string function that would allow me to extract the name? How do you control which customer email address the report rule will use when the customer has more than one and the default one is not the one we should use to send the invoice to? Yes, you can control both of these values in the Set Expression Popup window. You can either create a Custom Field in the Header of the Customer Invoice and it will then show up in this list and you can select it. Or you can use PLSQL and pull from the Database: While on the Report Rule Screen, Press F1 and you should see the details about ½ way down about Expressions and what you can do.
@clilouise I have found that setting a Report Rule is one of the easiest ways to do this. The key is getting the Customer Email Address into the Report Rule. This can be done with fields already on the report, a custom field added to the report, or an SQL statement in the XPath window when configuring the Action Properties. You can test this functionality by type your email into the To email address and then printing an Invoice.
I thought of that, but the window I’m looking at is the Machine Load per Work Center and it won’t allow custom fields.🙁 Sorry about that. I don’t know of another way.
@TosohLBlum I don’t believe there is a direct way in the Search window, but you could create a custom field (Read Only) with the ISO Week Start and then group on that.Example using the Wanted Delivery Date from Customer Order Line: SELECT trunc(col.wanted_delivery_date, 'iw') AS iso_week_start, col.wanted_delivery_date AS actual_wanted_del_date FROM customer_order_line colMake sure you set the custom field so it can be searched on (which is usually defaulted).Then in your Advanced Query you can group on the ISO Week Start, like this: Let me know if this is what you were looking for?
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.
