Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

SL2015 Allocation for period 13 not picking up the balance of the account

Posted on by 290

Hello,

We are working on an allocation to pull account Balances from the source account and allocate by unit.

When running the allocation for period 13, it is only picking up activity for the period not the balance of the account.

We have the allocation setup - Percent limit type- By Allocation

I believe this should pick up the Balance in the account for the year or is it for that period?

Below is the definition from the help screen:

Percent Limit Type
Calculates the limit percent amount either per allocation run or per period. If there is an amount entered at Limit Percent, use this field to indicate the Percent Limit Type. The options are:
·         By Allocation — Limits are applied based on the remaining balance in the account. If the limit percent is 50% and the allocation is generated multiple times (or other allocation groups are run which contain this account), each subsequent allocation will limit itself to 50% of the net balance after the previous allocations. Each time you run the allocation, you will be notified if there are prior allocations for the period, and given the option to stop the process.
·         By Period — Limits are applied based on the activity for the month. If the limit percent is 50% and the allocation is generated multiple times, the first allocation will include 50% of the activity for the month, and subsequent allocations will be zero.
Allocation setup:

Period-13-Allocation.PNG

  • NorK Profile Picture
    NorK 290 on at
    RE: SL2015 Allocation for period 13 not picking up the balance of the account

    Hi Carolyn, Thanks so much.  I am wondering if it is an issue with running the allocation multiple times to test.  Is there a way to clear PTDAlloc to essentially start over?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL2015 Allocation for period 13 not picking up the balance of the account

    Thanks Carolyn.

    I appreciate your updates on this post.

    I will wait to hear back from you.

    Chuck

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SL2015 Allocation for period 13 not picking up the balance of the account

    From the definitions, it certainly seems like it should, but as stated before, both Percent and Unit ratio use the PTDBal-PTDAlloc

    There is not a method that seems to look at the Beginning Balance of the period (which would be the YTD at that time).  Without a few hours of testing, I can't know for sure, but I'd say if you need the YTD #'s, then you would have to make a manual calculation.  I'll investigate this further and get back with you.

    Allocation Methods are:

     Percent — Amount allocated is distributed to each destination account according to the percent for each account; total percents for all destination accounts in a group must equal 100%.

     Unit Ratio — Amount allocated is distributed to each destination account according to the ratio between the units for each account and the total units of all destination accounts; unit used is user defined.

     Actual Period-to-Date — Amount allocated is distributed to each of the destination accounts according to the ratio of each account’s period-to-date balance to the total period-to-date balance of all destination accounts.

     Actual Year-to-Date — Amount allocated is distributed to each of the destination accounts according to the ratio of each account’s year-to-date balance to the total year-to-date balance of all destination accounts.

     Ledger Period-to-Date — Amount allocated is distributed to each of the destination accounts according to the ratio of each account’s ledger amount for a particular period to the total ledger amount for that period for all destination accounts.

     Ledger Year-to-Date — Amount allocated is distributed to each of the destination accounts according to the ratio of each account’s annual ledger amount to the total annual ledger amount of all destination accounts.

  • NorK Profile Picture
    NorK 290 on at
    RE: SL2015 Allocation for period 13 not picking up the balance of the account

    Hello,

    Is there a way for the allocation to pick up the YTD balance in the account?  These folks only do 1 allocation at year end so are looking for the allocation to pick up the balance in the account.  For example, for period 13 there is no activity but periods 1-12 had activity and there is a $5k balance.  We would like the allocation to pick up the $5K not the $0 activity for period 13.  It seemed like the "By Allocation" selection would do this.

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SL2015 Allocation for period 13 not picking up the balance of the account

    the Unit Ratio, being just like Percent, will ALWAYS allocate the difference between (PTDBal – PTDAlloc) and so it appears to be doing as designed and is what was done for periods 1 thru 12, just this time it is (PTDBal12 – PTDAlloc12) - keep in mind that in the tables PTDBal12 is the period to date balance for period 13 because the table starts out with PTDBal00 which is period 1.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans