Ivy Lopez-Oracle NSC Guru

Hi @User_G2AF5, Glad to have you with us today and thank you for creating another thread in our community! Usually, Line ID = 0 is the Main Line of the transaction. However, for Item Fulfillment transactions, as per design, there is no separate "Main Line" thus the first line (Line ID 0) is being considered the main line.…

I sent you a private message with a link of the file you sent which I converted to a CSV (Comma delimited) format. Kindly try that and check if it will still give an error.

I noticed that the file was saved as CSV UTF-8 (Comma delimited) format. Kindly try to save the file as CSV (Comma delimited) format then check if the import will still result in an error.

I saw your private message and I downloaded the file. Let me test it on my end, and I'll update you in this thread.

Hi @farrago, Are you doing the import via (1) Setup > Import/Export or via (2) Vendor Record > Financial tab > Items subtab > Import Price List button? I tried (2) in my test account, but was unable to reproduce the error you mentioned. Can you also provide the CSV file you were using?

Hi @Ancana, Glad to have you with us today and thank you for posting your concern here in our community. @Shamaine Chan-Oracle and @Dominica Sevilla-Oracle will be helping you out on this one. Anyone else have the same scenario? Feel free to share how you handle it in the system!

Hi @User_FZNHI, Glad to have you with us today and thank you for posting your concern here in our community. Tagging our Gurus who will be collaborating with you on this: @Micah Timbol-Oracle / @Emilia Ironov-Oracle, any ideas on this one? Anyone else with insights on this concern? Feel free to join in the discussion!

Hi @dle_35705, I checked my resources about your concern and noted that this is not yet possible in the system. There is an enhancement request logged for this functionality: Enhancement # 487059: Setup > Users/Roles > Manage Roles > Please have the ability to restrict users from fulfilling or doing inventory transfer from…

Hi Dallas, I do, in fact, play as a wizard in D&D sessions with friends, so maybe that's why? ?✌ Kidding aside, I think attending the NSC Webinar about Saved Search Formulas helped me out a lot! If you have time, you can check out the summary of the webinar in this thread: WEBINAR SUMMARY: Learn Handy Tips and Tricks on…

Hi @User_BQ1O5, Welcome to the community! ? Thank you for posting your concern here. Allow me to tag our gurus who will be assisting you in your concern. @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle / @Jeff Pineda-Oracle, any ideas about this? Anyone else have insights or suggestions, feel free to join the…

I think we can achieve it by using expressions in the Criteria. We can look for those items with Location Available Qty equal to or less than 0 OR Location Available Qty is less than the Location Safety Stock Level. Here's the revised Criteria for this: Make sure that the Use Expressions checkbox is marked. Also, the…

Hi there @Dallas H! It's good to see you again here in our community! ? Kindly try if this Item Saved Search will fit your requirement. Criteria tab: Formula: CASE WHEN NVL({locationquantityavailable},0) < NVL({locationsafetystocklevel},0) THEN 1 ELSE 0 END Results tab: Note: You can add or remove fields as necessary.…

Hi there @Tybrneryan, I have checked this on my end, and noted that the main function of the Engineering Change Order records is to document changes to your Bills of Materials (BOMs) and authorize the implementation of those changes. It does not support creating new items with their own name/IDs and specific BOM. I also…

Hi @User_4HDGW, Welcome to the community! Thank you for posting your concern here! ? Our Gurus @Patrick Fresnosa-Oracle and @Micah Timbol-Oracle will be collaborating with you on this one. Other members, feel free to join the discussion by commenting your insights/ideas about this.

Hi there @User_Q2U93, Thanks for creating another thread here in our community! Allow me to tag our Gurus @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle / @Jeff Pineda-Oracle who have expertise on your concern. Has anyone else tried to request Beta API access? Feel free to comment or share your experience here!

Hi @Tybrneryan, Thank you for creating another thread in our community! Tagging our Gurus with expertise on your concern: @Pauline Joy Cac-Oracle / @Jack Daryl Espiel-Oracle / @Mikko De La Fuente-Oracle / @Erick Dela Rosa-Oracle , any idea about this? To other members, feel free to join the discussion by commenting your…

Hi @Tybrneryan, Glad to have you with us today and thank you for posting your concern here in our community! ? Allow us to check this and we'll get back to you with updates. To our other members who use this feature, feel free to comment your insights about this.

Hi @imvsom, You are correct that receiving the free items at $0 cost will affect the average cost while allowing overage on item receipts will affect the bill amount. Instead, you can consider creating Inventory Adjustments to add the freebies from vendors to your inventory stock. The Adjust Inventory form enables users to…

Hi @User_LYA61, The main purpose of the created saved search is to send an email alert to the specified recipient/s if the Ship Date on an existing Sales Order has been changed. If you want to use the saved search to show only the changes in the Ship Date field, you can try this criteria: Let us know if this will work for…

Hi @User_LYA61, You can try this saved search that will send an email if the Ship Date field on the Sales Order is changed: 1. Go to Lists > Search > Saved Searches > New 2. Select Transaction 3. Add the following under the Criteria tab: 4. Add the following under the Results tab: Note: You may add other fields as…

Did you press Enter or Tab on your keyboard after you input the Inventory Number?

Thanks Emi! Hi @hunter, I think the reason why "Quantity" fields return 0 or no value is because of the Account included in the Criteria of the search. I tried this in my test account and I noted that if the there is no Quantity on the line of the Landed Cost Account. Can you try removing the Account in the Criteria tab,…

Hi @User_LYA61, Glad to have you with us today and thank you for posting your concern here in our community! ? I think that we can achieve your requirement by creating a saved search that will send an email notification if there is a change in ship date. Can you confirm please what specific field the ship date is based on?…

HI @wittekgolf, I don't think this is possible in the NetSuite UI without doing heavy customization or using 3rd party applications. However, you may explore the Manufacturing Mobile SuiteApp if this can provide what you need. We recommend to test the SuiteApp in a Sandbox or a Development Account first before using in…

To answer the question of the thread starter, it is not possible to include "Other Charge Items" in the Order Items Page. This is because this page suggests the quantity to order based on the preferred stock level and quantity of open backorders, or quantities scheduled on blanket purchase orders. In other words, only…

Hi Tiina, Per checking my resources, I noted that the ability to customize the Order Items page to add custom fields in it is not yet available in the system. It is documented in: Enhancement # 94794: Order items > ability to customize this screen You can vote for this in the SuiteIdeas page. The Customize button in this…

Hi @KNason76, Glad to have you with us today and thank you for posting your concern here in the community! You can try the solution that @Martha Hakes and @John Griffin provided if those will work for you. Just a note for John's solution, it would require the Advanced Bill of Materials feature to be enabled on the account…

You're very much welcome! I'm glad we were able to make it work! ?

Kindly try this formula if this will give what you need: (NVL({quantityonhand},0)+NVL({quantityonorder},0)) - (NVL({quantitybackordered},0)+NVL({quantitycommitted},0)) ====================================== If you find this reply to your question as helpful, others with the same question might find it helpful as well. By…

Hi Martha, Do you need this per Location or the total for all locations?