Versions Compared

Key

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


This Report

...

 does not work

...

on Report Dates, it searches the whole database. 

...

Image Added

This Report

...

 will show you details of Customers that have Customer Price Lists set up and the Price List

...

 is still live.

...

Field NameDescriptionField Limits and NotesRefresh  Close

  



Results Section:-

...

Image Added



Field Name

Description

Field Limits and Notes

Account

The Account Reference of the Customer that has a Customer Price List set up.

Read only field

This field Cannot be Changed from here.

Account Name

The Name of the Customer.

Read only field

This field Cannot be Changed from here.

Sales Person

The Sales Rep for the Customer.

Read only field

This field Cannot be Changed from here.

Country

The Country set against the Product.

Read only field

This field Cannot be Changed from here.

Region

The Region set against the Product.

Read only field

This field Cannot be Changed from here.

ProductCode

The Product Code for the Product.

Read only field

This field Cannot be Changed from here.

ProductDescription

The Description for the Product.

Read only field

This field Cannot be Changed from here.

Vintage

The Year of the Product.

Read only field

This field Cannot be Changed from here.

Producer Name

The Name of the Wine Producer.

Read only field

This field Cannot be Changed from here.

Case Size

The Case Size the Product is set up as.

Read only field

This field Cannot be Changed from here.

Price List

The Price List the Product is set up on.

Read only field

This field Cannot be Changed from here.

Qualifying Qty

The minimum Quantity for the Price List.

Read only field

This field Cannot be Changed from here.

DP Case Price

The Duty Paid Price of a Case as set up on the Price List.

This field Cannot be Changed from here.

DP Bottle Price

The Duty Paid Price of a Bottle as set up on the Price List.

This field Cannot be Changed from here.

UB Case Price

The Under Bond Price of a Case as set up on the Price List.

Read only field

This field Cannot be Changed from here.

UB Bottle Price

The

Price

Under Bond Price of a Bottle as set up on the Price List.

Read only field

This field Cannot be Changed from here.

Expires

The Date and Time the Price Lists Ends.

Read only field

This field Cannot be Changed from here.

Last Product Receipt

The Date you Most Recently Landed this Stock.

Read only field

This field Cannot be Changed from here.

Last Movement

The Date of the Most Recent Movement of this Stock

Read only field

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 Image Modified, CSV 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