-
multi CSV price import
I am testing multi CSV import in my Sandbox instance. File 1 is Internal item ID and Item File 2 is Internal item ID, Item, Currency, Price, Price Level, Quantity I am getting 24/124 records updated and all of my failures say "Please enter missing price(s)" I have attached a screen shot of what I am trying to import and…
-
The invoice CSV upload job name in CSV import status changed into "Charge Sales Invoice"
Hi Team, I encountered an issue when uploading CSV invoice. After running the upload, I review the CSV Import status and find that the job name is stated as "Charge Service Invoice". It is very confusing, since from the very first step I only choose the import subtype as a invoice transaction. Here is the screenshot below:…
-
Mapping merchant field on employee imported credit card transactions
We have employees that use personal credit cards for their travel expenses (not commercial cards) and we want them to import their transactions via CSV and then create their expense reports. Then we will reimburse them. I've been testing the process and everything works great, except I cannot map the Merchant field from my…
-
New to NetSuite | Import Lease Payments
Building on our previous discussions in the "New to NetSuite" series, we now present a detailed guide on the second method of creating lease payments, the CSV Import method. If you wish to know how to create it manually, you can check New to NetSuite | Method 1: Lease Payments via Lease Amortization Schedule subtab. This…
-
New to NetSuite | Method 2: Import Lease Record
We previously explored the first method to create lease records in this article. Now, we're going to dive into second method which is importing lease records, which is perfect when you have lots of data to import. Go to Setup > Import/Export > Import CSV Records. In the Import Assistant Step 1 – Scan & Upload CSV File…
-
NetSuite Admin Tip | Importing Journal Entries in Two Simple Ways
When it comes to managing financial data imports, Administrators play a crucial role in understanding the implications of different methods. Specifically, when creating Journal Entries from imported data, there are two different approaches. Each method carries its own set of benefits and constraints. This knowledge ensures…
-
New to NetSuite | Resolve Error: “The file upload failed...” During import with a default parser
When performing bank imports using default parsers in NetSuite, such as CSV, OFX, QFX, BAI2, or CAMT.053, users may encounter various errors. One prevalent issue users face is related to file naming conventions, and the below error is likely to occur during the import process. In NetSuite: In NetSuite Next: This error…
-
New To NetSuite | Understanding Banking Import History portlet
Reconciliation is a critical aspect of financial management in any business. With the goal of reducing paperwork, NetSuite offers a streamlined process to match transactions through automatic or manual import, ensuring bank transactions align with their corresponding book entries. NetSuite provides users with a powerful…
-
NetSuite Admin Tip | American Express Integration for Expense Reporting
In the world of business, efficient expense management is crucial for maintaining financial control and ensuring a seamless workflow. Say goodbye to the cumbersome task of manual expense reporting with NetSuite's innovative solution—the AMEX Corporate Card Integration SuiteApp. This feature is a game-changer for businesses…
-
Having issues importing item groups
I am a newbie to NetSuite. That does not help me much…. We are adding a 2nd tier pricing for a product line, so I took all the first tier items and created the second tier. They all appear good to me, but I am not sure… I am importing item groups and I am seeing "Invalid item reference key (component item)" when I looked…