Is there a table/field that holds the check amount of the check?
*This post is locked for comments
One the AP side (cash disburesements), you can use the PM Transaction Open (PM20000) and PM Paid Transaction History (PM30200). DOCTYPE = 6 is payments, and DOCAMNT for the Document Amount. On the AR side (cash receipts), you can use the RM Open (RM20101) and RM History (RM30101). RMDTYPAL = 9 is cash receipt, and ORTRXAMT is the original transaction amount.
Mike, I am looking for a check Amount, not a document amount.
A check amount can be greater than a document amount if one check is use to pay multiple invoices.
Bab,
How are you trying to analyze the data as there are a couple of ways to look at this data from the payment standpoint which would show the document amount of say $100 or from the apply scenario where a $25 invoice and $75 invoice exist and you either want to see what was applient to those invoices or the whole amount of the applied check to either of those invoices.
You are actually probably after data that exists in these tables:
In PM, these are the PM Apply To History (PM30300) and PM Apply To Work Open (PM10200).
In RM, these are the RM Apply History (RM30201) and RM Apply Open (RM20201).
Victoria Yudin has some SQL queries available on her blog already built around these scenarios that I would recommend taking a look at:
victoriayudin.com/.../payables-sql-views
victoriayudin.com/.../receivables-sql-views
Mike, thanks for replying so promptly.
May be you are right. May be the data I am looking is calculated based on the data from those tables or it could be in seperate table.
This is what i am trying to get.:
If you open the check distribution report, there is a header portion that contains:
Vendor ID Vendor Name Checkbook ID Check Number Check Date Check Amount
and I am trying to get the check amount of the check from the database level.
and by the way, i went through victoria's blog before posting this question. but i couldnt find the thing i was looking for.
Take a look at this view from my blog: victoriayudin.com/.../sql-view-for-payables-payment-apply-detail-in-dynamics-gp. If I am understanding your questions correctly, you're looking for the payables check amount, which will be the Payment_Functional_Amount in the results from this view. For checks that are applied to more than one invoice, you will see multiple lines in the results and the Payment_Functional_Amount will be repeated on all of them. So a $100 check applied to 2 invoices would look something like:
Payment_Functional_Amount Apply_To_Doc_Number Applied_Amount
$100 Invoice 1 $25
$100 Invoice 2 $75
Also, just to clear up some terminology - a 'document' in GP is another word for transaction. A check is a document (technically, it is a payment document of type check), an invoice is a document, a credit memo is a document. Document Amount is the functional total of the transaction, so...for a payment of type check, the document amount will be the same thing as the 'check amount'.
If this is still not answering your question, then can you please give us more detail/background on what exactly you are looking for?
Thanks Mike and Victoria for you input, the data i was looking is in the table PM30200. Somehow i overlooked. I came to notice after i reviewed the view.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
