Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hi @Alexsandro_Brazil_Oracle, Thank you for posting your concern here in the community! I checked on this one and it seems like this is a known system limitation and there is an existing enhancement logged for this: Enhancement # 173819: OneWorld:Setup > Accounting > Accounting List > New > Term. Customer is requesting for…

Hi @Martha Hakes, Thank you for posting another question here in our community! ? Allow our gurus some time to check on this one for you and we'll get back to you with our findings. To our other members, feel free to comment your insights and ideas on this thread!

Hi @HoJo, The Last Purchase Price field in the item record is a read-only field that displays the most recent purchase price of the item. This price is determined by the most recent transaction for the item that added positive inventory, such as a purchase receipt, inventory transfer or inventory adjustment. (This does not…

Hi @User_N5LAE, Welcome to the community and thank you for posting your concern here! Let me tag our Gurus who have the expertise on this one: @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any ideas? To our other members, feel free to share your insights and suggestions as well.

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…