JamesMorris's Profile
Intermediate
800
Points

Questions
4

Answers
134

  • Intermediate Asked on May 22, 2023 in How To's.

    Check out “Entity Bank Details fields missing for CSV Import” SuiteAnswers ID 82290. I think that should get you squared away without the need for a mass update or scripting.

    • 124 views
    • 1 answers
    • 0 votes
  • My understanding was also that you can only process transactions for US (and maybe Canadian?) subsidiaries without the Advanced Electronic Bank Payments. Although perhaps this has changed, as I haven’t interacted with this in a while. That and multi-currency (as you mentioned) were the two big things most companies ran into where they had to pony up for it.

    • 54 views
    • 1 answers
    • 0 votes
  • Intermediate Asked on May 22, 2023 in Saved Searches.

    Pretty sure you would have to script that if you wanted to dynamically generate a dropdown list each time. List/record dropdowns are static otherwise. You can create dependent dropdowns without scripting though, where you pick one dropdown to give you differing options in the second dropdown based on the first selection. “Steps for Creating Dependent Dropdown Lists” SuiteAnswer 102865, is a good place to start if you want to go that route.

    • 53 views
    • 2 answers
    • 0 votes
  • Intermediate Asked on April 25, 2023 in Accounting.

    You need to select a vendor in the “Name” field at the line level. That’s where you can associate specific JE lines with a vendor, customer, or employee.

    • 136 views
    • 1 answers
    • 0 votes
  • Intermediate Asked on April 21, 2023 in Administration.

    Employees are not considered a subordinate unless they are put in the supervisor hierarchy. Essentially, you need to go to all those other rep’s employee records and select their manager in the “Supervisor” field and then save the record. It’s totally fine to have your intended person multiple levels up in that hierarchy, as long as their subordinates are under them, or people under other people who are under them, etc., etc.  Check out “Setting Employee Restrictions” SuiteAnswers ID 91070 for more detail.

    • 107 views
    • 1 answers
    • 0 votes
  • Intermediate Asked on April 10, 2023 in Banking.

    Your bank rep should be able to give you the specifications or put you in touch with someone who can. Other companies’ formats may ultimately be different than yours, for a variety of reasons. You can just copy the closest existing format and tweak that until you get it right. “Setting Up Payment File Formats” SuiteAnswers 35024 is a good place to start. I know the syntax can be a little intimidating at first, but it’s actually pretty straightforward when you look at it closely.  And if you tell the technical person from BoA that you’re using NetSuite, depending on who you get, they might just be able to give you the whole thing exactly as you need it.

    • 130 views
    • 1 answers
    • 0 votes
  • Intermediate Asked on April 10, 2023 in Saved Searches.

    Take a look at “System Notes Overview” SuiteAnswers 92570 and the various linked articles. “System Notes Documentation” SuiteAnswers 93723 is a good (although not completely comprehensive according to the article itself) list of audit related articles.

    • 141 views
    • 1 answers
    • 0 votes
  • Audit trail is a good start (Transactions > Management > View Audit Trail).  A saved search of system notes is a good second, more thorough step (Reports > Saved Search > All Saved Searches > New, then select “System Note” as the base record, then create your saved search and run it).  If you want to see what saved searches people are running, you could do a saved search on the “Saved Search” base record, and you can see the Last Run By and Last Run On fields. I don’t think you can run the full Audit Trail list for searches other than looking in the UI at each search individually (or maybe you can see it via ODBC or SuiteAnalytics Workbook, but not sure there).

    • 146 views
    • 2 answers
    • 0 votes
  • Intermediate Asked on April 4, 2023 in How To's.

    Is that a field? An option in a custom record/list? Something else? To find the internal ID of a field, go to Home > Set Preferences (General tab) and check the “Show Internal IDs” checkbox. Then click on the field level help (the label) of that field and it’ll be in the the help box that pops up. Alternatively if it’s a native field you can look at the Suitescript Records browser, or if it’s a custom field look at your list of custom fields and find the internal ID there. If it’s an option in a custom record/list, mark show internal IDs as mentioned previously and go to the list link for the appropriate custom record or list. Internal ID will be displayed in the leftmost column. Alternatively, open the record itself and look in the URL bar, the id=XXXX will be where the internal ID is (it’s just the XXXX number, could be any number of digits).

    If those aren’t what you’re looking for you’re going to have to provide a little more detail about exactly what you’re after before anyone will be able to help.

    • 91 views
    • 1 answers
    • 0 votes
  • Intermediate Asked on April 3, 2023 in How To's.

    I’m not sure what, if anything, is actually different for the “Jcurve version” (after a very brief google search, I suspect that that nothing is different, and Jcurve is just your implementation partner). Regardless, you should be able to export, by creating a saved search on the Transaction record type, and then filtering the criteria to Type = Purchase Order (and whatever other criteria you need).  You can then export this to excel or csv via the appropriate buttons after running it. Check out “Defining a Saved Search” SuiteAnswer ID 8474 and the other linked SuiteAnswer articles on that page if you’re unfamiliar with saved searches.

    • 171 views
    • 2 answers
    • 0 votes