Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Shipment Not Showing u...
Finance | Project Operations, Human Resources, ...
Unanswered

Shipment Not Showing up in Enter/Match

(0) ShareShare
ReportReport
Posted on by brownmed 55

Hello-

I have seen similar versions of this questions being asked, but no resolution.  We are attempting to match invoice to a receiving shipment.  There are about 12 items on the invoices.  All 12 items have been received in a shipment.  When we attempt to match, 10 of the 12 items are able to be pulled in from the shipment.  However, 2 of the items are not.  The RCT number does not appear when attempt to match.  Is this an issue with the tables or is there another reason we can't find the shipment for those 2 items?  

Any help would be great.

Thank you

Categories:
Microsoft Dynamics GP
  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Shipment Not Showing up in Enter/Match

    Here are three queries to run:

    select * from pop10300

    select * from pop10310

    select * from pop10500 where ponumber='the po number we are having the problem matching things to'

    If you want to email me the results instead -- because of privacy considerations with company data -- that would be awesome.

    joe (at) jcma (dot) biz

    Joe

  • brownmed Profile Picture
    brownmed 55 on at
    RE: Shipment Not Showing up in Enter/Match

    Hi Joe,

    I went through the Enter/Match invoice screen and filtered through all of the previous transactions.  There is no no line items showing in the grid.  I would think looking at SQL is probably the best option now unless you have any other suggestions as I am stumped.

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Shipment Not Showing up in Enter/Match

    Something I just thought of here before the SQL queries...

    If you open the Enter/Match Invoices screen and use the first, previous, next and last buttons -- if you hit the first button, are there any transactions that come up that have missing information (no vendor, no document number) but there are line items showing in the grid?

    Joe

  • brownmed Profile Picture
    brownmed 55 on at
    RE: Shipment Not Showing up in Enter/Match

    Hi Joe,

    The quantities that appear in the 'i' screen are the quantities I need to match to the invoice but can't.  I can't find where they are matched too, but it looks like they are being matched to an unposted invoice.

    I am able to run SQL queries.  Do you have specific ones I can run?

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Shipment Not Showing up in Enter/Match

    Do the same quantities show for the two items you can't match on the "i" screen?

    Are you able to run a couple of SQL queries?

    Joe

  • brownmed Profile Picture
    brownmed 55 on at
    RE: Shipment Not Showing up in Enter/Match

    Thank you Joe.  I deleted the transaction and ran the reconcile. Nothing was found.  I also ran the shipment/match activity and the items were not found to be matched to any invoice.

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Shipment Not Showing up in Enter/Match

    Is there an unposted Enter/Match Invoices transaction or Purchasing Invoice Entry batch out there in Purchasing Batches? Or while entering the invoice match, did something happen to the computer or the network connection?

    In your top screen shot, SOMETHING has matched the invoice with the shipment, which is why matched is showing 125, but invoiced is showing 0 in the Unposted column.

    I would try these two things:

    1) Delete the invoice transaction in Enter/Match Invoices -- since it is unposted, you can just delete it.

    2) Run reconcile on the PO. Purchasing > Utilities > Reconcile Purchasing Documents. Just enter in the one PO number in the From and To fields.

    Joe

  • brownmed Profile Picture
    brownmed 55 on at
    RE: Shipment Not Showing up in Enter/Match

    Hi Joe,

    There were 2 shipments for the PO.  The other shipment has already been matched.  The unposted column for the 2 items is showing the qty amount next to 'Matched'.  See below.  The first screen shot is an example of the items we cannot match.  The second is an example of another item in the same shipment that we are able to match.   The match invoice document has not been posted.  If I am reading the below correctly, it is indicating that the item was matched already somewhere?

    Item we can't match

    pastedimage1614116610416v2.png

    Item that was matched

    pastedimage1614116626164v3.png

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Shipment Not Showing up in Enter/Match

    That is interesting.

    The 125 and 50 should also be showing in the Remaining Posted Shipments to Match field.

    Was there just one shipment transaction or multiple? Is there anything in the Unposted column for each of those line items on the "i" button screen you just looked at?

    Joe

  • brownmed Profile Picture
    brownmed 55 on at
    RE: Shipment Not Showing up in Enter/Match

    Hi Joe,

    The PO number does not show in the Auto Invoice option.  In the PO inquiry, the 'i' field brings up the following:

    Remaining to Ship - 0 for both items

    Remaining to Invoice - 125 and 50 for each time respectively

    Remaining Posted Shipments to Match - 0

    I am wondering if the Remaining Posted Shipments to Match not be 0?  I have never explored this field so I am not certain.

    I appreciate your quick responses!

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans