Skip to main content

Notifications

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) / Due Date on historical...
Microsoft Dynamics GP (Archived)

Due Date on historical PM transactions

(0) ShareShare
ReportReport
Posted on by Sharon Burley 1,970

I've created a SmartList that lists payment numbers and the invoices that the payment is applied to as well as vendor invoice information (amount, invoice number, etc.). I can't seem to find the due date though. I'd like to pull in the due date, so we can see how many days from the due date we actually paid a vendor invoice. I'm using tables:

PM Paid Transaction History File (PM30200)

PM Vendor Master File (PM00200)

PM Apply To History File (PM30300)

There is a due date field available in the PM Paid Transaction History File but it shows 1/1/1900 for all records. Any suggestions?

Thanks,

Sharon

*This post is locked for comments

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Due Date on historical PM transactions

    Hi Sharon,

    The due dates are in the PM30200 table. But ONLY on the invoice records, not on the payments. Without seeing your code, it's hard to speak definitively about it, but here is what I do in my code:

    1. Take all payment transactions from PM30200 and PM20000

    2. Link to PM30300 and PM10200 to get the transactions each payment was applied to ('apply to records')

    3. Link back to PM30200 and PM20000 to get the due dates for the 'apply to records'

    I suspect you're not doing the last step of linking back to the PM30200 to get the information about the invoices. You will not be able to get the due dates without a second pass through that table.

  • Sharon Burley Profile Picture
    Sharon Burley 1,970 on at
    RE: Due Date on historical PM transactions

    Thank you for the response and the SQL view. Could you let me know which table shows the due date of the historical payable transactions? I thought maybe I was pulling the wrong due date as well, but I don't see any other due date fields in the three tables I've linked together. I started with PM30200 and linked PM30300 and PM00200 to it. I'm going to try the SQL view, but I'm just wondering how I could be pulling the wrong due date when there doesn't appear to be any others to choose from. Thanks.

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Due Date on historical PM transactions

    Hi Sharon,

    I suspect you're seeing 1/1/1900 for the due dates because you're looking at the payment records, not the invoice records. Payments do not have due dates. You would have to link the payment to the apply records first, then link from the apply records to the invoices. I have actually done that in my code here: victoriayudin.com/.../sql-view-for-payables-payment-apply-detail-in-dynamics-gp. This code also includes records from the open tables, so if you have any partially applied records, it will capture them, as well.

    Hope that helps.

  • Sharon Burley Profile Picture
    Sharon Burley 1,970 on at
    RE: Due Date on historical PM transactions

    Thanks for the suggestion. The transactions are no longer due since they are paid, but when I look at them in Inquiry, I see the due date. Addtionally, when I run the historical aging report, there is a due date. It must be stored somewhere. I'm not seeing that anyone has made a mistake and not entered a due date when I look at the transactions through Inquiry. For some reason it is not in the historical table though. So maybe another table stores that information? Using the term code would be fine, but I don't see a field for that at all in the tables I'm using for this SmartList. Where is that located? Any help would be great. Thanks.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Due Date on historical PM transactions

    Well, are historical invoices that are fully paid due at all?  The blank field must be someone's error.

    You will need to take the document date and the terms code to calculate a due date.  Alternately, simply include the terms code and description in the SmartList

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans