M.Lisa Silver Medal

Yes, ideally these should be equal. Just make sure that both reports use the same date in the footer/filter.

Try changing the equal sign to IN CASE WHEN {terms} IN ('Before Shipment','3 Weeks Before Shipment','50% Deposit','50% Net 30') THEN NVL({total},0)-NVL({custbody_so_deposit_amount},0) ELSE 0 END

Hello, After typing in the search field, do you press enter or tab key on your keyboard? I remember I encountered this behavior previously. When I hit enter, the results are downloaded automatically, but if I hit Tab or click outside the search box, the results will be displayed in the UI.

SuiteAnswers 108951 says that this SuiteApp requires a NetSuite OneWorld account. That might be causing the Validation Failed error. (I also got this error☹️)

Check under Setup -> Accounting -> Accounting Preferences -> General -> Expand Account Lists preference should be enabled.

Answer is B

Oh well, at least we checked. Might be best if you can provide more details like screenshot of Validation & Defaulting and Sourcing & Filtering tabs of the custom field. It might also help the Gurus' investigation if you can provide the script or at least part of the script that you're using to set the value of the field.

Were there any scripts or other customizations implemented recently on IFs? You can check if any of those might be affecting this field. If this wasn't happening before and you only noticed it recently, then it might be a bug. Probably best if you submit a support ticket for this one so they can investigate.

Have you checked the System Notes? Or the History/Line System Notes? This usually gives you an idea why a field changes.

Strange. I tried both formulas in my end, but didn't encounter ERROR: Invalid Expression for either. I did encounter the 'possible divide by zero' error for the Stock term formula. Here are some options to get rid of that error: ({quantityonhand}+CASE WHEN {transaction.type} = 'Purchase Order' THEN…

My answer is B. @Dext3r, this is sort of a game so I'm guessing it's part of the fun? lol

It's B!

It’s C

C. I & IV

Unfortunately, saved search fields for user preferences do not exist yet. (at least none that I know of) Regarding the default language, according to NetSuite Help Guide (ID 96260): Company default language — This is also known as the base language and was assigned when your account was established. Your system record…

If you close a sales order in NetSuite that has a mismatch between what is billed and what is invoiced, it will not impact the GL transactions that have already taken place. When you close a sales order in NetSuite, it only affects the status of the sales order record itself. The GL transactions that were created when the…

@asha.jena, Not really an expert in scripting, but out of curiosity, I tried to ask ChatGPT and here's what I got: To send an email notification after the CSV import task has completed, you can modify your script by adding a callback function to the create method of the importTask object. Here is an example code snippet:…

Try checking your settings under Setup > Company > Email Preferences > General > Enable Email Alerts for WS and CSV Imports.

Try this: REGEXP_SUBSTR({field_name}, '^[^/]+')

Try using the NULLIF function. Use a Formula (Numeric) field and enter the formula: NULLIF(*field or formula*,0) Note that you need to replace *field or formula* with the exact field name or the formula that you use to calculate the backordered quantity of the order.

Glad it works! I guess I have some experience with Excel formula, which is somehow similar with SQL used in Saved Searches. Kind of the same logic, but different code/words used. Also, the formula I provided might look overwhelming at first, but if you look closely, its just the same formula copied from Dominica's article.…

Hi Dallas, Your previous requirement of just counting the lines with inventory item is pretty simple as we only needed to add a criteria to filter it out. For the average number of items per sales order, I assume the formula to compute this is (Total count of items)/(Total count of unique document number). Is this right?…

@Dallas H In your Criteria, add Item Fields… Type = Inventory Item you can also try adding Tax Line is False & Shipping Line is False

Screenshots of any/all the relevant info that you think can help other members understand your use case better. Examples are: how your items/assemblies are setup or how you are processing these items (steps to reproduce your issue) Make sure to show the important fields like the UOM, component, item type, etc. But hide any…

Your original question was about parent/child/grand parent relationship -- which is why we discussed matrix items. For the item types, you can know more about these by checking SuiteAnswers 28194.

Item Defined Cost is not available yet in standard reports. You can vote for Enhancement # 177979 for this feature. Maybe try recreating the report as a Saved Search instead to get the information you need.

Atleast we managed to solve half your issue. 😅 Have you tried the troubleshooting in the SuiteAnswers article I mentioned before? It discusses 4 reasons that may cause the behavior you are experiencing.

Hi @AhmedM, This is an interesting scenario. Maybe you can share some screenshots so the gurus and members can better visualize your use case and help you better on this one.

Hi @Entartes, This discussion might help:

I think you need to change the Type of the field to "Multiple Select" instead of "Free Form Text" then set what is the List/Record source.