Skip to Content
0
Jul 10, 2020 at 12:53 AM

How to Display GL Accounts without Chart of Account Prefix

273 Views

Hello,

I have a BW Query that has accounts in row axis. But it gets displayed with Chart of Accounts as a prefix in the excel workbook. How do I remove the prefix? In the example below, C001 is chart of accounts, 6010 is the account number. Thanks