Dynamics Community Forum Thread Details

Payable Apply Window (documents open, work or paid with check number all by vendor ID)

Hello Geniuses!

Today I need your help

I want to know if a document is paid or not and what check number was used to do it.

I need all the fields on the " Payable Apply Window"

The fields are : Voucher/ Payment # (This field tells you the CHECK #)

Document type (this field tells you if is WORK, HISTORY, OPEN OR PAID)

Vendor ID (Vendor unique ID)

Document number (Reads Invoice Number)

Purchase Amount (Reads Invoice Amount)

No idea what table will give me all these fields but I know that if I go to Search for Document number , I type the document number I'm looking for, I select it and then I click on "Apply" button the window named : "Payable Apply" window will appear and I want all the fields from it!

I Want to do a report that gives me for a particular Vendor ID: each invoice/document with its amount and status ( WORK, OPEN AND HISTORY with the Voucher/Payment # (Check number that paid it)

PLEASE GENIUSES I will super appreciate the bright help!

Note: I'm new at work so I do not have to much access level capability.

Your best bet is going to be to use a sql view and then you can build either an ssrs report off of that or a Smartlist through Smartlist Designer (depending on what version of GP you are on).

The good news is that many views have already been created so you don't have to do the hard part. Check Victoria Yudin's site (victoriayudin.com/.../payables-sql-views). There's a listing of payables views that she's created. Some of those will most likely get you what you need.

You'd just need someone to create the view on your sql server. Here's a quick little overview of Smartlist Designer but if you search for it through Google or Bing you'll get a lot more details on it. www.interdynbmi.com/.../introduction-smartlist-designer

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)