Account schedule Cost types with cost centers / objects as columns

(0) Share

Report

Posted on by JohnnyLM

187

Hello BC Forum,

I need a report like printscreen1 shown below.

I tried the default possibility in BC: cost Acctg. analysis (as seen in printscreens 2 and 3), and it basically does what I want, but you can only choose 8 columns., not more. So I tried to create a customized report via account schedules and with cost types (printscreen 4).

Somehow I do not find how to create columns of cost centers and cost objects. Also personalization gives me 4 columns with dimensions. I need cost objects / centers.

I have already read all the necessary MS Docs (so only a link to MS Docs probably does not help me).

Printscreen 1

Printscreen 2 (limited columns)

Printscreen 3

Printscreen 4

Thanks for the reply.

Greetings,

John

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Johnny,

In the Account Schedule, did you Edit the Column Layout? Here is mine sample:

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

JohnnyLM 187 on at

Like (1)

Report
Copy link

Link copied!

Hello Steve,

thanks for the quick reply. Your answer put me into the right direction.

I was looking at the wrong place. I had to look in Account Schedules / Process / Edit Column Layout Setup. What I did was go into my new Account Schedule because I thought that's the place to change the columns for this particular Report with personalization.

I was looking here:

I must say: a little bit confusing and not mentioned in the MS Docs...

Greetings,

John

Was this reply helpful? Yes No