プロフィール
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.
コメント
-
If they are custom fields on the Employee record I would do a search instead of a report.
-
I would use the inventory turnover report. It factors in what is on hand as well as sales.
-
Yes, sort of. What you want is a transaction search of fulfillments. Group byb Item, summary type date select Maximum, this gets the last fulfillment date, Possibly do a formula to get # days between that date and today? Also know that if an item does not have a fulfillment against it, it will not show up in the list.
-
That would be reports and not saved searches.
-
I would suggest ODBC and Crystal Reports. The ODBC driver gives access to most (but not all) of NetSuite and Crystal will give you almost unlimited flexibility.
-
Transaction Search. Criteria: Date Created = Yesterday, Posting = Yes Results would be your fields specified above (but mapped to the proper NetSuite fields)
-
Unfortunately I am also scripting challenged. One of my customers uses the Celigo Integrator I/O tool to run the searches and then export to FTP server (which I absolutely love).
-
The data extract should be a simple saved search ran after midnight for any GL posting transactions that were created on the Previous Day. The fun part (and I do not script) is to have a script run that runs the search and exports to the FTP site.
-
I used to do that with the Inventory Activity report and showing a running balance. I would export to excel to do some date math to get the number of days between transactions to see how long it was at zero stock level.
-
It would be a transaction search type=Bill Payment. I believe the join to the Bill is either the Applied To... or Applying... Records. I always have to select each as I always forget which to use.
-
Could you create a custom field for Locations and add the continent to each of your locations? Customization -> Lists, Records & Fields -> Other Custom Records Then include that field on your reports?
-
Not 100% sure this would work BUT you could create a custom record that mimics the Countries (Setup -> Company -> Countries The customer record would have the country as well as the continent (selected from a custom list you would need to create). On Sales Order create custom field sourced from the country in the address…
-
Total Revenue should just be the sum of the Income accounts in the GL.
-
Sean, Not sure on exceptions as we have not used. Under the covers uses standard ACH transactions so most notably would get: Insufficient Funds Invalid Account I will dig around their boards for more info. Lots of great info here- http://help.dwolla.com/ ) And thank you very much for the reply! John
-
Yes, exactly! We have been on NetSuite (through NetSuite Direct) since prior to SuiteSuccess existed
-
Glad you liked the site! Yes, we are hoping Dwolla takes off. Credit card and PayPal fees are crazy.
-
Bump... Anyone?
-
It is "OK" to do that and no, (unless you have made it required) you do not need a fake email. You may just want to do your sales report by state instead of Sales Manager unless you need the sales manager number.
-
We just uninstalled the bundle about a month after go live for the very same reasons that started this thread.
-
Jim, Just a HUGE guess, but possibly Mass Update permission?
-
In that case, yes, do forecasting from the opportunity as a customer will not purchase 3 different counter tops... Just make sure you have Forecast Type on Estimates to Omitted.
-
kkregowski, it is a setting in Setup -> Company -> General Preferences. "Add Primary Contact to Bill To Address"
-
The way I have always looked at it based upon training from NetSuite: 1) Opportunity record are where you store the items that you feel are a good fit for a customer based upon industry, need, fit, etc. They have not made an inquiry into purchasing a specific product (or products). You can capture Probability for gaining…
-
You could create custom fields as check boxes that represent all the "to do" items and create a work flow that does not allow it to go to pending fulfillment until all the boxes are checked. Just a thought...
-
You may want to check out the bundle/suiteapp "Warranty and Repairs Management" #51007. Has 52 installs
-
I did something previous that was a checklist for new items going onto our website (Copy, SEO, Photos, review)
-
Yes, that was my thought. Don't know if actually possible but just a thought.
-
Actually, the messages, activities are "really" attached to the lead. When you create an opportunity, the Lead changes to a Prospect and all the attachments, messages, etc are still there. Just check the Prospect record.
-
Jim, Can you use the same related items from SO?
-
Jim, You already have my cell so call if you want me to try anything. Traveling to your neck of the woods (well a little farther-NYC) tomorrow. Will have WiFi on the plane so drop me an email.