Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


This Report

...

 uses the End Date

...

 you have set in Report Dates.

It will not include any Stock owned by a Reserve Customer

Image Removed

Field NameDescriptionField Limits and Notes
Refresh  
Close  

...

Image Added

This Report will show your Stock Valuation

...

 grouped by Product


Results Section:-

...

Image Added


Field Name

Description

Field Limits and Notes

Warehouse Name

The Warehouse where the Stock is Held.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Country Name

The Country of the Product.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Region Description

The Description of the Product.

This field Cannot be Changed from here.

Product Code

The Product Code.

This field

is Read Only and Cannot be Modified from here

Cannot be Changed from here.

Product Description

The Product Description.

This field Cannot be Changed from here.

Analysis Description

The Product Type Analysis.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Product Group Code

The Code of the Group the Product belongs to.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Singles Per Unit

The Number of Singles Per Case.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Physical Stock

The Amount of Stock you Physically hold up to the Report End Date.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Under Bond Value

The Value of your Underbond Stock.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Duty Paid Value

The Value of your Duty Paid Stock.

This field

is Read Only and

Cannot be

Modified

Changed from here.

En Primeur Stock

The Amount of En Primeur Stock you have.

This field

is Read Only and

Cannot be

Modified

Changed from here.

En Primeur Value

The Value of your En Primeur Stock.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Actual Stock Value

This is the sum of your Underbond Value + Duty Paid Value - En Primeur Value.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Duty

The Total of any Duty.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Shipping + Insurance

The Total of any Shipping and Insurance.

This field

is Read Only and Cannot be Modified

Cannot be Changed from here.

RH&D

The Total of any Receipt, Handling and Despatch Charges.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Rent

The Total of any Rent.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Under Bond Price Per Case

The Underbond Case Price.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Under Bond Price Per Bottle

The Underbond Bottle Price.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Duty Paid Price Per Case

The Duty Paid Case Price.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Duty Paid Price Per Bottle

The Duty Paid Bottle Price.

This field

is Read Only and

Cannot be

Modified

Changed from here.

Stock Landed

The Date the Stock was Landed .

This field

is Read Only and

Cannot be

Modified

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 records on screen that you wish to see, you can if required extract the information in an XML Image ModifiedCSV Image Modifiedor PDF Image Modifiedformat by clicking on the buttons at the bottom of the screen which will email the results. 

  • Click the Image Addedbutton to refresh the report and make sure you are looking at the latest date