web
You’re offline. This is a read only version of the page.
close
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) / 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

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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!

  • Nancy Hogan Profile Picture
    Nancy Hogan 1,295 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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,

     

  • Ritesh Maharaj Profile Picture
    Ritesh Maharaj 945 on at

    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!!

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    I want to verify Michael Scalamogna reply. it works.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

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

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans