web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payables Apply Dates
Microsoft Dynamics GP (Archived)

Payables Apply Dates

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,852 Moderator

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

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Hello Mr. Richard

    I have been testing several scenarios to figure out where these two fields are being stored. Initially, I have looked up in the common inquiries and reports and it seems they don't show up. As usual, the support debugging tool plays a crucial role when it comes to such a task, the resource information and associated table can just deliver the magic. Apparently, everything leads me back to PM30200 and PM30300 .

    Here is my full testing scenario and associated findings,

    • I configured a new vendor, with no historical or open transactions at all.
    • On the Fiscal Period setup, I configured a new fiscal year; 2021
    • I posted an invoice and a payment for this new vendor, in 2017
    • On the Apply Payable Documents, I applied the invoice and the payment above, filling in 01-01-2021 in both; apply date and apply posting date.
    • Proceeding with my test, I used the common "search all db" procedure to find associated tables for this new vendor, and specifically the 01-01-2021 date

    Findings:

    1. PM30200 | DINVPDOF ( Date invoice paid off )
    2. PM30300
      1. DATE1  ( Date )
      2. GLPOSTDT  ( GL Posting Date )


    Furthermore, I have checked the GL20000 since there was a GL Posting date above with the 01-01-2021. As expected, there is nothing affected by the apply date and apply posting date filled in the payable apply window. Apply should not have effects on the general ledger details.

    You may check your data set in order to find out any further findings,

    Your feedback is highly appreciated,

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Mahmoud, thank you for this attempt. In my test scenario, I enter a payment in July to a vendor and did not apply it to any invoices. I then entered three invoices in August with various August dates. I then went to the apply window and set the apply date to 10/01/2014 and the posting apply date to 10/31/2014. I then searched for any occurrences for those dates and found nothing. One thought I have left is that this client is still on GP 10. I will attempt to try the same scenario with a GP 2013 installation and compare. We are scheduled to upgrade their GP later this year. If this works in GP 2013 this will give me even more ammunition to convince them to accelerate the upgrade.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    How did you search for these dates ? In case you've used the "Search all db" procedure, it will be ineffective.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    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.

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    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?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    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.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    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.  

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    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

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans