Can you try this as your search results

message has been deleted

so far this will compare your calculation of the required 'backorder' qty and show you the location that has the highest quantity available.

As a criteria "MAX({item.locationquantityavailable})-MAX({quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) )" Greater than or equal 0. Will show lines which can be fulfilled in total from a location. If it's negative means that the order quantity is higher than the Available qty.

Subject to testing and analysis in your account data

This method will also be prone to an issue where you have 3 orders for 7 units. When compared to the Location Available of 10 units, then each order will show that it can be fulfilled You'll need to filter for that.

Apologies for my ignorance, but can someone please explain the difference between 1099 vendor and a partner entity in NetSuite? If my customer uses external individuals (not employees) for recruitment, will these sales personnel be considered vendors (1099) or partners? Still confused on difference between the two. My understanding is that this would be a vendor since they are performing services for the course of the business through direct sales; but the customer would like to track revenue from these individuals---and i know partner records can be associated with transactions, but can vendors?

I have a formula to count the number of unique records and multiply it by a certain number in saved search. Its summary type is Sum. It seems to be working. COUNT(DISTINCT(CASE WHEN {type} = 'Invoice' THEN {createdfrom} ELSE NULL END)) * (1.79+0.45) HOWEVER, when I use it in another formula since I need to add this to another number, it's no longer working.

Does somebody know a fix to this? We have several parts that have formatting characters in the description. I have deleted everything and retyped it, but it comes right back . I have this on the assembly items as wells purchased items.

hello everyone, stock notification email feature is not working for few items what could be the reason

hello everyone, how to get url of current page of SCA website in 3 step checkout in Liveorder.model file?

[SuiteAnalytics / SuiteQL]: Does anyone know how to remove components of assembly items when viewing transaction_lines table?

Why is the code in the Advanced PDF Template editor getting condensed after switching back from the WYSWIG mode? When return to the code from WYSWIG mode, the line breaks are gone and it makes the code difficult to read. I get this message: Be aware that the template editor may not function properly if you switch back to WYSIWYG mode after edits have occurred in source code mode. What happens is the code line breaks and indents are removed and it all gets put into one paragraph.

is it possible to make a work order location something you can update via CSV or mass update?

Hello, is anyone here using Tesorio? If so what are your thoughts about the tool?

is it possible to add a custom field to the Unit Type -> UOM record? It’s missing a reference for externalID and I’d like to store it somewhere

How to you get a new user to link to your current sandbox?

how can I tell what item groups an item is in?

Hi All, is there a way to bulk print Customer Payments? I did checked the Print Checks & Forms page but there's no option to print receipts.

hello everyone, stock notification email feature is not working for kit/package and assembly items what could be the reason.

I understand that there are different versions of the NetSuite Browser, but is there a reason the "analytics" browser was dropped in 2021_2? From what I have read, the records catalog be used instead.

Hey All... Does anyone know if there is a way to have pick tickets automatically print? With our Customer Service team working from home now it would be great if once a sales order is entered the pick ticket automatically prints to the assigned printer.

How could you limit what custom fields are copied when the "Make Copy" action is used for an Item?

We are using WIP and manufacturing routing. I noticed that upon creating the WO Completion and/or WO Close, the Build field on the WO is not being updated. Is that really the case? The Completed Quantity field on the Operation Task record is updated though.

Does anyone here use OpenAir for project planning and management? If so, how many users do you have interacting within the environment?

Any news RE: New Release Quiz ?

Is it possible to "Assign" a task to more than one employee? Thanks,

Does anyone know how to add a custom saved search sublist to Subscription records? What I want to do (and it seems like this should have been standard anyway, but it isn't) is have a Sublist showing the Usage records associated with a Subscription. I already created the saved search, made it public and available as a List, and set Subscription as the filter. The custom sublists page doesn't give an option for Subscription. Transactions are supported, but I think Subscriptions are actually a type of "Other Record", which is not listed there.

Does anyone know how to export/view on a saved search the ACH data on Vendors? The fields do not show up in the dropdown. Routing numbers, Account numbers etc.

Where do I go to see how many active seats the business has?