Dominica Sevilla-Oracle Blue Diamond

Hello @Stuart Anderson, As per my understanding, you want to exclude some Open Invoices when receiving Customer Payment as they are already paid prior on being imported in NetSuite. Depending on your company policy, deleting an Invoice may not be an option. If your company policy allows, you may be able to void an Invoice…

Hello @User_E2PEY, Good day! 😊 Kindly try this Saved Search. Navigate to Lists > Search > Saved Searches > New Select Customer Rename the Saved Search Under Criteria tab > Standard subtab, add the following filters: Transaction Fields... Type is Sales Order Transaction Fields... Main Line is True Date of Last Order is…

Hello @User_NC62U, Can you confirm if the provided SuiteAnswers article worked on your end? It would be appreciated if you will click "Yes" on "Did this answer the question?" on the comment/s you find helpful. This will aid the others with the same question to easily find the answer. Thank you! 😊

Hello @Benjamin Paul - USA, It would be appreciated if you will click "Yes" on "Did this answer the question?" on the comment/s you find helpful. This will aid the others with the same question to easily find the answer. Thank you! 😊

Hello @User_A036B, Welcome to NetSuite Support Community! 🎉 Thank you for creating this 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. 😊

Hello @User_NC62U, If the Item doesn't have any Sales nor other transactions, the system has no history where to base the cost of your Item. Since no cost is present, the calculation for other columns will not be done as well, making your Inventory Turnover Rate and Average Days On Hand blank. Please refer to SuiteAnswers…

Hello @User_NC62U, Kindly check SuiteAnswers 71701 List of Items that does not have any related Sales Order or Invoice for more than Three Months. I hope this helps and will work on your end. Thank you! 😊

Hello, Good day! Do you need further assistance on this? To help me with my testing, I would just like to follow up on the addition information requested. Thank you. 😊

Hello @KNason76, Good day! You can check SuiteAnswers 78488 Item Saved Search > Inventory Detail Sub tabs (Inventory Detail, Bin Number and Inventory Number) > On Hand and Available. I hope this helps. Thank you. 😊 If you find this reply to your question as helpful, others with the same question might find it helpful as…

Hello Rachel, Kindly check if creating a Custom Field will work for you. Documented in SuiteAnswers 14019, there are scenarios where users want to source the Item Unit Price (Rate) of an Item from their Sales Order form to the Item Fulfillment form. This can be achieved by creating a Transaction Line Field applied to the…

Hello @Betsy Vance, Good day! As per my understanding, you don't want the view for your Locations to be in a long line, or in a horizontal view. Instead, you want to view their fields in a pop-up. Upon checking, the expected behavior seems possible via Suitelet. However, please be advised that we cannot assist on creating…

Hello @Nermin Wahdan-Oracle, Good day. Upon checking, it is best to reach out to our Professional Services team as they handle implementation concerns. Thank you for understanding. 😊

Hello @Benjamin Paul - USA, Good day! Note on Step 6, Under Available Filters tab, do the following: Mark Show in Filter Region checkbox Add Date This will allow you to filter the result with transaction on certain date. I hope this clarifies your concern. Thank you. 😊

Hello @User_JVL1I, 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. 😊

Hello Rachel, Good day! 😊 Apologies for the late response. It seems that the expected behavior is not possible. Per checking, based on related cases and records, the reason for the behavior is because that the way it functions is by multiplying Quantity and Rate. However, since on Item Fulfillment records, Rate is actually…

Hello Rob, 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. 😊

Hello @Benjamin Paul - USA, As per my understanding, you want to create a report to show average quantity of Sales Order per Item. Kindly check this Saved Search: Navigate to Lists > Search > Saved Searches > New Select Transaction Rename the Saved Search Under Criteria, add Type = Sales Order Under Results, add the…

Hello @User_E2PEY, Did the above worked on your end? It would be appreciated if you will click "Yes" on "Did this answer the question?" on the comment/s you find helpful. This will aid the others with the same question to easily find the answer. Thank you! 😊

Hello @US Water Systems, Inc., I would just like to follow up on the additional information requested. Thank you! 😊

Hello @Burgess-Mel, I would just like to follow up on the additional information requested. Thank you! 😊

Hello @Kitin Basilla, Did the above worked on your end? It would be appreciated if you will click "Yes" on "Did this answer the question?" on the comment/s you find helpful. This will aid the others with the same question to easily find the answer. Thank you! 😊

Hello @MHendi3506, As per my understanding you want to create a report for Accrued Purchases transactions. Kindly check the Saved Search below: Navigate to Lists > Search > Saved Searches > New Select Transactions Rename the Saved Search Under Criteria tab, add Account = account used for accrued purchases Add fields under…

Hello @User_RLW8F, I created a separate thread for this concern for better tracking. Allow us to further check this and will update you as soon as we have more information. Also, please be advised that I removed the file attached as it includes confidential information such as address. To other users, feel free to share…

Hello @User_RLW8F, I would just like to confirm, when you mentioned Fulfillment notification, are you referring when printing Packing Slip or email notification? Also, if you use Standard Packing Slip form, do you still encounter the reported behavior? Thank you! 😊

Thank you for this, @User_O6D8L. Is this the Subsidiary with Internal ID = 4? Also, can you provide the other information requested? Kindly confirm if you are importing Inventory Adjustment or Inventory Adjustment Worksheet. To help me with my testing, please provide screenshot of the Field Mapping of the CSV Import as…

Hello @User_S7PLZ, I would just like to follow up on the additional information requested. Thank you! 😊

Hello @US Water Systems, Inc., Kindly confirm the following: On the Sales Order record, on the Create PO column on Item line, confirm if it is Drop Ship or Special Order. On the Purchase Order created, confirm what form was used. If you use Standard Drop Ship Purchase Order form, is the expected behavior will be…

Hello @Kitin Basilla, Under the Saved Search's Results tab, add Item Fields... Purchase Price. I hope this will work on your end. 😊

Hello @Kitin Basilla, I am assuming that you are working on a Transaction Saved Search. Under its Results tab, add the field, Item Rate. Here are helpful SuiteAnswers you can check as well: 12077 Display Item Unit Price or Rate in Transaction Saved Searches for Sales Transactions 75439 Saved Search for Invoices with Line…

Hello @User_E2PEY, Good day! 😊 Kindly try this Saved Search. Upon further testing, I encountered the expected result using this one. Navigate to Lists > Search > Saved Searches > New Select Customer Rename the Saved Search Under Criteria tab > Standard subtab, add the following filters: Transaction Fields... Type is Sales…