M.Lisa Silver Medal

Hi, Calculating a running total or dynamically determining the first date when inventory will be depleted in a NetSuite Saved Search can be very challenging due to the limitations of the saved search formula functionality. Specifically, saved searches don't have a built-in feature for "running totals" across rows or an…

Maybe you can try adding a CASE statement in you formula that would only get the value of the transaction quantity if the transaction type is Item Fulfillment.. It will look something like: CASE WHEN {type#display} = 'Item Fulfillment' THEN {transactionlines.quantity} ELSE 0 END Test it out if it works. You might need to…

Since you have custom fields here, I suggest you also share the setup of your custom field, and where it is applied so our experts can further replicate and test. However, based on my understanding, it seems that you have a formula sourcing values from Custom Transaction Body fields, and then the other one is sourcing…

This behavior might be due to the Item: Location On Hand field on your Results tab. If you have different locations, then the search results will pull the On Hand value per Location, which will result in multiple lines/rows per item.

It's standard functionality that if the Inventory feature is enabled, those tasks will be on the checklist. I don't think there is a way to customize this. Sorry it's not the answer you want to hear.

Hey there Rebecca, interesting requirement you have here. I had an idea to use the running balance formula I previously saw here in the community: However, when I tried it, I received an error. Seems like the formula doesn't work if there is summary type. That being said, I don't think it is possible since you have Item:…

I agree with Amanda. It would be helpful if you can share screenshots of your Criteria and Results so we can further troubleshoot.

Is the Inventory feature enabled on your account?

Commit Orders page is not available if Supply Allocation is enabled. Check SA 32363. There's a note there that the topic is only applicable if you have not enabled the Supply Allocation feature in your account.

Have you tried to enable then disable the Centralize Purchasing in a Single Location preference? If this doesn't work, I suggest you file a support case.

Try adding TO_NUMBER before your free-form text fields. If that doesnt work, try to create a search showing the values of those fields to check if there is a non-numeric character in any of the results.

maybe try adding a line id column in the csv and mapping it to the line id of the member item

Create Project

answer: C

Answer: C A D B arrange the choices…

No, you can’t reference formula fields in search results. But you can add another formula field and copy paste the formula from your other formula fields into the 3rd one get the to get the result you need.

My bet is on Material Requirements Planning. Afaik, that’s a more complex version of Demand Planning basically, so there’s a high chance that enabling the feature exposed the field on your forms.

can you elaborate on what exactly you mean by independent assembly item? and by subitem, do you mean the component items? Usually, the term subitem is used when referring to Matrix Items. Sorry, just a bit confused as to why you want to create an assembly without components. The main purpose of assembly item is to be able…

I agree with Jeremy that the Ship Date might be pulling from the Expected Ship Date field in the item line. Check your custom form if it is hidden. It seems that something happened between Jan’23 and Oct’23 that might have somehow added the Expected Ship Date field on your account. You should look at what features were…

If you are using a transaction search, you might need to use the Customer Join field in the formula: {customermain.lastsaledate} Also, since it is already a transaction search, try using {trandate} instead of {transaction.trandate}

Hi, Can you try: CASE WHEN MAX({line.cseg_enco_manufactu}) = 'Crestron' THEN SUM({estgrossprofit})/SUM(NULLIF({amount},0)) END or CASE WHEN MAX({applyingtransaction.type}) = 'Sales Order' THEN SUM({tranestgrossprofit})/SUM(NULLIF({amount}-NVL({taxtotal},0),0)) END You might be receiving the error because you had SUM in…

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.