You’re offline. This is a read only version of the page.
75,730
On the Payables Apply window there two fields for Apply Date and Apply Posting Date. I am creating a report and I need to find which table(s) has these values. I have looked in the PM20000, PM30200, PM30300 and the PM10200 tables. All I find is the date of the original payment.
*This post is locked for comments
Hi,
What kind of entry are you posting? Has it, in fact, been applied? After a vendor invoice has posted, each of the applied documents are identified in the PM10200, the Apply to Work/Open table until they move to history. Once they are fully applied, they move into the PM30300, the Apply to History table.
Leslie
I want to see apply date after posting entry
Thanks Leslie. This will help in the future. We are going to upgrade to GP 2013 R2 so at least for future transactions these dates will be correct. This looks like a bug in GP 10.
Richard,
I wrote a blog article covering the date fields in the PM20000 (PM Transaction OPEN File 10 dates), PM30200 (PM Paid Transaction History File 11 dates) and the PM30300 ( PM Apply To History File 6 dates).
dynamicsconfessions.blogspot.com/.../whats-in-date-pm-transactions.html
I hope you find it helpful. Victoria is right about where those dates end up. The apply dates are used by the HATB reports and the 1099 processing routines and are often overlooked.
Kind regards,
Leslie
Richard,
Interesting. I am not able to duplicate this in my GP 2013 SP 2. So that may be something that's fixed in a newer version of GP like you mentioned before.
Further research uncovers this:
Prepayment entered with a date of 06/30/14
Invoice entered with a date of 07/04/14
Invoice entered with a date of 07/31/14.
If you go to Apply Documents and apply this prepayment to the 07/04/14 invoice using 07/30/14 as the Apply date and 07/31/14 as the Apply Posting date, the values for Apply_date and Apply_GL_Posting date from Victoria's view are both 08/12/2014.
However, if you reverse the dates for the invoice of 07/31/2014 and go to the Apply screen and use an Apply Date of 07/01/2014 and an Apply Posting Date of 07/02/2014, then these dates from Victoria's view are 07/01/2014 and 07/02/2014, respectively.
So it appears that the apply dates need to be prior to the date of the invoice. If not, it uses today's date or most likely POSTEDDT.
Could this have anything to do with the order being the dates of the transactions? The invoices are in June and July and the payment was made in August. Now I just tried with an invoice with a September date and now the Apply Date and the Apply Posting Dates have the correct October dates. I am going to create a new vendor and very carefully monitor the dates as I try again.
Victoria, I had tried your view on this sample data and the dates are wrong. There are no October dates in either of these tables.
Hi Richard,
Mahmoud is right. From all my testing and reporting on this (and I have done a lot), the apply dates will be DATE1 and GLPOSTDT in the PM10200 and PM30300 tables. I don't believe this had changed since early versions of GP. I would be very surprised if this was different in GP 10.0.
I have a view that will show these: victoriayudin.com/.../sql-view-ap-apply-in-gp. Can you please run this against your test data and see if it comes back with your October dates for the Apply_Date and Apply_GL_Posting_Date?
I had created a new vendor and entered one payment and three invoices. I then did a reverse lookup by DEX_ROW_ID of the PM2000, PM3000 and PM30300 tables and these transactions all appear at the top. None of the dates on these records are October dates.
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,151
Super User 2024 Season 2
#2
Martin Dráb
229,963
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (