Small and medium business | Business Central, N...

Variable allocation account

(1) Share

Report

Posted on by GinaH

It appears we can only use a statistical account for a Breakdown Account when using Variable Allocation Accounts. Even through G/L Account is available for a Breakdown Account Type, I can only get this to work with a statistical account as the breakdown.

I would like to distribute expenses over profit centers based on a % of revenue for each profit center. So the Breakdown acct is the G/L Account for Revenue.

Has anyone been able to use a G/L account for a breakdown account type?

Thank you,

Gina

Categories:

Business Central

All responses (4)

Answers (0)

GinaH 38 on at

Like (0)

Report

Variable allocation account

Jun Wang, I am creating a variable allocation account, not a recurring entry. The variable allocation account setup appears to allow GL accounts as breakdown accounts, but I can't get it to work. That's my problem.

Gina
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (1)

Report

Variable allocation account

I don't think you could allocate the cost of materials to dimensions this way. The correct way is to fill out the dimension at the time of the posting. for example

total amount is 1000$

when posting, you allocate to dimensions

100$ for dimension abc, account no. 50110

900$ for dimension xyz account no. 50110

this way different amount is posted to the same account by with different dimensions. Then you could filter the net change by dimensions.

this is an example from NAV for recurring journal allocation, which is an older version of BC, but they works the same way

Jun Wang
GinaH 38 on at

Like (1)

Report

Variable allocation account

Right...it says G/L account but I cannot get it to work. I have a revenue account with dimensions that I want to use as the breakdown account. I want to use the net change for the month. So revenue for 3/31/24 is broken out by 3 dimension values.

When I choose Test Allocation I get this:

The breakdown account balances are correct but the percentages and amounts are not calculating correctly

I tried a general journal and nothing allocates.

So I'm wondering if G/L Account for a Breakdown Type really doesn't work.

Gina
Suggested answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (0)

Report

Variable allocation account

As far as I know, both types you mentioned are available.

More details: What's new: Fixed and variable G/L allocations (2023 release wave 2)

https://youtu.be/BZF4MrVfvfY?si=eiobKr52x0g5s2YQ

Hope this helps.

Thanks.

ZHU