Announcements
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
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?
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.
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
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?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156