Invoice not found in any RM tables

(0) Share

Report

Posted on by Nhi Nguyen

Hi folks,

Please help me on this problem.

I merged two customer IDs let's say from A to B. Invoice # 14163 was originally on the A account. After the merge, I cannot see it under the Transaction by Customer for B account. However, when I ran Sales Lines Items smartlist, it shows the invoice under B account.

The only place I can find it is in the SOP30300 table.

Any suggestion?

Thank you in advance.

Nhi

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (2)

Suggested answer

Tristan Clores 2,812 on at

Like (0)

Report

Hi Nhi,

I assume you used PSTL Customer Combiner? It's quite unusual that the transaction was lost upon combining Customer A and B.

One thing I can recommend is revert to your backup file prior to the merging, load it to a test database and then redo the combine.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Nhi,

If you look in the SOP30200 table using SQL, is the record not there under any customer ID?

Kind regards,

Leslie

Was this reply helpful? Yes No
Nhi Nguyen on at

Like (0)

Report

Hi Leslie,

The record is under customer B. Any suggestion?

Thank you,

Nhi

Was this reply helpful? Yes No
Suggested answer

Tristan Clores 2,812 on at

Like (0)

Report

Hi Nihi,

So the transaction is in both SOP30200 and SOP30300 tables but not in RM20101, RM30101 and RM00401 tables?

Try running Check Links against the Sales series:

- Receivables Transaction History Files

- Receivables Open Transaction Files

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Nhi,

Since you merged A into B, then the invoice which was originally customer A, would now be customer B. In the SOP30200 table it's listed as customer B, which is the result you need. The SOP30200 is the SOP Header History table. The individual line items would be in the SOP30300 table. Do you have this listed in the SOP30300 table? If the header is there and the line items are there, perhaps you need to run Check Links and reconcile to match everything up again.

Do you find the invoice in either the RM20101 or RM30101 tables?

Kind regards,

Leslie

Was this reply helpful? Yes No
Nhi Nguyen on at

Like (0)

Report

Hi Tristan and Leslie,

I tried all of the solutions you suggested but nothing is fixed. The invoice is in the SOP30200 and 30300 table but not in any RM above.

Something is weird is that whenever I post individual sale invoice, my session hungs up. To avoid that incident, I have to save even one invoice in a batch and process the posting. When I posted this invoice, I posted individually and my session hang up.

Regards,

Nhi

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

OK,

So it looks like the Sales module didn't complete its post. It moved the SOP document to history but it never created the Receivable. When you posted the SOP document were there entries posted to the general ledger? What is the status of your Receivables Trial balance reconcile to the general ledger? Does it? My thinking is to follow this transaction through the system and create whatever documents it missed.

Kind regards,

Leslie

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

Looking at your other issue. If you look in the SY00500 table, do you have any records that show your user id as the batch id?

Kind regards,

Leslie

Was this reply helpful? Yes No
Nhi Nguyen on at

Like (0)

Report

Hi Leslie,

I ran this script Select * from SY00500 where USERID = 'nnguyen' and there is no BACHNUMB that has my user ID.

thank you,

Nhi

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

If you run the script Select * from SY00500 where BACHNUMB = 'nnguyen' does it also come up blank?

Moving on from that, what about the general ledger and the RM trial balance. We need to find how far this trx got through the system. This might be as easy as just creating the missing RM transaction.

Before I did that I would use SQL and search for the string that is the SOP Document Number. I would want to consider each table containing a field with that value.

Was this reply helpful? Yes No