Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Distribute sales value among the same dimension category.

Posted on by Microsoft Employee

Can I attach several dimensions to a one transaction and give percentages to the allocation?

My client required to distribute the company sales revenue among few departments and then get a dimension wise analysis report. 

As a example in a sales invoice they sell items worth USD.12000 and this should be divided among 3 teams based on a pre-defined percentages. Team A get 50%, Team B gets 30% and Team C gets 20% of the sales amount. Currently teams are created as dimension 01 and he want to get a dimension wise analysis report based on the team revenue.

Can we do this in NAV without much modification? Because he does not want to modify the system much.  

Thank You. 

*This post is locked for comments

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Distribute sales value among the same dimension category.

    You cannot do this with the default NAV version. This required a customization and it does not affect the posting routine of NAV.

    But this contain some reasonable modification to the system and it is advisable for move to another alternative method.

  • Verified answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Distribute sales value among the same dimension category.

    You cannot do it by default form example sales invoice. It is possible to make some customization, but not by default.

    But you can make the similar allocation after you post sales invoice. You can use Recurring General Journal with Balance recurring type. You can open Allocations and choose between percentage or amount.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans