Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / In Dynamics GP 2015 ho...
Microsoft Dynamics GP (Archived)

In Dynamics GP 2015 how does the PAcosttrxid field get populated

(0) ShareShare
ReportReport
Posted on by Kristie McNulty 977

We recently upgraded to Dynamics GP 2015 (R1 + Hotfix) and the PAcosttrxid field in the PA43001 table is not updating with the relevant values such as EE or TS, making it difficult to review (at a table level of course) how the employee expense or timesheet categories have been set up with respect to their GL accounts (trying to compare PAACTINDX to GL00105 ACTINDX).  What process updates the PAcosttrxid field please?  And, if it's not populated, is there any harm in me updating the field via a SQL script, once I identify the cost categories type?  I did review KB857196, but it does not mention how the field gets populated.  

*This post is locked for comments

  • Kristie McNulty Profile Picture
    Kristie McNulty 977 on at
    RE: In Dynamics GP 2015 how does the PAcosttrxid field get populated

    This is a great article, especially with the response where the user wrote "...but I am pretty sure that it had to do specifically with NONE account sources… " because this is what we've been told we have to move away from, using NONE.  We were also warned about PAChecklinks and I have not run those either.  Thank you very much for the update and I will monitor progress on bug # 9120.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: In Dynamics GP 2015 how does the PAcosttrxid field get populated

    Hi Kristie,

    Thanks for the détails.. yes now it makes more sense.. I had to deal with that kind of issues in the past when we had some GL Account number changes that were not dealt properly with by the PSTL changer tool. I had to run accross some of the entries with SQL scripts to update the GL Index acct number.

    Similar to when I added a bunch of new Cost Categories and didn't wanted to go thru all the 8 GL entries for each CC, I ended up inserting them into PA43001 from the back door... Not recommended, but it worked. You have to identify exactly what numbers need to be populated based on another CC that's using the same GL's.

    BTW, Christina Phillips just posted a blog entry this morning with a report about a bug #9120 that has been reported to MS about this issue...

    http://dynamicsgpland.blogspot.ca/2015/10/oddities-missing-project-accounting.html

  • Kristie McNulty Profile Picture
    Kristie McNulty 977 on at
    RE: In Dynamics GP 2015 how does the PAcosttrxid field get populated

    Hi Beat - thank you for your reply.  The table I reference holds the account indexes and corresponds to the respective Cost Category Accounts form.  The Transaction Usage values (upper right corner of Cost Category Maintenance form) correlate to the initials.  So, Employee Expense = EE and Timesheet = TS.  This table is being used to help us identify the account strings that need to be updated in the 100's of cost categories we're using and <XX> had indicated the PAcosttrxid field was to hold the EE, TS, ML, etc. values of the cost category's Transaction Usage setting for identification...but it does not.  I'm in no way wanting to update Open or Historical transaction tables.  My goal is to not have to update each of the eight (8) account lines within an individual cost category.  Because now, unlike in GP2010, if the WIP account field is blank and you post an EE expense, the COGS account is not getting used and the expense will not post.  We were lead to believe we could populate the WIP field with a 'dummy' account, but that has proven to be incorrect information as well.  So, now we're trying to get these fields populated with the correct accounts before anymore transactions get posted against them :-D...it's a scramble for sure.  Thank you so much for taking the time to review and reply to my post, I'll take all the help I can get.  

    In case it's helpful:  

    --Time and Materials Work in Progress

    select * from PA43001 where  PAsfid =26 and PAaccttype = 1

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: In Dynamics GP 2015 how does the PAcosttrxid field get populated

    Hi Kristie,

    I'm not sure you're looking at the right table... PA43001 does not get updated when you post any transactions... this table is meant for the PA Account Setup, which means every Contract, Project or Cost Category that you define in GP will get an entry in this table when you fill out the corresponding 'Account' fields... Don't get confused by the abbreviation 'TS'.. which has nothing to do with TimesSheets..

    You should more likely check the table PA30xxx and PA10xxx for the transactions (historical and unposted).

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans