anyone know how i can get all the transaction line...
# suiteanalyticsj
Jon Kears
10/28/2020, 8:55 AManyone know how i can get all the transaction lines that are being auto-eliminated using suiteconnect through odbc? I would expect to be seeing a boolean "eliminate" field on the transaction line but no dice unless it has a really weird name
t
tdietrich
10/28/2020, 9:04 AM@Jon Kears I'm not sure about SuiteConnect, but I can see an "eliminate" field on the TransactionLine table via SuiteQL: SELECT DISTINCT Eliminate FROM TransactionLine
Is "Automated Intercompany Management" enabled on the instance that you're working with?
j
Jon Kears
10/28/2020, 9:04 AMno it isn't
Jon Kears
10/28/2020, 9:05 AMGood spot, that means I should be able to use a suiteanalytics workbook
Jon Kears
10/28/2020, 9:05 AMthanks
t
tdietrich
10/28/2020, 9:05 AMHappy to help! Good luck.
3 Views