Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Partially entered POP Invoice Receipt Shows Applied

Posted on by 22,647

Situation:

Client created PO - no problem

Then received on two different shippments the full QTY ordered on the PO

Receipt 1 - 2 items - applied to the PO correctly

Receipt 2 - 18 itesm - applied to the PO correctly

Status of the PO - Ordered : 20

Shipped / Received : 20

Invoiced : 0

Here is where the problem starts.  Apparently during the entry of the Invoice - Enter Match Invoice - the client started be creating the receipt - appears to have clicked on the PO - but did not complete the data entry

Item_5F00_View.PNG

As noted in the above picture, there are no details attached to the Document Type - but the QTY Invoiced is showing correctly.

Now when the client attempted to open and correct the problem they were told that the POP was fully receipted and completed and that they could not enter any other invoices.

My Resolution

Found in the POP tables the RCT.....43317 and worked to remove that reference

Found in the POP tables where RCT.....43317 was referenced and removed the QTY Matched

Tables Adjusted

POP10600 - removed invoice

POP10500 - removed RCT....43317

POP10300 - removed RCT....43317

POP10500 - reset the QTYMATCH to 0 for the documents related to PO.....17621

Remaining Problem

Now when this was completed - the RCT of the Invoice was effectively removed. So, now we attempt to re-enter the Receipt / Invoice

EnterMatch/Invoice

Enter a new RCT number

Enter the correct Vendor Invoice Number

Enter the date, and Vendor Information

Enter the PO....17621

Enter the Item number and select the TWO Shipments to Match

NO PROBLEM TO THIS POINT

Situation now is that the Distribution for the transaction is incorrect.

When the Shipments were received the posting was to Inventory 1300 and Accrued Payables 2021

Now when then Invoice is received the posting SHOULD BE Accrued Payables 2021 and Payables 2000

However when I open the DISTRIBUTION button at the bottom of the EnterMatch Inovice scrreen, the distribution shows 1300 PURCH and if I attempt to change it, the message that we can not change at the Summary Level - to make this change we have to make it at the Item level.

This is where I am lost - when I go the ITEM detail, there is no where to change (that I have found) If I change at the Item Maintenance Level - and go back, click on Default - no change.

What am I missing?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Partially entered POP Invoice Receipt Shows Applied

    Bill can you delete this receipt and start over? Is this the only line behaving this way? I suppose the other thing to do is change the distribution using SSMS.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Partially entered POP Invoice Receipt Shows Applied

    Thanks for the confirmation Richard.  No all other invoice matches appear to be working correctly.  Only this Match is trying to post back to Inventory.

    I am sure that I need to remove the entire reference to the original Invoice Match and I may have missed something - not sure how to find it - but the PO number and I have the original RCT number for the invoice Match

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Partially entered POP Invoice Receipt Shows Applied

    If you are doing the invoice match it should not be trying to hit inventory. I just tried one and it is hitting payables and accrued. Have any of your other invoices matches behaved this 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans