Update 17.4 for Business Central has added the ability to allocate costs by different dimensions on recurring journals.
To allocate costs based on a G/L account balance by dimension, in the Recurring General Journal page, set the Recurring Method field to BD Balance by Dimension or RBD Reversing Balance by Dimension. Additionally, you can now specify dimension filters to be used to calculate the source G/L account’s balance by dimension from which you want to allocate costs. Just choose the Set Dimension Filters action.
For example, your company has a couple of business units and a handful of departments that you have set up as dimensions.
Each business unit has specific allocation keys for the department dimension, such as based on the number of employees, you can use the BD Balance by Dimension or RBD Reversing Balance by Dimension recurring methods to reallocate expenses for each business unit to the right departments based on the allocation keys.
Such balance allocation by dimension of source G/L account is not possible using the Balance or RB Reversing Balance recurring methods. Those methods will ignore the dimension values on source G/L accounts and always allocate the full balance. But now you can use the new BD Balance by Dimension or RBD Reversing Balance by Dimension recurring methods.
How do I get this?
For Business Central online you will get this update automatically – to check which version you are on go to the ? in the top right – then select Help and Support
Under Troubleshooting you can see which version you are using:
If you have any questions about this or need assistance, then please contact the GCC Group Support Team on 0345 260 1151 or firstname.lastname@example.org