Versions Compared

Old Version 5

changes.mady.by.user Kirk Jewell

Saved on

compared with

New Version Current

changes.mady.by.user Sarah Stalley

Saved on

Key

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


This Report works on Report Start Date
Once the results of the Report are

This Report shows you an overview of your overall Sales in Vision Commerce. 

  • Only Invoices posted through to Sage will be included.

    • Zero value Invoices in Vision Commerce will be excluded.

  • This Report works on Report Start Date to the present Date only.

    • A date too far in the past will produce too much data and the report will not be able to generate.

Image Removed

This Report shows you an overview of your overall Sales in Vision Commerce. 

Only Invoices which are posted through to Sage will be included, and therefore zero value Invoices in Vision Commerce will be excluded.

Field NameDescriptionField Limits and NotesRefresh  Close  

Results Section:-

Image Removed

Field NameDescriptionField Limits and NotesTrans DateThe Transaction Date of the Order.This field Cannot be Changed from here.Doc NoThe Document Reference of the Order.This field Cannot be Changed from here.Order NoThe Order Reference of the Order.This field Cannot be Changed from here.Type of SaleThe Type of Sales Order.This field Cannot be Changed from here.Customer County CodeThe County Code for the Customer.This field Cannot be Changed from here.Customer CountryThe Country for the Customer.This field Cannot be Changed from here.Cust Analysis Code 1The 1st Customer Analysis Code.This field Cannot be Changed from here.Customer Analysis Name 1The Name of the Analysis Code above.This field Cannot be Changed from here.Cust Analysis Code 2The 2nd Customer Analysis Code.This field Cannot be Changed from here.Customer Analysis Name 2The Name of the Analysis Code above.This field Cannot be Changed from here.Cust Analysis Code 3The 3rd Customer Analysis Code.This field Cannot be Changed from here.Customer Analysis Name 3The Name of the Analysis Code above.This field Cannot be Changed from here.Cust Analysis Code 4The 4th Customer Analysis Code.This field Cannot be Changed from here.Customer Analysis Name 4The Name of the Analysis Code above.This field Cannot be Changed from here.Cust Analysis Code 5The 5th Customer Analysis Code.This field Cannot be Changed from here.Customer Analysis Name 5The Name of the Analysis Code above.This field Cannot be Changed from here.Cust Analysis Code 6The 6th Customer Analysis Code.This field Cannot be Changed from here.Customer Analysis Name 6The Name of the Analysis Code above.This field Cannot be Changed from here.Cust Analysis Code 7The 7th Customer Analysis Code.This field Cannot be Changed from here.Customer Analysis Name 7The Name of the Analysis Code above.This field Cannot be Changed from here.Group AccountThe Group Account Code.This field Cannot be Changed from here.Group NameThe Name of the Group.This field Cannot be Changed from here.Account NoThe Code for the Customer.This field Cannot be Changed from here.Account NameThe Name of the Customer.This field Cannot be Changed from here.SupplierThe Code of the Supplier.This field Cannot be Changed from here.Supplier NameThe Name of the above Supplier.This field Cannot be Changed from here.ProducerThe Code of the Producer.This field Cannot be Changed from here.Producer NameThe Name of the above Producer.This field Cannot be Changed from here.Country CodeThe Product Country Code.This field Cannot be Changed from here.Country of OriginThe Country Name.This field Cannot be Changed from here.Region CodeThe Code for the Product Region.This field Cannot be Changed from here.Region NameThe Name for the above Region.This field Cannot be Changed from here.EP CampaignThe Campaign if this is an En Primeur (EP) Order.This field Cannot be Changed from here.Is Duty PaidIf this is a Duty Paid Order.This field Cannot be Changed from here.Prod TypeThe Type of the Product.This field Cannot be Changed from here.Prod Type Description The Description of the Product Type.This field Cannot be Changed from here.Product GroupThe Group for the Product.This field Cannot be Changed from here.Prod Grp DescriptionThe Description of the Product Group.This field Cannot be Changed from here.Prod Analysis Code 1The 1st Product Analysis Code.This field Cannot be Changed from here.Prod Analysis Name 1The Name of the above Analysis Code.This field Cannot be Changed from here.Prod Analysis Code 2The 2nd Product Analysis Code.This field Cannot be Changed from here.Prod Analysis Name 2The Name of the above Analysis Code.This field Cannot be Changed from here.Prod Analysis Code 3The 3rd Product Analysis Code.This field Cannot be Changed from here.Prod Analysis Name 3The Name of the above Analysis Code.This field Cannot be Changed from here.PromotionThe Promotion for this Order if there was one.This field Cannot be Changed from here.LocationThe Location of the Stock.This field Cannot be Changed from here.Product CodeThe Code for the Product.This field Cannot be Changed from here.Product DescriptionThe Description of the above Product.This field Cannot be Changed from here.VintageThe Vintage of the above Product.This field Cannot be Changed from here.SinglesThe Number of Singles on the Order.This field Cannot be Changed from here.Actual CasesThe Number of Actual Cases on the Order.This field Cannot be Changed from here.CasesThe Number of Cases on the Order.This field Cannot be Changed from here.@xlitresThe Litreage Total on the Order.This field Cannot be Changed from here.Sales ValueThe Value of the Order.This field Cannot be Changed from here.Cost ValueThe Cost Value of the Order.This field Cannot be Changed from here.DutyThe Duty Cost for the Order.This field Cannot be Changed from here.CCTThe CCT Cost for the Order.This field Cannot be Changed from here.Rent The Cost of the Rent.This field Cannot be Changed from here.RH&DThe RH&D Costs.This field Cannot be Changed from here.ShippingThe Freight and Insurance Costs.This field Cannot be Changed from here.DeliveryAny Delivery Costs.This field Cannot be Changed from here.Rep GroupThe Sales Rep Group.This field Cannot be Changed from here.DivisionThe Division.This field Cannot be Changed from here.Outlet CodeThe Code for the Outlet.This field Cannot be Changed from here.Outlet NameThe Name for the above Outlet.This field Cannot be Changed from here.Outlet GroupThe Group Code for the Outlet.This field Cannot be Changed from here.Total CostThe Total of all Costs.This field Cannot be Changed from here.MarginThe Margin on this Order.This field Cannot be Changed from here.GP%The GP Percentage %.This field Cannot be Changed from here.


Image Added

  • 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. 

Buttons at the bottom of the screen:

  • Once you have records on screen that you wish to see, you can if required extract the information in

an 

  • a .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.

 This field is Read Only and Cannot be Modified from here

...