John Griffin Silver Trophy

Hi @KNason76 , The option below should only be performed if the Assemblies you are working with do not have any other associated BOMs on their records (or you want to delete all associated BOMs). The OVERWRITE SUSBLISTS option under Import Options will replace all data on the Bills of Materials sublist with your imported…

Hi @Matan Shachaf, In general, you can customize the transaction fields displayed by using the Customize View button in the header. I am not sure I understand what field information you are trying to add. Are you looking for descriptions for the Transaction Types that are shown in column 3 of your pic? Thanks, John

No. All appears normal here.

Hi @User_RHKAB, I usually edit the existing item by adding an "X" at the beginning of the current item name and then make it Inactive. A new item can then be created with the same name. There is nothing special about using an "X" it is just what I did the first time I had to change an item's type. This keeps them all…

Hi @Matan Shachaf , In a Search, the field is "Line ID." It is created in the order that the lines are added to the Sales Order. Previously, I have not found a way to expose this field on the SO form and created a custom field that is used for SO Line #s. I just did a quick search in Records Browser and did not see where…

@KNason76 , Unfortunately, the saved search is limited by the fields NetSuite chooses to present to us. Perhaps someone else will have another idea. John

Hi @KNason76, Here is a saved search I created. It is only good for the top level, but multiple passes working down the BOM could yield a multilevel picture. Hope this helps, John

Hi @Greg Ebel , Once you delete the Item Fulfilment, the product will show back in inventory. If you receive an error while trying to delete the IF, additional steps may need to be taken to temporarily change UPS/FedEx not to create an integrated shipment. Hope this helps, John

Hi @Vernita, Other than checking to make sure the item/serial number was not duplicated somehow and is currently in inventory, it may be helpful to see all transactions that contained that serial number to gain insight as to what may be causing the issue. The link below shows a search I created that may be helpful.…

Hi @Tafara and @Pauline Cac-Oracle , Just a quick note to thank you for your responses and I apologize for the delayed response. Another project came up that took precedence and I will hopefully get back to this one next week. I had gotten started on Tafara's proposed solution, but the first attempt was not successful, I…

Hi @Peter Bergsma , Here is a transaction search I use that may be close to what you are looking for: The 3rd selection criteria, "contains 139", allows for using Transaction Serial/Lot Number filter to select a specific SN or pattern match. Hope it helps, John

Hi @Toanne Termeer - van de Ven, I have seen some issues with how the costing screen utilizes the BOM Revisions; out of curiosity, please try changing the BOM DISPLAY CONTROL from By Revision to By Date and setting the date to the current date, which should be the default. Perhaps that will correct your issue. Good Luck,…

Hi @Joy Noreen Magoling-Oracle , Last Friday I refreshed the repository once again and discovered that, miraculously, the demand for 022-02003-0001 FPWO in KeyW location is no longer being duplicated. I went through the process of completely refreshing the repository several more times with the planned order’s status in…

Hi Ivy, I tracked this down to the BoM revision component field not being checked on the custom form. The OPERATION field is not populating. Thanks for your help, John

Hi Ivy, I have only one script that adds a button to the work order form, and even though I did not think it was causing any problem, made it inactive anyway. As expected, the Operation field still does not populate. I do not see the "System Information > System Notes / Active Workflows / Workflow History", but do not have…

Hi Ivy, It appears that it is just my custom Work Order form where the Operation field is not populating. What is the mechanism that allows this to happen? I compared the other Standard forms to my custom form and do not see a difference. Thanks, John

Hi @Joy Noreen Magoling-Oracle , I performed some more testing on another outsource manufacturing item and also an in-house Assembly. The in-house assembly performed as expected when the top level PWO was made Firm (no component demands were duplicated, calculations appear correct, and the BOM structure did not disappear…

Hi @Joy Noreen Magoling-Oracle , Screen shots of the SPD & Planning Rule Group, as well as the Parent and a Child set up, are below. Since I am just setting up the Supply Planning module, I only have a few items set to use MRP Planning, so I am not sure if other configurations work or not. It is baffling how just changing…

Hi @User_H8CIW , Depending on how you handle closed periods, you should be able to edit the item receipt record with the correct cost. Hope that helps, John

Hi @Joy Noreen Magoling-Oracle , Thank you for following up on this. I entered a case on 5/25, but do not have a resolution or determination as yet. Is there any specific information on how I have this set up that would help your analysis? John

@Martha Hakes , Great! Glad it will work; it has been a great tool on a number of occasions. You are welcome, John

Hi @Martha Hakes , Will the Techfino Mass Deletion Script work for this? I have not tried it on this type of record. Good luck, John

Hello @JASONH , This may or may not work for you, but I handle a customer proforma invoice in this way: Create a new Item of type OTHER CHARGE FOR SALE; mine is named Customer Deposit, with a description of Deposit on Sales Order. Then create an invoice using this item and setting the custom rate to match the deposit.…

Hi @KNason76 , Another approach below starts with a Bill of Materials Revision search. With the Results page set as shown, a list of components is returned. If you remove the Group Summary Type is removed, the returned list will include the parent assembly and revision name as well. In that case, additional component…

Hi @Kenny Wise , The approach described above does work. I updated just over 400 items this morning using it, and although it is still not the most efficient approach, it was much faster and probably with better accuracy than scrolling through 30 - 50 screens to select items. The CSV update to the check box could be more…

Hi @Joy Noreen Magoling-Oracle, I too have been plagued with this issue and although I have used the Customize button to add the Item Name as a filter, I never thought about using a custom field to, in effect, use the import function to accomplish this. A quick look suggests that custom fields are exposed to this option,…

Hi, The only place I have seen to set this is where you set up your shipping carrier accounts; Setup - Accounting - Shipping. It appears you may need to change your default carrier to UPS instead of FedEx/USPS/More. John

Hi @adewage , I have used Techfino to mass delete records; the excerpt below is from a previous discussion. You can also search Techfino to find more disucssions. It is a very powerful tool that works well. This is bundle id 251197. Techfino offers a mass delete tool…

Hi, As of yet, I have not found a method that I like to handle consigned material a customer sends in that will be used in an end product sold to that customer. My latest approach is to create a consigned inventory location that is not made available for sale, but is made available to planning. I have to manually exclude…

Hi, You will probably need to remove the CD's link to the original sales order or reduce the amount of the CD and create a new CD for the balance, linked to a different sales order (or without a linked sales order). Hope this helps somewhat, John