Ivy Lopez-Oracle NSC Guru

Hi @BM136, What do you mean "only products that should be fixed"? Only those lines with 'Please Disallow BO'? You can use the Summary Criteria function of Saved Searches. I actually just created a discussion about this topic. You can check it out here: For your use case, we can also use this functionality. Summary Type =…

Hi @OliverK, Do you need to get the Qty On Hand per Location? If so, then use "Location On Hand" with Summary Type = Maximum in your Results tab. Then in the Criteria, try adding this: Formula: CASE WHEN {location} = {item.inventorylocation} THEN 1 ELSE 0 END Formula (Numeric): equal to Value: 1 Let us know if doing this…

By the way, your question regarding the difference between DECODE and CASE, you can check the pdf attached in SuiteAnswers 83496 as there are some examples provided there. But basically, here's the summary of the difference between the use of each: Use Decode if always comparing for equality Use Case if comparing in other…

Hi there @BM136, I tested this on my account, and I was able to reproduce the behavior you mentioned using both DECODE and CASE functions. The reason for this is because if there are multiple member items/components for the Kit/Package Item, then all the results will show up in the search. To achieve the results that you…

Hi @Biomerics_Admin, Thank you for posting again here in our community! @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas about this one? To our other members, feel free to share your insights as well.

Hi @User_Q5A9E, Welcome to the community! Kindly allow our gurus some time to check this for you. Tagging @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any ideas? To other members who might have encountered the same, feel free to share any insights that might help.

Glad I was able to help! ?

Hi @Martha Hakes, Glad to have you with us today and thank you for posting your concern here in the community! ? I think this may have something to do with a user's preference. Kindly check in Home > Set Preferences > Analytics > Report By Period preference. To know about How can I filter report results by periods or…

Hi @apettine, I checked my resources regarding your concern and it seems like this is not yet possible in the system. I also tried to find enhancement requests related to this, but there were none. You can submit a new enhancement request for this functionality on the SuiteIdeas page.

Hi @eleran, I tested the scenario that you provided in my standard test account. Here's the details of what I did: 1. Create regular Inventory Item with the following units: Primary Stock Unit = Box of 4 Primary Purchase Unit = Each Primary Sale Unit = Box of 4 2. Create Purchase Order for the item When I entered the item…

Glad to hear that, @Tlarkin! ?

Hi @User_0IIK0, Glad I was able to be of assistance. ? If my previous comment was helpful, we would appreciate if you can click "Yes" in the "Did this answer the question" below the comment. In doing so, it will tagged as the Accepted Answer and it will also help other members of the community that might encounter the same…

Hi @User_SDDLJ, Were you able to rename the Picked/Packed/Shipped statuses on your account? If my previous comment was helpful, we would appreciate if you can click "Yes" in the "Did this answer the question" below the comment. In doing so, it will tagged as the Accepted Answer and it will also help other members of the…

Hi @Dirk Nieuwkamp, Yes, it works the same way with past dates. If you set the As of Date to a past date, then it will only consider posting transactions up to the date that you set. Hope this clarifies your concern. ? -Ivy ========================= If you find this reply to your question as helpful, others with the same…

Hi @Asher_123, Glad to have you back with us today and for posting your question here in our community! Kindly allow our gurus/members some time to check this one for you and we will get back to you with our findings. To other users who may have insights regarding this topic, feel free to add your comments by replying to…

Hi @Eklon Eleuterio, Glad to have you with us today and for posting your question here in our community! Kindly allow our gurus/members some time to check this one for you and we will get back to you with our findings. @Micah Timbol-Oracle / @Katerina Winklerova-Oracle, any ideas regarding this one? To other users who may…

You would need to set the start date in the filter to the beginning or when the item was first used. Also, try removing the summary type on the Document Number field in your results tab, so that the quantity is summed based on only the grouped lot numbers. Unfortunately, this is the only documented workaround for now, and…

Hi @KNason76, In the Inventory Valuation Report, you can add the Transaction Serial/Lot Numbers under the Quantity On Hand folder. However, this would show like this on the report: If there is more than lot number in the transaction, it would be presented in only one line which is separated by commas. I further looked into…

Based on the information you provided, then it should be considered. Thank your understanding on this one. We would also appreciate if you can update us regarding Support's findings. I'm sure it will also help other members who might encounter the same scenario.

Hi @KNason76, MRP should consider firmed orders. Here are some things to check: What is the location set in the order? Is the location also included in the supply plan? Is the replenishment method of the item in the order set to MRP or MPS? If these settings are correct, and it isn't considered on your end, then I would…

If the information provided and the information in SuiteAnswers is not sufficient, then you can reach out to your account manager for possible engagement with our ACS team for a walkthrough regarding this.

Hi @User_SDDLJ, Yes, you can rename these under Setup > Accounting > Accounting Preferences > Order Management tab > Picking/Packing section: 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…

Hi @User_0IIK0, I checked my resources regarding your concern, and it seems that your requirement is not possible with Supply Allocation feature only since the Location needs to be indicated in the order to be able to allocate the quantity. Note that Supply Allocation feature only looks at the location entered in the order…

Hi @FoxFoxFox, This feature is part of the Manufacturing Work in Process Add-on Module. Please reach out to your Account Manager if this is not available on your account.

You can run an inventory Valuation Detail report to check how the Inventory Worksheets you created affected the costing of your item per location. You can also check the system notes of transactions like Item Fulfillment if there were any changes in the GL Impact.

Hi @moonking, It seems that the item you used in your example is a Serialized Assembly item. The serial number per item should be unique, so the quantity column is greyed out and defaulted to 1. I did test this as well on my test account and the inventory detail pop up is different for Lot Numbered and Serialized items.…

Hi @Dirk Nieuwkamp, The Review Negative Inventory page shows the negative inventory on hand as of a certain date. Quantity on hand is affected by posting transactions such as Item Receipt, Item Fulfillment, Assembly Builds, Inventory Adjustments, etc. If you set the As of Date to a future date, then it will also consider…

Thank you for your understanding on this one, @User_RHKAB! If my previous comment was helpful, you can click "Yes" in the "Did this answer the question" below the comment. In doing so, it will tagged as the Accepted Answer and it will also help other members of the community that might encounter the same concern. -Ivy

Hi @MarkCr, I looked into importing the Price Schedule for Vendors (Vendor record > Financial tab > Pricing Schedules subtab), and it seems that this is not yet possible in the system. This feature is currently requested in Enhancement # 390638: CSV Import > Import Type: Relationships > Record Type: Vendor > Ability to…

Hi @User_RHKAB, You are correct that you can set a default shipping method in Setup > Accounting > Shipping, however, since each shipping method has a Subsidiary selected, it will only work for those customers with the same subsidiary as the shipping method. I further checked into this and I noted that the feature you are…