Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to import unit acc...
Microsoft Dynamics GP (Archived)

How to import unit accounts into the payroll posting account setup

(0) ShareShare
ReportReport
Posted on by Brenda Willey 2,510

I have imported many times the payroll posting accounts.  Now I want to import the PR posting accounts with the new unit account feature.  I can not figure out which table these are being stored in.  I have added unit accounts to my posting setup in Fabrikam and they are not in the UPR40500 table.  I was considering just adding them to my file with the correct unit account index since they are in the GL00105 table and see what happens.  Any thoughts advise?

*This post is locked for comments

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: How to import unit accounts into the payroll posting account setup

    Brenda,

    Thanks for your reply.  I started configuring the table import file last week.  I'm going to try the upload today.  I'll let you know the results.  I hope it works for me.  

    Jim

  • Brenda Willey Profile Picture
    Brenda Willey 2,510 on at
    RE: How to import unit accounts into the payroll posting account setup

    I'm using table import from within GP but they are not showing up in the PR posting account screen.  They are definitely in the APR_UPR40500 table.

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: How to import unit accounts into the payroll posting account setup

    Brenda,

    Hello.  What method do you use to import the posting accounts.  I am attempting to do this myself and have hundreds to add to the hundreds that already exist.  SQL Insert?  

    Thanks.

    Jim

  • Brenda Willey Profile Picture
    Brenda Willey 2,510 on at
    RE: How to import unit accounts into the payroll posting account setup

    It is on the payroll posting account screen in GP2013.  I don't think it is part of Advanced.  

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to import unit accounts into the payroll posting account setup

    Hi Brenda,

    I wasn't aware you could use a unit account as a payroll posting account. How does that work? The payroll posting account lookup window doesn't show Unit accounts.

    Where did you find information saying that you could use a unit account as a payroll posting account?

    Kind regards,

    Leslie

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans