Skip to main content

Notifications

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) / Sub Acct won't ove...
Microsoft Dynamics GP (Archived)

Sub Acct won't override in Receivings Transaction Entry from project card when entered with a PO

(0) ShareShare
ReportReport
Posted on by Community Member

We recently started using the purchase order system with projects in GP 2013 R2. We generally use a location and practice area segment account override in the project card for COGS accounts. For some reason, the accounts will not use the updated practice area/location, when entering receivings transactions against POs, that existed before we changed the segments in the project card. If I create a new PO, it will pick up the changed segment from the project card. Anyone know why this happens or how to fix it?

*This post is locked for comments

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Sub Acct won't override in Receivings Transaction Entry from project card when entered with a PO

    The only way you'd be able to achieve this is to replace the account index ID# by the new one through a SQL update script... but that might possibly be a tedious task, depending on how many different accounts you use and have to replace..

    The account distribution table for every PO receiving is PO10390.. not sure you could this before the receiving has been created.

    As always, test this forehand in a TEST company first and make sure you have a full backup handy in case something goes wrong.

  • Community Member Profile Picture
    Community Member on at
    RE: Sub Acct won't override in Receivings Transaction Entry from project card when entered with a PO

    Thanks for the suggestion, Beat Bucher. We were able to verify that new purchase order lines do pick up the new segment. The unfortunate thing is that we have over a hundred POs with an average of 10 lines per PO. I was hoping to be able to change something in the configuration to use the acct. segment override and not have to re-key all the information.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Sub Acct won't override in Receivings Transaction Entry from project card when entered with a PO

    Hi,

    This might be by design, as the information for the account override from the Project / Cost Category could be picked up the time of creation of the Line Item in the PO... Try deleting the line item and re-add a new one with the same project / Cost category. Existing PO's would not know about the segment override changes..

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans