M.Lisa Silver Medal

great! Which do you usually recommend to clients? Netsuite WMS or RF Smart? Any limitations of these that users should know about?

Hi Angela! What are your thoughts on NetSuite’s WMS?

Hello, for the amount, have you tried just using the transaction.totalamount field in the formula? REPLACE(NS_CONCAT(DISTINCT(CASE WHEN {transaction.type} = 'Sales Order' THEN {transaction.totalamount} END)),',','<br>') In the original formula you have, you are just concatenating the “transaction.number :…

haven’t tested yet but here’s an idea: Create a custom field in your item record that would store the value of the custom form. (Store value should be checked) Then create a workflow that will set the value of the custom field you created based on the value of the custom form.

Either thru a script or maybe a workflow that would set the value of the new field based on the value of the old field. though the workflow route will require you to create a new field, then inactivate the old one, since the 2 need to exist in the account at the same time to be used in the workflow.

If you have MS Excel, you can use the Replace (Ctrl + H) functionality. Steps: Open your Excel file Press Ctrl + H on your keyboard Click the "Find what:" box, then press Ctrl + J on your keyboard Click the "Replace with:" box then put in <br> Click Replace All Save the file as a CSV It is important that your initial file…

Try this: FLOOR((NVL({employee.custentity_vacation_eb},0) + NVL({employee.custentity_pto_rollover},0)) - NVL(1,0))+CASE WHEN MOD((NVL({employee.custentity_vacation_eb},0) + NVL({employee.custentity_pto_rollover},0)) - NVL({employee.custentity_vacation_time_used},0),1) >= 0.8 THEN 1 WHEN…

Hi, can you provide examples of what you mean by "rounded to the nearest .5 hours"? For example, a value of "2.25" should be rounded to "2.5"? How about "2.75", "2.6" or "2.1"?

Weird that the formula I gave you doesn't work w/o a CASE statement. It works for me. 🤷‍♀️ Anyway, the problem with the formula you are using now is that it is pulling the Internal ID of the Work Order record, but what you want is the Sales Order picking ticket, right? The Sales Order is linked to the Work Order thru the…

Answer: B

Have you tried the 2nd search I provided in my previous post? The one with adding the formula in the Criteria > Summary?

If you have Administrator Role, check your Employee record > Access > Global Permissions. You might have the 'Perform Search' permission added on your employee record, which means that you will have access to create saved searches no matter what role you are currently logged in as.

Check SuiteAnswers 1013419. The video explains the difference. 😊

AFAIK, this is not yet possible. You can vote for the related SuiteIdea # 132996. The request is about showing the total amount for Item Groups.

Hi, thanks for providing the details! 😊 You can try this saved search instead: Note that this will compare the total line quantity of the item and the quantity billed of the item on the Purchase Order. So for example, you have: 100 quantity of Item A on the PO 100 quantity of Item A on the IR 90 quantity of Item A on the…

Hi, any particular reason why you are using System Notes: Date in your Criteria instead of just Date? Just asking because sometimes Field Joins cause duplicates in results. Also, it would be helpful if you can share the Results tab of the search you created, so we can see the specific fields you used and we can try to…

AFAIK, you can't just register for an account in NetSuite, unlike here in the NetSuite Support Community. You would need a provisioned account to login to NetSuite, so you should contact your Account Manager.

Yes, you can use Global Search to search using the Serial Number, and the Warranty Registration will be pulled up. It might be possible, but you would need customization like scripts/workflows/custom fields to show it on the Sales Order since the Warranty Registration is linked to the Invoice, not the SO.

Can you elaborate on not being able to access system.netsuite.com? Do you get an error or something?

Try this in a Formula (HTML): '<a name="Print" id="Print"href="'||'https://XXXX.app.netsuite.com/app/accounting/print/hotprint.nl?regular=T&sethotprinter=T&id='||{createdfrom.internalid}||'&label=Picking+Ticket&printtype=pickingticket&trantype=salesord&whence=&print=T"target="_blank">Print</a>'

Can you also check if there is any quantity on order, quantity available and quantity committed for the item? I only saw quantity on hand and quantity allocated on your screenshots.

It would be helpful if you can provide details of how your WF is setup, so the Gurus and other interested members can try to replicate on their end to figure out exactly what you need in your search.

Hi @Erleen, According to SuiteAnswers 1017123: You can access the SuiteApp by navigating to Reports > Supply 360 > Supply 360. The SuiteApp opens in the Overview subtab of the Supply 360 page. It's not meant to be added as a tab on Work Order records.

Not really sure, but it's worth checking. If it had something to do with your transactions, then it might show up, but if it was something that the system fixed in the back end, then it might not.

For WMS, here's what suiteanswer 87139 has to say: When you save a wave, NetSuite WMS generates pick tasks from the line items of orders, or from kit components particularly for kit/package items. Although I don't have a lot of experience in this module yet, but suiteanswer 1013016 has a demo video showing that when there…

Do you have any other NetSuite tabs open? Like did you run another search or page that uses a different search? example: You first opened the Sales Order list, then opened an Item Fulfillment list, then tried to export the Sales Order list. I only asked because I think I encountered the behavior before and this is what…

Hey there, is this comment still related to your negative inventory issue? Anyway, maybe you can also consider running an Inventory Valuation Detail report and add a Running Balance column on the Quantity. This would usually show the flow of transactions and would possibly show when your inventory quantity became negative.

That is weird behavior.. Out of curiosity, I tried the search on our instance and it worked for me. Here are some steps to try and troubleshoot: Run a Transaction search with only Type = Inventory Transfer as the Criteria, check if there will be results Run a Transaction search and add Type in the Results. Sort based on…

Haven't encountered this scenario yet, but based on expected system behavior, when two Inventory Worksheets are entered for the same day and the second one is marked as "Last In the Day", the financial impact of the first worksheet will be reversed or nullified because NetSuite processes the second worksheet as the final…

Have you checked SuiteAnswers 106442 which lists the Prerequisites for this SuiteApp? Basically, you need to: Have OneWorld Enable all the features listed Install SCM Mobile If you still encounter the error after making sure that you have done everything in the list, you should consider filing a case so support can check…