M.Lisa Silver Medal

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.

It would really depend on your business processes. I guess for matrix items, one useful feature is that you can set the naming convention for the child items. Think of the T Shirt analogy. I have a T Shirt with a Mickey Mouse character print on the front. This represents my Matrix SKU master/parent. This matrix SKU can now…

Not really an expert yet in Supply Allocation, but you can try checking SuiteAnswer ID99607 for some initial troubleshooting. Regarding the PO not automatically generating, maybe it has something to do with the Item Source field on the Work Order or in the BOM Revision? Can you confirm if it is set to "Purchase Order"? Try…

Not yet possible. Logged as Enhancement # 635464 Separate preference for Item Receipt. Mark or unmark Default Items to Zero Received/Fulfilled preference without affecting Item Fulfillment.

SuiteAnswer ID 7810 : Prevent Auto-Population of Quantity in Item Receipts Solution Navigate to Setup > Accounting > Accounting Preferences Click Order Management Fulfillment: Default Items to Zero Received/Fulfilled: Enter Checkmark Click Save

Maybe negative bins or serial/lot numbers? You can try running an Inventory Balance search for the item to check this. Also, providing screenshots would help the gurus investigate your issue. Just make sure to hide sensitive data.

If Support said that it is not possible, then it probably isn't. This is available in old accounts, yes. For new accounts it is no longer an option afaik. Maybe talk to account manager coz they might know if this is something that can be unlocked with $$$

What's the COSTING METHOD of the item? Seeing as the timestamp of the change is always around 8pm, it might be that the costing engine is scheduled to run at that time. Might be an inventory costing recalculation (suiteanswer ID28092) or system cost of sales adjustment (suiteanswer ID28147).

Was it working as expected for the item before? Is it only occurring on 1 specific item or are all items affected by this behavior? You can also send screenshots so we can better visualize the issue. Just make sure to hide anything sensitive/confidential.

Are you unable to edit on the invoice? Is it greyed out if you click on the inventory detail line? Also, have you tried removing the line then adding back the correct serial number?