Ivy Lopez-Oracle NSC Guru

Hi Sara, Per SuiteAnswers 49745, Customer Part Number supports inventory and assembly items only. I did find a related enhancement request for this filed under Enhancement # 417402. You can vote for this in the SuiteIdeas page. Unfortunately, at this time, there is no documented workaround yet to add customer part number…

Hi @Janis001, Thank you for the clarification. Can you confirm if you are using the Supply Allocation feature or not?

Sounds good. ?

Hi @Meherin, Kindly take a screenshot of the Related Records tab as well. Make sure to show the 'Link Type' column like the one below:

Hi @Asher_123, Were you able to check my previous comment? We'd appreciate the additional information so that we can further look into this.

Hi there @Janis001, From what I understand, you are trying to create a report/search that would show the item qty on hand, committed, and backordered for items. Is my understanding correct? Please let me know if it is not. Also, I got quite confused with your statement: "The issue is it will attach to a specific SO and…

Hi @Meherin, I tested this on my standard test account and had the same behavior that the Back Ordered column is blank for a Drop Ship item. This is the standard behavior for Drop Ship items. Per SuiteAnswers 11128: When you drop ship an item, the item is sent directly from your vendor to your customer and the item is not…

Hi @Asher_123, I did some tests on my test account, but was unable to reproduce this specific scenario. To be able to further check on this one, we'd appreciate if you can provide more information regarding this like: Is this the only PO/IR that this behavior occurred? Are there other items that have the same Was the PO…

Hi there @Carissa, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. By the way, can you also verify if there are any recent changes in the Audit Trail tab of the Saved…

Hi there @Ancana, Glad to have you back with us today and thanks for creating posting another question here in our community! ? I have already coordinated this with @Leonard Mallare-Oracle and he will be helping you on this one. To our other members, feel free to share your insights about this as well.

Hi @Dwight Schrute, Were you able to check my previous comment? If it was helpful in your concern, then we would greatly appreciate if you will click "Yes” on the “Did this answer your question?” below my previous comment. By doing this, you’ll be able to help other community members who might have the same concern find…

Hi @ChrisH, Were you able to check my previous comment? If it was helpful in your concern, then we would greatly appreciate if you will click "Yes” on the “Did this answer your question?” below my previous comment. By doing this, you’ll be able to help other community members who might have the same concern find the answer…

Hi @Vusi, Glad to have you with us today. Thank you for creating another thread. ? 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. ?

Thanks for providing your insights on this one, @Tiru Chembeti! ? Hi @ChrisH, There is a feature called Outsourced Manufacturing. If this feature is not available on your account, then you can reach out to your Account Manager. For more information about this feature, you can refer to the following SuiteAnswers articles:…

Hi @Dwight Schrute, There are resources about Supply Chain Control Tower in SuiteAnswers. Here are some links to videos and articles that may help: 70351 - Supply Chain Control Tower 70352 - Set Up the Supply Chain Control Tower Feature 70353 - Generating a Supply Chain Snapshot 82609 - Customizing a Snapshot Form 68875 -…

You're welcome, @Dwight Schrute. Glad I was able to help! ?

Hi @Martha Hakes, You can use the Applying Transaction joining fields to get the information from the PO/WO linked to the Sales Order, but if the POs/WOs are not linked, then we can't get that information. Anyone else have ideas or suggestions for a possible workaround for this one? Let us know by commenting on this thread.

Hi @Dwight Schrute, Please try the formula I provided in my previous comment. I noticed that it's not the one that you had in your screenshot. Thanks.

Hi again @Martha Hakes, Per checking my resources on this one, it seems that this field is not yet available for reports/saved searches. This system limitation is logged under Enhancement # 258217 which you can vote for in the SuiteIdeas page. For a possible alternate solution, you can refer to SuiteAnswers 34441. Hope…

Hi @jmack_admin, Glad to have you with us today and thank you for posting your question here in our community! Allow our gurus/members to check this for you and we'll update you with our findings. To our other members, feel free to comment your insights/suggestions about this as well.

Hi there @Martha Hakes, Glad to have you with us today and thanks for posting your concern here in our community. Allow our gurus/members to check this for you and we'll update you with our findings. To other members, feel free to comment your insights on this one as well.

Hi again @Dwight Schrute, Please try this formula: ROUND(((TO_CHAR((CASE WHEN {datecreated} > {trandate} THEN {datecreated} ELSE {trandate} END), 'J') - TO_CHAR((CASE WHEN {datecreated} < {trandate} THEN {datecreated} ELSE {trandate} END), 'J'))) + MOD(((CASE WHEN {datecreated} > {trandate} THEN {datecreated} ELSE…

Hi there @Dwight Schrute, I have split your comment to a new thread, since this requires further testing and investigation. I did notice on your excel file that the date created is usually after the transaction date. Note that the formula provided below will work as expected only when the start date is before the end date:…

Hi @Dwight Schrute, Glad you were able to figure it out, and thank you for keeping us updated. ? I have marked your latest comment as the correct answer for this thread to help other members who might encounter the same scenario.

Hi @Camila O, Glad to have you with us today and thank you for posting your question here! 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 members of the community, feel free to share your insights on this one as well ?

Hi @Dwight Schrute, If your startdate = {datecreated} and enddate=nvl({trandate},{today}), then you just substitute these in the formula. You will come up with something like this: ROUND(((TO_CHAR(nvl({trandate},{today}), 'J') - TO_CHAR({datecreated}, 'J'))) - ((((TRUNC(nvl({trandate},{today}), 'D')) -…

Hi @Dwight Schrute, Can you provide some examples that the results are inconsistent? One possible reason is that there are multiple Applied To Transactions, or the search is pulling information from multiple/different lines. It would be helpful if you can provide us the Criteria/Results tab of your search so we can also…

Hi @Rhys Gottwald, Yes, the system rule "Allow picking of expired items" is working as expected on my test accounts.

Hi @KNason76, Did you proceed with filing a case with NS Support? Or were you able to successfully import the CSV file? We'd appreciate it if you can keep us updated regarding this one. I'm also curious to know if there is indeed a limitation when uploading BOMs or if there's another reason why you are encountering an…

Hi @Rhys Gottwald, I did further tests on this one, but I was not able to reproduce the behavior you mentioned. I tried it in both the 2021.2 and 2022.1 versions of WMS. Per further checking, I did note a similar issue but has already been fixed, according to our records: Defect # 655891: WMS > Allow picking of expired…