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 |
