Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cannot Change PURCH ac...
Microsoft Dynamics GP (Archived)

Cannot Change PURCH account on Summary Level

(0) ShareShare
ReportReport
Posted on by Nancy Hogan 1,295

User is getting the error "You cannot change the PURCH account at the summary level" when attempting to match the second of a 2 line PO in the PO Invoice Match window.  Normally this error occurs in Receivings entry and not PO Match.  Obviously, I have reviewed KB article #952388 which advises to change the Inventory Acct at the Receiving Detail Line Item window.  Well, since the PO is already received as a shipment, we cannot do that.  Nor is there anywhere on the PO Match to change only the line item.  We have tried the following:

1.  Deleting and defaulting in the distributions

2.  Tried going back to the PO and putting in an acct there - it won't let us call up the PO because it says it has been either received, closed, or cancelled.

3.  Ran reconcile on the PO

4.  Ran checklinks on Purchasing Trxs table.

If we zoom back on to the original shipment receipt for this line item, it appears fine and there is a distribution acct entered. 

Please advise.

Thanks,

Nancy 

 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot Change PURCH account on Summary Level

    As long as you don't use PURCH as the distribution type you can make changes to the GL distribution at the summary level.  

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,004 User Group Leader on at
    RE: Cannot Change PURCH account on Summary Level

    I want to verify Michael Scalamogna reply. it works.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot Change PURCH account on Summary Level

    I just came across this issue. You should make sure you have something filled out on either the item master record or vendor master record for the default purchase price variance account. You don't have to delete the PO or receiving transaction or anything; just delete your invoice, make the changes to the master records and then re-enter. You should be good to go.

  • Ritesh Maharaj Profile Picture
    Ritesh Maharaj 945 on at
    Re: Re: Re: Cannot Change PURCH account on Summary Level

    Whoa! Easy there Richard!

    While Microsoft's intentions were well-intended with this change, in practice, they have screwed it up. Now, even when you're doing an invoice matching and enter a trade discount amount, the distribution defaults to the PURCH account that was on the shipment and you cannot change it as you get the same message stated above!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Cannot Change PURCH account on Summary Level

    One thing you could look at is the default posting accounts for the creditor. Just verify that the default accrued purchases account that is set up for the creditor matches the accrued purchases account used on the Shipment. (If the Creditor doesn't have a default accrued purchases account defined, check what the default is in the Posting Setup window (Tools >> Setup >> Posting >>Posting accounts)). I'm not saying this is your issue - but I do remember a similar problem a while back and it had to do with changes to default posting accounts after a shipment was received.

    Best regards,

     

  • Nancy Hogan Profile Picture
    Nancy Hogan 1,295 on at
    Re: Re: Cannot Change PURCH account on Summary Level

    I am not sure how to take your response. Either way, it is not helpful and does not answer my question.

    I am fully aware of the accounting process that takes place when you enter a PO and then receive it as a shipment.  There were 2 line items on this PO.  Both were received in Receivings Trx entry normally with a debit to an Inventory account and a credit to an Accrued Purchases account. The first PO Matching for 1 of the line items worked fine - there was not change in the amt from the original PO.  It is the second line that will not match and the user is not attempting to change the amount. 

    I think I will go straight to MS support.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Cannot Change PURCH account on Summary Level

    Boy are you really trying hard to mess up your GL or what?

    During the receiving transaction, the purchases account is debited with the value on the PO.  The offset to this should be purchasing accrual.  During matching, you debit purchasing accrual and AP.  Any difference should post to PPV.

    Later, if you bought a Fixed Asset that is not inventory, like a computer or a desk or a piano, journal the ppv to Fixed Assets.  If you botched the amount on the PO, fire the buyer. 

    Otherwise, your next post on here will be asking why the receiving accrual does not match the received not invoiced report.

    This is a USSIF error!

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans