For this one, based on the screenshots you sent, the item has different values under the "TRN OR PUR" column which is why it shows up as different lines.

One possible reason this might be happening is because the custom role does not have permissions to view some of the records specified in the criteria/results. To resolve this, mark the Run Unrestricted checkbox under the Results tab. As per field help of the Run Unrestricted: Check this box to make search results…

Try these instead: # to Order Both | Maximum: (SUM(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN NVL({transaction.quantity},0) ELSE 0 END) + MAX(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN NVL({locationsafetystocklevel},0) ELSE 0 END) + MAX(CASE WHEN {transaction.location} = 'Edmonton…

Hi @Dallas H, Since you do not have it grouped by Inventory Location, then you can try these formula: To Order (EDM): (SUM(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN {transaction.quantity} ELSE 0 END) + MAX(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN {locationsafetystocklevel} ELSE 0 END)…

Hi Dallas, I did try the formula you provided and it worked for me. I did not get any error. Can you try it again? (SUM(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN {transaction.quantity} ELSE 0 END) + MAX(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN {locationsafetystocklevel} ELSE 0 END) +…

Hi there @WillHendrick, Glad to have you back with us and thank you for posting your concern here in the community! ? I checked my resources about your concern, and it seems like setting Available Filters Fields as a Criteria of Saved 'Saved Search' Searches is not yet possible in the system. I also tried looking for…

Hi @Tom Dalton, Thank you for posting another question here in the community! ? The only preference related to the behavior that you mentioned is the Invoice in Advance of Fulfillment preference under Accounting Preferences > Order Management > Invoicing. However, this is not affected by the type of item in the order.…

Hi @Dan Moldover, Thank you for posting your concern here in our community! Allow our gurus/members some time to check this for you. Also tagging @Patrick Fresnosa-Oracle who will be helping you out on this one. To our other members, feel free to share your insights as well.

Hi @User_SZ0C3, Thank you for posting your concern here in our community! Allow our gurus/members some time to check on this for you, and we'll get back to you with our findings. Tagging my colleagues who will be able to assist you on this one: @Ely Gulen-Oracle / @Dominica Sevilla-Oracle, any ideas? To other members, feel…

Hi @Janis001, Was the information provided in my previous comment helpful to your concern? If it was, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer easier. Hope you…

Hi @User_QG2Y6, Were you able to test the solution provided in my previous comment? If it was helpful to your concern, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer…

Hi @Neo_Suite, Were you able to test the solution provided in my previous comment? If it was helpful to your concern, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer…

Hi @KNason76, I have tested this on my account and confirmed that the Master Default box was checked when the Overwrite Sublists option was checked. As an example, here's an Assembly Item with a BOM: CSV Import steps: Once the import was finished, the Master Default checkbox is now marked in the item record:

Thanks for providing the detailed steps, @John Griffin! I tried this on my account and I can confirm that this works. I looked back on the previous test that I did and realized my mistake -- the Overwrite Missing Fields option was checked. Also, hardcoding <NULL> in the Import Assistant results in an error so it would be…

Hi @User_SQQ29, Unfortunately, I could not find any documentation about your specific requirement. You may want to reach out to your account manager to confirm with Professional Services team if this is possible in customization of the WMS Mobile App. Apologies for the limited help we can offer.

Hello everyone! Our engineers are still working on the solution for this one. We'll make sure to keep you posted on any update and you can also check the NetSuite Status Page. We apologize for the inconvenience.

Hi @Pervaz R. Allauddin, Try this: MAX(CASE WHEN {applyingtransaction.type} = 'Work Order Issue' THEN {applyingtransaction.datecreated} END) - MAX(CASE WHEN {applyingtransaction.type} = 'Work Order Completion' THEN {applyingtransaction.datecreated} END) Note that this should be entered in the Summary subtab of the…

Hi @User_SQQ29, Have you checked the articles provided in my previous comment? Let us know if you need further assistance on this.

Hi @Dallas H, Were you able to test this out? Let us know if you need further assistance on this.

Hi @User_QG2Y6, There is no standard report for this, but you can try getting the information that you need using a Transaction Saved Search. This is based on the saved search presented in the related discussion below, but with an added column to show the value of the lot number: Criteria tab: Results tab: Available…

Hi @User_QG2Y6, Currently, we can't get the cost of the lot numbers in an Inventory Numbers saved search since it is not available in the Item Record, and there are no joining fields for transactions. This is a current system limitation and is related to the enhancements that Joy mentioned in her answer in your previous…

Hi @Neo_Suite, Here's a simple Item Saved Search that I created on my end: Criteria tab: Results tab: Formula Used: Top-Level Parent: REGEXP_SUBSTR({name},'[^:]+') Sample Results: Try this and let me know if it's what you were looking for. If not, then please do elaborate on what you need to show on your search. -Ivy

Hi @Ramgopal C, Thank you for posting your question here in our community! Allow our gurus/members some time to check on this for your. Let me tag as well my colleagues who will be assisting you on this one: @Micah Timbol-Oracle / @Patrick Fresnosa-Oracle, any ideas? To our other members, feel free to comment your insights…

Hi @Pervaz R. Allauddin, Thanks for the clarification! Here's the Transaction Saved Search I came up with: Criteria tab: Results tab: Formula Used: Work Order Issue Document Number: CASE WHEN {applyingtransaction.type} = 'Work Order Issue' THEN {applyingtransaction.number} END Work Order Issue Date Created: CASE WHEN…

Hi @Janis001, I agree with @John Griffin's answer. The ability to convert inventory items to lot numbered inventory items and vice versa is not yet possible and is tracked under Enhancement # 84689. You can vote for this in the SuiteIdeas page. Here's a discussion that you might also find helpful: Also, as mentioned in…

Hi @Pervaz R. Allauddin, Are the 'Fulfillment Issues' and 'Fulfillment Completion' records custom records? Or are they renamed records? I am only familiar with Item Fulfillments, Fulfillment Requests, Work Order Issues and Work Order Completions. Is it related to those? Or are these custom records that are associated with…

Hi @Lily O, I got the below details in the Oracle NetSuite Support Community Inbox: Thank you – thank you twice You provided more information and it was extremely useful. Once finding the setup spot in NetSuite, we re-registered the UPS account with a current invoice data and it works Thank you so much. For future…

Hi Dallas, Sorry if that was confusing. What I meant was, that if the Inventory Location field has the Summary Type = Group, then it will always show the results as grouped by the location. This means that the Location details will always show in separate lines, and we can't combine them together to show in a single line:…

Hi @Lily O, I checked on the case details and some other related cases, and I'm afraid that this particular error you are encountering can be resolved by contacting UPS. I further checked on the error (based on the submitted case), and it seems that the error is "The UserId is currently locked out, please try again in 30…

Hi @User_SQQ29, You can refer to the WMS User Guide for details regarding customizing the WMS Mobile App. You can also check out the following SuiteAnswers articles: 87481 - Mobile Device Customization 87325 - Customizing Mobile Device Processes 87483 - Setting Up Additional Fields on Custom Mobile Pages