Clarisa De Torres-Oracle NSC Guru

Hi @Gina Kessler can you further elaborate what do you mean by "with relation"? Can you provide screenshots for reference. Kindly cover any confidential information. Thank you!

Hi @Kevenale thanks for initiating this conversation. Hello everyone! We’d really appreciate it if you could share your thoughts and experiences to support a fellow member. Your input is valuable and much appreciated!

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

@User_FJEEG You're welcome! Glad the CSV upload worked :) Also, if you found any of the responses helpful, we’d really appreciate it if you could click “Yes” under “Did this answer the question?” on those comments. This not only helps other community members find solutions more easily, but it also brings you closer to…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you todirect them to our newly launched "New to NetSuite" page.This page is specifically designed to offer them information and guidance andhelp them make the…

Hi @User_DATN1 To pull up the Credit Memo on a Customer Refund Saved Search, try following the steps below: 1. Under the Criteria tab > Standard subtab > add Filter: a Type is Customer Refund b Applying Transaction Field... Type is Customer Credit Memo 2. Under the Results tab > Columns subtab > add the field: a Applying…

Hi @User_FJEEG just checking if you were able to check the previous comment? We would greatly appreciate if you can click "Yes" on “Did this answer the question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same concern find the answer easier and you will…

Hello everyone! We'd greatly appreciate your support in this matter. Your willingness to assist a fellow member doesn't go unnoticed and is sincerely valued. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page.This page is specifically designed to…

Hi @Jim Miller Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. Your willingness to assist a fellow member doesn't go unnoticed and is sincerely valued. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly…

Hi @lufiali , were you able to check the comment above? Kindly let us know should you need further assistance. Thank you!

Hi @lufiali , were you able to check the comment above? Kindly let us know should you need further assistance. Thank you!

Hi @User_FJEEG per checking as of the moment, there is no way to expose this field on the Customer record itself. This is covered by Enhancement No. 112229 | Add a "Show External ID" preference to the UI. The External ID field cannot be edited manually. This is also not also available for Inline Editing. The only way to…

Hi @Craig_Verde looks like this would be best answered by our fellow community members. Tagging some of them here: @Tigran Shahnazaryan @Miguel Ariza - Sol4IT @Amanda Edwards @CDuf @Dext3r @Hormese Paul @Manu Antony Vadassery @Tapendra Singh Please feel free to share if you have similar experience and have developed an…

Hi @User_BCKYD per checking, the feature you were looking for is currently a system limitation logged under Enhancement #229217 Return Authorization>Refund> Credit Memo> Auto Apply to Invoices related to transactions. You can go to SuiteIdeas page to vote for the enhancement. Apologies for the inconvenience this limitation…

no worries, @Daniel Katzman ! Let us know if you were able to figure it out :)

Hi @Daniel Katzman can you confirm if the user just added additional financial row for depreciation and amortization expense but didn't exclude it on the Expense row? Can he try to add a criteria to exclude them on the expense row? As mentioned, having an account on multiple rows might cause an issue since this is still a…

Hi @lufiali have you tried including Sales Team as column on your CSV file but with blank data and map it on the import page? Can you also check the Overwrite Sublists box and see what will happen? Please test this first on your Sandbox account to see and observe the result. Thank you,

Hi @Daniel Katzman can you confirm if this is how the user did the formula? Here's an example of a Customized Income Statement (US) report builder: On the expense financial row, I have to add a criteria to exclude the Depreciation and Amortization expense since the ability to assign an account to multiple Financial…

Hi @lufiali , no worries! Yes, if you want to update the line item of the Invoice, you will use the Line ID from the saved search created that will be used for your CSV file then map it with Invoice Items : Order Line from the Import Assistance page. You can also refer to SAID 85299 Update Transaction Line Item of an…

Hi @Kedalene glad to have you with us today, and thanks for posting here in the NetSuite Support Community! Greetings everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valuedand appreciated! -- In case you know…

Hi @Daniel Katzman can you try to check the sign for these amounts and if the appropriate operator has been used for the formula?

Hi Kabelo, if you want the Date filters similar with the standard A/R report, unfortunately, this is currently a system limitation. Workbook's date filter is limited to Year, Quarter, Month, Day, Date. The ability to have the same selection from a report/saved search when choosing date filter on workbook is logged as an…

Hi @Toanne Termeer thank you for the additional information. Per further checking, we do not have a direct way to pull the disc avail on the Payment and Invoice Form to be utilized in a Formula. Adding fields - Discount Taken and Discount Available is currently a system limitation filed under Enhancement 117088 Reports >…

Hi @lufiali were you able to uncheck the never empty box on the customized form? Can you check what's the preferred form for Sales Order under Customizations > Forms > Transaction Forms. Check Type = Sales Order then try to select the form you have customized (never empty = F) as the preferred one then perform the import…

Hi @Kabelo Tshukudu per checking it seems that you were able to add filter on the Category field. It's the same way with Date/Period if you have added them on the Dataset. You can place them under Rows together with Entity and Category. Hope this helps.

Hi @lufiali per checking your screenshot, it seems that the Line ID is already added on the saved search results: Once you have prepared the file, you can now start importing the file via Setup > Import/Export > Import CSV Records. On the Import Assistant page > Field Mapping step, you'll be able to map the Line ID from…

Hi @Kabelo Tshukudu thank you for the details. Upon searching "category" can you try clicking this button "Show more results" Once it loads, try to expand it to the right then use the 2 scrollbars to scroll downwards and look for this: Let me know if this works for you :)

Hi @ShaunH thank you for the additional details. I was able to replicate the behavior on our test account and per checking there is currently no standard unapplied payment report, however, there is an existing enhancement related to your concern under #24787 Reports>Add unapplied customer payments report. The alternate…

Hi @Kabelo Tshukudu can we have the case number? Were you able to mention your scenario that the entity field is missing so they could somehow check it on their end.

Hi @Toanne Termeeri tried replicating your saved search with the same criteria and results, however, i was unable to replicate the error you have encountered: Since we are unable to replicate this in our test account and the error doesn't give away any other details, it is recommended to file a case and reach out to…