Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Purchasing Returns - Replace Returned Goods / Invoice Expected for Returned Goods

(0) ShareShare
ReportReport
Posted on by 9,142

Hi

Has anyone had a play with the above mentioned boxes in the Purchasing Returns screens?  I am really interested to know others thoughts on what the actual business scenario is for these boxes when used together.  I am also really concerned about what it appears to do with the Goods Received Not Invoice report.  Here is a scenario I just played with:

Purchase Order raised for 20 items @ $5.00 each - total $100.00

Received 5 of the items - no change in cost price.

DR Inventory / Expense $25, CR Accrued Purchases $25 - as expected.

GRNI Report prints as expected.

Returned 2 of the items and marked both Replace Returned Goods and Invoice Expected for Returned Goods.

Interestingly, the return distributions wanted to post to the GL account set up for purchases in Posting Account setup - not Accrued Purchases - even though the Distribution Type was "ACCRUED".  I manually coded it back to Accrued Purchases before posting.

So DR Accrued Purchases $10, DR Inventory / Expenses $10

GRNI report shows original amount of $25, adjusted amount of $15.

Received the remainder of the items - auto receive ticks off 17 items - my remaining 15 plus two more.  Distributions as expected:

DR Inventory / Expense $85, CR Accrued Purchases $85.

GRNI report shows original amount of $110, adjusted amount $100.

Now here is where it gets interesting.  At invoice match, an auto-match marks 22 items to invoice, at a value of $110.

DR Accrued Purchase $110, CR Accounts Payable $110.

GRNI report now shows no items remaining.  BUT what about the additional $10?  Now this is sitting in my Accrued Purchases account - with nothing on the GRNI report to match it against.  Therefore, creating an out of balance.

I am really struggling with the real life business scenario of using these options?  Surely no one would ever want to process an invoice for more than they have actually received with no way then of seeing what you are expecting to receive a credit for?  Can anyone give me a real life example of where they are using this?  And where you code the return so you don't "lose" the quantity?

Cheers

Heather

*This post is locked for comments

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans