+1-888-319-3663

COMMUNITY FORUM

Duplicate rows in Smartview

Jignesh asked 3 years ago

I have smartlist with multi-company selected in summary. when I run this in smartlist it is good. but when I run this in smartview, it shows duplicate rows. I am using smartlist – Purchasing – Payable Transactions. using in-built smartlist Payable Transactions.

Answers

0 Vote Up Vote Down

Jignesh Prajapati answered 3 years ago

I found out that for multi company smartlist, you cannot use it in smartview.
you need to create SQL view to point to each company database and use smartview filter to filter companies.

If you would like to submit an answer or comment, please sign in to the eOne portal.