Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hi @faisalabdulmoid_39498, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the meantime, if any…

Hi @BryanL, Thanks for posting another question here in our community! I actually tried this on my test account as well, and got the same error. I found it weird because when I manually typed in the same formula, it worked: CASE WHEN {item.inventorylocation} = 'Warehouse' THEN {item.locationquantityavailable} ELSE NULL END…

Hi @Wendy_M, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hello @User_0RQ7O, Just wanted to check in if you were able to see the possible solution provided in my previous comment. If it was helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll earn points and unlock the…

Hi @FazeprooF, I tried it on my test account and was able to reproduce what you mentioned. As a workaround, please try using a Formula (Date/Time) field instead, and use the formula: {lineitemenddate} (which is the field id of the Line Item End Date field).

Hi @Kellyann, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle and @Elychelle Gulen-Oracle to take a look at your question and provide you with their thoughts. Please allow them some time to investigate and get back to you. As initial troubleshooting, can you…

Hi @User_HPB3I, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. Please allow them some time to investigate and get back to you. As an initial troubleshooting step, can you check if there's anything entered in the…

Hi Audrey @User_HQRSY, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you.…

Hello @Ivan Babiichuk, Try adding these fields in your Results tab:

Hello @User_0RQ7O, Try this: Formula: CASE WHEN {systemnotes.newvalue} = 'Shipped' AND {systemnotes.date}-({now}-(1/24)) < (1/24) AND {systemnotes.date}-({now}-(1/24)) > 0 THEN 1 ELSE 0 END

Hi @Dext3r, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. Please allow them some time to investigate and get back to you. In the meantime, if any other members have any thoughts, insights, or suggestions, we…

Hi @Christopher Williams, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the meantime, if any…

Hi @Andrii Siryi, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle and @Elychelle Gulen-Oracle to take a look at your question and check if this is possible in the native system. Also tagging @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl…

Hi @Preethi Kondur, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at this one and provide you with their insights. Please allow them some time to investigate and get back to you. In the…

Hi @User123554855, As documented in SuiteAnswers 31715: To use the Costed BOM Inquiry, enable the Standard Costing and Assemblies features. This inquiry can be run only for a standard cost assembly item. Also in SuiteAnswers 65696: Standard costing and assemblies must be enabled to use the Costed BOM Inquiry. You can run…

Hi @davidd039, Not quite sure what you need help with. Are you looking for a NetSuite solution similar to the Oracle Product Master Data Management? If so, then it would be best to reach out to your account manager for that. We can only provide assistance with what's available in NetSuite platform, which is the Item…

Hi @Kedalene, I checked my resources about this and noted that your requirement about FIFO history is not yet available in the system. Here are some enhancements related to this: Enhancement # 72134: Ability to display FIFO layers in a standard report/transactions Enhancement # 183211 : Inventory Valuation Report : Ability…

Hi @User_F5KU8, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi there @ssilveri777, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our experts @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl Espiel-Oracle and @Joahnna Given Uy-Oracle to take a look at your question and provide you with their thoughts. Please allow them some time to…

Hi @User_UY6JW, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Micah Timbol-Oracle and @Katerina Winklerova-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the meantime, if any other…

Hi @Sue Campau, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle and @Elychelle Gulen-Oracle to take a look at your question and provide you with their thoughts. Please allow them some time to investigate and get back to you. It would help if you can provide…

Hi @Brian D-Oracle, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In…

Hi there @Paul Salkeld, Thanks for reaching out to us in the NetSuite Support Community. I have reached out to our gurus to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back to you. In the meantime, if any other members have any thoughts,…

Hi @Aby James, Thanks for providing the steps! We appreciate you sharing your knowledge and expertise here in the community 😊 ---- Hi @Edwards_05, Please try the solution provided by @Aby James and let us know if it worked for you. I also remember @John Griffin providing similar steps in other threads. You can also check…

Hi @Kedalene, If you just want to adjust the Value of the items, without affecting the Quantity, then you have these options: Use an Inventory Adjustment Worksheet - you can keep the same Quantity, and just adjust the Value, however, serialized/lot numbered items are not supported Use 2 Inventory Adjustments - 1st…

Glad it works! 😊

Hi @PaulFleetwood, Thanks for reaching out to us in the NetSuite Support Community. Interesting question you have here. I tried it on my test account, but was unable to reproduce the behavior you mentioned. Can you send some screenshots of the Criteria tab, and also screenshots of the Event which is appearing multiple…

Hi @Kedalene, If you are referring to the Inventory Cost Revaluation record (as shown in below screenshot), then yes, Standard Costing feature is a requirement for this. However, if you just want to revalue (change the value or quantity) your inventory, then perhaps you can use Inventory Adjustment or Inventory Adjustment…

You're always welcome, @Dallas H! 😊

Hi @Joy Noreen Magoling-Oracle, What's something that you wish you knew sooner/earlier? Can be about NetSuite or about life in general. 😊