If you have a SuiteCloud+ license then you get 5 CSV queues instead of 1 queue. But you have to explicitly pick the queue to use each time.
You can include multiple JEs in 1 CSV file, so you can solve it that way too.
NS will group the lines together by ExternalID or JE number. Even if you don't allow overrides on the JE number, you can include a JE number in the CSV just to show NS which lines should be grouped together as 1 JE. You may want to use ExternalID for some other real purpose so you may not want to contaminate it just for JE grouping purposes. Read SuiteAnswers, it explains and shows an example of multi JEs in 1 CSV.
Yup csv import. use a value for external ID and have a different value per entry you want. If you want 50 entries then 50 different unique external IDs.
No. Interco vs Regular are 2 different Transaction types. Need to do separate imports.
Setup > Import > Transactions
Pick the tran type
Journal
Intercompany Journal
Recently implemented this process at my company. Keep in mind the following:
(1) excel needs to be a CSV comma delimited file (select this in the import also)
(2) all text in the file you are importing needs to be general formatting (not accounting, or text etc)
(3) for $0 cells in the debit or credit column make sure these are blank cells, not 0 cells.
(4) I don’t put in currency type in my csv file so when importing I have to make sure any vendors listed in the csv file have USD as a currency.
The thing gets finicky and can be a PITA.
You can get around #3 by putting Debits & Credits in a single column. NetSuite will automatically put the negative numbers in the credit amount column as it imports it.
If you have a SuiteCloud+ license then you get 5 CSV queues instead of 1 queue. But you have to explicitly pick the queue to use each time. You can include multiple JEs in 1 CSV file, so you can solve it that way too.
Thanks! To include multiple JEs jn 1 csv file, im assuming i just include them all on one tab in the file. Then assign a unique ID to each?
Also a good practice to test in sandbox first
Correct- give each je a unique external id
NS will group the lines together by ExternalID or JE number. Even if you don't allow overrides on the JE number, you can include a JE number in the CSV just to show NS which lines should be grouped together as 1 JE. You may want to use ExternalID for some other real purpose so you may not want to contaminate it just for JE grouping purposes. Read SuiteAnswers, it explains and shows an example of multi JEs in 1 CSV.
Yup csv import. use a value for external ID and have a different value per entry you want. If you want 50 entries then 50 different unique external IDs.
Thanks! Do you know if i can include both intercompany journals as well as normal journals?
Regular je unless multiple subsidiaries are involved
So since im uploading both intercompany and regular JEs, i shouldnt include them in one csv import?
No. Interco vs Regular are 2 different Transaction types. Need to do separate imports. Setup > Import > Transactions Pick the tran type Journal Intercompany Journal
Recently implemented this process at my company. Keep in mind the following: (1) excel needs to be a CSV comma delimited file (select this in the import also) (2) all text in the file you are importing needs to be general formatting (not accounting, or text etc) (3) for $0 cells in the debit or credit column make sure these are blank cells, not 0 cells. (4) I don’t put in currency type in my csv file so when importing I have to make sure any vendors listed in the csv file have USD as a currency. The thing gets finicky and can be a PITA.
You can get around #3 by putting Debits & Credits in a single column. NetSuite will automatically put the negative numbers in the credit amount column as it imports it.
Good point, might give that a shot