Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

PO Return not hitting accrued GL account

Posted on by 75,730

Using GP 2010, I just stumbled across an issue with PO Returns. Normally when you enter a PO shipment receipt, the GL accounts that get hit are a debit to inventory and a credit to accrued purchases. However, if you the do a PO Return for this shipment receipt it will credit inventory and debit cost of goods sold. So now your received/not invoiced report will no longer agree with your GL account for accrued purchases. Is there any way to correct this?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: PO Return not hitting accrued GL account

    Thanks Richard. Those boxes take some thinking to use them correctly. The Invoice Expected box really means that you expect an invoice for  the returned goods not that later on the goods would be reshipped and invoiced.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: PO Return not hitting accrued GL account

    In your example, DONT check the boxes!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: PO Return not hitting accrued GL account

    Well that does not make mujch sense. As an example let's say I order 1,000 Deluxe Widgets at $5 a piece.

    Step 1)I enter the PO for 500

    Step 2I do a shipment receipt for 500 accidentally. I now have a debit to inventory and a credit to accrued.

    Step 3)I realize this is a mistake and do a PO return, I now have a debit to COGS and a credit to inventory

    Step 4)I come along and do 5 shipments of 100 apiece. Each one does a debit to inventory and a credit to accrued.

    Step 5)Finally I do an invoice match for 500. This debits accrued and credits AP.

    After all of this I still have this incorrect debit to COGS sold that was created in Step 3.  How does that get corrected? The debit should have been to accrued not to AP. The only way I see now is a ledger entry.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: PO Return not hitting accrued GL account

    Marking Replace Returned Goods assumes they are returning 500 to receive 500 more separate from what was left remaining on the PO.  It assumes that an invoice will be sent to move the dollars from Accrued Purchases to AP and thus hits payables and inventory.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: PO Return not hitting accrued GL account

    The invoice match had not been done so it was a PO Return. Both boxes were checked.

    Replace Returned Goods and Invoice Expected for Returned Items.

    What had happened they had received 50 widgets but had entered and posted 500 on the shipment receipt. There were 750 on the PO. More were due in at a later date.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: PO Return not hitting accrued GL account

    Are you doing a Return or Return with Credit?  Are you marking the Replace Returned Goods or Invoice Expected for Returned Items?

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