Ivy Lopez-Oracle NSC Guru

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?

Hi @Paul Reading, Thanks for the clarification. What I meant was that whatever text you put in the description in the filter will be treated as a text/string, not as a field. See example below: Anyway, for your requirement, try adding a Formula (Numeric) in your Criteria with this formula: CASE WHEN {customitem316} =…

Hey there @Paul Reading, I'm testing this out, and was curious why you need the three spaces? Anyway, I think this is possible using a combination of the REGEXP_SUBSTR and REPLACE functions. In the meantime, if you just need the last word after the last colon, then you can try this formula:…

Hi @Paul Reading, Can you clarify what it is you are trying to achieve here? If you put in '{customitem316.name}' in the filter, then the search treats this as a string, and not as the value of the field. Are you trying to get only the items which have a value entered on that custom field?

Hi @Benjamin Paul - USA, Were you able to check my previous comment? If it was able to help in your concern, kindly click "Yes" on "Did this answer the question?". This will aid the others with the same question to easily find the correct answer. You will also earn points and may unlock the Answer Accepter badge.

Hi @Julien Mi Electronics, Were you able to check my previous comment? Let us know if this helped or if you need further assistance.

Wow, awesome @Tiru Chembeti! Also noticed that you are now at the top of our All Time Leaderboards. Congratulations! 🎉

Hi @Benjamin Paul - USA, Generally, the cost of any inventory deducting transaction (Item Fulfillment, Standalone Invoice, Negative Inventory Adjustment) will depend on the costing method of the item. If the costing method of the item is Average Cost, then the cost of the items will depend on the current average cost. For…

Hi @Asher_123, The field is called Location Available: The field ID used in search formula is {locationquantityavailable}.