Requisition Budget report 

Overview

Require a report that shows the differences between the Requisition and linked PO with regards to  the following

• Supplier Name

• Item Qty

• Item UoM

• Item Unit Price

• Item Total ex  VAT

The Report must filter by the Requisition Trans Date ( REQ  Transid = 71)
Purchase Order TransID  = 4

Fields Required

Req Status

Req Number

Req Date

Req Supplier

Req Reference 

Req Item Description

Req Item Qty

Req Item UoM

Req Item Unit Price

Req Item Total ex VAT

Req Approval Date (This will be the date it was approved by the Final Approver who is Bronwyn under FM checklist role)

Linked PO - Number

Linked PO - Supplier

Linked PO - Item Description

Linked PO - Item Qty

Linked PO - Item UoM

Linked PO - Item Unit Price

Linked PO - Item Total ex VAT

Item Var Price - (PO Unit Price - Req Unit Price)

Total variance -  (PO amount (ex vat) - Req Amount (ex vat))