Hi @"jenluna", Cost of Sale adjustments are usually being generated by the system in order to recognize the actual Cost of Sales if the item is sold underwater (selling the item even when you don't have the item in stock). For more details on underwater sales see Understanding and Avoiding Underwater Inventory. When the…

Hi @"coffeeguy", Welcome back in the community! For the part 1, unfortunately the screenshot is not attached. Can you confirm on the specific fields you would like to show in the saved search? For part 2, let me check this on my test account Other users who has inputs on these? Let us know your thoughts! @"Herdi…

If what you are looking for would be for searches/report, you may try the following: For dropshipments, you may refer to: Report that shows computation of Gross Profit for Drop Ship Transactions * Navigate to Lists > Search > Saved Searches > New * Select transactions * In the criteria tab (you may modify the criteria as…

Hi @"4266398", Just to confirm, would you like to compute for the Gross Profit rate of your dropshipments other that the ones provided by Gross Profit feature (as logged in the Estimated GP in the Sales Order). Preferably based on the actual Cost and the actual Sales Price, am I correct? Is this in the form of a…

Hi @"4170598"! Just to share regarding NetSuite WMS. You are correct that the WMS functionality, as provided by bundles SCM Mobile/Oracle NetSuite WMS, allows users to scan barcodes in processing inventory transactions (inbound/outbound). NetSuite WMS will run on a mobile device that will have the scanner built into it. It…

@"jmohr", I have already endorsed this thread to our SuiteCommerce gurus Tagging @"Jan Alfred Forbile-Oracle" / @"Sajishan Sivakanthan-Oracle" any insights on this one? Other users who have thoughts on this matter as well? Feel free to share your inputs Cheers! @"Herdi Rana-Oracle"

Thanks for the clarification and confirmation ! I tried to replicate the behavior on my end using a non-OneWorld test account, but was not able to do so. I modified my steps to match with yours: * Approval routing to Purchase Order = T. This is so that upon approval of the SO, the PO generated will be on Pending Approval…

Glad to be ofhelp @"Wendy Branham"! @"Herdi Rana-Oracle"

Thanks for sharing @"ShyamBandari", you are actually right! @"Wendy Branham", if you are indeed pertaining to the Price Level of your item, SyamBandari's reply is correct. In addition to this, in order to automatically see the Internal ID in the Accounting List: You may also setup a User Preference first in your account: *…

As designed, the available allocation for landed cost both in Inbound Shipment and Item Receipts are Weight, Quantity and Value. The computation is as follows: Weight (Weight of Item / Total Weight of Eligible Items) x Total Landed Cost If the item has no weight entered, NetSuite displays an error message Quantity (Total…

I can very much understand your sentiment. And I appreciate casting your votes for the said enhancement, the more votes in the enhancement may provide more traction to our product managers regarding the said request. No worries as well, I'm glad to be able to provide my insight Cheers! @"Herdi Rana-Oracle"

Hi @"jayjay159", I'm on it! Let me check on this one on my end and I will be providing my insights after testing Regards, @"Herdi Rana-Oracle"

Hi @"John Griffin", I was able to reproduce the same behavior. The Distribution Network field is not exposed for the importation of Lot/Serialized Assembly Items. Upon checking, this is still an enhancement, as requested under 309502 CSV Import for Numbered Items > Update > Allow the mapping of the Distribution Network and…

Hi @"4218125", Welcome to the community. Allow me to endorse this to our SuiteCommerce Gurus for their insights Other users who have thoughts on this matter? Feel free to share your thoughts! @"Herdi Rana-Oracle"

Thanks @"3963645"! Let me know if you have further questions on the options above Regards, @"Herdi Rana-Oracle"

Based on my testing, we could replicate the information in the inventory valuation report (on hand and inventory value) through the use of the Item saved search (or using Item dataset in the workbook). The limitation on this one is that it will show the information real time, meaning, we cannot set a date filter just like…

Wow! Thanks for sharing @"JCirocco"! @"Herdi Rana-Oracle"

Thanks for confirming! Just curious though, in the Work Order transaction, is the Routing Step and the Auto-issue also populated (and duly matched from your Manufacturing Routing record). Lastly, may I know if your Advanced Manufacturing bundle is updated? I think you may file a case in Support so that they can check if…

Hi @"3963645"! May I confirm the following first so that I could reproduce the same steps on my end? * Create a Sales Order with a regular inventory item for two line items (just to confirm, these are different items right?). Quantities of 8 each * Click on Spec. Ord in the create PO link (just to confirm, we will be…

Hi @"lraynor"! I tried to reproduce the same behavior on my end, but was not able to replicate the same result. Just to confirm, after the removal of the line item in the PO, the SO's Create PO column does not show the PO number right? I created a Sales Order with a dropship item. I entered this three times (since you…

Hi @"Tybrneryan"! You are correct, WMS's core functionality does not support yet the Select All for the outbound processes. It may be possible through extensive customization, in which you may reach out to your Account Manager for Professional Services engagement or to your in house developers. With regards to the…

Hi @"Kenny Wise", Currently, we do not have the functionality to restore deleted records unless you request an entire Data Restoration which will entail a related cost. If you want to know more on this, I suggest you consult your account manager regarding on this one for further discussion. The ability to restore deleted…

Hi @"Tybrneryan", Based on my understanding, you'd like to have the functionality so that customers or items' quantities can be entered on sales orders based on the order multiple. You are correct that we can set the minimum quantity required for orders in the item record. However, in the core/standard functionality, 'In…

Hi @"Nikolay Georgiev", We'll look into this one. Our Guru who specializes in this matter will be providing you their insights after testing/researching on this matter @"Herdi Rana-Oracle"

Hi @"nic_reg_01", We're on it! Let us test this and we will be providing insights on this thread Other users who have insights on this matter? Feel free to share your thoughts! @"Herdi Rana-Oracle"

Hi @"Johnny Cash", Let me look into this one As far as I know, to be able to recreate the Inventory Valuation's report functionality to track back the historical on hand values (e.g. as of last month) is not yet supported in Item Saved Searches and Item Workbooks. These can only pull out inventory values/information at…

May I know if the Advanced Bill of Materials is enabled in your end? Since you are able to set the BOM quantity to Zero in your assembly components, I am assuming that this is enabled, is that correct? Just to know as well, are there any errors/messages thrown in the Work Orders AM Production Results sub tab (under…

@"Jay Schwausch", I was able to research on this one As per my testing, by design, the On Hand, Available and On Order columns in an item search/list will always give the total quantity across all locations (and all subsidiaries) and is not affected by Location nor Subsidiary Restrictions placed on the role. This is…

Glad to hear it worked! Cheers! @"Herdi Rana-Oracle"

@"Martha Hakes", I think this can be achieved through an item search. Just to verify, you would like to view the Open order qty from supplier + Total Inventory on hand – Back order qty – committed qty in a total right (not on a per transaction level?) You may try the following in an item search: * Navigate to Lists >…