Hello @Ayitah Tallada-Oracle , Here is a sample screenshot For columns D and E, the View Detail option will display the document details. Column F is the formula as (D - E) and would like to see if there is a option to show similar details for column F as well. Thank you

Hello, We have a Standard Report for Transactions which include information: Column 1 - Amount for current month Column 2 - Amount for previous month Column 3 - Column 1 - Column 2 For first 2 columns the View Details option is linked to detail report with document numbers and account information. Is there a standard or…

@Patrick Fresnosa-Oracle Thank you for the response. The alternate solution is not acceptable for the audit team, as the data needs to be in Excel and not pdf.

Thanks @Able Wilson for the response. This is helpful. On another note, if we customize any standard report in Netsuite (Financial or standard reports), is there an option to customize the report title to include 'Run Date' of the report. This is normally requirement from Audit when we generate reports there is no option…

Let me rephrase the question. In the available filters when added shows all possible values in dropdown. Is there a way to restrict the dropdown list by certain criteria (like for GL accounts filter dropdown, restrict the values available by certain type or account starting with specific number?)

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…