Mi contenido
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Comentarios
-
You should have defaults set. directly above that checkbox. <setup>, <accounting>, <accounting preferences>, Items and Transactions tab
-
I am hoping it is this simple... We experienced the same thing and found out that our warehouse needs to run the "Bin Put Away Worksheet" https://system.netsuite.com/app/accounting/transactions/binwksht.nl What happens is Customer Service (or who ever takes customer returns back) does a return for an item. NetSuite…
-
I asked the same to support and was told that the system notes for members of assemblies and kits is an enhancement request. Sorry but I didn't record the number.
-
I do not subscribe to the rule. Took us a couple of months to get it correct but I would never go back to using No Bins.
-
Our biggest problem was our purchasing group would remove "Use Bins" while a bin had a quantity on hand. Perform a few weeks of transactions and then add the bins back. This is what throws bins WAY out of whack. Example: item ABC has bin# xyz with a quantity of 10 User changes item to uses Bins = False you sell 3 item ABC…
-
Actually on your item saved search specify Vendor, Vendor Code, Vendor Price and Vendor Schedule. For items with multiple vendors entered you will get multiple entries. To get the info for just the preferred vendor, add criteria of "Vendor Is Preferred"=True or to get just the secondary, use False. Do not specify it and…
-
Did you ever find a resolution for this? I may have stumbled upon one for you. We had a similar problem except it was the inventory group that was turning off Bins, doing transactions and then turning it back on with the original Bin number. How we resolved: Created New Bin Numbers that were VERY similar (but different)…
-
Check to see if someone Attached a script to the entry form. I had an intern attach a bad script to a production form and had a similar problem.
-
@andy I know how you feel. I just found that out yesterday as well...:D
-
Are you using the actual "Locations" function of NetSuite and is that what is really causing the problem? Or are you just trying to do a mass move of items from their current Bin to another?
-
That is perfect. Thanks! Having never had formal training in Saved Searches I keep forgetting I can use the SQL Expressions. You have greatly simplified my life :)
-
We use Bins also and found that just unchecking the Use Bins function may cause more damage than good if you ever want to go back. That being said, since you want all stock to come out of location "City, State" are Bins really needed? Or do I not understand this and your "City, State" just part of the Bin Name/ID? Also…
-
In order for a Sales Order to impact inventory it must be in approved status. Once the Sales Order is approved, use the Available Quantity to reflect what your inventory is. If you are using the NetSuite cart, that should already be happening.
-
<snip> When adding the DEF in our method, I'd just alter the item description to note what is going on. So, if the standard line item says... Item #.........Description............PRICE DEF............brass widget ....... $10 We would alter it to..... Item…
-
Thanks for the replies. Unfortunately I need an order to go to the warehouse to still Pick/Pack/Ship the original ABC item. If I send an order out to the customer with a pack slip of DEF I will get another call of possible mis-ship as many of our products are similar with important minute changes. So my original problems…
-
If I remember correctly, it takes till the next day to be able to do transactions against it.
-
Interesting. Wish I would have seen this sooner... We used custom forms Edit pricing only - Form has All field Inline only (except pricing as it cannot be changed) Edit all BUT pricing is displayed on the form, we didn't even show it.
-
I would just mass update the old item setting the Obsolete Date and the add the new member item setting an effective date that same.
-
Go look at the default uncustomized form. "Should" be on the main tab and visible by default
-
Shot in the dark BUT if you use Bins, have you checked the Bin Putaway Worksheet?
-
I still have the Contact (and customer) joins in both 2018.2 as well as my release preview for 2019.1 Does the role of the person doing it have Contacts under the list permissions?
-
My apologies as this does not directly answer your question BUT if you were using Kits in place of Groups, this would be a very simple search.
-
Way too detailed probably to go into here. I almost always will just save the CSV to a PC Folder and use Microsoft Query to import into Excel. I can do additional sorting, criteria, move columns around and even create calculated columns using SQL. If this is data you will run often and want to do different functions, the…
-
*** Edit *** Ignore this :rolleyes: See Roberts response below about SuiteAnswer 61543 Not missing anything (unfortunately). Supposedly SuiteAnalytics Workbooks will (eventually) solve this but in the mean time I have a couple of custom fields derived from a saved search and then Stored versions of each that are updated…
-
I believe the problem is the "-" within the Display Name. I have items with dashes that force you to type all including the dash
-
Yes, same here. Once you save the Saved Search CSV for all the tables, you would Microsoft ODBC them to tabs with VLookup OR do the joins within MS Query itself (No limitation on how far you do the joins out either)
-
Robert, Thanks for that. Didn't even know those fields were there as I do not see them on any of my forms. Are they part of LSA bundle?
-
You could use a CASE function So if you wanted to see records where internal id is between 1 and 1000 OR 2000 and 3000 "case when {internalid} >= 1 and {internalid} <= 1000 then 1 when {internalid} > 2000 and {internalid} < 3000 then 1 else 0 end" is equal to 1 (see attached)
-
The NEW Analytics Workbook function "should" allow for that kind of join but not sure.
-
My first guess is the it is a Locked Bundle (not just that field).