Ivy Lopez-Oracle NSC Guru

Hi @User_WRTMI, Glad to have you back with us today and thank you for posting your concern here in our community! ? Regarding the concern, allow me to tag our gurus who have the expertise on this one: @Joahnna Given Uy-Oracle / @Jack Daryl Espiel-Oracle, any ideas? To our other members, feel free to share your insights as…

Hi @ChrisH, You can try these: ((CASE WHEN NVL({inventorylocation},0) = 'Location # 1' THEN {locationquantityavailable} ELSE 0 END) + (CASE WHEN NVL({inventorylocation},0) = 'Location # 2' THEN {locationquantityavailable} ELSE 0 END))-5 (CASE WHEN {inventorylocation} = 'Location # 1' OR {inventorylocation} = 'Location # 2'…

Hi @ChrisH, You can do an Item Saved Search: Criteria tab: Results tab: If you need to, you can also use a Formula (Numeric) field (Summary Type = Sum) with the formula: CASE WHEN {inventorylocation} = 'Location # 1' OR {inventorylocation} = 'Location # 2' THEN {locationquantityavailable} ELSE 0 END Alternatively, you can…

Hi @BM136, As I've mentioned in my previous comment, the system allows the same UPC Code on different items, even those which are not Matrix Items. Unless you have some customizations applied, there will be no error message when saving item records that have the same UPC Code since the native functionality to detect…

Thanks for the update, Dirk!

Hi Joe, In the Inventory Adjustment, you will be able to select which account and department will be charged. The inventory account credited is the inventory account set in the item record. Hope this clarifies your concern. -Ivy ========================= If you find this reply to your question as helpful, others with the…

Hi Vernita, Was my previous comment able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of the previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Or if you…

Hi Dirk, Was my previous comment able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of the previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you have a…

Hi @Brad3987399, Was my previous comment able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of the previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you…

Hi @User_B2SDR, It would depend on your business process on how you want to record this, but for transactions involving inventory items, you can consider using Inventory Adjustments which can deduct the quantity you issued to an internal department from the item's stock and also record the cost. You can check SuiteAnswers…

Hi Drew, Aside from the Print Checks & Forms page, there is no other functionality like what you described that is readily available in the system. However, upon further looking into this, it may be possible via SuiteScript. Let me tag my colleagues who has the expertise on this. @Erick Dela Rosa-Oracle / @Mikko De La…

Hi @Drewmich, Glad to have you with us today and thank you for posting your concern here in our community! ? Have you tried going to Transactions > Management > Print Checks and Forms page? For more information, you can refer to SuiteAnswers 9057: Printing Checks and Other Transactions. Anyone else have ideas or…

Hi @BM136, I have tested this one on my end, and noted that the child matrix items can have the same UPC Code as the parent. Here's the steps I did: Edited the Parent Matrix Item Populated the UPC Code field Clicked More Actions > Update Matrix Marked all the child matrix items Clicked Submit This will update that specific…

Hi @Vernita, You can also check if there are any scripts or workflows in the Item Fulfillment record that might be affecting this behavior on your accounts. I've tested it in my account and the standard behavior is that the checkboxes are marked by default if the Integrated Shipping Label is enabled in the Item…

Hi @Brad3987399, Did you also create Custom Item Fields for each of the Custom Matrix Option Lists that you created? Based on SuiteAnswers 28221, you also need to set up a custom item field for each list you created. Here is an example of a Custom List that I created: And here is the Custom Item Field (Matrix Option = T)…

Hi @Vernita, Just to add, based on my testing, these checkboxes are unchecked/greyed out if the Integrated Shipping Label checkbox is unmarked. And it is checked by default if the Integrated Shipping Label checkbox is marked. Maybe you can also check the setup of the Shipping Item used, if the Shipping Label Integration is…

Hi @Vernita, Thank you for posting your concern here in our community! Upon testing and checking my resources about your concern, I have noted that it is not yet possible to have these checkboxes unmarked by default. There are existing enhancement requests regarding this functionality: Enhancement # 124152: Fulfill Sales…

Hi @Dirk Nieuwkamp, If there is a Work Order linked on the item line of the Sales Order, then the details should be pulled if you use the Applying Transaction joining fields. Here is the item line of the Sales Order; Search Criteria tab: Note that I just added the Item Criteria to filter my results for testing purposes.…

Hi @Dirk Nieuwkamp, As documented in SuiteAnswers 87483, it is possible to set up a dynamic list by using a saved search: Below are the steps to be able to do this: Create a dropdown field on the Page Elements. Create a Custom List with values and convert to Custom Record. Create a Custom Record Saved Search and source the…

Hi there @Chad C, Glad to have you back with us today and thank you for posting your concern here in the community! ? @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle, any ideas regarding this one? Let me also tag our gurus who are experts in customization: @Joahnna Given Uy-Oracle / @Mikko De La Fuente-Oracle / @Erick…

Hi @User_6YI1X, When using the REGEXP function, getting the string within the text will normally stop if there is a line break. This is the standard behavior. However, if you specify a line break (\s) in the pattern of the REGEXP function, it should capture even the text after a line break:…

Glad I could help, @User_6YI1X! ? If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that helped in your concern. This will also help other community members who might have the same concern find the answer easier. Hope you have a great day!…

Hi @User_6YI1X, Is this for a Saved Search? If so, you can use a Formula (Text) field with this formula: REGEXP_SUBSTR({purchasedescription}, '\*\*MISC.+') || '<br>' || '<br>' || REGEXP_SUBSTR({purchasedescription}, '\*\*CROSSMEMBER.+') You can remove the line breaks ('<br>') if these are not needed. Let us know if this…

Hi @Dirk Nieuwkamp, Try using these fields in your Results: Applying Transaction Fields... Quantity Applying Transaction Fields... Units Hope this helps! ? -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the…

Hi @Dirk Nieuwkamp, Based on your tests and update, I suggest that you file a Support Case for this since this is a potential defect on the behavior of the sorting of the recommended bins for pick tasks. We'd appreciate if you can also update us regarding Support's findings so that it will also help other members who might…

Hi @Meherin, I was able to find related SuiteAnswers article 9293: Printing FedEx® Shipping Labels and Forms Below is an excerpt from the article: "The first line in a Ship From address is taken from the Attention field in the location’s Address window. The second line is taken from the location’s Name field. If you print…

Hi @Dirk Nieuwkamp, Kindly check if the Use Pick to Clean Process at Locations Using Warehouse Management preference is enabled under Set Up > Accounting > Accounting Preferences > Order Management > Picking/Packing section. If this preference is enabled, NetSuite WMS recommends the bin with the exact or highest available…

Hi there @Richard Appleford, Glad to see you here again! I checked on this and noted that there is currently no standard way to reverse work order issuance and this functionality is requested in Enhancement # 380633: Work Order with WIP = T > Reverse effect of Work Order Issue to release components. You can vote for the…

Hi there @User_EKY01, Thanks for creating another thread here in our community! Allow me to tag my colleagues who will be able to help you out with your concern. @Micah Timbol-Oracle / @Patrick Fresnosa-Oracle, any ideas about this one? To our other community members, feel free to share your insights on this as well. While…

Hi @User_7QVM7, Welcome to the community! We are glad to have you here with us today! ? To get you started, we recommend the following: Update your profile, add a profile picture and preferred username so other members can address you properly moving forward. You can check out Community Tip: Updating Your Profile! on how…