Ivy Lopez-Oracle NSC Guru

Hi @User_RHKAB, When I tested this one on my account, it was excluding weekends. Can you send a screenshot of the results tab showing the following fields: Date Created Actual Ship Date Formula (Numeric) with the formula provided Formula (Percent) with the formula provided

Hi @Tom Dalton, Can you provide more details on what you are updating in for the Matrix Items? What exact fields are you trying to update? I am trying to replicate the error on my test account so it would be much appreciated if you can provide the steps you took to encounter this error.

Hi there @User_RHKAB, Were you able to test the solution I provided in my previous comment? Let us know if it was able to resolve your concern or if you need further assistance on this one. -Ivy

Hey there @Dallas H, Good to see you again here in our community! ? Regarding getting the results to show the quantity/amount sold per month, I have a related discussion which I posted: Although the title says "Items Shipped by Month, this can also be applied to get information like Quantity Sold, Received, Returned,…

Hi @Martha Hakes, I checked on this and noted that this functionality is not yet available in NetSuite. Currently this is logged under: Enhancement 68529 Price Levels > Allow users to create price levels that calculate based on an item's cost instead of your entered base (selling) cost. Currently, Price Levels in NetSuite…

Hi @sanimesa, Thank you for posting your concern here in our community! Allow us to check on your concern and we'll get back to you with our findings. Also tagging our Gurus who can help you out on this one: @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any insights you can share? To our other members, feel free to…

Hi @JohanvL, Thank you for posting your concern here in our community! We'll be checking on this and we'll get back to you with our findings. To everyone, feel free to comment your insights on this.

Hi @User_MC441, I agree with @John Griffin that the CSV Import for negative and positive adjustments should be done separately. Additionally, can you try using the Internal ID of that Inventory Status instead of the name? You can find the Internal ID by checking Lists > Supply Chain > Inventory Statuses. Then make sure to…

That is correct. Based on my testing, when I try to set the BOM to blank/null, I get this error message: Please enter value(s) for: Bill of Materials I did some further research about this but I could not find any documentation about unlinking or removing BOMs from Assembly Items by bulk. However, I tested it on my test…

Hi @KNason76, I think the one of the comments in your previous post is applicable to this one: Based on my testing, you would first need to disassociate the BOM with the Assembly Item. To do this, a CSV Import for the Assembly Item is needed to be done first. Here's my sample Assembly Item: Notice that it has only 1 BOM…

Hi there @User_RHKAB, I did some tests on my account and here's the formula I came up with: Formula (Numeric): CASE WHEN (ROUND(({actualshipdate}-{datecreated})/7*5 + MOD(ROUND({actualshipdate}-{datecreated}), 7)) - (CASE WHEN TO_NUMBER(TO_CHAR({actualshipdate},'D')) < TO_NUMBER(TO_CHAR({datecreated},'D')) THEN 2 ELSE 0…

Hi @NitinEOH, Per checking, there is currently no way to automatically calculate and update the Item Classification field. I did find an enhancement request related to this which you can vote for on the SuiteIdeas page: Enhancement # 610991 : WMS > Ability to auto calculate and populate the Item Cycle Count ABC…

Hi there @Jay Schwausch, Glad to have you back with us today and thanks for posting your question here in our community! You are right that there is a character limit in formula fields. There is an enhancement related to this one: Enhancement # 287420: Saved Searches > Formula Fields > Increase the character Limit…

HI @eleran, Did we help in your concern? If you have clarifications related to this, let us know. -Ivy

Hi @Tom Dalton, It is standard behavior of the system that 1 Work Order will be created per item line in the Sales Order. So if you have a dozen line items in the Sales Order, there will also be a dozen Work Orders created, even if it is the same item. However, if you only have 1 line item in the Sales Order, but for 12…

Here's the Criteria and Results tab of the search I tested: Results page: Note that if you run this search, it can only show the total completed quantity per Work Order. As mentioned, it is still an enhancement to get the value of the fields per Work Order Completion.

Hi @User_8P1E0, I tried this on my test account and was able to reproduce the same behavior. Upon further checking, it seems that this is currently a system limitation and is logged under Enhancement # 252217. You can vote for the enhancement on the SuiteIdeas page. If the search criteria has Type = Work Order Completion,…

Hi @jmack_admin, Does the Item Receipt have a GL Impact? If not, then this behavior might be related to the Generate Accruals Preference on Non-Inventory Items. You can watch this video to learn more about the behavior and how to resolve it: Hope this information helps! ? If it did. then we would greatly appreciate if you…

Hi there @Tlarkin, Glad to have you with us today and thank you for posting another question here in our community! I checked on this and it seems your requirement is not yet possible. I did find an existing enhancement requesting for this functionality: Enhancement # 456523 : Automatic Location Assignment = T > Default…

Hi @Biomerics_Admin, Thanks for creating another thread here in our community! ? Tagging our gurus who will be assisting you in this one: @Dominica Sevilla-Oracle / @Ely Gulen-Oracle, any ideas? To our other members, feel free to comment your insights here as well!

Hi @eleran, I agree with @John Griffin's answer. You can set the Primary Purchase Unit in the Item Record, and you can also set the Purchase Price per Vendor. The Purchase Price you enter should be based on the Purchase Unit. Then, when you create a PO, the Purchase Unit will default and the Purchase Price will depend on…

Hi @Asher_123, This can be done in either an Item Saved Search or a Pricing Saved Search. You need to use the Formula: Item Search = CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitprice} ELSE 0 END Pricing Search = CASE WHEN {pricelevel} = 'Name of Price Level' THEN {unitprice} ELSE 0 END Here's…

Hi Oliver, I think the simplest way to know if you are using OneWorld is if you are using Subsidiaries. Anyway, I'm glad I could help! Have a great day as well! ? -Ivy

You can submit a Support Case for it to be further investigated on your account.

Hi @davidd039, Do you still need help with this? We'll be waiting for the requested information in my previous comment.

Hi @OliverK, Are you using a OneWorld account? It seems that for OneWorld accounts, the ability to set a beginning Quantity on Hand for new Items is not possible and this is by design. This feature is currently filed as Enhancement # 169533: OneWorld > Items > Allow entering an initial quantity on hand per location. I…

Hi @User_QG2Y6, If that preference is already blank, then you can check if there are any scripts or workflows deployed on your account that may be causing this behavior. If there are none and you are still having this warning, then I recommend filing a Support Case so this can be further investigated in your account.

Hi @User_6YI1X, Were you able to check this? If the information provided in my previous comment was helpful. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer easier. Hope…

Hi @phbryan, Try this formula: (TO_DATE(TO_CHAR({custbody_rfs_endtime}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') - TO_DATE(TO_CHAR({custbody_rfs_starttime}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS')) Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on “Did…

Hi @User_QG2Y6, There is a preference for this called Days Before Lot Expiration Warning. You can find this under Setup > Accounting > Accounting Preferences > Items/Transactions > Inventory. If you want to turn off the pop up warnings/alerts, then you need to set the preference to blank. However, note that since this is…