@"Herdi Rana-Oracle" Thank you. I will vote on the "enhancement" for whatever good it does. I don't mean to appear negative, but this seems more of a deficiency than an enhancement. It just gets frustrating spending inordinate amounts of valuable time on simple things that are accomplished easily in other ERP systems I…

@"JCirocco" Good thought, thanks for the input. John

Hi @"Shamaine Chan-Oracle", I am using basic printing and have successfully added the fields to the footer of my invoice form. Since the summary box is not modifiable, I also added a screen field for Amount Paid in the header primary information until Enhancement 217539 is implemented (will vote for it). Thank you for your…

Thank you @"Herdi Rana-Oracle". I am not sure how other businesses process the creation of BOMs, but ours start out with the effective date as the current date(usually) and it may take several days to add all the components and/or to roll costs. When the Costing Report points back to the current revision's effective date,…

Thank you very much Michelle! John

No, I was just trying to source it from the Current Standard Cost field, but it was not presented as a source option. I am using multiple locations, but at this time not too concerned about the individual Location Standard Cost. I have a main location that I can probably use for a summary search and see how that works out.…

In the event anyone looks at this thread trying to determine how to perform something similar, the code snippet below is the final for loop code that worked: for(var i=0; i<searchResult.length;i++){ var piItem = searchResult[i].getValue({name:'itemid', summary:'GROUP'}); var piDesc =…

Hi @"Mikko De La Fuente-Oracle", I am at the point where the portlet is populated with the columns and if I define a discrete var in either the "for loop" or the "row" definition, the discrete var is passed to the output. Otherwise the variables defined in the "for loop" return no data and log.debug shows them as returning…

Thank you Mikko. I was able to create the script record with this. Interestingly, I used both Notepad++ and Eclipse on the code, and input from one or the other of them; in conjunction with NetSuite's upload validation, got me to what I originally posted. I'll study what you provided and hopefully learn some more. Thanks…

Hi Mikko, Is the modification below what you meant? ...... {columnid1 : 'value1', columnid2 : 'value2', columnid3 : 'value3', columnid4 : 'value4', columnid5 : 'value5'}] }); }; render: render return }}}))); ........ When trying to upload the script file after this mod, I get this error: Fail to evaluate script:…

Robert, I am logged on as Administrator and SuiteIdeas is the only area I am seeing this problem. So far, attempts to change the PW are unsuccessful, as it will not accept my current or previous PW as the "old" PW. Thanks, John

HI Robert, Any ideas on what is causing this issue? SuiteIdeas is forcing a password change because my password expired(?). I tried the steps you suggested in your previous response, but I am not allowed to save my employee record. Instead, I am redirected to a Request New User dialog box. Thanks, John

Thank you Pauline. John

Hi Michelle, Thank you for your response. I will vote for the enhancement. When I create a custom center, is there any way to suppress the creation of the Support tab? This is not desirable for an outward facing scenario. Thanks, John

Yes, the screenshot below shows a sample of setting up phantom items on a BOM using the Item Source field. Items may also be set up as phantoms at the item level. John

Martha, in case your data does not have all possible scenarios and you are basing the success of "Maximum" on the one example... I added Location On Hand to a report I use and this field's value is incorrect when I use Maximum as opposed to Sum. I would think the Location On Hand would act the same, but I am using Bins and…

Martha, I have used TechFino's mass delete tool for just this purpose and it works very well. You can install bundle 251197 and a link to more info is below. John Sorry, picked up the wrong link somehow... https://www.techfino.com/blog/netsuite-mass-delete-tool

Problem solved: For whatever reason during our implementation (need to review) we had to create a custom transaction line field, "Item Number", sourced from the Item: Name field, that is used on the Sales Order and Quote custom transaction forms. When set up it was not applied to the Opportunity Items, resulting in it not…

Thanks Chris - will give that a try. John

The case where custom fields were affected is all I saw too. No scripts are running. We only have basic support, so trying to submit a case is a last resort - getting close though. Thanks Robert. John

Update: With help from the NetSuite Professional group on Slack.com, this is how the work order number (tranid) was retrieved. Apparently the N/currentRecord module does not work very well in view mode, so the N/record module's record.load function was used with var woId (created from N/currentRecord module) pointing to…

Thanks Chris. This is worth pursuing; I need to check the Brady printer specs, but I believe it recognizes ZPL. John

In follow up; it appears NetSuite performs the automatic lead time calculations over the weekend time frame. John

Very powerful and useful tool!

Glad it worked out. Those types of issues can drive you crazy. John

Hi Chris, As a point of reference, are you able to IA out something less than the whole quantity; perhaps -186.0? John

I have confirmed that the calculation is performed for each receipt and averages up to the last 3 receipts. I cannot determine when the calculation occurs, but appears to be complete for my receipts through 6/28. I have receipts from 7/1 & 7/2 that are not in the calculation yet - will keep an eye on them to see when the…

HI, I was out of the office the end of last week and could not get back to you. Your settings look correct. How long has your NetSuite been live? I recall thinking it took a long time to start seeing calculated lead times. Do any items you are looking at have multiple receipts? And are the POs closed or fully billed? The…

Chris, I agree. I have also seen where the lead time is extremely exaggerated when you have a "Blanket" PO set up with multiple lines of the same item with weekly or monthly scheduled receipt dates. The lead time gets progressively longer at each receipt. John

A couple of things to check: Make sure the Lead Time and Safety Stock Per Location box is checked. Setup > Accounting > Inventory Management Preferences. Make sure that the POs have a Location associated with them. If those are not the issue, let us know. John