Hi all.
Anybody know why I get an "Invalid parent...
# accountingk
Kristofer Nael Mayordomo
12/04/2020, 6:05 AMHi all.
Anybody know why I get an "Invalid parent key" on my csv import for COA even though the account for parent exists and not inactive? The account was Retained Earnings.
n
Netsuite Tragic
12/04/2020, 9:08 AMIf you are doing it as text, you need ot be specific on the spacing between the levels ie Top level [space][colon][space]Account name. Top Level:Account will fail , Top Level : Account will pass. OR are you matching Text to an Internal ID? If in doubt you can always import bu Internal ID which is Unique.
m
Mars
12/04/2020, 9:22 AMTry creating one account via the UI instead of import. How you input the value for the parent field in the form is the way to format your data in your CSV file for import.
k
Kristofer Nael Mayordomo
12/04/2020, 8:04 PM@Netsuite Tragic I did all the approaches especially the internal ID because you know...can't tust text lol.
Kristofer Nael Mayordomo
12/04/2020, 8:05 PM@Mars I did try to create an account and choosing the account as parent but it doesn't show up in the drop down list
n
Netsuite Tragic
12/04/2020, 8:18 PMIf you cannot select the parent in the UI, then the Import wont either. Is the parent set to "Active"?
k
Kristofer Nael Mayordomo
12/04/2020, 9:48 PMYes it is
Kristofer Nael Mayordomo
12/04/2020, 9:48 PMAlso, this account is Equity
Kristofer Nael Mayordomo
12/04/2020, 9:48 PMI checked the drop down account types available for parent for new accounts and I saw that Equity is not an option
Kristofer Nael Mayordomo
12/04/2020, 9:49 PMIs this standard behavior for NS? Or is there some feature that has been disabled?
m
Mars
12/05/2020, 2:39 AMyou should really show a screenshot of what you are saying otherwise hard to guess what's happening
Mars
12/05/2020, 2:40 AMshow the part where equity is not shown as an option
k
Kristofer Nael Mayordomo
12/05/2020, 2:43 AMmessage has been deleted
Kristofer Nael Mayordomo
12/05/2020, 2:43 AMhere
k
Karina
12/08/2020, 5:46 PMis the internal ID of the account in question 52?
k
Kristofer Nael Mayordomo
12/08/2020, 9:27 PM@Karina yes it is. System-generated.
k
Karina
12/08/2020, 9:29 PMyou cannot make it a summary account, it is set up like that systematically. be aware of playing with that - there is RE functionality associated with this account as well
k
Kristofer Nael Mayordomo
12/08/2020, 9:29 PMOh. That makes sense.
Kristofer Nael Mayordomo
12/08/2020, 9:29 PMThanks!
m
Mars
12/08/2020, 9:39 PMwhat we did in that case is create a separate parent then make that system-generated account 52 as a subaccount of the parent equity account
2 Views