Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Part invoice Purchase Orders

Posted on by 2,445

We have many Purchase Orders, that have been received, but only part invoiced, we believe this is down to when we first started using Nav & did not match every Order to an Invoice. We are happy that the Orders have been paid & what to removed the PO's from the list view, apart from Manually opening each one to check & then archive & then delete, is there a better way of dealing with this?

The Delete Invoiced Purchase Orders Batch Job does not work as the Orders are not fully invoiced.

Any hep gratefully received.

Nav 2009 R2

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Part invoice Purchase Orders

    Yes.  If you are not used inventory item in Purchase order, there is no problem.

    Otherwise, you have consider/accept these below situations.

    1. The actual purchase amount of those item ledger entries will be zero and invoiced quantity for that line will be zero

    2. If you have setup expected cost post in Navision, it might have posted some amounts into inventory interim account, those entries will not reversed unless you invoice the receipt lines.

    Some consultant’s, may advice to invoice those lines with zero amount. But, it may affect your item average cost when you run Adjust cost item entries batch.

  • Ian Fletcher Profile Picture
    Ian Fletcher 2,445 on at
    RE: Part invoice Purchase Orders

    Ok Thanks, it was worth asking the question, we will probably do it manually & archive & delete the PO's in question - will this cause any problems?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Part invoice Purchase Orders

    There is no such functionality available in NAV. Only way, you have to ask your partner to develop customized program to delete those orders.

  • Ian Fletcher Profile Picture
    Ian Fletcher 2,445 on at
    RE: Part invoice Purchase Orders

    Hi Tarek,

    I did see this before but it is different to my problem, an example if I have a Purchase Order of 2 lines

    Line 1 is for qty 1 which has been received but shows as not invoiced, but in reality this has been invoiced

    Line 2 is for Qy1 which has been received & shows as Invoiced so all correct.

    Because the PO still shows Line 1 as awaiting to be invoiced the PO is still available in the PO Table, if we run the delete Invoiced PO's then this is not deleted as Nav still thinks it is outstanding.

    We know the PO has been invoiced but how do we tell Nav this so that the PO can be removed?

  • Tarek DEMIATI Profile Picture
    Tarek DEMIATI 680 on at
    RE: Part invoice Purchase Orders

    Hello Ian,

    This is a recurring issue I've had a few times , I think there's a hotfix for this, check the end of the thread below :

    www.mibuso.com/.../viewtopic.php

    // Tarek

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans