web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Allocation of Revenue ...
Microsoft Dynamics NAV (Archived)

Allocation of Revenue account

(0) ShareShare
ReportReport
Posted on by Community Member

Hi, I am a new user to NAV2016.

I provide a Service which is tied to a revenue account.  I would like this Service Item revenue to be able to allocated among 3 dimensions with all the the references to the original invoice retained.  Is this possible?  How would I do this?

Thanks.

*This post is locked for comments

I have the same question (0)
  • Mohamad Barada Profile Picture
    Mohamad Barada 180 on at
    RE: Allocation of Revenue account

    Hi, you want to allocate this service item revenue to 3 different dimensions or 3  different dimensions value within the same dimensions. Please can you give us an example of the case so we can understand better and provide you with the right solution.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Allocation of Revenue account

    I have an Item set up for Project Management.  This revenue all goes to a/c 405000 which a business segment dimension of "SS".  I need to allocate this "SS" dimension to BS1- 50%, BS2-30%, BS3-20%.  and still retain the invoice number detail from the original transaction.  Thank you for your help.

  • Mohamad Barada Profile Picture
    Mohamad Barada 180 on at
    RE: Allocation of Revenue account

    You can use Recurring journal for such case. You can find recurring journal under Financial management --> Periodic Activities --> Recurring Journals.

    All you have to do is to create a new line within the recurring journal page with recurring Method = balance, Recurring Frequency Daily if you want to do it on daily basis or keep it empty so you can run it whenever you need it,  and select G/L Account 405000. Keep Amount empty and lick on the action button Allocations. Set line for each allocation as you propose :BS1-50% and BS2-30% and BS3-20% .

    This recurring journal can be configured as daily or any other frequency that you see suitable.

    Please let me know if this answered your problem

  • Community Member Profile Picture
    Community Member on at
    RE: Allocation of Revenue account

    When I tested this I now have a balance in the account and dimension I expected.  If I leave the Recurring frequency as 1D - will the allocation occur automatically overnight?  When I left blank I got a message that there is nothing to post so I am not sure what I did incorrectly.  Do I manually need to enter the amount?

  • Suggested answer
    Mohamad Barada Profile Picture
    Mohamad Barada 180 on at
    RE: Allocation of Revenue account

    The post cannot be done automatically unless you do minor customizations. the regular process is that you come at the end of each day and you post the batch and the system will create a record for the second day so you just have to come the second day and click refresh than post.

    Please if this will solve your problem click on verified answer in order to mark it as closed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans