Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hi @Erleen, There's no native feature exactly as you described, but you can check the Inventory Status feature as this is something similar. You can also explore the option of adding custom fields to your item record to show the status/lifecycle of your items. Hope this helps. Anyone else with ideas/suggestions? Feel free…

Hi @User_C6XDE, Per checking, it seems that what you reported is the standard behavior in WMS, and there is no standard/native setting or preference to only display the Child Item Name in WMS Mobile. I tried to search for enhancement requests related to this, but there is none. You can submit a new one in the SuiteIdeas…

Hello @OliverK, Have you tried using Maximum as Summary Type for the {quantityavailable}?

Hi @User_LWL3U, I checked this on my end and it seems that there is no standard/native preference or setting related to your requirement. I coordinated this internally with our SuiteCloud Gurus and was advised that since you want to determine if the tracking numbers are being used or not, somehow, you can do that via…

Hi there @Asher_123, The error you are encountering is most likely because you used the NS_CONCAT formula in the Criteria > Standard tab of your search. Note that in Saved Searches, NS_CONCAT only works in the Results tab when the lines are grouped, and the Formula (Text) field with the NS_CONCAT formula has the Summary…

Hi there @Paul L. Walker, Thank you for posting your concern here in our community. I have checked this internally and have confirmed that the time indicated in the notification is in 24HR Format - U.S. Pacific time. Hope this clarifies your concern. ---- If you find this reply to your question useful, others might be as…

Hi @User_NC62U, I have tested this on my end and confirmed that the preferences you mentioned can not be applied to Item Fulfillments or Item Receipts created from Transfer Orders, Over fulfilling and over receiving is not yet supported for Transfer Orders. Per further checking, I found an Enhancement # 297139 related to…

Hi @Sivasubramaniam, @Margrat Chakkalakkal Rappai is correct. It is currently not possible to convert serialized items to service or non-inventory item types. At this time, users can only convert Non-Inventory Items or Other Charge Items to either Regular Inventory Items or Serialized/Lot Numbered Inventory items. Other…

You can use JEs to adjust the current balance of the accounts whenever necessary. If you want to add expense and decrease the COGS, then it would be the same as what we discussed earlier. The JEs will be reflected in the period that you enter in the transaction. As a general best practice, it is not advisable to back date…

Generally, that is correct, if the costing method of the item is set to Average.

You're welcome, @Dwight Schrute! Glad to help. 😊

Let us know if you need further assistance on this one.

Yes

It would depend on your business processes, but you can make a JE for that. To our other members, feel free to share your insights on this as well.

Hi @Dwight Schrute, You can try the saved search provided in SuiteAnswers 24892. Hope this helps. 😊

Hi @Dirk Nieuwkamp, Work order transactions track the production of assembly items needed for stock or to fill orders. Work orders track the quantities of assemblies that need to be built and the quantities of components, or member items, needed to do so. That being said, it is not possible to add another item type to a…

Hi @Camila O, Thank you for posting your question here in our community! Allow our gurus/members to check this one and they'll keep you updated on this thread. To our other members, feel free to share your insights on this thread as well.

Hi there @dspringfield, Glad to have you with us today and thank you for posting your concern here in the community! Allow our gurus/members to check on this one and we'll update this thread for findings or if more information is needed. Also tagging @Leonard Mallare-Oracle who may be able to help you out on this one. To…

Hello @User_X9AE5, You can reach out to your NetSuite Account Manager to discuss training options available for you. I suggest to also check out this site to learn more about NetSuite Education Services. Another option is to attend free Webinars offered here in the NetSuite Support Community. We do have one scheduled today…

Hi @OliverK, Per checking, the Location Last Purchase Price is still not available on Item Saved Searches. This system limitation is tracked under Enhancement # 156755 Lists> Search> Saved Searches> Item: Show Last Purchase Price on each location as can be seen on item record as opposed to most recent receipt/cost at any…

Hi @Dwight Schrute, Good idea, but since there is no standard System Notes recorded for any change, your requirement might be difficult to accomplish. You may contact your developers or your Account Manager for possible engagement with our Professional Services team for this customization.

Thanks for your understanding. Unfortunately, it is not possible with just a formula in a saved search that is based on the value from the location sublist of the item record. If anyone else has ideas or insights regarding this one, feel free to comment on this thread.

Hi @Sankar Ganguri, Per checking, it seems that this is not possible using formulas if the source is the location lead time. Since if we use the Location Lead Time field in the formula, it can only pull the data from that specific inventory location. For you to accomplish your requirement, you would need to have a custom…

Hello @Dwight Schrute, I checked my resources on this one and it seems that it is not yet possible to track the history of the prices in the vendors sublist. This is requested in Enhancement # 150314: Multiple Vendors: Lists > Items -- Track changes made to multiple vendor machine fields. Preferred Vendor Purchase Price -…

Hi @Paul Reading, I was able to do some further tests and came up with this formula: CASE WHEN (LENGTH({name})-LENGTH(REPLACE({name},':','')))=3 THEN '&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp' || REGEXP_REPLACE({name},'.*: ',' ') WHEN (LENGTH({name})-LENGTH(REPLACE({name},':','')))=2 THEN…

Got it. Allow me to test this further and try to come up with a formula for your requirement.

Hi @Betsy Vance, Thanks for the update. For other members who might have the same question, you may refer to SuiteAnswers 75343.

Hi @Paul Reading, Thanks for providing additional information. You can try this formula if it will show what you need: REGEXP_REPLACE({name},'.*: ',' ') If you want to have the spaces (&nbsp), we'd need a slightly more complex formula, Can you confirm that there are only at most 3 levels in the hierarchy? Example: Level1:…

Glad I was able to help. 😊 We'd appreciate if you can click the "Yes" on the "Did this answer the question" under the comment that was helpful to your concern. This way, other members who might encounter the same can find the answer easier.

Hi @Paul Reading, Can you compare the Available Filters tab of the search you are working on and the search that search you have on your vendors?