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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Allocation in AX 2012 R3
Microsoft Dynamics AX (Archived)

Allocation in AX 2012 R3

(0) ShareShare
ReportReport
Posted on by Scania_Bjorn 397

Hey all,

Using AX 2012 R3 and this question is related to Allocation functionality

Example: we want to allocate the rent for the office space where we receive the invoice in January, to be allocated over the year .

Invoice amount is 12.000 and we want to allocate 1.000 per month. 

Creating the allocation rule and postings for this is fairly straight forward, but my questions is:

Do we have to keep all future periods in the current year open to make this work? Is that really the design from MS or am I missing something?

Obviously accounting do not want to keep the full year open, but seems the design would force us?

IF that is the case, how have all of you solved this? Any other workable solutions?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MuhammadFaisal Profile Picture
    MuhammadFaisal 329 on at

    Hello Björn Wallmark ,

    Allocation rules are used to allocate the amount on fixed percentages, fixed weights, equal distribution, or basis as defined in the associated Ledger allocation basis and they are automatically calculated as per the rule defined.

    What i get from your example you are looking for the solution to record the rent entries. You can use Periodic journal with the Move option to manage the rent recording and it will not required to open the future period.

    And yes as you said in your example that you received the full invoice in the first month of the year i.e January, if you can accrue the full amount of invoice in the month of receiving then you can use payment schedule to settle the invoice amount on monthly basis.

    And yes, Purchase agreement can also be used if the rent agreement are involved with the expiry dates.

    If you think this answer your question then Please mark it as verified answer. It will be helpful for the others who are looking for the same answers.

    Regards,

    Faisal

  • Suggested answer
    MuhammadFaisal Profile Picture
    MuhammadFaisal 329 on at

    Hello Björn Wallmark ,

    Allocation rules are used to allocate the amount on fixed percentages, fixed weights, equal distribution, or basis as defined in the associated Ledger allocation basis and they are automatically calculated as per the rule defined.

    What i get from your example you are looking for the solution to record the rent entries. You can use Periodic journal with the Move option to manage the rent recording and it will not required to open the future period.

    And yes as you said in your example that you received the full invoice in the first month of the year i.e January, if you can accrue the full amount of invoice in the month of receiving then you can use payment schedule to settle the invoice amount on monthly basis.

    And yes, Purchase agreement can also be used if the rent agreement are involved with the expiry dates.

    If you think this answer your question then Please mark it as verified answer. It will be helpful for the others who are looking for the same answers.

    Regards,
    Faisal

  • Scania_Bjorn Profile Picture
    Scania_Bjorn 397 on at

    Will test and verify. Thanks

  • Scania_Bjorn Profile Picture
    Scania_Bjorn 397 on at

    Hi,

    Sorry I don't understand your solution here.

    The periodic journal is supposed to look like what to cover my example above?

    And why would I "move" the journal? If I do, I can only use it once correct? Then what is the purpose of using it in the first place?

    Allocation functionality is what I was looking for, without having to keep future periods open.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Bjoern,

    Have you tried using the accrual scheme functionality, which is doing what you are looking for.

    Your future periods need to be open for your people who post the accruals not for all people.

    Best regards,

    Ludwig

  • Scania_Bjorn Profile Picture
    Scania_Bjorn 397 on at

    Thanks Ludwig,

    It's not perfect as we're a small organization meaning most users would then in the end have access to post in future periods. I'll give it a try.

    We also have other scenarios where Allocation probably is the correct process, but the same issue that periods has to be open.

    Anyway, thanks.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Bjoern,

    Alternatively, you can use periodic journals or excel uploads to regularly post the costs into the correct months.

    When using periodic journals or excel uploads you run the risk that somebody forgets posting.

    I do not think that leaving future periods open should be a problem because you can restrict the access to future periods to a handful of people by making use of the module access level where you assign a user / team who is allowed to post into the future. Maybe try that one if this works for you.

    Best regards,

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans