Hi there,
I am trying to create an Item Purchase History Report by Vendor and see there is an Infor delivered report called 'Vendor Payment History'. But, there is no relation to the 'VendorItem' business class, 'Vendor' business class, or even 'PurchaseOrder' business class?
As an alternative solution, I have created a report using 'PurchaseOrderReceiptLine' that pulled the fields:
-Company
-Vendor
-PurchaseOrderReceipt
-PurchaseOrder
-PurchaseOrderLine.LineNumber
-Item
-VendorItem
-Description
-EnteredRecievedQuantity
-PurchaseOrderLine.CalculateExtendedAmount
-PayablesInvoiceRel.TransientPaymentDate
-PurchaseOrder.PurchaseOrderDate
For sorting, I have used Set13 to sort by Vendor and VendorItem. For totaling, I am using "Total" on CalculateExtendedAmount and EnteredReceivedQuantity. This sorts the VendorItem incorrectly, as it has separate subtotal lines for the same VendorItem.
Has anyone else experienced this issue/know a better way to sort?
