-
Download transaction data?
HI, I'm looking for a way to download all transaction data. Literally every field from every transaction since we started using NetSuite. I've tried the 'Full CSV Export' from Settings>Import/Export, but only get other records like our Vendor and item lists and a variety of reports which only include data from this month.…
-
Migrate Historical Intercompany Trial Balance
Hi Team, We are in the process of migrating our data from Quickbooks to NetSuite however we are encountering issues with migrating our Intercompany balances. We encountered error message: Elimination settings for the journal line, account, and name do not match. To check this line for intercompany elimination, you must…
-
Transactions tab under Financial Vendor Record
Hi, User is not being able to see historical transactions (Transactions subtab) under Financial tab in a custom role. Please note that 'Financial History' permisssion is added on the role, current access level being set to Full
-
Best Practice to load open AP and AR transactions after go-live?
We went live on NetSuite on 5/1/24. The historical trial balances were loaded at a summary level. For the open AR and AP transactions as of 4/30/24, what is the best practice? I was thinking that a clearing account for AP and AR would be a viable option versus entering them to the respective revenue and expense accounts? I…
-
Import historical data for only one subsidiary
My customer created a new UK subsidiary and they need to import 7 years of historical data. I would like to know which would be the best way to work on it, considering that we will need to reopen periods. Would be a good ideia to create another fiscal calendar and assign only to this subsidiary? would this calendar…
-
Making Tax Digital (MTD): Reports > VAT/GST > Tax Reports (International) - submit in new currency
Hi, I wanted to check the forum's opinion in here, in addition to our NetSuite partner. We have setup a new accounting book in GBP currency in our Production and Sandbox environment. The reason being that we need to upload our UK Tax Reporting with HMRC by using the in-built NetSuite function for Making Tax Digital (MTD):…
-
Historical legacy records for reporting
Hello! I need to bring historical legacy records into NetSuite so they are available to report on. Specifically, sales records (what was sold) by customer and item. In another discussion I learned that bringing the invoiced records isn't feasible as there isn't an easy way to close, void, or mark the invoice as paid in…
-
Manually closing (marking paid in full) an invoice
Hello. I want to load historical invoice transactions in from our legacy system prior to our NetSuite implementation so I can have historical year-over-year sales reports. My implementation consultant told me to load the invoices in via .csv, then reverse out the financial transactions the invoice load will cause, and then…
-
How to upload a bank statement in CSV or excel format and delete/match previous uploads?
Hi, We currently have several transactions from prior years that have not been reconciled in the bank reconciliation, nor will they ever be reconciled and so when attempting to clean this up, a solution would be to upload an amount on the bank statement side with the specific amount, since it is non posting item in the…
-
Mass update to mark historical transactions to cash accounts
We just imported our historical transactions (J/E's) from 2016 - 2020. We were told by our NS implementation team that we had to "manually" mark those transactions (reconciliation) to our checking accounts. We are talking thousands. Corporations must have millions. They said they typically enlist a team of Netsuite people…