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 GP (Archived) / Finding Fixed Allocati...
Microsoft Dynamics GP (Archived)

Finding Fixed Allocation in tables or view

(0) ShareShare
ReportReport
Posted on by painterisaac 3,015

I need these two circled (fixed allocation account AND distribution account) from the SQL database in order to create a needed report. However, I can only find the distribution account (it is titled account from what I can find).

Can anyone help me in identifying where I can find these? Even the names of the SQL table would be helpful.

I am using GP 2010, Report builder 2.0.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Olaf Laos Profile Picture
    Olaf Laos 1,890 on at

    The GL00103 table is the Fixed Allocation Master table.

    The "account" is column ACTINDX

    The "distributions" are in the column DSTINDX

    And you would have to cross reference these "index" values to their respective GL account number in the GL00100 table.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Here is code for a SQL view that will show you all the active fixed allocation accounts:

    victoriayudin.com/.../sql-view-for-fixed-allocation-accounts-in-dynamics-gp

  • painterisaac Profile Picture
    painterisaac 3,015 on at

    How would I go about joining customer payments with this?

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Allocation accounts are never posted to, they are like shortcuts that redirect to other accounts. So you are not going to find transactions that can be linked to allocation accounts. Maybe you could give some more detail or an example of what you are looking to do?

  • painterisaac Profile Picture
    painterisaac 3,015 on at

    Well when we enter in a payment, segment 4 of the distribution account represents a breakout that would be very useful to us. However, I can't seem to find a way to link it to the payments.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Segment 4 of the Distribution Account or the Fixed Allocation Account?

  • painterisaac Profile Picture
    painterisaac 3,015 on at

    segment 4 of the distribution account

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Then the fixed allocation account should be irrelevant....the accounts recorded with the transaction will be the distribution accounts. Is that not what your data shows?

  • painterisaac Profile Picture
    painterisaac 3,015 on at

    It is relevant because we need to trace it back to the fixed allocation as well. This is what we need basically in a table format....

    Fixed allocation account Distribution account Percentage Customer Name Document number Applied amount

    I don't know if I am making any sense. Still trying to figure out how all of this works. 

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    The fixed allocation account is not stored with transactions, so this is not possible.

    Maybe you can explain why this is needed? What you are looking to accomplish with this report? Sometimes understanding the business need can help someone suggest a different way of either reporting or entering these transactions.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans