Posted cash receipt: checkbook ID field blank?

(0) Share

Report

Posted on by l-thomas

1,325

Hello All

In which table can I find the checkbook ID field (CBKIDCHK) of a posted cash receipt document. When capturing the cash receipt the field in populated in the RM10201 however, when you post the document I cant find it. Where does it disappear too?

Thanks in advance for your help!

Louella

*This post is locked for comments

All responses (4)

Answers (0)

l-thomas 1,325 on at

Like (0)

Report

Re: Re: Re: Re: Posted cash receipt: checkbook ID field blank?

Thanks Ruel! You're a star.

What an obscure place for the checkbook ID field
Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Posted cash receipt: checkbook ID field blank?

It's in the RM20101 table. Check out the MSCSCHID field.
l-thomas 1,325 on at

Like (0)

Report

Re: Re: Posted cash receipt: checkbook ID field blank?

Rashid,

RM10301 is a work table which has un-posted transactional data. My original post states that Im looking for posted transactions table. Also, if you do a test you will notice that the CBKIDCHK in the RM20101 table is blank - the field is not populated with the data from the RM10301 table when you captured the transaction.

Does anyone else know in which table the checkbook ID field gets populated from the RM10301 (unposted cash receipt).
Rashid Farooq 1,000 on at

Like (0)

Report

Re: Posted cash receipt: checkbook ID field blank?

Dear Louella

The filed CBKIDCHK exist in following table.

SELECT CBKIDCHK,* FROM RM10301

SELECT CBKIDCHK,* FROM RM20101

SELECT CBKIDCHK,* FROM RM_SALES_HDR_WORK
SELECT CBKIDCHK,* FROM ICJC9000