Hi @User_NG5TG, Welcome to the community! 😊 Glad to have you with us today and thank you for posting your question here. You can try using Formula (Numeric) fields with the below formula: Days past expected: CASE WHEN {expected close date field} < {actual close date field} THEN {actual close date field} - {expected close…

Per checking, emailing the workbook in pdf format is not yet supported. This is tracked under the Enhancements 542183 & 546523. You can vote for these in the SuiteIdeas page.

Hi @User_E1GW7, You can add both those fields in your dataset and use them in the chart. Here's an example I created in my test account:

Hi @User_E1GW7, By "Location", do you mean the Country or State? Anyway, you can try using the Address fields, and use the Country or State or any of the other fields there and check if it would get you the Location that you need.

Hello @Benjamin Paul - USA, Note that you can not enter a Service for Purchase item in a Sales Order. As the name suggests, it is only available to be entered in Purchase Orders since it is a Service for "Purchase" item. "Discount" Items are Item records that are used to help you with transaction management for selling and…

Hi @Dirk Nieuwkamp, I have tested this on my account and I have the same behavior when I input Special Order Sales Order/Work Order for the item. This seems to be the standard behavior for these type of transaction since the Work Order is linked to the Sales Order, which means that the demand quantity from the Sales Order…

As mentioned, there is no documented workaround for this yet. You might need to consult with your developer or account manager for possible engagement with professional services team regarding a customized solution for your account.

Thanks for the update, @FazeprooF!

Hi @FazeprooF, Thanks for checking and updating this thread. Let us know if you need help with creating a support case. Or if you already created one, it would be greatly appreciated if you can also update this thread with Support's findings. I'm sure this will be helpful to others who might encounter the same behavior.

Hi @User_Q1DPO, Per checking, CSV Import of UOM records are not yet supported in NetSuite. There is an existing enhancement related to this: Enhancement # 286213: Setup > Import/Export > Import CSV Records > Ability to import Units Of Measure You can vote for this enhancement via the SuiteIdeas page. There is no documented…

Hi @User_EVVPG, Glad to have you with us today and thank you for posting your question here in our community! Allow me to tag our gurus who have the expertise on this topic: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle, any ideas? To our other members, feel free to comment your insights as well.

Hi @User_CS3KK, Glad to have you with us today and thank you for posting your question here in our community! Allow me to tag our gurus who have the expertise on this topic: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle, any ideas? To our other members, feel free to comment your insights as well.

Hi @NKusiak, I'm glad the formulas work! You can use another formula to get the email address to show as all lowercase letters, that way, it will be treated as the same email address. The formula you can use is: LOWER({email}) so your search results should look something like this:

Hi @Rachel Sheng, Were you able to check my previous comment? Let us know if you need further assistance on this one.

Hi @KNason76, The Detail Frequency (Lot) in the Quality Inspection is not specific to only Item Receipts, but can be used on other transaction types like Item Fulfillment as well.

Hi @FazeprooF, This is a new feature in NetSuite and I was unable to find specific documentation regarding the error or the behavior your are encountering. That being said, you can still check the following: Employee record - if there are any Subsidiaries/Locations set Custom Role record - make sure the permissions…

Hi @User_C6XDE, Per further checking, it seems that this is a current system limitation and is logged as: Enhancement # 524401 Item Location Configuration search > Be able to use or expose the Item Fields Since the Item fields are not exposed on the Item Location Configuration search, the same is true for the Item Search…

Hi @Martha Hakes, Thanks for the update! You are correct that the Est. Ship Date or the Expected Ship Date in the transaction item lines is listed as "Ship Date" in Sales Orders. However, please note that the Ship Date field may result in different values depending on whether it is on Main Line or not. If Main Line = T,…

Hi @User_C6XDE, In an Item Saved Search, there isn't an Item Location Configuration join. This is because without enabling the Advanced Item Location Configuration feature, the fields are part of the Item Record > Locations sublist. When using an Item Saved Search, you can use the fields that start with "Location" in the…

Hello @User_SIXKD, You can create an Item Saved Search and use the following fields in the Results tab: Hope this helps.

HI @Preethi Kondur, Glad to have you with us today and thank you for posting your question here in our community! Our gurus will be checking this one and we'll get back to you with more information. To our other members, feel free to share your insights on this as well.

Hi there @JPrice, Thank you for posting your question here in our community! Allow me to tag our guru who has expertise on this: @Leonard Mallare-Oracle, any ideas? To our other members, feel free to share your insights on this as well.

Hi @JohnCirocco, Thanks for posting your concern here in our community! Allow our gurus to check on this one and we'll get back to you with more information. To our other members, feel free to share your insights as well.

Hi @Dirk Nieuwkamp, Yes, this should be supported by Material Requirements Planning feature. Also, apologies for the confusion. Per further checking, it seems that the enhancement I provided was referring to ALL existing supply, even after the date range. I did some additional tests on my account and it seems that existing…

Hi @PP US, Per checking, there is no standard way to set this up in NetSuite. There is a related enhancement requesting for this functionality: Enhancement # 184294: Ability to select "Free Domicile" Billing Option for UPS International Shipping to charge for Duties and Taxes You can vote for this enhancement in the…

Hi @Rachel Sheng, It shows in the item lines on my end. Here's an example: Sales Order line: Item Fulfillment line: Search results page: Notice that in this transaction with 2 line items, the custom column field value still shows for both the item lines, but not the lines with the account. This is standard system behavior.…

Si compró una edición Suite Success de NetSuite, "debería" haber paneles estandarizados para los roles predeterminados.

Parece que el campo Fórmula (texto) tiene un límite de caracteres de 4000 y por lo que he visto, la fórmula tiene más de 5000 caracteres. También encontré una mejora relacionada con esto que puede votar en la página de SuiteIdeas: Mejora no. 287420: Saved Searches > Formula Fields > Increase the character Limit (Current is…

Una vez verificado, la capacidad de exportar libros de trabajo de SuiteAnalytics a un archivo CSV sigue siendo una mejora propuesta en NetSuite. Aquí están los detalles de la mejora: Mejora 546523 Pivot Report > ability to export to Excel, CSV and PDF Solución alternativa: exporte el conjunto de datos a un archivo CSV y…

¿Qué tal utilizar la función REPLACE (REPLACE(char, search_string [, replacement_string ]) )? REPLACE('123-4567-8901-234-567','-')