603 GRN Accruals

This Report works on Report End Dates.

Field Name	Description	Field Limits and Notes

Field Name	Description	Field Limits and Notes
Refresh
Close

This Report will show you details of all Stock which have Landed and Receipted but there is no Invoice for the goods.

It will show goods where we are waiting for any part of the full or part Invoice.

To show on the Report the Order Line need to be Status O, I, IR or R.

Where the Status is C or IR then the Date Receipted must be less than the Report End Date.

It will show goods where there is no Invoice Date, the Receipt Date is prior to the Report End Date and the Units or Singles Received is greater than zero.

You will not see any Consignment Orders.

You will not see any goods where the Order header is Status Cancelled.

Results Section:-

Results Section:-

Field Name	Description	Field Limits and Notes

Field Name	Description	Field Limits and Notes
Campaign	The Campaign if this is an En Primeur (EP) Order.	This field Cannot be Changed from here.
Order Type Code	The Code for the Order Type.	This field Cannot be Changed from here.
Purchase Order Type	The Type of the Order.	This field Cannot be Changed from here.
Account	The Code for the Customer.	This field Cannot be Changed from here.
Name	The Name of the Customer.	This field Cannot be Changed from here.
Product Code	The Code for the Product.	This field Cannot be Changed from here.
Product Description	The Description of the above Product.	This field Cannot be Changed from here.
Date Arrived	The Date the Goods were Landed.	This field Cannot be Changed from here.
Quantity Order	The Quantity of goods Ordered in Singles.	This field Cannot be Changed from here.
Buying Price	The Buying Price of the goods.	This field Cannot be Changed from here.
Trade Discount	The Percentage % of any Trade Discount Received.	This field Cannot be Changed from here.
Exchange Rate	The Exchange Rate from GBP.	This field Cannot be Changed from here.
Order Value	The Value of the Order.	This field Cannot be Changed from here.
Quantity Delivered	The Quantity of goods delivered in Singles.	This field Cannot be Changed from here.
Delivered Value	The Value of the goods delivered.	This field Cannot be Changed from here.
Quantity Invoiced	The Quantity of goods Invoiced.	This field Cannot be Changed from here.
Invoiced Value	The Value of the goods Invoiced.	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 , CSV or PDF format by clicking on the buttons at the bottom of the screen which will email the results.