Dwight Schrute Blue Ribbon

Thank you @Michelle Jabanes-Oracle I appreciate your feedback

Thank you @Patrick Fresnosa-Oracle for looking into this, this has been helpful.

Thank you @Micah Timbol-Oracle - Yes that is correct and that was helpful, I further dived deep into this and understood that it is work as expected.

Thank you @Alex Joves -Oracle for this detailed answer, this has been very helpful.

Thank you @Angela Bayliss for the details explanation and snapshots, however this is not the report I was referring to. Thank you @Clarisa De Torres-Oracle - These were indeed the fields I've used, however, since most of the transaction are JE, this is why it did not show results. So I added both the transaction address…

@Angela Bayliss - It's applicable on the one hand, however the values turn up blank. Could you please share a screenshot from where you extract the values from Under the Transaction Dimension

@Harsha Kumara - THANK YOU very much, this worked!!! Appreciate this very much

Thank you @Clarisa De Torres-Oracle & @Tafara this has been helpful, I will apply this in NS-SBX first, I think it should work

Thank you @Jervin Nicholas Teopengco-Oracle - this has been very helpful

@MTL_MIA - For sure will do that, thank you for feedback this has been very helpful.

Thank you @MTL_MIA - But what about the Revenue Recognition generated from the SO? Wouldn't this cause financial issues that we have a negative rev rec which is not generated from credit memo? As for the Discount Item, thank you for sharing the article, I am looking into this as we speak.

Thank you @Jervin Nicholas Teopengco-Oracle - This has been very helpful!!!

Thank you @Patrick Fresnosa-Oracle for looking into this.

Thank you @Patrick Fresnosa-Oracle apricate this detailed explanation. However, I am still missing the piece where I can see the currency Revaluation that is related to all the trasnactions. This is solution, but I will need to use the Account number as workaround to get to the results. I was looking for a more straight…

Hi @Patrick Fresnosa-Oracle - First off, just wanted to let you know that I appreciate your prompt feedback and apologized for the delay on my end. Please see screenshot below, I do not have the filter available as you do, not sure why. As for the "issue" we've been trying to figure out, we most likely understood where it…

Hi @Patrick Fresnosa-Oracle - Could you please share a screenshot of the filter of the secondary book you've mentioned, I am unable to see this on me end. As for screenshots, I really do appreciate all of you dedicated assistance, however, they are irrelevant at the moment for we've already proceeded, I am trying to get an…

Hi @Patrick Fresnosa-Oracle - No we don't have scripts. I think there is gap in the communication, I was referring to the Currency Revaluation generated from closing the period, is this what you've tested as well? Thank you

Got it, thank you @Nicole Mendoza-Oracle

Thank you @Nicole Mendoza-Oracle this has been very helpful. Is there we can have the Filter field auto-populated based on the transaction the user is currently in? Meaning that the user will not need to manually populate the Document Number within the Filter Field, rather it will get auto-populated based on the…

Hi @Patrick Fresnosa-Oracle - At the time the Vendor Bill Status was either Open, once we noticed that the ER is unmediatable, I've advised the team to issue a Vendor Bill Credit (not CM credit memo which is related to customer invoice). I hope this help, thank you

Thank you @Niks Blando-Oracle for the check up, greatly appreciated

Thank you @Niks Blando-Oracle - In that case the only work around is custom saved search, and I will have it as a scheduled report emailed once a month to get a "snap shot". BTW, do you know if the report: 'Stock Ledger will capture Items in transit? Thank you

Thank you @Patrick Fresnosa-Oracle for looking into this. It's the WF, tested in NS-SBX started from scratch. Thank you for this and good catch.

Hi @Patrick Fresnosa-Oracle thank you for the great questions, please see my answers below: Yes I am using the admin role and able to reproduce the issue Yes we have WF & script but non of them are related to the exchange rate field It is NOT editable in either custom/standard form. Yes it is grayed out. Thank you

Thank you @Angelica Mae Segador-Oracle for the check up. What about a suite script, could that work? If so, could you please help me out with this one?

Thank you @Angelica Mae Segador-Oracle - This is a nice solution HOWEVER it is NOT applicable for Custom Line Items. If an Inventory adjusment has more then 1 line Item I would like the workflow to trigger ONYL if 1 or more line Est. Unit Cost = 0 Any other ideas? Thank you

Thank you @Angelica Mae Segador-Oracle - The request is very straight forward. I would like to create a WF for Inventory Adjustment transaction upon update/creation to return a user error when the field est. cost value = 0. Please see screenshot below. The goal we are trying to achieve is have more control over user usage…

Hi guys, could anybody please assist with this? Just an FYI, I have tried a custom Transaction Line field with the following formula: {quantity}-NVL({quantitypicked},0), HOWEVER this did not work, I think the reason is that we cannot flag the 'Store Value' checkbox, for if it is flagged, no results are showing and when…

Thank you @Angelica Mae Segador-Oracle !!!

@Tigran Shahnazaryan - Brilliant!!! It's working, thank you very much for this.