We are running a saved search that groups transactions that hit our Accrued Purchases account by Created From, which has the effect of grouping them by PO (since we always create a separate vendor bill for each PO) so we can see the total of the transactions affecting that account for each PO. In the vast majority of cases this gives us a list that we can compare to the list on the Post Vendor Bill Variances page, so we can confirm that the journal entry is needed.
The problem is that some POs that are shown to be out of balance in regard to Accrued Purchases by the saved search don't appear at all on the PVBV page.
This is particularly a problem for drop ship POs that had to be received into inventory. When this happens an Item Receipt is created that credits the Accrued Purchases account, but of course the vendor bill doesn't hit that account at all since it is for a drop ship. We need to post a journal entry to balance this out, but if we create one without using the PVBV page it will not have been "created from" the PO, so our report doesn't work. We need to show this report to our accountant, so it is crucial that we are able to group this transactions by PO, to explain the total in Accrued Purchases.
Is there a way to create a journal entry that is "created from" a PO without using the PVBV page? Or a way to report transactions that hit Accrued Purchases grouped by PO without using Created From?