User_KAGURA Green Ribbon

Hi everyone! I figured this out and used ${.now?string("dd/MM/yyyy HH:mm:ss")}. Just sharing in case anyone else has the same concern. Thank you!

Hi @Lea Orzales オルザレス・レア -Oracle Is your solution only applicable as columns in the statement pdf? I also have a similar concern where I need to show Invoice fields (custom fields and Ship To) in the header of the customer statement advanced pdf.

Hi @Olivier Gagnon NC , I am trying basic pdf too for Bill of Materials. I ticked the columns in custom form but it did not show in the PDF.

Hi @Clarisa De Torres-Oracle thank you but we've actually already sorted this out. We added 'Applied To Link Type is Order Bill/Invoice' in the criteria, after which the summary amounts were correct and no longer doubled.

@Patrick Fresnosa-Oracle Thank you so much!

Hi @Elychelle Gulen-Oracle Thank you but I already sorted this out. I just need to add the criteria Sub Of and set it to -none-.

Hi @Wee Ming This might really needs scripting. Thank you!

Hi @Wee Ming we tried it before but we cannot find a subsidiary triggering client field.

Hi @Wee Ming Thank you for that! But can we have it not before record submit? Because sometimes the location is different, so users would just like it to default but can be changeable.

Thank you so much for your insights @Tigran Shahnazaryan and @Wee Ming . I actually have sorted this out by customizing the report like this: I added the column Customer/Project: Company Name and removed Customer/Project: Name (Grouped). I appreciate your answers. Again, thank you!

Hi @Patrick Fresnosa-Oracle thank you for the fast response. And yes this worked! Thank you again!

Hi @Patrick Fresnosa-Oracle , I have a similar concern but in a Transaction Search. We want to return the secondary accounting book (PLN) currency amounts in the saved search. Amount (foreign currency) does not work since if the currency is not PLN, it will return the transaction currency/amount. I tried looking the…

Hi, @Jervin Nicholas Teopengco-Oracle thank you for this but unfortunately it didn't work. I followed your instructions but the destination field still did not update even after an hour. It says here that the saved search and the base record of the workflow should be the same but the summary search used is Vendor…

Hi @Richard James Uri-Oracle! Thanks for this, we just changed the criteria from execution log: user to script: owner. Thanks again!

@CDuf Hi! Unfortunately, I cannot attend the session. Thanks for the invite tho!

@Pauline Joy Cac-Oracle Hi! Is there a way where we don't need to edit and save the record for the destination field to update its value?

@Jack Daryl Espiel-Oracle This is what we have done in our case. We need to populate the Last Vendor Prepayment Date in the Purchase Order. The summary search and workflow are working, however our concern is the need to Edit and Save the record for the field's value to update. Is there any way where the destination field…

Hi all! I have now found where the list is. Actually, the list that I am trying to find earlier is State, and just recently found out that this is a standard list in NS which is found in Setup > Company > State/Provinces/Counties.