John Griffin Silver Trophy

Hi @Dominica Sevilla-Oracle, The transferlocation field does not appear to be exposed to saved searches. And I did not see a way to source that field to a custom field. Thanks, John

Hi @Benjamin Paul - USA, Without knowing exactly what you are seeing, I think you are having issue with the transferlocation field. If so try using To Location. The screenshots below are a quick setup I used to test this. Best Regards, John

Hi @Lee Ann R, It is a long shot, but try opening your CSV file in Notepad to see if there are any extra or corrupt lines that are not visible otherwise. Hope this helps, John

Hi @Benjamin Paul - USA, I am not an accounting expert by any means, but we mapped inventory adjustments to a Cost of Goods Sold type account. We named ours Inventory Adjustments. It pretty much depends on how much detail you want to track. There could be separate or combined accounts for inventory adjustments, scrap,…

HI @Adam Birk, I have struggled with this, too, and have not found a way around the issue. From my experience, if our existing PO dates do not align with NetSuite's calculated dates, the existing PO is ignored and a new PO is planned. I could see this if the existing PO is not firm planned. Sadly, NetSuite ignores that the…

Hi @Benjamin Paul - USA, This is possible using Transfer Orders that are created and fulfilled in the source location and then received into the destination location. Check under Transactions Inventory> Enter Transfer Orders to see if you have this option. SAID: 27951 has more detail on this. Best Regards, John

Hi @Wellyntong, I am glad you were able to resolve the issue. John

Hi @Betsy Vance, Try going into BOM edit mode on a BOM that displays the button and one that does not to see if they both use the same form. I cannot think of anything else that might cause this behavior. John

Hi @Deano_M, If these are custom fields, you can try checking the MANDATORY box under Validation & Defaulting within the custom field set up. John

Hi @Wellyntong, I would uncheck one or more work orders necessary to free up the quantity/lot numbers needed for the order in question, and then check that work order and enter the quantity, if necessary. Hopefully that makes sense; if not please let me know. John

Hi @User_7EPKA, Have you checked the Reallocate Items transaction screen to see if there is another demand that is already allocated? Best Regards, John

@KNason76, Thanks for the update, it may come in handy in the future. John

Hi @Ben Belzer, I think changing the packaging to inventory items is the only way to manage the inventory within NetSuite. Would mapping the COGS account of those items to your packaging expense account mitigate the negative costing side affects? John

Hi @KNason76, There may be another way, but you can export to Excel from Lists>Supply Chain>Manufacturing Routings and Lists>Supply Chain>Bills of Material and compare the BOM file to the BOMs listed in the routing file to see if BOMs exist that do not show up in the routing file. Hope this helps, John

Also here is another thread on this topic that may be of use. John

Hi @User_WDL8R, This is best accomplished with Outsourced Manufacturing. To start, check out SuiteAnswer ID:91095. I can give you some pointers and info if this looks viable to you. John

Hi @GLL, Although I have a One World Account, I am currently using only one subsidiary, so my transactions have been limited to transfers between locations within the same subsidiary. I looked into this further and as you already discovered, there does not seem to be a way to transfer inventory between subsidiary locations…

You're welcome. Glad the info helped some. John

Hi @Dwight Schrute, Is this something close to what you are looking for? John

For the item not to show up on the inventory detail I would expect that it does not have a BIN and also does not have Inventory Number(s). If that is the case, I am not sure how it is being included in the search results since the criteria is Bin On Hand : On Hand is not 0, but it may be because the results are using the…

A couple more points of clarification: The 414 quantity in the Amazon FBA location does not show up in the Inventory Detail view, so I assume it does not have a Status assignment? I think the blank line from the last result is coming from the Bad Inventory parent location, since its child locations have quantities…

In addition to Inventory Detail screenshot, please provide the Locations view too. Thanks, John

Please try temporarily removing the the STATUS field from the results. And can you provide screenshots of the Location information and Inventory Detail from this item's record? John

Hi @GLL, What was the failure mode of the CSV attempt; large number of records or errors? I routinely transfer material between locations within the same subsidiary via CSV, but it does requires two transactions; one for reducing the inventory in the FROM location and another increasing the inventory in the TO location.…

Hi @User_NC62U, I suspect the large number of results is a factor of Locations, BINs, and Lot or Serial Numbers based upon the Criteria and Results set up. I have not tried to recreate your exact search, but my first thought is to try using Summary Type = GROUP in the Results. For example a BIN On Hand search I use is set…

Hi @Julien Mi Electronics, What is the due date of the parts on order? My experience has been that If this date does not line up with the calculated date determined by your planning parameters (time fences, etc...) the planning engine ignores the existing purchase order and suggests creating an order that is in alignment.…

Hi, No other workflows or scripts. I created the new field below and it still does not show in the workflow action parameters. John

Hi @Joahnna Given Uy-Oracle, Just checking to see if there is any insight as to why 2 of the 3 custom check box fields are not available to the workflow's set field value action. Thanks, John

Hi @Joahnna Given Uy-Oracle, The Inventory Item below shows three custom check box fields. The INSPECTION REQUIRED check box is the only one that is available for selection within the workflow set field value action parameters. Comparison of Custom Item Fields Desired Field for workflow action Only available Field Workflow…

Hi @Karanjot Singh, From your home screen you should be able to select Personalize Dashboard from the lower left. From there the tile should be visible, for selection, on the SuiteApps tab. John