Versions Compared

Key

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


...

This Report

...

 uses the Start Date

...

 as set in

...

 Report Dates.

...

This Report

...

 provides information on

...

the Detailed Margin

...

 for each Invoice

...

 within Vision Commerce.

...

The Transaction Date

...

 in these Reports is the Invoice or Movement Date -

...

the Date

...

 the Transaction

...

 actually occurs.

...

Image Added



Field Name

Description

Field Limits and Notes

Refresh

  



Close

  




Results Section:-

...

Image Added



Field Name

Description

Field Limits and Notes

Trans Date

The Date of the Transaction.

This field

is Read Only and

Cannot be

Modified Read Only and

Changed from here.

Inv No

The Invoice Number.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Order No

The Order Reference.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Rep Name

The Name of the Sales Rep.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Account No

The Code for the Account.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Account Name

The Name of the Account.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Location

The Location of the Stock.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Product Code

The Code for the Product.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Product Description

The Description of the above Product.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Cases

The Quantity of Cases.

This field

is

Cannot be

Modified Read Only and

Changed from here.

@x Litres

The Quantity of Litres.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Sales Value

The Value of the Sales.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Cost Value

The Cost Value.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Duty

The Duty Cost.

This field

is

Cannot be

Modified Read Only and

Changed from here.

CCT

The CCT Cost.

This field

is

Cannot be

Modified Read Only and

Changed from here.

RH&D

The RH&D Cost.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Rent

The Rent Cost.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Shipping

The Shipping Cost.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Total Cost

The Total Cost.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Margin

The Margin.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Delivery Cost

The Delivery Cost.

This field

is

Cannot be

Modified Read Only and

Changed from here.

Net Margin

The Net Margin.

This field

is

Cannot be

Modified Read Only and

Changed from here.

GP%

The GP % Percentage.

This field

is

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 the records on screen that you wish to see, you can if required extract the information in

...

an XMLImage Modified, CSVImage Modified

...

or PDF Image Modified

...

 format by clicking on the buttons at the bottom of the screen which will email the results.