Hi Tristan Joy Mendoza-Oracle. It looks like that the inventory valuation report will not pick up any items that do not have stock. We need of a list of every item in the system in a report version. Do you know of another report that will pull that?

@Patrick Fresnosa-Oracle Sorry, I was on vacation for the holiday. I tried removing data based on what you sent. I do see some values now. I will try adding criteria back slowly to see what is causing it to fail. Is the number the formula returning the seconds? I need to show the time between the two approvals. Sorry to be…

Tristan Joy Mendoza-Oracle Thank you! That worked perfectly!😀

@Tris Mendoza-Oracle Thanks you for the response. Yes we have a saved search but I need to build a report so that we can web query it. I wish you could do that in a saved search. Life would be much easier. lol

@Tris Mendoza-Oracle My team is looking to pull the following infomation: Internal ID Name Description Product Category And a few other custom fields we have on the item record

@Patrick Fresnosa-Oracle I dropped that formula in and it does return a date But the other formula is still not showing any data on the results

HI Patrick Fresnosa-Oracle Unfortunately nothing worked. I removed as many fields as I could and it is still acting the same. I can't even see the formula field unless I group everything and then it is still blank. :(

Hi @Patrick Fresnosa-Oracle I tried adding the formula and the column does not even show up on the report. I also tried to group the columns and sun and max that formula column and then it does show but is blank. It is so weird Max Sum No grouping

@MTL_MIA Thank you so much. Worked perfectly!

Hi @Patrick Fresnosa-Oracle . Yes this is a custom field. Here is the criteria I have set. I then tried the formula you suggested. I really just need the time in system notes from when the custom field went from Tax Rate Needs Reviewed to Verified/Order Approved. The date the SO was created could have been a few days ago.…

Grace Catabian-Oracle, we were able to get the formula corrected. This is the one that worked. (custbody28 is the Amazon Date Time Stamp that is brought over into the custom field)

@Nicole Mendoza-Oracle Your formula has an unrecognized field in it. Please go back and correct the formula and resubmit.

@Tris Mendoza-Oracle these were deposit records

@Clarisa De Torres-Oracle Thank you for the information

@Able Wilson I did edit an item record and changed the Product Catagory, saved and it still did not populate. @Angela Bayliss I did check the scripts and see nothing running against these that should be affecting it.

Purchase Order

@Grace Catabian-Oracle Thank you for the information!

@Able Wilson So this is what I did. I first created a Other Record Field and chose Product Category as the record type. Dropped that into the Product Category form and populated the proper Parent Subsidiary. This is how the custom field looks on the Prod Cat Record I then created a Custom Item Field and source list from…

@Angelica Mae Segador-Oracle Yes I saw that. I am able to see it on reports but it is not populating on the item record from the custom field I sourced from the Product Category record.

@Able Wilson Product Category is not an option. Class is the only option

@Ely Gulen-Oracle thank you

@Able Wilson After I submitted I realized I needed to source it to the item record. I created another field and sourced it but it now shows in search criteria but is not populating on the item record. Item Sourcing from Class Custom Field on Item Record

@Ely Gulen-Oracle. Thank you. We were able to build it using Quantity to Order, but it is Subsidiary specific so you have to restrict view. Was hoping we could get it in one report but if this is the only option we will make it work. The Qty on Sales Order had to be a formula Committed + Backorder.

@Niks Blando-Oracle Yes I understand that RF Smart is not supported here. I am just wondering if a workflow can be written to automatically add a discount under certain items on a sales order

@Micah Timbol-Oracle I opened a case and this was the result. Thanks for picking up the call and for joining me on zoom. You showed me the errors received on the Bulk Processing page that says: “The Imported Employee Expense is missing information about the following field: Currency ; Transaction Detail: Transaction ID:…

@Micah Timbol-Oracle We are not manually importing these. It is auto fed from AMEX. I tried adding the currency that was missing but it is still giving errors

@Edwards_05 Thank you for the assistance! I was able to tweek it a bit and this worked

@Patrick Fresnosa-Oracle Yes that was it. I did check before but was only looking at 2023. Thanks You!

Thank you!!! @Jervin Nicholas Teopengco-Oracle yes that worked with an additional couple of updates. I changed customer.terms to just terms since this is on a transaction form I also had to set Main Tab and Insert before. It was putting it in a lower section. Final formula. CASE WHEN {Terms} = 'Prepaid - Credit Card'…

@Vasya_2 No unfortunately it was not figured out