Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Thanks for the additional testing, @FazeprooF, Sometimes the "Pricing Search" results might be affected if you generate custom Price Lists. It seems you haven't done that. Can you create a test transaction adding the newly created items on a few lines with the same price? Let's see if that duplicates the search results.…

The criteria will be different for each Dashboard Tile. You would need to locate the Saved Search that's powering your Dashboard Tile and edit the "Audience -> Department" of that Saved Search. This is where the Saved Search is shown on the Dashboard Tile record:

I see what you mean, @Panadick, To see Sales Order items, the only option is to run the Sales Order Saved Search on a line level (i.e., Main Line = False). Certain joins, such as "Installment On Sales Order Fields..." is attached to the Sales Order header, and you can't natively combine them in one Saved Search.…

I see what you mean. Saved Searches power dashboards, and you should be able to achieve what you are looking for by setting department restrictions on related Saved Searches. Here is a Dashboard Tile sample Saved Search for the reference:

Hi @ER-Sree, When you said, "Later, I added that custom column to the journal list view. but it does not show the total there.", do you mean you added the newly created field to a Saved Search listing Journals? If yes, you would need to create a "Store Value" version of this field that will be regularly updated via…

Hi @Sue Campau, Yes, you can do that by navigating to the required Dashboard Tile and adding the required roles. Here is an example:

Yes, it is a browser issue, and we need to do that from time to time. Chrome (and other browsers) rely on the cache (temporary files) to speed up page loading. Sometimes the data in the cache becomes corrupted and causes issues for NetSuite.

Hi @User_DEF0A, If you are using Sales Orders, you can do it through "Related Records: For each flow, you have to go to the source transaction and check "Related Transactions". You can do it for entity records, such as Customer, Vendor, Project, etc.

Hi @TBalser, It happened to me a few times when I forgot to edit the Vendor Record before editing the Address. Can you check if that might be the case?

@Panadick, There must be an issue with the criteria. To help with the troubleshooting, please create a custom Transaction Search and share the results:

Hi @User_DJ8IA, Let's say the company has two Corporate Credit Cards: GL 1080 - Chase Visa GL 1090 - AmEx You would select one of these under "Account" on the Use Credit Card page. All charges are thus associated with this specific Credit Card. Let's say you have a $20,000 balance at the end of the month under "GL 1090 -…

Hi @User_Y0RZ7, The PO Vendor field on the Sales Order line is accessible via a script. The script can copy the current value to a custom PO Vendor (stored) field to be displayed on Saved Searches. The script also allows copying of the selected PO Vendor when the Sales Order is being copied instead of populating the Item's…

Hi @Panadick, Can you please add "Main Line = False" to the Saved Search criteria and try again? Typically, when the "Main Line" is removed from the criteria, NS considers it as "Main Line = Is Any".

Hi @User_E15G4, I have several questions: Is the AUD a Foreign currency for all the employees entering Expense Reports? If yes, what is the primary currency? When you say "notice on every Expense Report", do you mean to auto-populate it? Would you like to make it inline / non-editable?

Agreed, this is item related. Whatever it is, Item #110015 has 308 of that, and Item #110023 has 216. Did you generate Price Lists for both of these items? Also, can you create a test item and see how many results you will get?

Hi @FazeprooF, Thanks for testing the recommended steps and updated findings. Please try two extra steps to narrow down the cause of the issue: Choose another Item with the current Customer Choose another Customer with the current Item Let's see how different the search results are for each use case. If we get…

Hi @Quatro, Sure:

Hi @User_D4XL9, When an Item with a selected Unit Type is used on a transaction, NetSuite creates back-end records and dependencies to enable required functionalities and calculations. This is why it won't allow changing the Unit Type as long as the Item is assigned to a transaction. If the item appears only on a few…

Hi @BM136, Are you using Advanced Taxes? If yes, you can do that. You would need to create a Tax Schedule with the "taxable" unchecked for all states where you don't want to calculate tax on Shipping Items. You would then select that Tax Schedule on the Shipping Item, so NetSuite would calculate the Shipping Tax only for…

Hi @BM136, Please set the following permissions under "Custom Role -> Permissions -> Lists" to: Perform Search: Level = View Publish Search: Level = View This should allow creating/previewing Saved Searches but not saving them.

Hi @User_DATN1, There is a chance you have some mandatory fields on the Item Form, which possibly had been customized. Can you check if all "Unit..." fields are shown? Note that some of the mandatory fields might be on other tabs. In most cases, NetSuite error message mentions there is a missing mandatory field when…

@User_REJ14, When I read the post's title, 'Is Report last ran date available in Saved Search?" I misinterpreted it as "Last Run" for Saved Searches. NetSuite doesn't give users access to Report's Execution Logs, which is why a Saved Search built for Reports can't display it. I see why you are trying to do it, which is a…

I was referring to something like this:

That's good. Do you have the NetSuite Field Explorer extension for Chrome? If yes, please go to one of those PO, click the extension icon, and search for that PO's Internal ID. Let's see what field references that PO. In this hyperlink example, the Internal ID of the Project is 112:…

Depending on your system configuration and the edition, some fields, their underlying records, and relationships might differ. Let's try a few things. When you create a Purchase Order Saved Search and choose the "Project Name" field from the "Project (Main Line)..." join, does the Project Show up?

Hi @CDuf, Thanks for the clarification. You would need customization to achieve the result you are looking for with one Saved Search. Here is why: Credit Memo (or Payment, etc.) are applied to an Invoice on the header level. To see Invoice items, you need to run the Saved Search on the line level. A Payment/JE/Credit Memo…

@Wildtype, What would be the purpose of having "Name" on the Expense Report line by default? The "Employee" entity is on the header, and the "Customer/Project" is on the line. NetSuite native functionality covers 80% of the use cases of most businesses - far more than any other ERP and non-ERP, such as QB. NetSuite built a…

Hi @User_REJ14, Yes, you can do that. You would need to build a Saved Search and choose "Saved Search" as the type. In the "Results" section, choose "Last Run By" and "Last Run On". Best, Tigran

Hi @User_DPOHC, You can build a Saved Search that shows the Total Amount of Projects, Total Invoiced, Amount Invoiced, and Remaining Invoiced. Are you attaching projects to Sales Orders? The report might look like this: Best, Tigran

Hi @FazeprooF, One of the fields in the "Results" might be causing this. Although you see two decimals for the Unit Price, in the back end, each may have more, with slight variations in Unit Prices. You can do a few things to troubleshoot this: Export the list to Excel and see if there are differences in Unite Prices when…