You’re offline. This is a read only version of the page.
2,947
Is there a table/field that holds the check amount of the check?
*This post is locked for comments
Bab,
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?
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.
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:
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (