Allow BC.ACCOUNTDETAILS to fetch more account information (e.g., posting type, blocked). This is currently possible with BC.QUERY, but creating a whole query is a bit much for basic account data. A use case is if the user wants to pull a complete chart of accounts (including accounts or posting and non-posting/totals) but also wants to use Excel formulas (such as SUMIFS) on the list without duplicating amounts.
0 Votes
1 Comments
C
Chauncey Beggsposted
21 days ago
Please ignore/delete this post. I'm not sure what I was looking at, but BC.ACCOUNTDETAILS doesn't exist. I have no idea what I was looking at previously. EXPANDACCOUNTRANGE covers the needed functionality.
0 Votes
Allow BC.ACCOUNTDETAILS to fetch more account information (e.g., posting type, blocked). This is currently possible with BC.QUERY, but creating a whole query is a bit much for basic account data. A use case is if the user wants to pull a complete chart of accounts (including accounts or posting and non-posting/totals) but also wants to use Excel formulas (such as SUMIFS) on the list without duplicating amounts.
0 Votes
1 Comments
Chauncey Beggs posted 21 days ago
Please ignore/delete this post. I'm not sure what I was looking at, but BC.ACCOUNTDETAILS doesn't exist. I have no idea what I was looking at previously. EXPANDACCOUNTRANGE covers the needed functionality.
0 Votes
Login or Sign up to post a comment