Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Dimension reposting

Posted on by 305

During the posting specific entries I don't know exactly dimension and I post everything on one common dimension per one account. After that, on the end of months I post correction and repost to proper dimensions. I made estimate about percentage; percentage is not the same every month. This is a lot of work. Is there an utomatic?

I use NAV2009R2 classic.

*This post is locked for comments

  • IMSA Profile Picture
    IMSA 305 on at
    RE: Dimension reposting

    Thanks a lot, both of you.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Dimension reposting

    Hi,

    you can have the same account in the recurring journal line and its allocations, but deviating dimensions according to your dimension distribution. Like Aleksandar suggested, but the balance on the account wil be the same as before.

    Is there a specific reason to post with a dummy dimention first?

    with best regards

    Jens

  • Verified answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Dimension reposting

    Of course, this is the same. If you want to relocate dimensions, you need to put source dimension value code on journal line and on "Gen. Jnl. Allocation table" you need to put the same account in each line, but different destination dimension value code.

  • IMSA Profile Picture
    IMSA 305 on at
    RE: Dimension reposting

    OK. This is for accounts, but for dimensions?

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Dimension reposting

    If I understand your problem, you want to migrate posting entries from one account and dimension value to many? For this, you can use "Recurring Journals". At Recurring Frequency field, you must to put date formula for recurring. At Recurring Method, you must put Balance option. Balance option work as the posted amount on the account on the line will be allocated among the accounts specified for the line in the "Gen. Jnl. Allocation table". In each line, you need to fill in the Allocation % field in the "Allocation List" table; every month you can change this percentages. After posting, the balance on the account will thus be set to zero.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans