I would like to create a dataset (Analytics UI) to...
# suiteanalytics
z
I would like to create a dataset (Analytics UI) to get Bill Payments only for one Bank account, but can’t find the field for make a criteria
m
you have to drag the transaction type to the criteria field in order to filter
z
The transaction type is already set. I am looking for the bank account field
k
is it a bank account or AP account? regardless, you need to use filters in your workbook. You could also use filters in your dataset, but then you would limit this dataset to only one bank account, not best practices (but still works)
z
it is the bank account. I am trying to fimd out the filed from field list under transaxtion and put them in the criteria section. I am not asking for steps, I askimg where NetSuite stores Bank Account value
k
in account dataset just type Bank in the search, and it will give you options
z
did you try it?
k
yes..
z
k
are you not using Payment bundle? Is your “bank account” is one of the list of GL accounts? sorry not able to understand you
w
Try to pick the transactionLine that is mainline and check the transactionAccountingLine.account