The documentation for this report (http://msdn.microsoft.com/en-us/library/aa598272.aspx) states:
The Accrued purchases report displays details about product receipts that have been entered and posted, but not invoiced, as of the cutoff date that you specify. The report contains data that you can use to reconcile one or more accrued purchases accounts. Invoice details are displayed on the report when one of the following conditions is true:
-
The receipt transaction date is before or equal to the cutoff date, and the invoice transaction date is after the cutoff date.
-
The invoice transaction date is before or equal to the cutoff date, and the receipt transaction date is after the cutoff date.
The description makes it sound like I can look at a snapshot in time of Purchase Orders, seeing what's been received as of the cutoff date, and what remains to be invoiced. However, if I run the report it completely filters off PO lines that have been invoiced and shows no relative information on them as the report description leads me to believe.
For instance, I do not see any Invoice details related to a PO line that was received before the cutoff date, and invoiced after. I see nothing: no records.
I did a little digging, and there is a line in the Report Data Provider class (VendAccruedPurchasesDP_NA) that shows clear as day the filtering out of Fully Matched records:
//Exclude fully matched records
SysQuery::findOrCreateRange(qr.query().dataSourceTable(tableNum VendPackingSlipTrans)),fieldNum(VendPackingSlipTrans,FullyMatched)).value(queryValue(NoYes::No));
Commenting out this one line now gives me all PO lines, but it's pretty useless because the numbers are all zero because the quantity which everything is calculated on is the remainPurchFinancialPosted - which is zero for fully matched records.
Could anybody shed some light on this report for me? What is it trying to show me? Is it broken, or am I misinterpreting the description?
