Hello @Red Atok-Oracle This question is somewhat related for Transaction Type = Journal Search. Is there a way to identify the type for {name}, as we have Journals for Customer, vendor and employee records and the name corresponds to the respective record id. Would like to know in saved search if we can extract the name…

Formula (Text)

I tried the above syntax and it gives errors 'Invalid expression'

There are other complexities using is NULL function as one of the type we are checking for 2 categories: category1 category2 and when used the formula category1 <> MISC or null, category2 <> INTERNAL or null, satisfies both conditions for the same {type} and the results are incorrect. In this case it Netsuite allows nested…

Hello @FazeprooF Thanks for the note. Yes tried that approach, however <> 'AAA' type condition does not capture for null values, that's why = 'AAA else works in theory so that else also incorporates null value.

Hello I have a similar requirement and would like to know if it's possible or a limitation. I have transaction saved search and the formula I like is CASE WHEN ({type} = 'A' or {type} = 'B' and {category} = 'XXX') THEN 'XXX' ELSE 'yyy' END CASE WHEN ({type} = 'C' or {type} = 'D' and {category} = 'AAA') THEN 'AAA' ELSE…

Hello, I have similar requirement and the above suite answers link does not work. Thanks

Hello @Shiela Marie Villaluz-Oracle Option A is not suitable as it will only remove from the report but the balance will still stay. For Option B, if the payment was already received against this invoice as part of bulk JE, how would this work? Thank you

Hello @Clarisa De Torres-Oracle Thank your for quick response. It seems we also had a criteria account type = 'Bank' and that's the reason applied to transactions fields did not work. Will fine tune the criteria further now that I know the field is available. Appreciate your help.

Hello @Micah Timbol-Oracle Thank you for the suggestion. This approach worked, although curious to know what was the challenge with original option as that is normally how users add the pages to their shortcut.

Basically I type in 'Match Bank Data' on global search which takes to appropriate page and then I click on 'Star' to add this page to Shortcuts menu, enter the description I wish to see on the menu and Save. No error comes up, however from Home dashboard when I click on Star to review shortcuts, this page is not there.

@Jervin Nicholas Teopengco-Oracle I tested this solution and it works as expected. Appreciate your help. Thank you

@Jervin Nicholas Teopengco-Oracle Thank you for the detailed steps. Please allow me 3-4 days to test this out and I will update the post

Hello @Jervin Nicholas Teopengco-Oracle Thank you for the response. We tried this approach before and it works. The challenge we have is, the same custom form is used by all roles. There are some roles in Procurement, Finance and Supply chain users who would need this Email option available to email the PO to Vendor if…

Hello @Veronica Steluta Mincior-Oracle Thank you for the response. We already have Track messages set to 'View' for these roles and as you mentioned the user can still manually click Actions → Email to trigger the email. I would like to understand customization option (although not preferred) to restrict this access.

@Tris Mendoza-Oracle Thank you for the feedback. As I am checking in with our Account Manager as well, wanted to get some thoughts from this forum too, Our original requirement is to consume part from different bins (from same location) in parallel at the same time from multiple production stations. As we build product…

Thanks @Tris Mendoza-Oracle for the update. This is noted. Based on the feedback provided: Is there a source we can reach out to get update on these pending enhancements. This will help us invest time/efforts in building customizations which could take months and if the enhancement is planned to be released in the next few…

We have similar process. How about sub locations from the main location. Can we issue components from multiple sub locations/bins associated with main location. Basically we would like to evaluate if we can issue same component from 2 separate preferred bins set up for 2 sub locations (the sub locations have the main…

Hello, We are looking similar process and possibility of creating saved search. However, the transaction saved search does not provide Planned order types and we would like to have a report where for each item we can summarize what are planned and actual orders.

Hello @Elychelle Gulen-Oracle Thank you for help. It turns out you cannot directly edit the csv file with dates (as the format gets reset to m/d/yyyy. After few troubleshooting, figured out that all data needs to be created in Excel with correct date formatting. Once done, save the final file to .csv for import. Issue…

We use MRP as our replenishment method for all items. Also no matter how the date is formatted on csv (using short date, text, general), it changes back to 1/1/2024 instead of 01/01/2024

Yes it is. Even when we set the fixed value in the mapping (instead of mapping from csv file), get the same error

Sorry this message was for another post.

Yes it is. Even when we set the fixed value in the mapping (instead of mapping from csv file), get the same error

Hello @Tris Mendoza-Oracle , While I explore other options, I still want to see if the line level custom fields work. Created 2 fields: WO Header Qty and WO Fulfilled Qty (At WO line level). Created WF to update these fields: WO Header Qty = Current Record. Quantity and WO Fulfilled Qty = Current Record. built (with the…

Understood. Thanks

Yes I had followed that guide last week and it works. Thank you We actually wanted to get this result with no addition of custom fields. It seems redundant to have some of the header information duplicated with custom item fields, just to show on the saved search and was looking for options to get this data without having…

Hello @User_ZCWF3, Thanks you for the screenshot. Basically we would like to achieve consumption accuracy with this report and the fields we need WO# Header Item, Header Qty (repeated for each component) Component Component Qty Used in Built Issue Qty With the above method if WO has 6 components, we get 7 rows (including…

Thank you @Tris Mendoza-Oracle. This is very helpful

Thank you. This is helpful. One more question if I set up Scheduling method as Forward, enter Start Date, we expect end date to be calculated as 5 days from start date (based on WO Lead time set up at item), instead it defaults to Start Date