-
Sales Order with 13,000+ Lines – What is the Recommended NetSuite Approach?
Hello everyone, We have a business requirement where a single customer order can contain approximately 13,000 line items. We understand the documented transaction limits: UI: 500 lines per transaction CSV Import / SOAP Web Services: 5,000 lines per transaction Transactions with more than 1,000 lines may also impact…
-
CSV Import - How to Update Sales Orders While Keeping the Sales Team Blank?
Hi everyone, I'm using CSV Import to update existing Sales Orders in NetSuite. My CSV file only contains the fields that I want to update, and I do not want to assign any Sales Team members. However, during the import, I receive the following error: You must enter at least one line for sublist: Sales Team. My intention is…
-
CSV Import - How to Update Existing Transaction Line Fields (Department / Class) ?
Hi everyone, I'm trying to perform a CSV Update to modify existing transaction line fields, such as Department and Class, without changing any other line information. Based on the NetSuite Help documentation for Line Item Updates on Transactions Imports (Suite Answer ID#37258), NetSuite recommends using Items : Order Line…
-
Permission Violation
"Permission Violation: You need a higher level of the 'Lists -> Perform Search' permission to access this page." This morning users are suddenly getting a permission violation when searching for items on a sales order line (also quotes and opportunities). The roles all have Lists>Perform Search - View permissions. I have…
-
Transaction line in Revenue Recognition Event
How is that transaction line created and show in the transaction line drop down when creating revenue recognition event? When creating a revenue recognition event the transaction line (transactionline) is mandatory. I'm trying to create events for a Credit Memo but there is no transaction line showing for that credit memo…
-
Netsuite account for a retail enterprise with extensive number of transaction lines
Hi. During our analysis of the business's existing transactions, we observed many transaction lines. After reviewing the monthly transaction line count in the workbook, we've noticed that this count is significantly inflated due to the inclusion of COGS/tax lines for each transaction and majority of their sales are through…
-
Update Item fulfilment via CSV
Hi, I need to massively update a column in the item fulfillment line but i cannot find the record in the CSV import page and i don't need to massively create item fulfillment via CSV. I cannot update the table via JDBC either.. there's a chance to massively update the records? best regards Filippo
-
Changing Location of IA Line Items with Paste
I have a large Item Receipt record that has been attributed to the wrong location. I changed the location main line however it has no effect on the line items what is the purpose of the Main Line Location if it apparently does nothing? and much more importantly why is it the case that when i paste in the correct value into…
-
AMORTIZATION_SCHED_LINES and TRANSACTION_LINE_BOOK_MAP in Netsuite2.com
Hello, AMORTIZATION_SCHED_LINES and TRANSACTION_LINE_BOOK_MAP were available in netsuite.com datasource. What are the corresponding tablenames in Netsuite2.com Thanks, Saqib
-
Item download file Internal ID
We have the download file name exposed on the Item record and using a custom transaction line field, the file name defaults to the Transaction Line. I would like to add the file Internal ID to the Item and deliver that to the transaction line. I have tried to define another custom Item field and custom Transaction line…