Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Fixed allocation account issue

Posted on by Microsoft Employee

Hello Community, I have a vendor invoice that I would like to post against an allocation account I created. I did that however the individual distribution accounts are not reflecting any amount even after I posted the vendor payable. The individual distribution accounts only reflect amounts once I post a general journal entry against the allocation account. Is it not possible for me to use an allocation account while posting a vendor invoice?

Thank you so much. 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed allocation account issue

    So, was this question finally answered? I have a similar issue with a fixed allocation account, referenced by an inventory item included on a Sales Transaction.

    The fixed allocation account is, in my situation, 7-390-4610-1. Under distribution accounts, I have 1-390-4610-1 at 50%, and 6-390-4610-1 at 50%.

    In the Inventory item, under Accounts, I have 7-390-4610-1 on the Sales line.

    When I set up a new Sales Transaction Entry, I use that inventory item and add a dollar amount. When I Go To Distributions, the Sales line shows up with account 1-390-4610-1. ????

    Just to try something different, I put a different fixed allocation account into the inventory item Sales line, and that behaves the same way in a new Sales Transaction, it only uses the first distribution account.

    Any ideas?

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Fixed allocation account issue

    I look

    Forward to your reply, I have always considered it a gl thing.

    Leslie

  • michelle brayton Profile Picture
    michelle brayton 95 on at
    RE: Fixed allocation account issue

    That is not how it is supposed to work... I will test in my system and get back to you...  I have clients that use allocation accounts all of the time for payables.  Give me til Friday and I will update.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Fixed allocation account issue

    Hi,

    This is how it works. The allocation is not distributed until the Journal entry is posted. The amounts are held in a table but are not committed to the ledger until it's posted. This behavior gives you the opportunity to change the percentages after you post the payable. Working as designed.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed allocation account issue

    Yes what I mean is once I post my payables transaction I go back to the individual distribution account to see if the appropriate amount got posted and I don't see any posting. The balance is there under the allocation account. When I make a Journal entry this doesn't happen. The individual distribution account gets its share of the percentage once I post the Journal entry.  

  • michelle brayton Profile Picture
    michelle brayton 95 on at
    RE: Fixed allocation account issue

    Do you mean that the payables batch is stopping in the GL for additional posting?  

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans