What table in GP holds payment received information?

(0) Share

Report

Posted on by Bill Stoltz

We are attempting to modify a web version of our invoice, and need to locate the table which holds the amount billed to a customer's credit card so that we may list that amount on-line. We have not been able to locate the table. Does anyone know where it is or if it holds some name that does not appear to match its contents?

thanks

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report

I presume you are posting these credit card receipts as RM cash receipts?

Are these posted or unposted cash receipts?

Unposted receipts will be in the RM Cash Receipts Work File (RM10201). Posted will be in the RM Open file (RM20101), and historical cash receipts (Fully applied and transferred to history) will be in RM History (RM30101).

You will want to select documents where the RM Document Type All = 8, and the Cash Receipt type = (not sure, but query the table and you will find out - might be '2' since Credit Card is the third option on the cash receipts entry window)

Check out the RM Apply tables (RM20201 and RM30201) to find out what Invoices the cash receipt is applied against...so you know which invoice to include the billed amount on.

You will also be interested in the 'Applied Amount'...since in theory one credit card receipt could be applied to many sales invoices.

Hope this helps.

Was this reply helpful? Yes No