This Report works on Report End Dates. |
 |
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:- |
|---|
 |
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 |
|