M.Lisa Silver Medal

I still think this might be related to a customization on your account. What you can do is to check what scripts/workflows are deployed on the assembly item record. You can do this by going to Customization > Scripting > Scripted Records then view the Assembly record. Check if any of the scripts or workflows deployed are…

Try using the “Location Quantity” fields instead of just the Quantity fields so you can get the Location Quantity details.

+1 on @Honey Soe’s latest comment. Try checking the custom form used by the Assembly Items.

Answer: B and D

in your formula, instead of {today}, try using the field for Date. That way, the formula will consider the date of the transaction instead of the date today.

thanks for the confirmation Tiru!!

https://community.oracle.com/netsuite/english/discussion/comment/16902971#Comment_16902971 thanks! Will this not affect current financial statements? Any best practices or things to take note of?

Also, are custom segments supported in expense allocation feature? Customer wants to be able to allocate expenses based on percentages of the total revenue per custom segment. Is this possible? Thanks!

Hi Tiru, hope you can provide some insights on this scenario: I have a client who is using NS for about 3 years now. They want to upload 10years worth of Trial Balance data in the system to serve as static reference only. This will enable them to have comparative analysis and trend insights in their reports. Is this still…

https://community.oracle.com/netsuite/english/discussion/comment/16896044#Comment_16896044 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…

https://community.oracle.com/netsuite/english/discussion/4503639/saved-search-time-entry-calculation-round-to-nearest-5 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"?

https://community.oracle.com/netsuite/english/discussion/comment/16884012#Comment_16884012 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…

Answer: B

https://community.oracle.com/netsuite/english/discussion/comment/16884006#Comment_16884006 Have you tried the 2nd search I provided in my previous post? The one with adding the formula in the Criteria > Summary?

https://community.oracle.com/netsuite/english/discussion/comment/16883974#Comment_16883974 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…

https://community.oracle.com/netsuite/english/discussion/4504191/difference-between-document-number-and-transaction-number-in-netsuite Check SuiteAnswers 1013419. The video explains the difference. 😊

https://community.oracle.com/netsuite/english/discussion/4504196/is-there-a-way-to-display-the-sum-of-the-rates-at-the-top-of-the-item-group-header 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.

https://community.oracle.com/netsuite/english/discussion/comment/16883891#Comment_16883891 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…

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…

https://community.oracle.com/netsuite/english/discussion/comment/16883858#Comment_16883858 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.

https://community.oracle.com/netsuite/english/discussion/4504013/warranty-and-repair-search-by-serial-number 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…

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>'

https://community.oracle.com/netsuite/english/discussion/comment/16883838#Comment_16883838 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.