You’re offline. This is a read only version of the page.
890
I have invoice in the rm00401 and rm20101 tables that is not in any SOP tables. Inquiry > Sales Docs does not show it but Inquiry > Sales by customer or sales doc shows it. The real invoice is INVxxxx this phantom invoice is INVxxxx001. Can I delete INVxxxx0001 from these two tables?
*This post is locked for comments
Hi Martin,
Any update on this?
Hi MartinK,
SOP and Inventory will not have any records of the INVxxxx001, only the RM tables will (and possibly GL with respect to the RM records).
I recommend checking these points further:
1. What happens when you are in the Receivables Transactions Enquiry - Document and try to zoom to the INVxxxx001 invoice? Does it take you to the INVxxxx document (Sales Transaction Enquiry Zoom)? If not, do you get any error messages?
2. When you do an enquiry for the INVxxxx document in the Receivables Transactions Enquiry - Document and try to zoom to the INVxxxx001 invoice, do you get redirected to the correct invoice? Is it the same invoice that came up in the Point #1?
I am really not keen on deleting the records tbh as usually this is a valid transaction. Maybe try sending me the results of the scripts below (tristanthor@msn.com):
select * from SOP30200 where SOPNUMBE in ('INVxxxx','INVxxxx001')
select * from SOP30300 where SOPNUMBE in ('INVxxxx','INVxxxx001')
select * from RM00401 where DOCNUMBR in ('INVxxxx','INVxxxx001')
select * from RM20101 where DOCNUMBR in ('INVxxxx','INVxxxx001')
select * from RM30101 where DOCNUMBR in ('INVxxxx','INVxxxx001')
Please save the results to a .RPT file for better viewing on my part.
I actually came about this issue in the past already, hence the reason I am quite familiar with it. I believe there was a KB regarding this when I was with Microsoft Support, but they probably tagged it already as an internal article since it's not searchable online.
Let me know if you have further questions.
@Mahmoud Check Links did not correct it.
@Tristan your reply makes sense, this transaction was imported from pour webstore.
The only records for INVxxxx001 are in the rm00401 and rm20101. Nothing in the SOP tables and nothing in RM30101.
No inventory transactions for INVxxxx001.
INVxxxx has information in all the places you would expect it.
So is it ok to delete INVxxxx001?
@Tristan where did you find the information about imported documents adding the 00x? I would like to learn more about GP.
RM20101 is an Open transaction table which means the invoice has been posted. Do not delete anything from this table; enter a credit note and apply to the invoice to correct the balance.
Hi,
This usually happens when transactions are imported into Sales Order Processing and there has been an instance of the same document number in RM already.
What the system will do is it will add a corresponding "00X" prefix to the document number when it records the document in the RM tables.
I do not recommend deleting the record in the RM tables as of yet.
I recommend that you check the RM00401, RM20101 and RM30101 for instances of the INVXXXX and INVXXX001 and then verify if the transactions are valid.
Let me know if you have further questions.
I would recommend going for check links which may have a look at such orphan records and handle them correctly. Documents in RM20101 may have a distribution and other records associated in other tables, therefore, check links may be a better solution as you may not be able to determine all the tables.
Let's see what the results of check links are.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (