You’re offline. This is a read only version of the page.
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!?
*This post is locked for comments
I have the same question (0)
Hi
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
Share
Report
All responses (
Answers (
