Dynamics Community Forum Thread Details

AP Metrics

Our controller is wanting an AP Metrics report containing the following fields.

apdoc.refnbr,

apdoc.vendid,

vendor.classid,

apdoc.docdate,

apdoc.InvcDate,

apdoc.duedate,

apdoc.paydate,

apdoc.PerPost,

apdoc.perclosed,

apdoc.OpenDoc,

apdoc.crtd_user

The apdoc.paydate isnt the actual date the invoice was paid, it is the caculated field in Voucher and Adjustment entry. I cant figure out how to get that information.

Help!?

Please find below details of the Date column

DocDate : Document Date. Defaults to today's date. For 'RC' type documents, this is used as the Next Generation Date. Used as Transaction date for cash management for checks

DueDate: Due Date, as calculated from APDoc.Terms.

InvcDate: Vendor Invoice Date

PayDate : Pay date of document. Defaults as calculated from APDoc.Terms. Used for the selection of vouchers to pay. Defaults to the discount date if Vendor.PayDateDflt = 'D' or the due date if Vendor.PayDateDflt = 'U'

You can execute the below query to get the above information

Query to View all Records

======================

Select RefNbr, ApDoc.VendID,Vendor.Name as 'Vendor Name',Vendor.ClassID,DocType,DocDate,InvcDate,DueDate,PayDate,PerPost,PerClosed,OpenDoc,ApDoc.Crtd_User from

ApDoc Join Vendor On ApDoc.VendId=Vendor.VendId

Query to View the records for particular period

========================================

Select RefNbr, ApDoc.VendID,Vendor.Name as 'Vendor Name',Vendor.ClassID,DocType,DocDate,InvcDate,DueDate,PayDate,PerPost,PerClosed,OpenDoc,ApDoc.Crtd_User from

ApDoc Join Vendor On ApDoc.VendId=Vendor.VendId

Where PerPost='201401' --Jan 2014

Hope this Helps

Thanks

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)