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) / Auto Invoice data missing
Microsoft Dynamics GP (Archived)

Auto Invoice data missing

(0) ShareShare
ReportReport
Posted on by Bill Campbell

When we open the Enter Match Invoice transaction window in Purchasing >> Transactions we enter the needed data for the Vendor and then when the cursor is in the PO field, we click on AUTO INVOICE.

Now from this system window we expect to see all outstanding PO documents.  However we are missing one.

If we close this Auto invoice window, and manually enter the PO number in the field, we can move forward to the VENDOR ITEM and select an item, however it is at this point that the client gets a message that says the LINE ITEM is fully Received and Invoiced.

Challenge here of course is that we are just trying to enter the invoice for this item for the first time.

I have done

VENDOR - Batch - Reconcile

VENDOR - Summary - Reconcile

= both with no effect

Looking for next suggestion. 

Thanks.

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Auto Invoice data missing

    Thanks Matt - that solved that problem - now the PO shows up when trying to complete the Auto Invoice function.

    Knew I had to be missing something simple.

  • Verified answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Auto Invoice data missing

    Yeah, I'd set the QTYMATCH to 0.  That's basically a flag for how many of that receipt have an invoice matched to them.  It sounds like the orphaned invoice that you deleted had updated the QTYMATCH for the shipment receipt.

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Auto Invoice data missing

    Yes, there is NOW only one record.  There were two

    RCT0012963 SHIPMENT - status posted

    RCT0013229 INVOICE - status not posted - but also with no header

    When I looked at the Purchse Receipts Zoom for one item on the PO I could see attached to the ITEM the non-posted document, but it was missing field data in the screen.

    We have deleted the RCT0013229 and now we are left with same results in the Select window, but in the ZOOM only the correctly recorded SHIPMENT is there.

    Maybe more than I needed to send, but I want to be complete

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Auto Invoice data missing

    So just to make sure I'm following.  The one record in the POP10500 for that PO is the shipment receipt, correct?  If so then try setting the QTYMATCH to 0.

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Auto Invoice data missing

    Matt, sorry for the delay but have been out of the country and client has been ignoring this for now - anyway - we are back.

    So, looking at the POP10310 there were no duplicates

    In the POP10500 we found a record RCT0013229 that had no header details and as attached to this PO - we removed that

    In the POP10500 the QTYMATCH (1) is the same value as the QTYSHPPD (2) and the QTYINVCD (3) is showing ZERO

    so - PO - 0007498

    (1) 60.00

    (2) 0

    (3) 60.00

    Only thing happed to the PO is the receipt of the Shiptment - noted correctly in the table.

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Auto Invoice data missing

    Hey Bill,

    We run in to this from time to time and there are typically a couple of different reasons I see for this.  1) There's an unposted invoice that already has that po/item on it.  I usually check the POP10310 tables for this and sometimes find an orphaned record.  2) Check the POP10500 table and filter by that PONUMBER and POPRCTNM.  What does the QTYMATCH field say?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans