amwalshjde
Well Known Member
We would like to generate a report that shows our total A/P Spend. On the report we want, Vendor#, Date, Quantity (1 if not PO), unit Price (RP amount if no PO)
, Extended Price (RP amount if no PO), Item #, Item Description (if from PO)
This would need to include regular PO's that have been received, vouchered and Paid. There are also situations were a voucher based from a PO has an additional line added at time of voucher. Additionally, there are vouchers created without a PO.
Getting the F0414, F4311, F43121, and F0413 linked together correctly without anything missing or double counted seems to be harder than I thought it would be for thgse different scenarios.
Is there an existing UBE that does this, if not, has anyone else done something like this in SQL?
Thanks
Aaron
, Extended Price (RP amount if no PO), Item #, Item Description (if from PO)
This would need to include regular PO's that have been received, vouchered and Paid. There are also situations were a voucher based from a PO has an additional line added at time of voucher. Additionally, there are vouchers created without a PO.
Getting the F0414, F4311, F43121, and F0413 linked together correctly without anything missing or double counted seems to be harder than I thought it would be for thgse different scenarios.
Is there an existing UBE that does this, if not, has anyone else done something like this in SQL?
Thanks
Aaron