Hi, Is there a way to create an Account saved sear...
# accountingn
NS User
12/06/2021, 5:34 AMHi, Is there a way to create an Account saved search and pull Elimination enabled accounts? If yes, can you please share the criteria to pull it?
n
Netsuite Tragic
12/06/2021, 7:37 AMAs you already found doesn't look like {eliminate} is available on search. I did build an Analytics dataset and that field can be included and filtered that way, allowing you to pull the list.
k
Karina
12/06/2021, 4:33 PMconcur that, Analytics is great tool for COA analysis
n
NS User
12/06/2021, 11:17 PMGreat to know that. Can you tell me how to build it from my end as well? Thanks
NS User
12/06/2021, 11:18 PMOne more question. It looks like there is no way to expose “Eliminate” field on the transaction saved search. Can you please let me know if there is a way to do it? Thank you so much in advance.
n
Netsuite Tragic
12/06/2021, 11:27 PM@NS User you just have to go to Analytics, New Dataset.
Netsuite Tragic
12/06/2021, 11:28 PMThe field is not available in saved search. I tried it also as a sourced custom field, also not available. You could do it as a workflow. But my question is how often do you need this view? It's no really a dynamic setting that is changing regularly.
n
NS User
12/06/2021, 11:31 PMthat is true, we don’t need this change often. Here is little background about it. I am trying to upload a Journal and it is throwing an error “Elimination settings for the journal line, account, and name do not match. To check this line for intercompany elimination, you must check Eliminate Intercompany Transactions on the account record and enter a To Subsidiary on the name record, if used.”
NS User
12/06/2021, 11:33 PMSo, i wanted to run a COA report and pull all the accounts that are assigned to “Eliminate Intercompany Transactions” on the account record.
n
Netsuite Tragic
12/07/2021, 5:13 AMI suggest just extracting the accounts list through Analytics. But I think your import has other problems. Try creating the journal in the UI to get your combination of accounts that you need.
n
NS User
12/07/2021, 6:15 AMThank you!
k
Karina
12/07/2021, 6:09 PM@NS User - this is not necessarily a setting in COA; it means you are trying to upload an ICJE without proper IC customers and vendors setup or IC accounts setup
👍 1
n
NS User
12/07/2021, 6:21 PMThank you all!
3 Views