Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Allocation Function/Set up

(0) ShareShare
ReportReport
Posted on by

I can't seem to find any sort of online help/tutorials regarding allocation functions outside of the basic recurring journal allocation. (Which to my knowledge is limited to percentage, quantity, and amount.) My company is hoping to do the two tasks below, does anyone know of a manual or helpful video to walk us through the allocation functionality? (preferably for NAV 2009, but I'll take whatever help I can get if it's for a more recent version).

-set up expense allocations based on sales activity and/or item shipments

-set up monthly allocations of the balance of an account, versus allocating each individual transaction

*This post is locked for comments

  • Jens Glathe Profile Picture
    6,092 on at
    RE: Allocation Function/Set up

    Hehe... ;) NAV isn't antique, it is UX-optimized. To the point of getting useless for real work, sadly.

    Regarding these examples: They sound like cost accounting to me. If you don't want to use the CA module, Raokman's workaround is the best choice. How you get the sales activity / item shipments out to CA as a usable reference unit is another matter, though.

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    23,116 on at
  • Community Member Profile Picture
    on at
    RE: Allocation Function/Set up

    Could you download the relevant balances/activity each period into an Excel spreadsheet, which would have the allocation formulas you would want to use, then upload a JE from the Excel spreadsheet?

     

    We have many JE templates set up for recurring entries where the account selection remains the same, but the amounts change (payroll is one example), that we just upload on a weekly basis.  Formulas determine amounts, and posting dates.

     

    Just another example of a workaround needed if you want to use the antique NAV in real life.  I think I'll crank up my Model T now and take it out on the highway...

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans