It works! Thank you so much for your assistance. Greatly appreciated!

We've almost got it. The report is now working however, I would really like to add the created date and the created by fields to the results. I've added them to the results tab however, they don't appear on the final search.

Here is the full screenshot.

Thank you for the update. I'm having trouble saving the formula. It will not save. Do I need to enter options for the function and field?

Hi @dominica. Thank you for your follow-up. Here is a view of the results tab. I attempted to add Maximum to the Summary Type however I get an error as you can see by the second screenshot below.

Thank you for your comments! This is very helpful. I'll surely log in to the SuiteIdeas and vote in the affirmative for the customization to be implemented. In the meantime, I've followed your instructions and have come up with an alternative solution.

Hi and thank you for your comments. I've added the date created column as you instructed. It looks like I'm still getting the same issue. The most recent transaction looks to have the rate at $88.12 however, the mass update isn't recognizing it. Here are the steps I've followed to create the mass update. Maybe this will…

Update: I have resolved the issue of the MPN showing in 2 columns. Thank you again for your assistance Jack!

Thanks Jack. I've added to the source code per your instructions and it is working however, I now have 2 columns showing the MPN. Can you guide me through deleting the unnecessary MPN# column? Here is a screenshot of my source code.

Continuing with this form, I have run into another issue. The MPN # is not showing up on the PDF form of the PO. The MPN fields on the new element function are grayed out and I am unable to select them. I'm not sure why this is the case. What am I missing? You can see here that an MPN# is associated with this item. This is…

Thank you Jack. I'll remember to remove our account info in the future. I followed your instructions and the image is now showing. Thanks!

Gaurav, Thank you for your quick response. I followed your instructions, and it fixed my issues. You're awesome!

Thank you for your quick reply. Yes, by applying those 2 fields you suggested, I was able to extract the information my team needed. Thank you Ivy Lopez-Oracle, you're awesome!

Here is a screen shot of the original PO for the 3 non-inventory items I've referenced.

I forgot to post the last screenshot. Here it is

Thank you for your assistance. We look forward to this enhancement in the future.

Hi Ivy. With some additional work, I was able to perform the operation as you outlined and it is working for our needs. Thank you so much for your assistance!

Thank you so much for your reply. Could you walk me through the process of creating the formulas? I have everything else created and it seems to be working.

Hi Jack and thank you for your comments. I have not yet had a chance to test the procedure. I will test soon and will reply back. Thanks.

My apologies for not replying earlier. I was out of town for a holiday weekend. This is the field ID info. It does appear that we have renamed the field from department to division.

Hello. I believe this field is not a custom field.

Thank you for your assistance. It will be convenient once the mass update feature has been implemented. In the meantime, I utilized Shamaine's instructions and it worked for my needs.