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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP Projects and Cost C...
Microsoft Dynamics GP (Archived)

GP Projects and Cost Categories

(0) ShareShare
ReportReport
Posted on by Baradhi 157

Hello Gurus,

We have around 500 new projects to be added for new fiscal year.

I want to know if there is a way I can import into GP table and link with cost categories to them.

Can you please let me know what are the tables I need to know.

Thanks

Reddy

*This post is locked for comments

I have the same question (0)
  • 26P2ER Profile Picture
    26P2ER 1,775 on at
    RE: GP Projects and Cost Categories

    Integration Manager (GP eConnect adapter) has EE and ETimesheet integrations.

    You could try using a proven approach using MS Merge when combined with GP Macros.

    1. You would capture the keystrokes used to add a PA project by signing onto GP and adding a project. Click on start recording the macro before you open the PA project window. Click on stop recording the macro after you are done saving the project.
    2. This macro will be saved to file that you can open in MS Office word and with a help of an excel list (that includes projects) you could replace the project code literals found in the macro with the parameter that will be sent by the mail merge command.

    Not crazy about this. But macros are like IM wherein if GP pops a dialog box in the middle of your macro it will just stop.

    PA01201  - PA Project Master File
    PA01001  - PA Cost category File 

     Alternatively you could turn SQL trace on by setting the log SQL message setting found in the dex.ini file of the GP install\data folder and capture the SQL used while you add a new Project. Then make sense of the dexsql.log file found under the same location and write  SQL wrapper to replace all the literal values.  You may have to make changes to the wrapper program the next time you upgrade GP.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans