Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

How to return items received and how to return invoiced items?

Posted on by Microsoft Employee

A purchase order is raised for 1000 Nos. @ 100 per unit.

1000 Nos are received to the warehouse using Warehouse receipt

Only 750 items are invoiced @ 100 per unit

Balance 250 items should be returned.

Of the 750 items invoiced, 10 items should be returned using with Credit Memo.

 

How can we perform this process?

I tried this, but the ledger entries were confusing for me

See below link

https://community.dynamics.com/nav/f/34/t/153870.aspx

*This post is locked for comments

  • Verified answer
    RichardRobberse Profile Picture
    RichardRobberse 335 on at
    RE: How to return items received and how to return invoiced items?

    Hi Jiju,

    I understand that the invoice (bill) will differ from the records in the purchase order..

    In this case the vendor is going for the quick and dirty solution, I've had the same in the company where I've implemented NAV2013. The trick is to educate your vendors :)

    Some dirty solutions:

    Undo the receipt line in the posted purchase receipt, and then receive 750 instead of 1000, this will only work if you still have all of the items (1000) in inventory.

    Fully invoice the 1000 items, and change the price, as if you get 250 items for free.

    Then create a purchase return order/credit memo internally.

    Maybe someone else knows a more correct way to solve this..

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to return items received and how to return invoiced items?

    Hi Richard,

    Suppose the vendor sends the bill for 750 only after they accept the returned items.

    The invoice (bill) will differ from our records and this may result in Auditor's comment.

    Wouldn't this result in reservation in audit report?

    Thanks again for your valuable suggestion.

  • Suggested answer
    RichardRobberse Profile Picture
    RichardRobberse 335 on at
    RE: How to return items received and how to return invoiced items?

    Hi Jiju, I get what you mean.

    I think the most correct way is to fully invoice the 1000 items, and then create a purchase return order/credit memo for the 250 items.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to return items received and how to return invoiced items?

    Thank you Richard..

    Consider a situation that after receiving 1000 items at warehouse, you found 250 items obsolete and you want to return them and don't want to pay for them.

    Yes my inventory should be 750 only then.

    After getting invoice from my vendor, I found 10 items are out of expiry date. That can be returned using credit memo.

  • Suggested answer
    RichardRobberse Profile Picture
    RichardRobberse 335 on at
    RE: How to return items received and how to return invoiced items?

    1. Correct

    2. Correct

    3. This will do the job for now but will the other 250 be invoiced, if that's not the case then the purchase order will never be fully invoiced.

    4. Why do you want to return the 250 items, this has impact your inventory, and your inventory will decrease to 750.

    5. Correct

    To make it a bit easier:

    You've received 1000 items

    10 items will be returned to the vendor because something is wrong with it or w/e.

    Will the remaining 250 be invoiced?

    If that's not the case then you've received 1000 items for the price of 750 items, you could solve this by using a line discount.

    If the other 250 will be invoiced, then you should change qty to invoice to 750, invoice it and then qty to invoice will be 250.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to return items received and how to return invoiced items?

    Ref: https://community.dynamics.com/nav/f/34/t/153870.aspx

    1. Create Purchase Order for 1000 Nos at 100
    2. Release and Create Warehouse Receipt for 1000 Nos
    3. Go to Purchase Order,  Enter 750 Nos. in Quantity to Invoice and Post
    4. Create Purchase Return Order, Enter 250 Nos in Qunatity to Return and Post Shipment
    5. Create another Purchase Return Order, Enter 10 Nos in Quantity to Return and Quantity to Invoice and Post Ship and Invoice.

    I follow these steps. Is this correct way?

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