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…

Hi @davidd039, Please note that we have deleted the screenshots you initially provided since they contained your account number. Moving forward, please redact/hide/crop sensitive information like this. Anyway, regarding your concern, can you specify what you mean by "only show the items which have additional inventory in a…

Hi @Aman Mirza, I'm glad that this worked for you! ? By the way, you can set your Notification Preferences in your Profile page so you will always be notified when someone answers or comments on your posts. Hope you have a great day! -Ivy ----- Your experience can help others make informed decisions about technology.…

Hi @OliverK, Thanks for the update! I'm glad that the search is now working as you need it to. ? Hope you have a great day! -Ivy ----- Your experience can help others make informed decisions about technology. Complete a NetSuite product review on G2 in less than 5 minutes and G2 will provide a $20 Visa.com gift card (while…

Thanks for clearing that up! I tested this on my account and was able to get it by using Applied to Transaction: Ship Via. Here's what my search looks like: Criteria Tab: Results Tab: Results page: Here's the item line of the Sales Order: -Ivy ========================= If you find this reply to your question as helpful,…

Glad it worked for you! ? By the way, it would be great too if you can update your profile with your User Name, Profile Picture, and Support Type. To know how, visit Community Tip: Updating Your Profile!

There is no known workaround for this since Item Fulfillment transaction is not exposed yet for CSV.

Yes that is correct.

To utilize the Mass Update functionality, you need to check the Mass Update Fields tab there. Only those fields that show in the Mass Update Fields tab can be updated using this functionality. Check SuiteAnswers 8419 for more information on this. However, as I mentioned, when I checked it on my account, the 'Period' field…

Hi @timjaha, Updating existing Item Fulfillments via CSV is a known system limitation and is logged under Enhancement # 164772. Currently, the documented workaround for this is to use Mass Update (Lists > Mass Update > Mass Updates > General Updates > Item Fulfillment) . Kindly note however, that not all fields can be…

Thanks for the input, @JohnCirocco! Hi @OliverK, Based on my understanding, you need to show the Quantity of the Assembly Builds as a positive number in the Results of your search. Is this correct? I am wondering why you are adding a formula in the Criteria tab of your search. If you do this, it will only filter out the…

Hi there @Wendy_M, Thank you for posting another question here in our community! Let me tag our Guru who can help you out on your concern: @Leonard Mallare-Oracle, any ideas on this one? To our other community members, feel free to comment on this thread and share your insights as well!

Hi @User_1K0CO, I ran some tests on this on my standard test account and here's the Results tab of the search I came up with: Base Formula: CASE WHEN {shipdate} = TO_DATE({today}+x) THEN NVL({quantity},0) ELSE 0 END Note: just change the x to the number of days from today. Hope this information helps! ? If it did. then we…

When I tested on my account, using Ship Via field in the Results tab of the search shows the Shipping Item whether or not the Enable Item Line Shipping is marked or not. Is the behavior different on your end?

Hi @User_6YI1X, There is a Ship Via field in the Results tab of a Transaction Saved Search. You can use this field to get the value of the Ship Via in the item line. As for the Criteria, if you want to filter to only orders with the Enable Line Item Shipping = T, then you can use the Is Multi Ship To filter. Here's a…

Hi @Aman Mirza, Per checking, the SuiteAnswers articles you provided is designed for Serialized Items (with only 1 quantity per serial number) so they might not work for you since your use case is for Lot Numbers. There is a similar thread to your concern, and you check my comment on it below: In summary, Reports/Saved…

Hi @Biomerics_Admin, If the item in a transaction (e.g. Sales Order) is expressed in another unit of measure, other than the base unit), upon creation of the Transaction Saved Search, the Quantity column would still be displayed in base units. There is are fields in the Results tab of the search called Quantity in…

Hi @Biomerics_Admin, Thank you for creating another thread! Let's see if our community members have suggestions regarding your concern. Tagging our Top Contributor for January, @JohnCirocco, maybe you have some ideas to share? ? To our other members, feel free to comment your insights on this as well!

Hi @Jeanine S., Glad to have you with us today, and thank you for posting your concern here in our community! ? I checked on your concern and it seems that your requirement is not yet possible in the system. I did find an existing enhancement requesting for this functionality: Enhancement # 328425: Bin Numbers in…