Wednesday, 22 October 2014

How to transfer budget from one ledger dimension to the other ledger dimension?

In this post, i am going to describe how to transfer budget from one ledger dimension to the other ledger dimension.
I am using COM data set here:
First allocate budget against ledger dimension from which budget will be transferred.
There has to be one source ledger dimension from which amounts will be go out and one destination ledger dimension on which amounts will be go in.
I am creating Budget register entries against the source ledger dimension in order to allocate the the budget.
You should have Budget model, budget code setup otherwise Budget register entries cannot be created
Go to Budgeting > Common > Budget register entries > All budget registries
Click New > Budget register entry button on the action pane
Select OPERATION as Budget model
Select OB as Budget code
Press CTRL + S
Click Add line button
Select Expense as Account Structure
Set Dimension value = 999-61101-120-101
Set Amount = 10000
Press CTRL + S (Budget check results should be marked as checked)
Click Update > Update budget balances button on action pane
Click Ok button
Budget register entries should be created successfully


Go to Budgeting > Common > Budget register entries > All budget registries
Click New > Budget register entry button on the action pane
Select OPERATION as Budget model
Select OB as Budget code
Press CTRL + S
Click Add line button
Select Expense as Account Structure
Set Dimension value = 999-62300-120-101
Set Amount = 1000
Press CTRL + S (Budget check results should be marked as checked)
Note that Budget Check results should be checked and Create transfer button should be enabled otherwise you cannot transfer budgets















Click Create transfer button
Press CTRL + S 
Set Amount = 1000 [Underneath 'To dimension values' field]
Click Add line button
Set From dimension values = 999-61101-120-101 [Source ledger dimension]
Set Amount = -1000 
Amount will be go out that's why negative amounts should be put in here otherwise budget cannot be transferred.
Amounts for source ledger dimension should be negative and Amounts for destination ledger dimension should be positive.






















Click Update > Update budget balances button on action pane
Click Ok button
Two vouchers should be created for Transfer Budget register entry. One for source ledger dimension and other for destination ledger dimension.



Budget register created for Transfer budget shows how amounts are transferred from one ledger dimension to the other. 




This is posted budget register entry and you cannot make any amendments on this Budget register entry as the Budget register entry status is completed.
Source document of Budget register entry from which transfer budget is also linked to the transfer budget register entry shows above.


This is how budget is transferred from one ledger dimension to the other.
Hope, you learn from this post.

Happy Daxing!

4 comments:

  1. Do you have any blogs on Projects?

    ReplyDelete
    Replies
    1. My blogs on Projects are in pipeline. I will post blogs on Projects very soon.

      Delete
    2. My blogs on Projects are in pipeline. I will post blogs on Projects very soon.

      Delete