603 GRN Accruals

This Report works on Report End Dates.

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.

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.