Hi Carissa, As documented in SuiteAnswers 63328: Drop Ship Items are designed not to appear in Picking Tickets because they do not get delivered to the Warehouse. There is no need to Pick them because they are delivered to the customer straight from the Vendor. Picking tickets also rely on the Committed Quantities from the…

Hi @KaylaM, When creating negative inventory adjustments (reducing quantity in a location), the est. unit cost field is greyed out and can't be edited. This is because the system will automatically calculate the cost of the negative adjustment once the transaction is saved. This behavior is also stated in SuiteAnswers…

Hi @paula.courtemanche, You can check SuiteAnswers 26826. This article discusses a suggested process on handling returns when an incorrect item is shipped to the customer. For easy reference, here is the process discussed in the article: Step 1. Put the item (correct) that was never sent back to inventory Create a Return…

Hi there @User_6YI1X, You can try these criteria in a Transaction Saved Search: Type = Work Order Item On Any Line = none of XXX (Select the specific Item) Let us know if this works for you! ? -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it…

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…