Puede empezar con esto: Fórmula (numérica) = CASE WHEN (to_char(LAST_DAY({today}) + N,'D') = '7') THEN LAST_DAY({today}) + N + 2 WHEN (to_char(LAST_DAY({today}) + N,'D') = '1') THEN LAST_DAY({today}) + N + 1 ELSE LAST_DAY({today}) + N END Nota: reemplace + N según sus necesidades.

Hi @Sonics, Thank you for posting another question here in our community! Allow our gurus to check on this one: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle, any ideas? To our other members, feel free to share your insights as well.

Hi @Dirk Nieuwkamp, I checked on your concern and found an enhancement related to this: Enhancement # 688961: Time phased Items> Generate Item Supply Plan > System does not consider existing supply to cover all demand prior suggesting to create new planned orders You can vote for this enhancement in the SuiteIdeas page. To…

Hi @User_NC62U, Thanks for posting another question here in our community! Our gurus will check this one and get back to you with more information. To our other members, feel free to share your insights on this too.

Hi @User_NC62U, Thanks for posting another question here in our community! Our gurus will check this one and get back to you with more information. To our other members, feel free to share your insights on this too.

Hi @User_AHJ5A, Welcome to the NetSuite Support Community! We're glad to have you with us today and thank you for posting your question here. 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 comment your insights on this as well.

Hi @Rachel Sheng, There is a Difference between Created From Joining Fields and Applied To Transaction Joining Fields in Transaction Saved Search. The Created From fields source the data from the Main Line of the transaction it was created from. The Applied To Transaction fields source the data from the Item Line of the…

Hi @Benjamin Paul - USA, As documented in SuiteAnswers 28034: Inventory Turnover Report, the average inventory value is calculated as follows: Average Inventory Value = [SUM (on hand value on the last day of each month) / # of months in period] You can refer to SuiteAnswers 28034: Inventory Turnover Report for more…

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

Hi @Andrew Malek, Thanks for posting your concern here in our community! I agree with @Edwards_05 that this one is hard to check without looking into your account. Have you tried creating a support case for this one? It is weird that the fields are greyed out in edit mode, which sort of hints that a script/workflow might…

Hi @User_YMWNR, Glad to have you with us today and thank you for posting another question here in our community! Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members, feel free to share your insights as well.

Hi @User_75YL8, If you want to add a "View" link that opens the actual User Note, you can do so using a Formula (Text) field in the Results tab: Formula used: '<a href=https://' || 'system.netsuite.com/app/crm/common/note.nl?id=' ||{usernotes.internalid}|| '>View</a>' Hope this helps. 😊

Hi @Edwards_05, Glad to have you with us today and thanks for posting your concern here in our community! Allow our gurus to check on this and get back to you with further information. To our other members, feel free to comment your insights on this as well.

Hi @User_75YL8, Thank you for posting another question here in our community! You can try the suggestion provided by one of our members if that would work for you. Our gurus will also be checking on this one and will provide feedback soon. -- Hi @Edwards_05, Thanks for providing your insights on this one! We really…

You're welcome, @Karanjot Singh! Glad I could help. 😊

You're welcome, @Betsy Vance! Glad I was able to help. 😊

Hi @KNason76, According to the NetSuite Certification Policy, notice of exam availability is emailed to address on file for all current status holders. For more information, you can visit the NetSuite Certification page, NetSuite Certification FAQs, or Contact NetSuite Certification Team.

Hey there @Betsy Vance, Based on the error message you shared, you are encountering the error because of Permission Violation: You need a higher permission for custom record type SCM Preferences to access this page. To resolve the error, try adding the mentioned permission to the custom role: 1. Using the Administrator…

Hi @User_YLQQA, Were you able to test what I mentioned in my previous comment? If it worked for you and you found it helpful to your question, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to help other community members who might have…

Hi @Jeanine 2022, Thank you for posting your question here in our community! Allow us to check on our Gurus who specializes in this area and we will get back to you the soonest time possible. Any members who has an insight on this, please feel free to reply to this thread.

Hi @CDuf, We're glad to have you with us again today and thank you for posting your question here in our community! @Micah Timbol-Oracle / @Katerina Winklerova-Oracle will be checking on your concern and they'll get back with more information. To our members, feel free to share your insights on this as well!

Hey there @User_41YFV, Welcome to the community! We're glad to have you with us today and thank you for posting your question here in our community! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, feel free to share your insights on this!

Hi @Karanjot Singh, You can use this formula: ((CASE WHEN (FLOOR(({fieldforendtime}-{fieldforstarttime})*24)) < 0 THEN FLOOR(({fieldforendtime}-{fieldforstarttime})*24)+24 ELSE (FLOOR(({fieldforendtime}-{fieldforstarttime})*24)) END)*60) + (CASE WHEN MOD((({fieldforendtime}-{fieldforstarttime})*1440), 60) < 0 THEN…

Hi @Rachel Sheng, I tested this on my account and had the same behavior when the transaction search has Type = Item Fulfillment in the Criteria. This seems to be the standard behavior since the value of this field in the Item Fulfillment is being sourced from the Sales Order, which is similar to the behavior of having the…

Hi @Rachel Sheng, Usually, the reason why custom fields return null/blank on saved searches is that the "Store Value" is unmarked in the custom field. This behavior and a possible workaround is discussed in the following SuiteAnswers articles: 29291 - Custom Field Displays Blank Values on Saved Searches When Store Value Is…

Hi @User_CS3KK, Just wondering if you were able to check Jack's comment. If it was able to help in your concern, then we would appreciate it if you can click "Yes" in the "Did this answer the question" on the previous comment. Doing so,you’ll be able to help other community members who might have the same concern find the…

Hi @User_YLQQA, The steps should still be similar to what was mentioned in the video and SuiteAnswers 62364. The only difference is that the first adjustment should be a positive/adding adjustment since the Location On Hand is less than the Bin On Hand. Step 1: Unmark Use Bins in the Item Record Edit Item Record Under…

Hope the provided information in previous comments helped in your concern @Benjamin Paul - USA. Appreciate if you can also click "Yes" on the "Did this answer the question?" below the comment/s that were helpful.

Hi @Betsy Vance, The only way we can add columns on the Bill of Materials Inquiry page is to click the Customize button: Under the Additional Columns, check the Include box next to Display Name and Type. The page will now show the columns you included at the right most part of the page: However, this must be done per user…

Thanks for providing this @Ivan Griggs UK! Hope this information helps in your concern @Benjamin Paul - USA. Appreciate if you can also click "Yes" on the "Did this answer the question?" below the comment/s that were helpful.