RM Keys Table

(0) Share

Report

Posted on by Community Member

I am writing some dex code to validate whether or not an SOP Number for a specific Document ID that I want to create has already been used or not. In trying to determine the best way to do this I was looking at using the RM_Keys_MSTR (RM00401) table. While looking at the data in this table I found the Document Status (DCSTATUS) field. It would appear that a value of 3 would mean the sop document has been posted and can be found in the SOP_HDR_HIST (SOP30200) table. Likewise a value of 2 would mean the sop document has not been posted and can be found in the SOP_HDR_WORK (SOP10100) table. What I am finding however is that 295 of the over 15000 records in the RM_Keys_MSTR table for the records I am looking at are in the SOP_HDR_HIST table but still have a Document Status of 2. Are there any cases where a posted SOP document would still have a Document Status of 2 in the RM_Keys_MSTR table?

Thanks,

Lonnie

*This post is locked for comments

All responses (5)

Answers (1)

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: RM Keys Table

You are most welcome Sir,

Please never hesitate to share any further inquiries.
Community Member on at

Like (0)

Report

RE: RM Keys Table

That answers my question perfectly. Thanks you!
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: RM Keys Table

I might need to provide further illustration on the SOP documents and status. First of all, we need to take into consideration the document status values in RM00401

Reserved - 0

Work - 1

Open - 2

History - 3

Now, in SOP, there is no open table for the posted transactions. Unposted transactions are recorded in work tables; sales transactions work header and amount details (SOP10100 and SOP10200).

Once the invoices are posted, they move into SOP history tables; which are sales transaction history header and amount details (SOP30200 and SOP30300), on the receivable management level, they are moved into Open tables (accordingly, associated key master is updated in RM key master RM00401).

Therefore, you can see documents in SOP history table with either (2 or 3) document status in RM00401.

Once the invoice is fully paid, the status in RM00401 changes into 3, while the SOP document is SOP history tables remains.

Further issues to consider, in SOP tables, there are a various posting status numbers that you might encounter, Mr. Mariano has a great added value on this; Sales Order Posting Status

In addition, you may get further essential information from Ms. Leslie greatest of all article ; Tables Names and Transaction Flow, for me this is absolutely a legendary article of all times.

Your feedback is highly appreciated,
Community Member on at

Like (0)

Report

RE: RM Keys Table

So does this mean for Sales Order Processing Entry Invoices and Returns made from the SOP Entry window corresponding entries in the RM_Keys_MSTR table do not get updated until the credit for the return has been applied or the invoice has been paid?

Thanks again,

Lonnie
Sheilajr 745 on at

Like (0)

Report

RE: RM Keys Table

Hello Lonnie,

In the sales module, paid transactions do not move to history automatically like the payables transactions do. Users must move fully paid transactions to history manually in Sales Routines > Paid Transaction Removal. Documents that are fully paid and applied will move to history while all other documents will remain in the Open and Work tables.

Depending on your accounting department, they should setup a procedure each month to run this process. They will be able to set cutoff dates for transactions they want to move and it's a good policy to choose a date where they believe they will not have to edit the payments or how they are applied. Once documents are moved to history it is much more difficult to modify those accounts.

Hope this helps,

Sheila