Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Allocation of Revenue account

Posted on by Microsoft Employee

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

  • 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.

  • Community Member Profile Picture
    Community Member Microsoft Employee 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?

  • 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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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

    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.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans