In the results subtab, add the same formula except just use {quantity}-{quantityshiprecv} as the formula. The result is the open quantity per line. ~angela

I doubt you can get a refund, but you may be able to get a credit towards new licenses, etc. If you purchased it from NetSuite. Clearly, I'm not in sales. 😏 ~angela

It's sad, really.. People purchase in good faith, and once it's labeled 'Built for NetSuite' and is supported by NetSuite, it feels like it's only about sales. And the clients who purchase it are the ones who suffer. I'm sorry for your frustration. ~angela

This won't be helpful in your case, but I have found that it's worth my clients investment to purchase a 3rd party connector for any integration with an external website. When you have a 'built for NetSuite' connector, there doesn't seem to be available support for the issues you mentioned. I wish I could be of actual…

Journal Entries

To check for scripts- navigate to customization>scripts>scripted records. Choose the transaction types, click edit, and you can see everything running against the record. ~angela

NetSuite Quality management does not meet most company requirements. It supports basic quality needs, but does not conform to government standards in most industries that are managed by the FDA or other government entities. What, specifically - would you like to know? ~angela

If you navigate to Setup>Company>general preferences, do you see this checkbox, and is it checked?

Hi Kedalene, I suspect that you won't find an answer for this question in this forum. The answer is an accounting decision, one that should be made by your own senior accounting department. People here can guess, but your company has to live with the decision. I'm sorry that this isn't the answer you want. ~angela

One suggestion for you: Always have a transaction that you expect to see in your results open - this way you can easily find the fields to add to your search. Under your results tab, add the 'Units'. In this snip, I grabbed both values (there were 2) to ensure I get the one from the transaction. Run the search after adding…

The simple and easy way is to create a 'pro forma invoice' Sales Order. Create the form, and tie a printed sales order version that prints 'Invoice' instead of sales order. It's simple, clean and supports the native accepting customer deposits. ~angela

In your criteria, add a formula (numeric) like this: All lines that are completely fulfilled will be filtered out. ~angela

The simple way to see if there is a script affecting the RMA's is to navigate to Customization>Scripts>Scripted records. Choose the transaction type that you are concerned about, and disable each script one at a time. It is doubtful that a script would make a field inline, but this is how you would check that. ~angela

I'm really confused at this point, as that bundle has been deprecated:

It is always recommended that you test installations of new features in your sandbox. ~angela

You have to update the lines that are open on the PO to closed, individually - The PO Status is a summary status made up of the line values. When you click the 'close' button on the actual PO in the UI, it marks all lines on the PO that are still open to 'closed' I don't believe that you can perform this action via a…

You have to update the lines that are open on the PO to closed, individually - The PO Status is a summary status made up of the line values. When you click the 'close' button on the actual PO in the UI, it marks all lines on the PO that are still open to 'closed' I'm not sure that you can perform this action via a…

When using ODBC, the connection to NetSuite is driven by the type of external application you are using to connect. Depending on the application, the data retrieval process may not be the same. What external application are you using to connect via ODBC? ~angela

It sounds like your team needs to clear their browsing cache. If this is not done regularly, things like what you're describing happen - along with other weirdness. Here is a document on how to clear your cache, and optimize your usage of NetSuite. ~angela

I was able to easily add a group of static customers. You may want to clear your cache and try again. Or log in using incognito mode and give it a try.

You should be able to source the field 'intercotransaction' (PAIRED INTERCOMPANY TRANSACTION) to the search to see the related PO. Is that not working? ~angela

Customize your report, and check what is set in the 'description' under more options. Titles don't usually repeat the report title. Make sure this description box does not have 'Demo NonProfit' in the description column. If it doesn't, then it's in the company setup. Let me know and we can go through the troubleshooting…

Hi Kedalene, Intercompany elimination entries are created during month end, when the closing process is run. (Assuming that interco framework is configured). Journal entries with the 'elimination' column are Intercompany Journal Entries, while journals without the elimination column are standard Journals. Unless something…

Unless something changed recently, you cannot publish a dashboard to the mobile app. The mobile app is very specific, allowing users to enter time, expenses, etc - it's not expected to support custom activities. Sorry it's not the answer you want. ~angela

Hi Kedalene, To understand the difference, you need to understand the purpose of the 2 tables. The consolidated exchange rate table is used to drive reporting. It contains the Current, Average and historical rates by month. Depending on the settings within each account in your COA, accounts can be converted for reporting…

Your issue is occuring due to the field attempting to source data again when a PO is created. However, if the 'store value' of the field is checked, it shouldn't source again. Can you provide 2 sets of screenshots? 1 set is a field that is sourcing on the PO as expected, the second should be a field that is not sourcing…

To create a new one time posting rule, create a new rev rec rule, and choose 'one time direct' as the posting type. You can then apply this rule to the items you want to post once without further rev rec to apply. ~angela

Hi Ken, You will need administrator access in both systems to create the tokens. It's best if the user for the integrations has a web services only role. Is it safe? I can't answer that specific question, but I can tell you this: when connecting to a web services only role, there is a high level of security. Also, any…

Now, with 2024.1, you are correct. You can no longer just add email addresses to the report schedule, or even to just email the report. You will need to update the report to add either a group, or specific recipients. If the recipients are employees, you can create the employee record without giving them access. Note- to…

Yes. In your screenshot, set this field: This will apply to the entire order. ~angela