John Griffin Silver Trophy

Hi @User_CA6YI, Here is a previous discussion that should help you out. The main thing is, perform the negative transactions separately and they will use the "Bin" and "Issue Inventory Number" fields. Please let me know if you have additional questions on this. John

Hi @User_MJC7X, The steps I took are as follows: Create a custom Item field Checkbox. From within the Planned Standard Cost Rollup and Revalue Standard Cost Inventory forms, select Customize and add the custom checkbox to the Additional Filter parameter. Additionally, add the field to the Additional Column parameter if you…

Hi @User_MJC7X, Let me put together some screen shots and I will get back to you; probably will not be until tomorrow morning, though. John

You're welcome - let us know how it works out.

Hi @KNason76, Below is what I have used in the past to disassociate BOMs from Assemblies. The CSV file contains a listing of the Assemblies and the BOM column does not contain any info. By choosing to overwrite sublist data, the existing BOM is removed from the Assembly. Once the Assembly items are corrected you can import…

Hi @Ben Belzer, There are probably other ways, but the first one that comes to mind is the Quantity Back Ordered field on the Item's Location Tab. I believe that field reflects all open SO quantity, unless the Item is also used on work orders. Would that work for what you? John

@Dwight Schrute, My original version did not have the formula, as I was looking for TOs in transit, and the results showed multiple lines for each item on the TO, but only one of them with the actual quantity fulfilled. The extra lines are probably because there are multiple items on the TO and no way to return distinct…

@Dwight Schrute, That is good to know, thanks for sharing. Also, in your previous search, I believe the the numeric formula is excluding any TO that is fulfilled because it resolves to 0 if the lines are completely filled. John

I performed a couple of checks and the headers for these location will not even show on the results without the Summary Type Group. John

You are welcome. Glad it helped Happy New Year, John

Hi @FazeprooF, You can create a new Transaction Saved Search as shown in the screenshots below and modify the selection criteria and sort order to hopefully show the transaction detail you need. This search was just created and not very refined, but should give you some idea how to proceed. I use the Classic Dashboard and…

Hi @Dwight Schrute, This works for me within a Main Line is "FALSE" Transfer Order search I have. John

Hi @AhmedM, My first thought is that you probably want the UOM for your Assembly items to be EACH, since they are made up of items with varying UOMs; Rice pack (Inventory Item with UOM Kg), Bag(Inventory Item with UOM EACH), OUTSIDE PROCESS Item(Service for Purchase item with undefined UOM). I may not fully understand the…

In my case, RMAs are repaired/replaced and returned, so it makes sense to bring them into stock and return them on an associated SO. The other advantage is the RMA provides the data to track Quality Performance Metrics or KPIs. In my experience I have always used an RMA process, so I am not sure if there are other…

Hi @User_KWKGU, I am using Advanced Inventory Management and when transacting an RMA receipt, there is a checkbox to restock the item. There is also an Accounting Preference under the Order Management tab that can be set to check the checkbox by default; otherwise it must be checked at time of receipt. Hope this helps, John

Hi@Asher_123, I am at a loss to see any reason for your TO Packing Slip not to show up in the drop down list. Perhaps take it into edit mode, save, and submit again, ignoring the warning that nothing changed, in case there was some sort of glitch the first time. @Kristoffer Viray-Oracle, do you see a reason this packing…

Hi @Asher_123, Once you have created these custom forms: -Transfer Order, Transfer Order Item Fulfillment, Transfer Order Packing Slip, and -Transfer Order Packing Slip Layout Configure your custom Transfer Order form, including the Linked Forms tab, to point to your custom Item Fulfillment and Packing Slip forms. You will…

HI @Asher_123, Yes, you can modify your existing transaction and layout forms and save them under new names, leaving their Preferred checkboxes unchecked. Your new transfer order transaction form will specify using your new layout form. After modify these forms to achieve the look you want and assigning where they are…

Hi @Jack Daryl Espiel-Oracle, Thank you for your response. I originally used the Visual Builder and ended up going to the custom formula. Your Condition screenshot allowed me to realize what I did wrong within the Visual Builder - I selected Sales Order under Record, thinking that I had to select a Record to be able to…

Hi @Benjamin Paul - USA, This info is pulled in from the PO. The expenses are entered and edited on the PO and are received within the receipt transaction. Best Regards, John

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