Jam Amper-Oracle Gold Trophy

Hi @Phill Allen, Just wanted to confirm if you were able to see my response above? If yes, please let us know if you need further assistance. If there's none,kindly click "Yes"on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the…

Hi @valtir_SuiteGeek, Glad that this worked on your end. Have a great day ahead!

Hi Valtir, Please follow the steps below: Open your current dataset Create the following datasets (Adjusted Quantity, Count Quantity, Snapshot Quantity): Use the following formula below: Adjusted Quantity Case when {transactionlines.transactionlinetype#display} = 'Inventory Count: Adjusted Quantity' then…

Hi @Razvan Mesteriuc, Unfortunately, we have been unable to replicate the issue in our test accounts due to the specific configuration of your setup. We highly recommend that you create a case with NetSuite support to investigate this matter further. The support team will be able to examine the duplicate of your account in…

Hi @Eunice_Rep, Thank you for the clarification. When I tested this on my test account, it usually sources the base unit for a transaction saved search. It is possible to source or differentiate the units of measure through the 'Units Type' search, which is why I mentioned the previous enhancement, given that your desired…

Hi @Phill Allen, Typically, you could click the header for the UPC Code to be able to sort it on the highest/lowest number. With the screenshot you have provided, can I confirm if this a saved search? If not, kindly provide the navigational path of this page. Thanks!

Hi @Phill Allen, No worries on this! Have a great day ahead :)

Hi @Phill Allen, Upon testing, unfortunately, it was found that you cannot add a new item to the item line after the initial item receipt. As a workaround, you can partially receive the item that arrived and then generate a separate item receipt for the missing item from your original order. For the extra item received,…

Hi For your concern with saved search, kindly see the following articles on the criteria needed for saved search to show on the custom field drop down list. 31727 - Creating Custom Fields with Values Derived from Summary Search Results In summary, you would need to have an Available Filter and Summary type on the results…

Hi! This should work once linked. Let us know if you have created both the search and workflow for your item receipts. Thanks!

Hi @Buckeye1497, The Status by Location tab appears to be a customized one. Would you be able to confirm this? Also, upon checking there is a linked enhancement for your expected result found on Enhancement # 498281 Saved Item Search > Display Inventory Status per Bin Number and Location Including Quantity on Hand per…

Hi pbr528, We are glad to have you with us today, and we extend our gratitude for posting within the NetSuite Support Community! Greetings to all! We have a community member in need of our assistance. Please feel free to offer your knowledge and insights to support them. Your contributions are of great value and deeply…

Hi User_6G058, We are glad to have you with us today, and we extend our gratitude for posting within the NetSuite Support Community! Greetings to all! We have a community member in need of our assistance. Please feel free to offer your knowledge and insights to support them. Your contributions are of great value and deeply…

Hi @User_RUQ2X, We have an existing documentation that may arrive on your expected result please see the article below: SuiteAnswers ID: 63824 Saved Search to Show Purchase Order with Item Receipt not yet Billed. Hope this helps!

Hi Buckeye, Please let us know if you need further assistance. If there's none, kindly click "Yes"on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. You will also earn points and may unlock the Answer Accepter…

Hi Javier, Just wanted to confirm if you were able to check the articles above on your end? If yes, please let us know if you need further assistance. If there's none, kindly click "Yes"on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily…

Thanks for confirming this Valtir. To confirm, are all fields on your end native or are you using custom fields as well. Do you have any workaround for this as of the moment?

https://community.oracle.com/netsuite/english/discussion/comment/16883171#Comment_16883171 Hi Amanda, I believe this is the closest we can get to arrive on your expected result. I have looked into similar scenarios and relevant articles for this and have found no existing documentation for this.

Hi @Buckeye1497, I agree with what Tigran is suggesting which is to pull items with the a certain status per location via a saved search. Just in case you encounter a problem, you may also consider looking into this article as well SuiteAnswers ID: 28426 Item Saved Search With Inventory Location as a Filter Does Not…

Hi @javierm, Feel free to look into the following articles below for the standard behavior of supply allocation, particularly for the Perform Supply Allocation After Transaction Entry, Update or Delete feature: 87876 Setting Demand Preferences for Supply Allocation 87883 Supply Allocation Calculations 87886 Setting Supply…

Hi @MoonK, Yes, that is the expected behavior.

Hi @Lee Ann R, May we ask what kind/type of reporting is this?

https://community.oracle.com/netsuite/english/discussion/comment/16883069#Comment_16883069 Hi Elizabeth, Confirming the following information above. For everyone, let us know if you have any other insights for the search. Thank you!

Hi Kagura, Just wanted to confirm if you were able to review my response above? If yes, please let us know if you need further assistance. If there's none,kindly click "Yes"on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the…

Hi Amanda, You may consider looking into the following SuiteAnswers article as it provides a somewhat similar expected result that you're going for. Please see below: 71845 Saved Search > Purchase Order > Highlight based on PO Status 81562 Save Search That Highlights Newly Created Purchase Orders For One Week Hope this…

Hi @Razvan Mesteriuc, Glad that we could be of help to you. Please let us know if you need further assistance. If there's none, kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. You will also…

Hi Elizabeth, Quick question on this, what type of saved search are you currently using? I tried looking for the specific fields to recreate your saved search and cannot locate some as it seems to be a custom field on your environment? I would like to test this further. Also, please provide any other formulas you have used…

Hi Valtir, The formula you provided can likely be implemented in SuiteAnalytics Workbook, but the exact syntax might need to be adjusted to conform to the platform’s formula language. Here’s how you could potentially structure the formula for SuiteAnalytics Workbook: IF ({transactionlines.transactionlinetype#display} =…

Hi @Razvan Mesteriuc, The error frequently occurs when the previous transaction is processed but subsequently closed, leaving the WMS system stalled while searching for the serial number. As a workaround, you can perform a bin transfer by navigating to Transactions > Inventory > Bin Transfer in the UI of the admin role.…

Hi @User_KAGURA, As noted in SuiteAnswers ID: 40254 Add Customer Name in Demand History by Item Detail Report and previously aligned, the reports only captures posting transactions such as sales orders. Unfortunately, since work orders aren't a posting transaction this is currently a system limitation on a standard…