SBX - Search With Button

SBX - Forum Post Title

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

Microsoft Dynamics SL Forum

NorK asked a question on 3 Aug 2018 11:17 AM
My Badges

Question Status

Unanswered

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:

Reply
Carolyn Froton responded on 7 Aug 2018 9:30 AM
My Badges

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.

Reply
NorK responded on 7 Aug 2018 10:16 AM
My Badges

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.

Reply
Carolyn Froton responded on 8 Aug 2018 9:03 AM
My Badges

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.

Reply
Chuck Otis responded on 8 Aug 2018 10:15 AM
My Badges

Thanks Carolyn.

I appreciate your updates on this post.

I will wait to hear back from you.

Chuck

Reply
NorK responded on 8 Aug 2018 10:46 AM
My Badges

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?

Reply

SBX - Two Col Forum

SBX - Migrated JS