Discussions
Import QIF File
I am trying to import a QIF file of credit card transactions using the Setup > Import/Export > Import QIF File option. This is to create brand new CC transactions in NetSuite (not the Bank Stmt Reconcilation function which also accepts QIF files)
I cannot get NS to match the existing G/L account. Instead NS creates a new account in my G/L.
We use 6-digit G/L account Numbers, so I have tried all 3 of these strings:
123456 Account Name (concatenated G/L number space Name)
Account Name (G/L Name Only)
505 (InternalID of G/L Account)
So, does anyone know how to format the Account string so it will match to an existing G/L in NetSuite? Help!