Hi @Micah Timbol-Oracle, I noticed that you usually say "CHEERS!". What's your favorite drink and why? ?

You're welcome, Jay! Glad I could help! I agree with you that sometimes it can take a while to find the right fields to use in saved searches, but know that the community is always here to help do just that. ? By the way, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the…

Hi @Jay Schwausch, My bad, it kinda slipped my mind that we were looking for the quantity of the Kit's member items. So we need to use the Inventory Location of the member items in the criteria as well. Try Member Item: Inventory Location instead. Let me know if this works. -Ivy ========================= If you find this…

Try using Inventory Location in the Criteria, not just Location. Here's the difference between the two: Inventory Location Field corresponds to the Location Name of the physical location of user's inventory quantities. They are found under the Location Subtab of the item records. While Location Field pulls up the Location…

Hi @Jay Schwausch, Try using these fields in your formula instead: {memberitem.locationquantityonhand} {memberitem.locationquantityavailable} Also, if you want to filter it by the specific Location, you can add the Criteria: Inventory Location = Location Name Let me know if this works for you. -Ivy…

Awesome, @Tiru Chembeti! ?

Hi @gjnido, Glad to have you back with us today and thanks for posting your concern here in our community! Allow our gurus to check this one and we'll get back to you with our findings. To our other members, feel free to share your insights on this as well.

Hi @Meherin, I did see the Location on the Main Line of both the SO and the PO, but what I was asking for was the Location on the Item Line Level, which can sometimes be different than that on the Main Line (might be affected by scripts or workflows). I also noticed on the screenshots that the Quantity on the Purchase…

Hi @Meherin, First thing that comes to mind is to check the Location on the item line level of the Sales Order, if it is similar to the Location on the Purchase Order/Item Receipt. If this is not visible on the form, you might need to customize the form for it to show. You can refer to SuiteAnswers 63532 for more…

Hi @User_NC62U, Glad to have you back with us today and thanks 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 users, feel free join in the discussion as well. ?

Hi @KNason76, Upon checking my resources on your concern, it seems like this is a system limitation and is logged under: Enhancement # 647869 : MRP > Assembly Items > Supply Lot Sizing Method = Fixed Lot Size > Generated Planned Work Orders do not follow Fixed Lot Size You are correct that the possible alternate solution…

Hi @Ian T, Were you able to check my comment? Let us know if it did help in your concern or if you need further assistance on this one.

Hello @Kgothatso, Were you able to check my comment? Let us know if it did help in your concern or if you need further assistance on this one.

Hi @Ian T, In Saved Searches, you can use the Feed Name field to get only the name of the child item. Note that this is field will pull the value from the Item Name/Number field only when the Web Store Display Name field is null/blank in the item record. This behavior is documented in SuiteAnswers 95554. I also found an…

Hi @Kgothatso, Here are some reasons why the quantity in Sales Orders go on back order or do not commit: Under Setup > Accounting > Accounting Preferences > Order Management tab > Sales Order section, Perform Item Commitment after Transaction Entry preference is disabled. In the Sales Order: Location in the Item Line is…

Hi @Karanjot Singh, Thanks 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. @Micah Timbol-Oracle / @Katerina Winklerova-Oracle, any ideas you can share? To other users, feel free join in…

Hi @RachaelRahe, Thanks for posting your 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. @Michelle Jabanes-Oracle, need your expertise on this one. To other users, feel free join in the discussion as well. ?

Hi @Eklon Eleuterio, Thanks 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. @Mikko De La Fuente-Oracle, any ideas?? To other users, feel free join in the discussion as well. ?

Hello @Kgothatso, Let us know if the provided solution worked on your end.

Hi @Asher_123, I checked my resources on this one, but I couldn't find any documentation catering to your specific requirement. NetSuite has Shipping Integration with FedEx, UPS, and USPS/Endicia but that is mainly used for calculating real time rates and printing shipping labels. You can reach out to your Account Manager…

Hi @aisaadaniya, Have you tried creating a Bin Putaway Worksheet for the item? Using Administrator role, go to Transactions > Inventory > Bin Putaway Worksheet. Just populate the Location on where the item was received in (but was not put in a bin), then the item will show in the list, so you can put it away in a bin. Try…

Hi @Amjad Kasem, Thank you for posting another question here in our community! Allow our gurus/members to check on this, and we'll get back to you with our findings. To our other members, feel free to comment your insights on this as well.

Hi @Karanjot Singh, Glad to have you with us today and thank you for posting another question here in our community. Allow our gurus/members to check on this one and we'll get back to you with our findings. In the meantime, you can check SuiteAnswers 65560 and related articles to serve as a guide. To our other members,…

Hi @Camila O, Thanks for posting another question here in the community! ? Per checking, this is not possible yet since the ability to source Stock Units into a Transaction Column Field is not yet possible and is logged as Enhancement # 62405. You can vote for this in the SuiteIdeas page. To anyone who has ideas or…

Hi there @CDuf, Glad to have you with us today and thanks for posting your concern here in our community. Let's see if our other members have any suggestions for your requirement.

Hi @Kgothatso, Yes it is possible. You can use the same steps in SuiteAnswers 48988, but just use these formula: From Bin = CASE WHEN (MOD({linesequencenumber},2)=1) THEN {inventorydetail.status} END To Bin = CASE WHEN (MOD({linesequencenumber},2)=0) THEN {inventorydetail.status} END Hope this helps. ? -Ivy…

Try changing the formula in the search to 'kg' instead of 'Kg' since formulas are case sensitive.

Can you also send a screenshot of the Items subtab of the WO showing components with Units = Kg?

Hi @User_9E4AO, I tried this on my test account and I was able to get a value to show up using a Saved Search and with the Store Value check box unmarked. Here's the setup of my custom field: And here's the Transaction Saved Search I used: Formula: CASE WHEN {mainline} != '*' AND {unitabbreviation} = 'Kg' THEN {quantity}…

Hi @Amjad Kasem, 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. @Elychelle Gulen-Oracle / @Dominica Sevilla-Oracle, any insights you can…