Trying to export Parent Account Id in a csv file from an Account report
When I create a report of my Accounts - I ask for the following fields:
Account Name
Parent Account
The .csv file that exports shows
ACCOUNTID Account Name Parent Account ACCOUNTID
I was hoping that one of the ACCOUNTID columns would be the Account ID of the Parent Account, but both ACCOUNTID's are of the Account Name.
Is there another way to get the Parent Account ID - or do I just have to search by the "Name" and not the Id?