Microsoft Dynamics GP is a powerful accounting software that provides various features and tools to manage your financial operations efficiently. One such feature is Elastic Windows. In this blog post, we will discuss how to identify the last invoice and payment for a vendor in Microsoft Dynamics GP using Elastic Windows.
On the Microsoft Dynamics GP Forum, Adeel Ahmad (https://community.dynamics.com/members/adeel333) asked the question of how to identify the last invoice and payment for a current vendor. A user by the name RogerRogerATX (https://community.dynamics.com/members/rogerrogeratx) provided a solution. We made a small adjustment to their SQL Script, as shown below. We made the adjustment in the ORDER clause, where the order of the posted date was changed to include the document date and the document number.
The original SQL Script order clause was:
ORDER BY PM.POSTEDDT DESC
The adjusted SQL Script order clause is:
ORDER BY PM.POSTEDDT DESC, PM.DOCDATE DESC, PM.DOCNUMBR DESC
By making this small change in the SQL Script, you can easily identify the last invoice and payment for a vendor. To make it even more convenient, you can create an Elastic Window in Microsoft Dynamics GP that will show this information every time the user enters the vendor ID.
Elastic Windows provide a convenient and efficient way to manage your additional fields for your financial operations in Microsoft Dynamics GP. By using Elastic Windows, you can access your company’s personalized information directly in your GP Windows and save time and effort in finding the last invoice and payment for a vendor.