Joy Noreen Magoling-Oracle Gold Crown

Hello @kfluk, There are 2 Average Cost Fields that can be shown in the Current Inventory Snapshot report once it is customized. They are located under the Inventory Item Folder and Quantity on Hand Folder in the Customized Edit View of the report. Average Cost Field under the Inventory Item Folder - pertains to the…

Hello @US Water Systems, Inc., If in case you'll be able to reproduce the error again, some screenshots of the Sales Order and specific steps to reproduce would be more helpful in our checking. Nevertheless, one possible cause of the behavior might be some scripts deployed. But you shared that this was not encountered in…

Hello @Curtis Beene, I am coordinating this with our guru who might have insights on the behavior of the formula returning an error in the the Saved Search . We'll provide an update once available. Regarding your other query, I came across an enhancement request which is related to it. Enhancement # 125956 - Ability to set…

Hello @User_9F2NC, I tried to look into this and found out that this is not possible yet since setting the preferred bin needs editing the Item Record, and the ability to set a restriction on specific field only to be able to edit some fields on a form but maintain restriction on other fields is not yet available in…

Hello @User_GE55S, As I understand the concern, you'd like to show the Class field (main) in the Item Fulfillment record, but even after customizing the form, the field is still not showing. If my understanding is correct, sharing with you my findings. I performed a test on this and encountered the same: no Class field is…

Hello @Benjamin Paul - USA, Unfortunately, this is not yet possible in standard NetSuite account. Currently, the feature you are looking for is logged under this enhancement request: Enhancement # 110144 - Ability to sort accounting list by either numbers or names You can go to SuiteIdeas page to vote for the enhancement.…

Hello @nic_reg_01 The Inventory Activity Detail report shows the activity associated with your inventory items. The report shows the quantity per transaction of inventory items. This might be helpful with your requirement. To generate one, navigate to Reports > Inventory/Items > Inventory Activity Detail (Administrator).…

Hello @katherine_15328, Unfortunately, there is no documented workaround for this. You can reach out to your Account Manager to check with the Professional Services team if your requirement is possible. To anyone who have ideas that might help us here, feel free to join this thread. Regards, Joy

Hello @Biomerics_Admin, I would just like to check if you were able to see my previous comment and if it worked on your end. It would be great if you can confirm or if you can mark "Yes" in the "Did this answer the question?" for the comment which helped you so that other members who might have the same concern can easily…

Hello @User_ZCWF3, Yes, this field is manually entered in the Item record or on the Bill of Materials record (if Advanced Bill of Materials feature is enabled). What NetSuite calculates automatically is the necessary quantity to build or order which is based on the component yield settings. Here are few articles that you…

Hello @Curtis Beene, Thanks for the update! For the error when using Fixed Lot Size in formula, I still cannot reproduce it. I was assuming that some Locations/Department permissions might be causing this, however, removing permissions to these Lists do not affect the Search Results on my end. Would you mind sharing the…

Hello @Biomerics_Admin, Apologies for the late revert. I performed a test on this and was able to reproduce the scenario on your end. I discovered that this is the behavior when a Manufacturing Routing is associated to the Work Order. I noticed that in your screenshot, there are no values for the Starting and Ending…

Hello @Kitin Basilla, I would just like to check if you were able to see my previous comment. The community would very much appreciate your feedback and any input you can provide . ? Thanks and regards, Joy

Hello @YYF, Glad that you were able to discover the cause of the discrepancy through John's suggestion in the other thread. ? Thank you for the update and for sharing your workaround here. It would be helpful to other members who might encounter the same. Regards, Joy

Hello @User_IE7NG, Upon checking your concern, we've found out that there is an existing issue logged under Defect # 639545 - Home> Dashboard > Key Performance Indicators vs. Daily Open Trend Graph > Data do not match > Server Timezone vs. User Preference Timezone Conflict Upon checking further, I've also noticed that a…

Hello @YYF, Apologies for misunderstanding your concern and thank you for clarifying this. I checked SA 37836. The goal of the SuiteAnswer article is to check if there are pending transactions related to the transfer order which causes the balance in the Inventory in Transit Account. Upon seeing the amounts in the…

Hello @katherine_15328, By design, the transactions in the activity detail report are displayed on a per row basis I looked into this and found this enhancement request related to your concern. Enhancement # 44753 - Add a weekly/monthly column to a report You can go to SuiteIdeas page to vote for the enhancement. To other…

Hello @Kedalene , Welcome to NS Support Community and thank you for posting your concern here! ? Regarding the concern, kindly allow our gurus some time to check it for you and one of the gurus will reply on this tread with his/her insights or should more information be needed. Thanks and regards, Joy

Hello @User_92YNP, Thanks for checking it and for updating the thread. In the standard NetSuite Account, the generation of the replenishment plan is based on the On-Hand Quantity, however, as I understand your concern, you'd like to base it on the committed quantity. Unfortunately, the ability to automatically trigger…

Hello @YYF, Transfer Orders are used when transfer of inventory from one location to another is needed. With Transfer Orders, you can track each stage of the transfer process and know when items are in transit, thus Item Receipts and Fulfillment transactions are generated. You can check if any from your team uses this type…

Hello @User_ZCWF3, The calculation is based on the component yield settings present in the Item Record (Components subtab). Here are the fields you can set on the item record: The Quantity field on the Components subtab - this is disabled because this quantity is calculated by NetSuite. This field displays the amount…

Hello @User_92YNP, Have you tried checking SuiteAnswer Id 87078 - Replenishment? In this article, it is discussed that if users want to drive replenishment based on an item’s stocked quantity, we can do so manually using a replenishment report. If we want to drive replenishment based on a primary bin’s stocked quantity, we…

Hello @Curtis Beene, I assume that when using an admin role, you are able to see the expected values for the formula. Is this correct? I was trying to reproduce the behavior on my end but in my tests, it's either all values are showing (for both Fixed Lot Size and the Formula) or all values are not showing at all for other…

Hello @User_Q2NHQ, Based on your description above, only two Locations are affected, however there are thousands of items involved. With this, it is expected that it will take time for the process to be completed and it is not possible to speed this up. What I can recommended is to run the revaluation by batch. It may…

Hello @Kitin Basilla I performed some tests on this in my test account but could not reproduce the behavior. May I confirm if the one component with zero available quantity has On Hand quantity but committed to other Sales Orders? In SuiteAnswer Id 8713, where it is shared that we cannot release kit/package items with…

Hello @Liz Madrid, Combining here all the steps provided in my previous comments in order for us to import the 200 items into the customer record > Item Pricing. ? To easily follow the steps, I created a sample Price Level "SOCORRO CONTRACT" similar to the Price Level in your sample and 3 sample Items (Test Item 1, Test…

Hello @3ric, Thank you so much for sharing your findings and for helping the community! Regards, Joy

Hello @Liz Madrid, Yes, that's possible. In the Saved Search, you can set the Filter 'Price Level is CORORRO CONTRACT' under the Criteria tab. You can refer to Step 3 in my previous comment. ? Run the Saved Search and check if the Results show the desired information. You can export it by clicking the Excel icon then save…

Hello @Liz Madrid, Thanks for the clarification! With this, we can create an Item Saved Search to pull the values of the Pricing fields in the Item Record. I created a sample for your guide: Here is a screenshot of my sample Item: My goal is to get the value of the Price Level 'Base Price' from the boxed column. To do…

Hello @Dallas H, I would just like to check if you were able to see my previous comment and if it worked for you. It would be great if you can mark "Yes" in the "Did this answer the question?" if the comment helped you so that other members who might have the same concern can easily refer to it for the solution. Feel free…