PO Summary reports

Summary:

This report gives an overview of Purchase Order (PO) activity, separated by Work Order, with the ability to drill down to Supplier Invoice and GL Transaction level details.

BEGIN: What you need to have to start accessing your PO Summary reports:

• Your Unit4 login

PROCESS:

1. Login to Unit4
2. Navigate to the "Reports" tab on the Menu.
3. Select "Manager Reports" folder, and then select "Finance" folder
   1. For the Dean/Director report, select the "Area Manager" folder
4. Click on "PO Summary (Manager)"
5. Click the blue "Search" button
   1. 
6. Results columns:
   
   1. WO Mgr = Person who is listed as the Work Order manager 
   2. Work order = Work Order attached to the PO
   3. Requested by = User Name of the person who submitted the Purchase Request (Note that most POs transferred from FRS will have Jocelyn listed as the 'Requested By'
   4. NT = Code used to identify 'Regular' vs 'Blanket' PO
   5. PO OrderID = Code used to uniquely identify a single Purchase Order
   6. SuppID = Supplier listed on the PO
   7. PO Total $$ = The total amount, including full tax, on a PO for the listed Work Order (Note this may be a combined total of several lines for non-blanket POs)
   8. Expected Tax Rebate/Line = A calculated amount, used to estimate how much is left to spend on a PO
   9. Registered Invoices = The amount on this PO/WorkOrder for invoices which have been registered but not yet posted (invoices still requiring a goods receipt)
   10. Posted Invoices = The amount on this PO/WorkOrder for invoices that have been posted to the GL
   11. PO Remaining / WorkOrder = The amount left to spend on a PO and not be over-spent (PO Remaining = Total - Exp.Tax - Registered - Posted)
7. On the right hand side, drop down the "Select Link", and click on one of the desired linked reports. Other sections of this page give details of those reports

Summary

This report shows invoice activity for a selected Purchase Order. This report shows the full amount paid to the Supplier for any invoices on that selected PO.

PROCESS:

1. From a 'PO Summary' report, click the "Select link" dropdown at the far right and select "PO Invoice Activity"
   1. 
2. The report will automatically run
3. Report Columns:
   1. T = represents the Invoice state. A = Registered (still requires a goods receipt), B = Open (match to goods receipt, ready for payment), C = Historical (has been paid to the Supplier)
   2. PO OrderID = unique identifier for the Purchase Order, the PO# from the row selected to 'drill down' to this report
   3. SuppID = unique idenfiier for the Supplier
   4. TransNo = Transaction Number, click to drill-down further into the transaction details and view an image of the invoice
   5. InvoiceNo = The Supplier's invoice number
   6. TT = Helps to identify the 'invoice state' (not relevant for most general users)
   7. Inv.date = Invoice creation date, from invoice provided by the Supplier
   8. Due date = Invoice payment due date, from invoice provided by the Supplier
   9. Invoice Amount = the full amount of the invoice

Summary: 

This report shows the GL split of all Registered Invoices for the selected PO. 

PROCESS:

1. From a "PO Summary" report, click the "Select link" dropdown at the far right and select "PO Registered Invoices"
   1. 
2. The report will automatically run.
3. Report Columns:
   1. SuppID = Unique identifier for the Supplier
   2. PO OrderID = unique identifier for the Purchase Order
   3. TT = transaction type, used to help identify "invoice state" (not relevant for most general users)
   4. Trans.date = date of processing
   5. Period = the fiscal period the invoice was registered/posted for
   6. TransNo = Transaction Number, click to drill-down to the transaction details and see an image of the invoice
   7. InvoiceNo = Invoice Number provided by the Supplier
   8. # = the row number of the transaction details (for when a single invoice will hit multiple account/work order combinations)
   9. Account = the GL account for a given transaction line/amount
   10. WORKORD = the GL Workorder for a given transaction line/amount
   11. Amount = the amount for a given transaction line/account/work order

This report is functionally identical to the 'PO Registered Invoices' report, but shows Posted invoices instead of just Registered invoices

PROCESS:

1. From a "PO Summary" report, click the "Select link" dropdown at the far right and select "PO Posted Invoices"
   1. 
2. The report will automatically run.
3. Report Columns:
   1. SuppID = Unique identifier for the Supplier
   2. PO OrderID = unique identifier for the Purchase Order
   3. TT = transaction type, used to help identify "invoice state" (not relevant for most general users)
   4. Trans.date = date of processing
   5. Period = the fiscal period the invoice was registered/posted for
   6. TransNo = Transaction Number, click to drill-down to the transaction details and see an image of the invoice
   7. InvoiceNo = Invoice Number provided by the Supplier
   8. # = the row number of the transaction details (for when a single invoice will hit multiple account/work order combinations)
   9. Account = the GL account for a given transaction line/amount
   10. WORKORD = the GL Workorder for a given transaction line/amount
   11. Amount = the amount for a given transaction line/account/work order