Page Comparison

This Report does not work on Report Dates, it searches the whole database.

Image Removed

This Report will show you details of all Outstanding PO's grouped By Product.

Results Section:-

Image Removed

Field Name

Description

Field Limits and NotesProduct CodeThe Code of the Product Outstanding.This field Cannot be Changed from here.Description The Description of the Product Outstanding.This field Cannot be Changed from here.AccountThe Code of the Supplier.This field Cannot be Changed from here.Account NameThe Name of the Supplier.This field Cannot be Changed from here.Purchase Order NumberThe Purchase Order (PO) Reference Number.This field Cannot be Changed from here.SupplierRefThe Supplier Reference.This field Cannot be Changed from here.Order TypeThe Type of Order.This field Cannot be Changed from here.Order DateThe Date of the Order.This field Cannot be Changed from here.Date RequiredThe Date Required.This field Cannot be Changed from here.Duty PaidIs this a Duty Paid Order?This field Cannot be Changed from here.Is Free Circulationis this Stock in Free Circulation?This field Cannot be Changed from here.Singles Per UnitThe Number of Singles in a Case.This field Cannot be Changed from here.Units OrderedThe Number of Units Ordered.This field Cannot be Changed from here.Singles OrderedThe Number of Singles Ordered.This field Cannot be Changed from here.Total Singles OrderedThe Total Quantity Ordered converted to Singles.This field Cannot be Changed from here.Buying Price Per SingleThe Buying Price Per Single.This field Cannot be Changed from here.Unit Or SingleThis field Cannot be Changed from here.Gross ValueThe Gross Value for the Order.This field Cannot be Changed from here.Trade Discount (%)The % of any Trade Discount.This field Cannot be Changed from here.Discount ValueThe Value of the Discount.This field Cannot be Changed from here.Net ValueThe Net Value of the Purchase Order.This field Cannot be Changed from here.Currency SignThe Sign for the Currency of the Purchase Order.This field Cannot be Changed from here.Currency NameThe Name of the Currency for the Order.This field Cannot be Changed from here.Exchange RateThe currency Exchange Rate.This field Cannot be Changed from here.Fixed ERIf the Exchange Rate has been Fixed.This field Cannot be Changed from here.GBP Net ValueThe Value in GBP.This field Cannot be Changed from here.

Once the results of the Report are retrieved you can filter on 1 or multiple fields to only show some records as per any search criteria you enter.

Once you have the records on screen that you wish to see, you can if required extract the information in an XML Image Removed, CSV Image Removedor PDF Image Removedformat by clicking on the buttons at the bottom of the screen which will email the results.

Click the

Image Removedbutton to refresh the report and make sure you are looking at the latest date

	This shows items on purchase orders which have been received. The report is intended as a chack for items where the invoice and original PO price has changed, or the quantity is different or for those receipted not yet posted or those invoice posted not yet receipted.
Limitations	Filtering is based on the RECEIPT Date of the stock
Grouping	No grouping
Date Restrictions	VC Reporting - Start Date / End Date
Notes	The values shown on this are from the purchase order lines and will be in the currency of the purchase order, use the exchange rate column to convert non base currency orders to the base currency.
Output	Once you have the records on screen that you wish to see, you can outouyt in the following formats EXCEL Image AddedCSV Image AddedPDF Image Added To refresh the results click the Image Addedicon

...

Explanation of fields in the report

Where the contents of a field should be obvious this is not listed on the output shown below

Field Name	Description and Notes
VATCode	See VAT Rates from within Commerce, generally S - Standard Rate Z - Zero Rates E - Exempt Transaction
Status	O - Outstanding R - Receipted I - Invoiced IR - Invoiced and Receipted C - Complete X - Cancelled
Invoice Saved	Will show YES if invoice has been posted to the finance system
Credit Saved	Will show YES by default unless Return Changed is set to YES then this will set to NO and only return to YES when the credit has been saved to the finance system
Return Changed	If you entered some returns this field will change to YES
GRNAccruals	Will be marked as Y if this record needs to show on the GRN Accrual report.

Versions Compared

Old Version 2

New Version Current

Key

Explanation of fields in the report