John Griffin Silver Trophy

Hi @Wee Ming, "Have you tried using this saved search condition trigger on After Record Submit and Event Type as Create ? I have used SS condition for newly created records before and the trigger on need to be after record submit." That makes sense; I will keep that in mind the next time I use a SS condition. Thank you for…

Hi @Wee Ming, The Transfer Order is using the standard Ship To addressee field, although it is not a stored address and is entered from the custom option of the drop down list. I revised the formula to use {shipaddressee} which also evaluated to FALSE. I went back to the Condition Visual Builder to go through the available…

Hi @User_VZ83X, It will help in troubleshooting if you can provide examples of your templates and field mapping. The information below may be helpful. Inventory Adjust Multiple File Set UP When dealing with files containing SN/Inv Number data, positive and negative adjustments must be imported separately and correctly…

Hi @Wee Ming, Since this was not among the formulas I already used, I tried the formula, INSTR(NVL({addressee},0),'Transf')=0, which also evaluates to FALSE. Thank you for your suggestion and please let me know if you think of anything else. John

Hi @Angelica Mae Segador-Oracle, I am trying to set the value of a transfer order’s custom body field with specific text when the transfer order addressee is a specific entity. As a higher level check, without the condition, the workflow will update the custom field on any transfer order that is created or edited. With the…

Hi @katherine_15328, Within website setup there is a checkbox to show the cookie consent banner. When checked, the banner is displayed at the top of the landing page and covers the Login and Register buttons until clicked to close the banner. The only control you have over this function is to display it or not. John

Hi @User_Z8QTG, You need to edit the employee record of the employee that left to free up the license. On the Access tab of the employee record, remove the check from the Give Access box. You may then check this box on the other employee's record. John

@Nickey, I do not have an answer. Our use case is mainly to facilitate return and repair of product, without processing a CM. We just close the RMA and ship the customer owned product back out on a $0 SO. John

@Nickey, I believe the register is a running record that is not cleared. Only the status is updated to Closed. John

Hi @Nickey, From your description, it appears the CM was created outside of the RMA. From within the RMA record there is a refund button that creates the associated CM. Alternatively, you can just close the RMA. Hope that helps, John

@User_EIUIZ, The custom template does not; only the standard template. John

Hi @User_EIUIZ, I am pretty sure that NetSuite's native check printing process is hard coded to utilize checks purchased from NetSuite - or at least a check in the same format. I found this out at implementation and was just recently reminded when I created a custom template to make slight adjustments to the print…

Glad you got it resolved. John

@User_Q0SW6, Good luck. Let me know if I can clarify anything. John

Is the Description on the Criteria tab populated?

@User_Q0SW6, You can modify this search as needed - I have some custom fields that you will not. The results may be exported to CSV, Excel, or PDF. The Full CSV EXPORT navigation from the HOME screen is: John

Hi @User_Q0SW6, If you are using Advanced BOM, I have a Saved Search I can share with you that the results can then be exported. There is also a FULL CSV EXPORT function that I have not used and do not know what that includes in the output. John

Hi @ThomasOPT, If you have not already, check to see what your Purchase Price is showing under the Item Record's Vendor sublist. If the UOM was updated from EACH, that value probably increased by a factor of 5. John

@Tom Dalton, I am seeing the same issue. I know the tracking worked last week. I just set up UPS OAuth authentication yesterday and my integrated UPS labels are being generated as expected, so I am not sure if the tracking issue is related or not. John

Hi @User_JNKPT, The discussion below indicates that active tokens do not expire. Otherwise, having no shipment activity within a 60 day period, tokens will expire and need to be refreshed through the shipping set up page. John

Hi @User_CTUW2, I think the Internal ID is taking precedence over the External ID and since the new records do not have an Internal ID, they are getting lumped together. If you have assigned External IDs to the existing records, I would try mapping only the External ID field. Alternatively, I would map only the PO # field.…

Sam, Addressing the lack of an item revision level was one of the first customizations we made at NetSuite implementation. We created a Custom Item Field that is populated with the current revision of all Inventory and Assembly items. The custom field was then added to all transaction form templates. When we have a…

Hi @Dext3r, I may be off base here, but your description leads me to believe you are processing the purchase of the assembly item via Outsourced Manufacturing, which unless you are having outside operations performed on components you are providing the vendor, is not needed. I would check the state of the ALLOW PURCHASE OF…

Great! Glad we found a solution. John

Brian, Have you tried using only 1 import file? Realizing I cannot see this set up in my system, it seems that since you are not trying to create new member items, the optional file is not needed. Are you able to map column Y in your primary file, that contains the existing member item, to the member item field? John

Brian, I do not have a way to check this, but SuiteAnswer #68142 may be of help. While it is discussing replacing components, at step 8 you can select Add instead of update and ignore steps 9 and 10. The subsequent steps concerning file set up and mapping should be the same for adding or updating.…

I almost asked that question first in my original comment and after seeing your files they did not appear consistent with Advanced BOM. I do not have experience with Legacy BOM and do not have any suggestions as to the action you should take to resolve this issue. My apologies if I have wasted your time. John

Brian, are you using Advanced BOM, that utilizes a BOM and BOM Revisions? (As opposed to Legacy BOM).

Hi @Brian Finlay, Can you share screenshots of your import templates and your import mapping? Are you trying to associate a common BOM/BOM Revision to multiple Assemblies? If so, check that the BOM is set to Available for all assemblies. If you are associating individual BOMs with each Assembly Item, having the same single…

Hi @User_M4JOC, Are you attempting to import the BOM and the BOM Revision at the same time? Although this can be accomplished, over time, I have found using a two step approach works well. I import the BOM, associating it with the Assembly first and then import the BOM Revision, associating it with the BOM. Can you share…