Hi there Paul! For your 1st question about excluding specific locations, are you referring to Auto Calculate Re-order Point And Preferred Stock Levels, as documented in SuiteAnswers 73031? Per checking my resources, I noted that it is currently not possible to exclude specific locations. This is a system limitation and is…

Under the Criteria Tab Summary subtab, add: Summary Type = Sum Field = Formula (Numeric) Description = is 1 Formula = CASE WHEN ((SUM({quantity})+MAX(NVL({item.locationquantitybackordered},0)))-(MAX(NVL({item.locationquantityavailable},0))+MAX(NVL({item.locationquantityonorder},0)))) > 0 THEN 1 ELSE 0 END Let me know if…

Hi Roberto, I understand that you are creating a transaction saved search for Inventory Adjustments and need the Location of the transaction to show as the result. You mentioned that you used a joining field for this. Is this field called "Fulfilling/Receiving Transaction : Location"? Please note that this joining field is…

Here are the added/modified formula on the Results tab: Qty Backordered: MAX(NVL({item.locationquantitybackordered},0)) Needed Qty: case when ((SUM({quantity})+MAX(NVL({item.locationquantitybackordered},0)))-(MAX(NVL({item.locationquantityavailable},0))+MAX(NVL({item.locationquantityonorder},0)))) > 0 THEN…

Glad that we're on the right track! ? Here are the columns you can add to the Results tab of the search: For the Item Display Name and Item Type, you can find this in the Item Fields joining field on the drop down. Again, here's the formula I added/changed: Qty On Order: MAX(NVL({item.locationquantityonorder},0)) Needed…

I think we can achieve your requirement via Transaction Saved Search for Planned Work Orders. Here's what I came up with on my standard test account: By the way, I used the same item names as you provided in your initial post. I just did some sample Work Orders in Planned status on my test account to test if the search…

Hi @Umar Tanwir-Oracle, thank you for creating this poll! To our community members, appreciate if you can answer this quick poll about how your organization handles Payroll. ?

Thanks for creating this discussion, @Umar Tanwir-Oracle! ? Anyone who can share what made you decide to hire HR or Payroll specialist for your company? Feel free to comment on this thread!

Thanks Mikko! Hi Roberto, I checked my resources regarding this, and noted that even in NetSuite UI, it is not possible to set a specific Approver on the Inventory Count record. The possible reason on why this is not yet possible is because there is no separate permission for Approval of Inventory Counts. This is a system…

Thanks Emi! Hi @User_5RMAF, Kindly provide the following details so I can try and reproduce this in my standard test account: What is the costing method of the Assembly item? What is the costing method of the Component items? What is the value set in Setup > Manufacturing > Manufacturing Preferences > Average Cost…

Hi @User_DJQ3M, Welcome to the community and thank you for posting your question here! ? I checked my resources regarding this and noted that the system currently does not support Parent Matrix Items to be components on Assembly items. This system limitation is logged in Enhancement # 445836 - Allow Parent Matrix to be a…

Hi there @Kyle_Lautzenhiser-Oracle! Glad to have you back in the community and thanks for posting your question here! Please allow our gurus/members to look into this and update you for any findings. Also tagging my colleague @Micah Timbol-Oracle -- need your expertise here. ?

Assembly Item = Include Children checkbox is marked / Available to all subsidiaries Component Item = Restricted / Available only to some subsidiaries Is this the scenario that you have? Please note that as a general rule, the subsidiary field of the component items should include all of the subsidiary of the associated…

Hi there @Sonics! May we know if you are using the Demand Planning module in the system? The Demand Planning feature is used to analyze your stock demand needs. This feature also lets you determine replenishment requirements, and then create orders according to a supply plan that will add stock as needed. You can find more…

I checked my resources and it seems like this is not possible via saved search. You can check the SuiteScript Records Browser as it lists the standard NetSuite fields and their corresponding Internal ID. For the custom fields, you can view the field name/description and ID under Customization > Lists, Records, & Fields >…

Hi @rburns515, Thank you for posting your question here! Glad to have you back in the community! ? May we know if you are referring to custom fields or standard fields? Maybe you can try the SOAP Schema Browser or the SuiteScript Records Browser if this will give you the information you need.…

Hi @User_O2F3P, Welcome to the NetSuite Support Community and thank you for posting your concern here! ? Please give some time for our gurus/members to check on your concern and update you for any findings. @Camille Cagalingan-Oracle, need your expertise on this. Other members may also comment ideas which may be helpful.

Hi Roberto @User_LAGAM, Welcome back to the NetSuite Support Community and thank you for posting your concern here! ☺️ I checked my resources about being able to prevent commitment of expired lot numbers and found out that this is not yet possible in the system. This is logged in Enhancement # 268261 - Provide setting to…

Thanks Mikko! Hi @Kenny Wise, can you please provide the exact error message you receive when trying to change the component of the assembly item?

Hi @User_Q9SHI, John's answer is correct. You can click the Inventory Item in the list and it should open the form used to create a new regular inventory item. Thank you @JohnCirocco for the input! ?

Hi @markival, Thank you for posting your concern here in the NetSuite Support Community! I have checked my resources regarding your concern but unfortunately, there is no NetSuite module or bundle which allows for this requirement. The closest documentation I can find related to this is Enhancement # 136234 which is…

Thanks Mikko! Hi @Anaelena Zerpa, Per checking, I noted that that the ability for Non-Inventory Item to track landed cost is currently logged as Enhancement # 51394. This is the case because landed cost can only be tracked for Inventory Items within the system, the landed cost recognized is applied to the asset account of…

Thanks for letting us know! Glad that the 50 addresses were successfully imported. ?

Hi @farrago, Welcome back and thank you for posting your question in our community! ? Have you tried the steps in SuiteAnswers 67932 Add Multiple Customer Address via CSV Import? Note that in the instructions provided on the article, there needs to be 2 CSV files. The Primary file contains only the internal ID, then the…

Glad it worked Debbie! Have a great day as well ? ====================================== If you find my previous reply to your question as helpful, 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 aid the community to find the solution…

Thanks Mikko! Hi @User_HRB8G, I have checked this in my test account and I noticed that WMS Zones are required when creating new bins, even when creating via UI. Please note that Zone and WMS Zone are different fields on the Bin Record. Zone is used when creating Pick Strategies To create new Zone, go to Lists > Supply…

Hi @David Hali, Glad to have you back in the community and thank you for creating another discussion thread! ? I was able to test this in my test account and encountered the same behavior when the Show Display Name with Item Codes preference is enabled under Setup > Company > General Preferences. From what I gather, this…

Hi Bob! Just want to add additional information regarding the Default Accounts relating to Item Records. These default accounts will only apply for newly created Item Records. Changing the value for these default accounts will not affect the account which is already set in existing item records. Users will need to manually…

You're welcome! Glad I was able to help, Bob! ? ====================================== If you find my previous reply to your question as helpful, 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 aid the community to find the solution…

May we know what usually happens first? Is it the custom field being checked on the SO or creation of the IF?