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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Project Accounting - W...
Microsoft Dynamics GP (Archived)

Project Accounting - Which table the Source field storing?

(0) ShareShare
ReportReport
Posted on by Community Member

In the Cards > Project > Project > Budget button, choose one of the cost category, click on the blue arrow button at the Cost Category header.

Pic-2.png

 

In the Budget Detail Entry, click on the Accounts button, it will open the Budget Accounts window.

Pic-3.png

May I know which table is the Source information store at? For example, how they store the selection now is "Cost Category" for the "Work in Progress" account type? How they store the selection now is "Customer" for the "Contra account for costs" account type?


Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Project Accounting - Which table the Source field storing?

    I will recommend a method to get you the answer not only for this case but for any other similar cases. The support debugging tool is the ultimate tool in such a case, you can trace the source table from any window in Dynamics GP, and drill down for the fields on the SQL server accordingly.

    In a previous post, I have posted the steps to consider in order to run a trace on a specific window in Dynamics GP and reach the associated tables, check it out on how to findout the tables using forms in gp please any one can guide me

    Your feedback is highly appreciated,

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Project Accounting - Which table the Source field storing?

    I found it, the query should be:

    SELECT TM_WIP_SRC, TM_COGS_SRC, tm_COST_CONTRA_SRC, TM_UNBILLED_AR_SRC, TM_UNBILLED_REV_SRC, TM_AR_SRC, TM_PRJ_REV_SRC, TM_OVHD_SRC FROM PA01301

    Hope this help. :)

  • Community Member Profile Picture
    Community Member on at
    RE: Project Accounting - Which table the Source field storing?

    Dear Mahmoud M. AlSaadi,

    Thank you for your reply. Really appreciate that. :)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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