Reports - Sales Reports - Types and Uses Summary

Reports are a useful tool to extract the information you require in spreadsheet format. This lesson will summarises the details and uses of each Sales report in its default format.

The order of this list matches the order present on Zedonk for easy reference.

System Reports

Sales

Customers

'Full Customer' Report

'Reports' > 'System Reports' > 'Sales' > 'Customers' > 'Full Customer'

Extract this report for a full summary on all customers in your system

Default Columns Present in the 'Full Customer' Report:

Ac
Customer
Account Code
Account Manager
Category
Sub Category
Priority
Account Status
Website
Main Office
Customer Bank Details
Customer Bank Ref
Shipping Terms
Payment Terms
Signature
Our Customer
Ccy
Bank Sortcode
Bank Details
Account Name
VAT Number
Terms & Conditions
Payment Due Days
Store Name
Store Full Address
Store Address 1
Store Address 2
Store Address 3
Store Town
Store State
Store Postcode
Store Country
Delivery Full Address
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State
Delivery Postcode
Delivery Country
Delivery Contact
Delivery Email
Delivery Telephone
Delivery Mobile
Delivery Fax
Accounts Full Address
Accounts Company Name
Accounts Address 1
Accounts Address 2
Accounts Address 3
Accounts Town
Accounts State
Accounts State Code
Accounts Postcode
Accounts Country
Accounts Contact
Accounts Email
Accounts Telephone
Accounts Mobile
Accounts Fax
Contact
Email
Telephone
Mobile
Fax
Shipper
Shipper Contact
Shipper Email
Shipper Telephone
Shipper Mobile
Shipper Fax
Order Description
Date Created
Date
Date Last Modified
Valid From Date
Unapproved SO Quantity
Unapproved SO Value (GBP)
Sold Order Quantity
Sold Order Value
SO Value After Discount (GBP)
Gross Profit (GBP)
Sold Profit After Discount (GBP)
Commission Value (GBP)
Commission Value After Discount (GBP)
Delivered Quantity
Delivered Value (GBP)
Closed Quantity
Closed Value (GBP)
TemplateColumn
TemplateColumn1

'Customer Email' Report

'Reports' > 'System Reports' > 'Sales' > 'Customers' > 'Customer Email'

Extract this report for a summary of all your customer's email addresses

Default Columns Present in the 'Customer Email' Report:

Category
Store Country
Customer
Account Code
Contact
Email
TemplateColumn
TemplateColumn1

'Full Customer Contact' Report

'Reports' > 'System Reports' > 'Sales' > 'Customers' > 'Full Customer Contact'

Extract this report for a full summary of your customer's contact details

Default Columns Present in the 'Full Customer Contact' Report:

Ac
Customer
Account Code
Category
Store Country
Contact Type
Description
Reference
Contact
Email
Telephone
Mobile
Name
Address 1
Address 2
Address 3
Town
State Code
State
Postcode
Country
TemplateColumn
TemplateColumn1

'Customer Gross Profit' Report

'Reports' > 'System Reports' > 'Sales' > 'Customers' > 'Customer Gross Profit'

Extract this report to analyse the profit made per customer

Default Columns Present in the 'Customer Gross Profit' Report:

Ac
Customer
Account Code
Category
Sold Order Quantity
SO Value (GBP)
SO Value After Discount (GBP)
Sold Cost (GBP)
Sold Profit After Discount (GBP)
TemplateColumn
TemplateColumn1

'Full Customer Notes' Report

'Reports' > 'System Reports' > 'Sales' > 'Customers' > 'Full Customer Notes'

Extract this report to pull all notes under your customer profiles. Note tags will help with filtering this data.

Default Columns Present in the 'Full Customer Notes' Report:

Ac
Customer Name
Account Code
Category
Priority
Territory
Store Country
Currency
Customer Note Date
Customer Note Tag
Customer Note
Attachment File Name
TemplateColumn
TemplateColumn1

Orders

'Full Order' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Full Order'

Extract this report for a detailed breakdown of all order details.

Default Columns Present in the 'Full Order' Report:

Season
Ac
IS
Order Number
Our Ref
Account Code
Category
Complete
Cancelled
Customer
Customer Tag
Account Manager
Territory
Account Status
Customer Trade Discount %
Customer Discount %
Customer Reference
Customer Currency
Customer Country
Contact
Email
Telephone
Mobile
Fax
Invoice To Full Address
Invoice To Contact
Invoice To Telephone
Delivery Name
Delivery Start
Delivery End
Shipping Terms
Payment Terms
Payment Due Days
Exchange Rate
Order Date
Order Total (GBP)
Order Total
FX Rate
Value (GBP)
Value
Value After Discount (GBP)
Value After Discount
VAT Value (GBP)
VAT Value
Total Value (GBP)
Total Value
Total Value After Discount (GBP)
Total Value After Discount
Total Profit (GBP)
Total Profit
Total Profit After Discount (GBP)
Total Profit After Discount
Landed Quantity
Landed Value (GBP)
Landed Value
Landed Value After Discount (GBP)
Landed Value After Discount
Last Buy/Memo Payment Received
Last Buy/Memo Payment Date
Last Proforma Discount (%)
Last Proforma Discount (GBP)
Last Proforma Payment Required (%)
Last Proforma Payment Required (GBP)
Allocated Quantity
Allocated Value
Allocated Value After Discount
Allocated Value (GBP)
Allocated Value After Discount (GBP)
Picked Quantity
Picked Value
Picked Value After Discount
Picked Value (GBP)
Picked Value After Discount (GBP)
Despatch Quantity
Despatch Value
Despatch Value After Discount
Despatch Value (GBP)
Despatch Value After Discount (GBP)
Unshipped Quantity
Unshipped Value
Unshipped Value After Discount
Unshipped Value (GBP)
Unshipped Value After Discount (GBP)
SHIPPED %
SHIPPED Value
SHIPPED Value After Discount
SHIPPED Value (GBP)
SHIPPED Value After Discount (GBP)
PT+DN Quantity
PT+DN Value
PT+DN Value (GBP)
PT+DN VAT
PT+DN VAT (GBP)
PT+DN Total
PT+DN Total (GBP)
Invoice Discount %
Invoice Discount Value
Invoice Discount Value (GBP)
Revised Exchange
Revised Order
Revised Value
Revised VAT Type
Revised VAT
Revised Total
Revised Total (GBP)
Invoiced Quantity
Invoiced Value
Invoiced Value After Discount
Invoiced Value (GBP)
Invoiced Value After Discount (GBP)
Credit Note Total
Credit Note VAT
Credit Note Total (GBP)
Credit Note VAT (GBP)
TemplateColumn
TemplateColumn1

'Order Value by Customer Country' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Order Value by Customer Country'

Extract this report to view the value of your orders grouped by country.

Default Columns Present in the 'Order Value by Customer Country' Report:

*(report is grouped by country)*

Ac
Season
Customer
Customer Category
Customer Trade Discount %
Town
Order Reference
Order Owner
Payment Terms
Sales Order Quantity
Value
Total Cost (GBP)
Order Discount Value (GBP)
Value After Discount (GBP)
Total Profit (GBP)
Total Profit After Discount (GBP)
Delivery Start
Delivery Cancel
Approved
TemplateColumn
TemplateColumn1

'Order Gross Profit' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Order Gross Profit'

Extract this report to view the gross profit amount per order

Default Columns Present in the 'Order Gross Profit' Report:

Season
Ac
Order Type
Order Number
Customer
Account Code
Order Reference
Customer Category
Customer Trade Discount %
Order Date
Customer Country
Sales Order Quantity
Value (GBP)
Order Discount Value (GBP)
Value After Discount (GBP)
Total Cost (GBP)
Total Profit (GBP)
Total Profit After Discount (GBP)
Approved
TemplateColumn
TemplateColumn1

'Full Order Product' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Full Order Product'

Extract this report for a detailed summary on sales order quantities and a summary on all sub documentation per order. (Proformas, Invoices, Delivery Notes, Credit Notes, and Returns Authorisations)

Default Columns Present in the 'Full Order Product' Report:

Season
Customer
Customer Category
Customer Territory
Order Reference
Customer Country
Account Manager
Store Number
Order Type
Order Number
Order Date
Order Tag
Customer Reference
Delivery Start
Delivery Cancel
Ac
Approved
Closed
Product ID
Product Category 1
Product Category 2
Product Category 3
Product Category 4
Product Category 5
Style
Fabric
Description
Colour
Manufacturer
Unit Cost (GBP)
Unit Order Value
Ccy
Order Discount %
Sales Order Quantity
Order Value After Discount
Order Cost Price (GBP)
Order Value After Discount (GBP)
Order Gross Profit (GBP)
Invoice Quantity
Invoice Value After Discount
Invoice Cost Price (GBP)
Invoice Value After Discount (GBP)
Invoice Gross Profit (GBP)
Balance To Invoice Quantity
Balance Value After Discount
Balance Cost Price (GBP)
Balance Value After Discount (GBP)
Balance Gross Profit (GBP)
CN Quantity
CN Value After Discount
CN Cost Price (GBP)
CN Value After Discount (GBP)
CN Gross Profit (GBP)
TemplateColumn
TemplateColumn1

'Full Quantity Sold By Style' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Full Quantity Sold By Style'

Extract this report to analyse your product sales order quantities with the report grouped by style.

Default Columns Present in the 'Full Quantity Sold By Style' Report:

Season
Customer
Customer Category
Customer Territory
Customer Country
Order Date
Order Type
Order Number
Order Tag
Customer Reference
Order Reference
Delivery Start
Delivery Cancel
Product Category 1
Product Category 2
Product Category 3
Product Category 4
Product Category 5
Withdrawn
Fabric
Colour
Description
Image Path
Image
WSP Markup
Unit Cost (GBP)
WSP (GBP)
RRP (GBP)
Discount Value (GBP)
Sales Order Quantity
Value (GBP)
Value After Discount (GBP)
Docket
Manufacturer
Line Delivery From
Line Delivery To
TemplateColumn
TemplateColumn1

'Full Product Sold By Country' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Full Product Sold By Country'

Extract this report to view the sales order quantity of your products grouped by country

Default Columns Present in the 'Full Product Sold By Country' Report:

Product ID
Style
Fabric
Colour
Description
WSP Markup
Unit Cost (GBP)
Suggested WSP (GBP)
WSP (GBP)
Gross Profit Margin
Unit Gross Profit (GBP)
Sales Order Quantity
Total Cost (GBP)
Wtg Avg Price (GBP)
Total SO Value (GBP)
Total SO Value After Discount (GBP)
Total Gross Sold Profit After Discount (GBP)
Clients Sold To
TemplateColumn
TemplateColumn1

'Full Order Product Size' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Full Order Product Size'

Extract this report to view the sales order quantities of your products per size with product details.

Default Columns Present in the 'Full Order Product Size' Report:

Season
AC
Order Type
Order Number
Order Date
Approved
Closed
Complete
Order Owner
Order Priority
Order Tag
Customer
Store Number
Account Code
Account Manager
Customer Category
Customer Territory
Customer Reference
Order Reference
Customer Country
Country Code
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State Code
Delivery State
Delivery Postcode
Delivery Country
Delivery Country Code
Delivery Telephone
Delivery Email
Accounts Company Name
Accounts Address 1
Accounts Address 2
Accounts Address 3
Accounts Town
Accounts State Code
Accounts State
Accounts Post Code
Accounts Country
Accounts Country Code
Delivery Period
Delivery Start
Delivery Cancel
Shipper
Shipping Terms
Payment Terms
Payment Due Days
Withdrawn
Product ID
Product Category 1
Product Category 2
Product Category 3
Product Category 4
Product Category 5
Style
Fabric
Colour
Description
Size
Barcode
Size Category
Textile Content
MID
Country of Origin
HTS Code
Intrastat Code
Weight (KG)
Manufacturing Type
WSP Markup
Unit Cost GBP
Order Product ID
Line Comment
WSP GBP
Ccy Symbol
Ccy
Unit Order Value
RRP
Sales Order Quantity
Value
Commission Value
Order Discount %
Value After Discount
VAT Rate
Total Value
FX Rate
Value (GBP)
Value After Discount (GBP)
Total Value (GBP)
Closed Quantity
Ready To Ship
Possible To Ship
Allocated Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
Invoiced Quantity
Balance To Ship
RA Quantity
RA Returned Quantity
Credit Note Quantity
Consignment Quantity
Docket
Is Open
Line Book Out
Line Book In
Line Closed
Line Pending
Manufacturer
Manufacturer Address
Labels
Opening Stock
Stock Adjust
Required Stock
Ordered Stock
In Transit Quantity
Received Stock
Allocated Stock
Picked Stock
Unshipped Stock
Shipped Stock
PT+DN Stock
Closing Stock
Projected Stock
Available Stock
Work in Progress
Expected Stock
Closed Quantity
Stock Alert Quantity
Stock Alert - Closing Stock
Stock Alert - Projected Stock
Date Last Modified
Modified By
TemplateColumn
TemplateColumn1

'Full Order Product Size (Barcode Image)' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Full Order Product Size (Barcode Image)'

Extract this report to see your full order details per product per size.

Default Columns Present in the 'Full Order Product Size (Barcode Image)' Report:

Season
Ac
Order Type
Order Number
Order Date
Approved
Closed
Complete
Order Owner
Order Priority
Order Tag
Customer
Store Number
Account Code
Account Manager
Customer Category
Customer Territory
Customer Reference
Order Reference
Customer Country
Country Code
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State Code
Delivery State
Delivery Postcode
Delivery Country
Delivery Country Code
Delivery Telephone
Delivery Email
Accounts Company Name
Accounts Address 1
Accounts Address 2
Accounts Address 3
Accounts Town
Accounts State Code
Accounts State
Accounts Postcode
Accounts Country
Accounts Country Code
Delivery Period
Delivery Start
Delivery Cancel
Shipper
Shipping Terms
Payment Terms
Payment Due Days
Withdrawn
Product ID
Product Category 1
Product Category 2
Product Category 3
Product Category 4
Product Category 5
Style
Fabric
Colour
Description
Size
Barcode
Barcode Image Path
Barcode Image
Size Category
Textile Content
MID
HTS Code
Intrastat Code
Manufacturing Type
WSP Markup
Unit Cost GBP
Order Product ID
Line Comment
WSP GBP
Ccy Symbol
Ccy
Unit Order Value
RRP
Sales Order Quantity
Value
Commission Value
Discount %
VAT Rate
Total Value
FX Rate
Value (GBP)
Total Value (GBP)
Closed Sales Quantity
Ready To Ship
Possible To Ship
Allocated Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
Balance to Ship
Docket
Line Book Out
Line Book In
Line Closed
Line Pending
Manufacturer
Manufacturer Address
Line Delivery From
Line Delivery To
Opening Stock
Stock Adjust
Required Stock
Ordered Stock
In Transit Quantity
Received Stock
Allocated Stock
Picked Stock
Unshipped Stock
Shipped Stock
PT+DN Stock
Closing Stock
Projected Stock
Available Stock
Work In Progress
Expected Stock
Closed Quantity
Stock Alert Quantity
Stock Alert - Closing Stock
Stock Alert - Projected Stock
TemplateColumn
TemplateColumn1

'Order Product Size' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Order Product Size'

Extract this report for a summary of your sales order quantities per product per size.

Default Columns Present in the 'Order Product Size' Report:

Season
Ac
Order Type
Order Number
Order Date
Approved
Customer
Customer Category
Customer Reference
Order Reference
Customer Country
Delivery Period
Delivery Start
Delivery Cancel
Payment Terms
Withdrawn
Style
Fabric
Colour
Description
Size
Line Comment
Textile Content
HTS Code
WSP Markup
Manufacturer
Sales Order Quantity
Ccy Symbol
Ccy
Unit Order Value
Value (GBP)
RRP
TemplateColumn
TemplateColumn1

'Order Product Size Values' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Order Product Size Values'

Extract this report to view product sales order values per size

Default Columns Present in the 'Order Product Size Values' Report:

Season
Ac
Order Type
Order Number
Order Date
Approved
Customer
Customer Category
Customer Country
Customer Reference
Order Reference
Delivery Period
Delivery Start
Delivery Cancel
Payment Terms
Product Category 1
Product Category 2
Product Category 3
Product Category 4
Product Category 5
Withdrawn
Style
Fabric
Colour
Description
Size
Size Category
HTS Code
Textile Content
WSP Markup
Line Comment
Manufacturer
RRP
Sales Order Quantity
Ccy Symbol
Ccy
Unit Order Value
Value
Total Value
Value (GBP)
Total Value (GBP)
TemplateColumn
TemplateColumn1

'Order Product Size SOR/Consignment' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Order Product Size SOR/Consignment'

Extract this report to analyse your consignment units per product /per size. We recommend you utilise the Order Tag feature of your settings so that you can filter by order tag. e.g. ' Consignment'

Default Columns Present in the 'Order Product Size SOR/Consignment' Report:

Season
Ac
Order Number
Customer
Customer Category
Customer Territory
Customer Country
Order Tag
Order Reference
Customer Reference
Payment Terms
Style
Fabric
Colour
Description
Size
Barcode
Sales Order Quantity
Ccy
Ccy Symbol
Unit Order Value
Closed Quantity
PT+DN Quantity
Invoiced Quantity
RA Quantity
RA Returned Quantity
Consignment Quantity
Unit Cost GBP
TemplateColumn
TemplateColumn1

'Full Order Product Size Figures' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Full Order Product Size Figures'

Extract this report to view the value of your units per product/per size. This report takes discounts and commissions into account.

Default Columns Present in the 'Full Order Product Size Figures' Report:

Ac
CS
Season
Order Type
Order Number
Order Date
Approved
Locked
Locked Date
Order Owner
Order Txt
Customer
Account Code
Customer Category
Customer Country
Store Full Address
Delivery Full Address
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State Code
Delivery State
Delivery Postcode
Delivery Country
Accounts Full Address
Contact
Delivery Period
Shipper
Shipping Terms
Customer VAT Number
Payment Terms
Bank
Comments
Product ID
Size
Itemcode
Ccy Symbol
Ccy
Price
Sales Order Quantity
Value
FX Rate
Value (GBP)
Duty Ccy Sym
Duty Ccy
VAT Rate
Total Sales Order Quantity
Value Of Goods
Value Of Goods (GBP)
Discount Percentage
Discount Value
Discount Value (GBP)
Value of Goods After Discount
Value of Goods After Discount (GBP)
Total Cost (GBP)
Total Profit (GBP)
Commission Percentage
Commission Value
TemplateColumn
TemplateColumn1

'Order Detail' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Order Detail'

Extract this report for a summary of your sales orders and their value

Default Columns Present in the 'Order Detail' Report:

Season
Ac
Order Type
Order Number
Order Date
Approved
Customer
Customer Country
Withdrawn
Product ID
Size
Unit Order Value
Sales Order Quantity
Value
Total Value
Value (GBP)
Total Value (GBP)
TemplateColumn
TemplateColumn1

'Quantity Sold by Style Size' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Quantity Sold by Style Size'

Extract this report to view your units sold per size, grouped by style.

Default Columns Present in the 'Quantity Sold by Style Size' Report:

Season
Ac
Order Type
Order Number
Order Date
Approved
Customer
Customer Category
Order Reference
Customer Country
Delivery Town
Withdrawn
Product ID
Description
Size
RRP
Ccy Symbol
Sales Order Quantity
Value (GBP)
Total Value (GBP)
Closing Stock
Expected Stock
Projected Stock
Available Stock
TemplateColumn
TemplateColumn1

'Production Required by Order Product Size' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Production Required by Order Product Size'

Extract this report to view what production units would be required based on existing stock. *only available to inventory users* - most useful if you have many carryover styles.

Default Columns Present in the 'Production Required by Order Product Size' Report:

Season
Ac
Order Type
Order Number
Order Date
Approved
Customer
Customer Country
Delivery Start
Delivery Cancel
Manufacturing Type
Withdrawn
Size
Sales Order Quantity
Opening Stock
Stock Adjust
Required Stock
Ordered Stock
Projected Stock
TemplateColumn
TemplateColumn1

'Order Docket' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Order Docket'

Extract this report to review a summary of your production orders and their linked sales order quantities

Default Columns Present in the 'Order Docket' Report:

Season
Ac
Order Type
Order Number
Order Date
Approved
Customer
Customer Category
Customer Country
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery Postcode
Delivery Country
Delivery Start
Delivery Cancel
Withdrawn
Order Product ID
Style
Fabric
Colour
Size
Barcode
Sales Order Quantity
Docket
Manufacturer
Line Delivery Start
Line Delivery Finish
TemplateColumn
TemplateColumn1

'Full Order Product Materials' Report

'Reports' > 'System Reports' > 'Sales' > 'Orders' > 'Full Order Product Materials'

Extract this report to view a summary of your raw materials required for production based on the SO quantity

Default Columns Present in the 'Full Order Product Materials' Report:

Approved
Order Type
Order Number
Order Tag
Order Reference
Customer
Order Priority
Manufacturer
Product ID
Size
Sales Order Quantity
Supplier
RM ID
Our Ref
RM Colour
Comments
Ccy
Cost
Cost (GBP)
UOM
Rating
Total Rating
TemplateColumn
TemplateColumn1

Shipping

'Shipping Progress' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'Shipping Progress'

Extract this report for a summary of your products' shipping progress percentage

Default Columns Present in the 'Shipping Progress' Report:

Season
Ac
Order Number
Approved
Order Priority
Order Tag
Customer
Order Type
Customer Country
Customer Territory
Sales Order Quantity
Value
Allocated Quantity
Allocated %
Allocated Value
Picked Quantity
Picked %
Picked Value
Unshipped Quantity
Unshipped %
Unshipped Value
Shipped Quantity
Shipped %
Shipped Value
PT+DN Quantity
PT+DN %
PT+DN Value
Invoice Quantity
Invoiced %
Invoiced Goods Value
Discount Value
Transport Charge
Invoiced Sub Total
TemplateColumn
TemplateColumn1

'Open Sales Orders' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'Open Sales Orders'

Extract this report to view a summary of your open sales orders and view the outstanding quantities

Default Columns Present in the 'Open Sales Orders' Report:

Season
Ac
Order Number
Order Date
Approved
Closed
Complete
Customer
Order Type
Account Code
Customer Country
Delivery Period
Delivery Start
Delivery Cancel
Allocated Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
Sales Order Quantity
TemplateColumn
TemplateColumn1

'Order Delivery Status' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'Order Delivery Status'

Extract this report for a summary of your sales order's delivery status'.

Default Columns Present in the 'Order Delivery Status' Report:

Ac
Season
Approved
Order Number
Order Date
Closed
Order Priority
Order Tag
Customer
Order Type
Customer Category
Customer Country
Order Reference
Delivery Period
Delivery Start
Delivery Cancel
Withdrawn
Style
Fabric
Colour
Size
Unit Order Value
Sales Order Quantity
Ready To Ship
Allocated Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
TemplateColumn
TemplateColumn1

'Ready To Ship' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'Ready To Ship'

Extract this report to view a summary of orders ready to ship based on your picks.

Default Columns Present in the 'Ready To Ship' Report:

Season
Ac
Order Number
Order Date
Approved
Order Priority
Order Tag
Customer
Order Type
Account Code
Customer Country
Order Reference
Customer Category
Delivery Period
Delivery Start
Delivery Cancel
Style
Fabric
Colour
Description
Size
Barcode
Textile Content
Sales Order Quantity
Possible To Ship
Ready To Ship
Allocated Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
Docket
Manufacturer
Manufacturer Address
Closing Stock
Projected Stock
Work In Progress
Closed Quantity
TemplateColumn
TemplateColumn1

'Ready To Ship 2' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'Ready To Ship 2'

Extract this report for a detailed summary of orders ready to ship based on your picks, including values.

Default Columns Present in the 'Ready To Ship 2' Report:

Season
Ac
Order Number
Order Date
Approved
Closed
Order Owner
Order Entity
Order Txt
Customer
Order Type
Store Number
Account Code
Customer Category
Customer Reference
Order Reference
Customer Country
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State
Delivery Postcode
Delivery Country
Delivery Period
Delivery Start
Delivery Cancel
Payment Terms
Product ID
Style
Fabric
Colour
Description
Size
Barcode
Size Category
Textile Content
MIP
HTS Code
Internal Fabric
Manufacturing Type
Unit Cost GBP
Order Product ID
Line Comment
WSP Markup
Ccy
Ccy Symbol
Unit Order Value
RRP
Sales Order Quantity
Value
Discount Value
VAT Rate
Total Value
FX Rate
Value (GBP)
Total Value (GBP)
Closed Quantity
Ready To Ship
Committed In Ship
Allocated Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
Balance In Ship
Docket
Manufacturer
Line Dock In
Line Dock Out
Opening Stock
Stock Adjust
Required Stock
Ordered Stock
Received Stock
Issued Stock
Closing Stock
Projected Stock
Work In Progress
Available Stock
Expected Stock
TemplateColumn
TemplateColumn1

'Balance To Ship' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'Balance To Ship'

Extract this report to view a summary of the balance of orders to ship based on your picks.

Default Columns Present in the 'Balance To Ship' Report:

Season
Ac
Approved
Closed
Order Priority
Order Tag
Customer
Order Type
Customer Reference
Order Reference
Delivery Period
Delivery Start
Delivery Cancel
Withdrawn
Style
Fabric
Colour
Description
Size
Unit Order Value
Sales Order Quantity
Allocated Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
Balance to Ship
Closing Stock
Work In Progress
Projected Stock
Available Stock
TemplateColumn
TemplateColumn1

'Balance To Ship 2' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'Balance To Ship 2'

Extract this report to view a summary of the balance of orders to ship based on your picks.

Default Columns Present in the 'Balance To Ship 2' Report:

Season
Ac
Order Number
Approved
Closed
Order Priority
Order Tag
Customer
Order Type
Customer Category
Customer Country
Withdrawn
Product ID
Style
Fabric
Colour
Description
Size
Unit Cost GBP
WSP GBP
Sales Order Quantity
Allocated Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
Balance to Ship
TemplateColumn
TemplateColumn1

'To Dispatch' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'To Dispatch'

Extract this report for a summary of your units outstanding dispatch, based on your pick ticket and dispatch note quantities.

Default Columns Present in the 'To Dispatch' Report:

CS
Season
Ac
Order Type
Order Number
Approved
Customer
Customer Category
Order Reference
Delivery Period
Withdrawn
Order Product ID
Line Comment
Sales Order Quantity
Picked Quantity
Unshipped Quantity
Shipped Quantity
PT+DN Quantity
Balance To Ship
Possible To Ship
Closing Stock
TemplateColumn
TemplateColumn1

'Pick List' Report

'Reports' > 'System Reports' > 'Sales' > 'Shipping' > 'Pick List'

Extract this report for a list of your pick tickets.

Default Columns Present in the 'Pick List' Report:

Season
Ac
Order Number
Approved
Payment Terms
Order Reference
Account Code
Customer
Order Type
Accounts Address 1
Accounts Address 2
Accounts Address 3
Accounts Town
Accounts State Code
Accounts State
Accounts Postcode
Accounts Country
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State Code
Delivery State
Delivery Postcode
Delivery Country
Delivery Telephone
Delivery Email
Delivery Period
Shipper
Delivery Start
Delivery Cancel
Style
Fabric
Colour
Description
Size
Barcode
WSP GBP
Ccy Symbol
Sales Order Quantity
Total Value
Total Value (GBP)
TemplateColumn
TemplateColumn1

Order Tracker

'Full Proforma' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full Proforma'

Extract this report for a full summary of your proformas.

Default Columns Present in the 'Full Proforma' Report:

Ac
CS
Season
Document Type
Proforma Number
Proforma Date
Document Month
Order Priority
Order Tag
Customer
Account Code
Account Manager
Customer Category
Customer Territory
Payment Terms
Comments
Proforma by Qty
Proforma Qty
Order Ccy
Ccy Symbol
Proforma Value
Proforma Value (GBP)
Payment Due Date
Paid
Paid Date
SO Number
Sales Order Quantity
Value
Value After Discount
VAT
Total Value
TemplateColumn
TemplateColumn1

'Full DN Product Size' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full DN Product Size'

Extract this report for a detailed summary of your delivery note quantities per products per size.

Default Columns Present in the 'Full DN Product Size' Report:

Ac
DN Number
DN Date
Shipped
Dispatch Date
Order Number
Order Ccy
Ccy Symbol
Approved
Order Owner
Order Priority
Order Tag
Customer
Store Number
Account Code
Account Manager
Customer Category
Customer Country
Order Reference
Customer Reference
Delivery Full Address
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State Code
Delivery State
Delivery Postcode
Delivery Country
Delivery Period
Delivery Start
Delivery Cancel
Gross Weight
Number of Cartons
Dimensions
Shipping Terms
Shipper
Tracking Number
Manufacturing Type
Product ID
Style
Fabric
Colour
Description
Size
Size Category
Customs Type
HTS Code
MID
Textile Content
Order Product ID
PT/DN Quantity
Invoiced Quantity
RA Quantity
RA Returned Quantity
Credited Quantity
Balance To Invoice
TemplateColumn
TemplateColumn1

'DN Product Size' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'DN Product Size'

Extract this report for a summary of your delivery note quantities per product per size.

Default Columns Present in the 'DN Product Size' Report:

Ac
DN Number
DN Date
Order Number
Approved
Customer
Account Code
Customer Country
Style
Fabric
Colour
Size
PT/DN Quantity
TemplateColumn
TemplateColumn1

'Full DN Product Size Figures' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full DN Product Size Figures'

Extract this report for a full summary of your delivery note quantities per product per size including values.

Default Columns Present in the 'Full DN Product Size Figures' Report:

Ac
CS
Season
DN Number
DN Date
Locked
Locked Date
Shipped
Dispatch Date
Order Number
Order Date
Approved
Order Owner
Order Priority
Order Tag
Order Reference
Customer Reference
Customer
Account Code
Customer Category
Customer Country
Customer Full Address
Delivery Full Address
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State Code
Delivery State
Delivery Postcode
Delivery Country
Delivery Contact
Delivery Contact Email
Delivery Telephone
Accounts Full Address
Terms
Delivery Period
Shipper
Shipping Terms
Gross Weight
Number of Cartons
Dimensions
Order Ccy
Ccy Symbol
Duty Ccy
Duty Ccy Sym
Payment Terms
Customer VAT Number
VAT Rate
Bank
Comments
Product ID
Size
PT/DN Quantity
PT/DN Value (GBP)
TemplateColumn
TemplateColumn1

'Full DN Product size Manufacturer' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full DN Product size Manufacturer'

Extract this report for a full summary of your delivery note quantities per product per size including manufacturer details.

Default Columns Present in the 'Full DN Product size Manufacturer' Report:

Ac
DN Number
DN Date
Locked
Shipped
Dispatch Date
Order Number
Approved
Order Owner
Order Priority
Order Tag
Customer
Account Code
Customer Category
Customer Reference
Order Reference
Customer Country
Delivery Full Address
Order Ccy
Ccy
Product ID
Style
Fabric
Colour
Description
Size
Size Category
Customs Type
Textile Content
MID
HTS Code
Manufacturing Type
Manufacturer
Manufacturer Full Address
Order Product ID
PT/DN Quantity
Invoiced Quantity
Credit Note Quantity
Balance To Invoice
TemplateColumn
TemplateColumn1

'Full Invoice/Credit' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full Invoice/Credit'

Extract this report for a detailed summary of your invoices and credit notes.

Default Columns Present in the 'Full Invoice/Credit' Report:

Season
Ac
Document Type
Document Number
Document Date
Document Month
Locked
Credit Note Tag
Credit Note Date
Invoice Date
DN Number
Shipper
Dispatch Date
Order Number
Order Owner
Order Priority
Order Tag
Customer
Account Code
Account Manager
Customer Category
Customer Territory
Customer Reference
Order Reference
Customer Country
Customer Full Address
Delivery Full Address
Accounts Full Address
Contact
Delivery Period
Shipper
Shipping Terms
Tracking Number
Gross Weight (KG)
Num Of Cartons
Dimensions
Payment Terms
Customer VAT Number
Bank
Comments
IN/CN Quantity
Ccy
Duty Ccy
FX Rate
Goods Value
Goods Value (GBP)
Discount %
Discount Value
Discount Value (GBP)
Goods Value After Discount
Goods Value After Discount (GBP)
Transport Charge
Transport Charge (GBP)
Sub Total
Sub Total (GBP)
VAT Rate
VAT
VAT (GBP)
Total Value
Total Value (GBP)
Total Profit After Discount (GBP)
Payment Due Date
Paid
Paid Date
Commission %
Commission Value
Commission Value After Discount
TemplateColumn
TemplateColumn1

'Invoice/Credit' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Invoice/Credit'

Extract this report for a summary of your invoices and credit notes

Default Columns Present in 'Invoice/Credit' Report:

Season
Ac
Document Type
Document Number
Document Date
Document Month
Locked
Credit Note Tag
Credit Note Date
Invoice Date
DN Number
Shipped
Order Number
Customer
Account Code
Customer VAT Number
Ccy
Sub Total
VAT
Total Value
Paid
Paid Date
Payment Due Date
TemplateColumn
TemplateColumn1

'Full IN/CN Product' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full IN/CN Product'

Extract this report for a full summary of products on invoices and credit notes and their details.

Default Columns Present in the 'Full IN/CN Product' Report:

Season
Ac
IN/CN Number
IN/CN Date
Locked
Credit Note Tag
Dispatch Date
Order Number
Order Owner
Order Entity
Order Priority
Order Tag
Customer
Store Number
Account Code
Customer Country
Delivery Country Code
In EU
Delivery Country
Delivery In EU
Customer Reference
Order Reference
Shipping Terms
Product Category 1
Product Category 2
Product Category 3
Product Category 4
Product Category 5
Product ID
Style
Fabric
Colour
Description
Size
Size Category
Customs Type
Textile Content
Mill
Country of Origin
HTS Code
Intrastat Code
Unit Weight (KG)
Manufacturing Type
WSP Markup
WSP
RRP
IN/CN Quantity
Total Net Weight (KG)
Unit Price
Ccy
Ccy Symbol
FX Rate
Goods Value
Goods Value (GBP)
Discount %
Discount Value
Discount Value (GBP)
Goods Value After Discount
Goods Value After Discount (GBP)
VAT Rate
VAT
VAT (GBP)
Total Value
Total Value (GBP)
Paid
Paid Date
Unit Cost (GBP)
Gross Profit After Discount (GBP)
Commission %
Commission Value
Date Last Modified
Notes & Txt
TemplateColumn
TemplateColumn1

'Full IN/CN Product Size' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full IN/CN Product Size'

Extract this report for a full summary of products on invoices and credit notes and their details.

Default Columns Present in the 'Full IN/CN Product Size' Report:

Season
Ac
IN/CN Number
IN/CN Date
Locked
Credit Note Tag
Order Number
Order Month
Order Owner
Order Tag
Customer
Store Number
Account Code
Customer Country
Country Code
In EU
Customer Reference
Order Reference
Product ID
Style
Fabric
Colour
Description
Size Category
Size
Textile Content
MID
Country of Origin
Customs Type
HTS Code
Intrastat Code
Unit Weight (KG)
WSP Markup
IN/CN Quantity
Total Net Weight (KG)
Unit Price
Ccy
Ccy Symbol
Goods Value
Discount %
Goods Value After Discount
VAT Rate
Total Value
Paid
Commission Value
Date Last Modified
Modified By
TemplateColumn
TemplateColumn1

'Full IN Product Size Figures' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full IN Product Size Figures'

Extract this report for a full summary of your invoice product per size including cost figures

Default Columns Present in the 'Full IN Product Size Figures' Report:

Ac
CS
Invoice Number
Invoice Date
Locked
Locked Date
Delivery Note Number
Delivery Note Date
Shipped
Dispatch Date
Tracking Number
Order Number
Order Date
Order Tag
Account Code
Customer Category
Customer Reference
Order Reference
Customer Country
Customer Full Address
Delivery Full Address
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State Code
Delivery State
Delivery Postcode
Delivery Country
Accounts Full Address
Accounts Company Name
Accounts Address 1
Accounts Address 2
Accounts Address 3
Accounts Town
Accounts State Code
Accounts State
Accounts Postcode
Accounts Country
Delivery Period
Shipper
Shipping Terms
Payment Terms
Customer VAT Number
Bank
Comments
Product ID
Fabric
Colour
Description
Size
Size Category
Unit Price
Ccy
Ccy Symbol
FX Rate
Goods Value
Goods Value (GBP)
Duty Ccy
Duty Ccy Sym
Sales Order Quantity
Total Goods Value
Total Goods Value (GBP)
Discount Percentage
Discount Value
Discount Value (GBP)
Total Goods Value After Discount
Total Goods Value After Discount (GBP)
Transport Charge
Transport Charge (GBP)
Sub Total
Sub Total (GBP)
Total VAT
Total VAT (GBP)
Total Value
Total Value (GBP)
Total Cost (GBP)
Total Profit (GBP)
Paid
Paid Date
Commission Percentage
Commission Value
TemplateColumn
TemplateColumn1

'Full CN Product Size Figures' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full CN Product Size Figures'

Extract this report for a full summary of your products per size and their cost figures

Default Columns Present in the 'Full CN Product Size Figures' Report:

Ac
CS
Season
Credit Note Number
Credit Note Date
Credit Note Tag
Locked
Locked Date
RA Date
RA Number
Invoice Number
Invoice Date
Delivery Note Number
Delivery Note Date
Shipped
Dispatch Date
Order Number
Order Date
Order Owner
Order Tag
Customer
Account Code
Customer Category
Customer Reference
Order Reference
Customer Country
Customer Full Address
Delivery Full Address
Delivery Company Name
Delivery Address 1
Delivery Address 2
Delivery Address 3
Delivery Town
Delivery State Code
Delivery State
Delivery Postcode
Delivery Country
Accounts Full Address
Accounts Company Name
Accounts Address 1
Accounts Address 2
Accounts Address 3
Accounts Town
Accounts State Code
Accounts State
Accounts Postcode
Accounts Country
Contact
Delivery Period
Shipper
Shipping Terms
Payment Terms
Customer VAT Number
Bank
Comments
Product ID
Size
Credit Note Quantity
Unit Price
Ccy
Ccy Symbol
FX Rate
Goods Value
Goods Value (GBP)
Duty Ccy
Duty Ccy Sym
Sales Order Quantity
Total Goods Value
Total Goods Value (GBP)
Discount Percentage
Discount Value
Discount Value (GBP)
Total Goods Value After Discount
Total Goods Value After Discount (GBP)
Transport Charge
Transport Charge (GBP)
Sub Total
Sub Total (GBP)
Total VAT
Total VAT (GBP)
Total Value
Total Value (GBP)
Total Cost (GBP)
Total Profit (GBP)
TemplateColumn
TemplateColumn1

'Full RA Product Size' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full RA Product Size'

Extract this report for a summary of your return authorisation products per size.

Default Columns Present in the 'Full RA Product Size' Report:

Ac
CS
Season
RA Number
RA Date
RA Tag
Locked
Closed
Order Number
Order Priority
Customer
Store Number
Account Code
Account Manager
Customer Category
Customer Country
Order Reference
Customer Reference
Comments
Shipper
Shipping Terms
Tracking Number
Product ID
Style
Fabric
Colour
Description
Size
Textile Content
MID
Country of Origin
HTS Code
Ccy
Ccy Symbol
Price
Line Comments
RA Quantity
Goods Value
Goods Value (GBP)
Returned Quantity
Back To Stock Quantity
Credited Quantity
TemplateColumn
TemplateColumn1

'Commission Value' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Commission Value'

Extract this report for a summary of commission values of your order owners

Default Columns Present in the 'Commission Value' Report:

Season
Ac
Document Type
Document Number
Credit Note Date
Invoice Date
Order Owner
Customer
Account Code
Customer Category
Comments
IN/CN Quantity
Ccy
Goods Value
Discount %
Goods Value After Discount
Paid
Commission %
Commission Value
Commission Value After Discount
TemplateColumn
TemplateColumn1

'Intrastat' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Intrastat'

Extract this report for a summary of your customs data and intrastat orders/shipments (within/between the EU only)

Default Columns Present in the 'Intrastat' Report:

Season
Ac
Intrastat Code
Goods Value (GBP)
Discount %
Discount Value (GBP)
Goods Value After Discount (GBP)
Shipping Terms
Total Net Weight (KG)
IN/CN Quantity
Delivery Country Code
Order Month
IN/CN Date
IN/CN Number
Product ID
Description
TemplateColumn
TemplateColumn1

'Full Order Notes' Report

'Reports' > 'System Reports' > 'Sales' > 'Order Tracker' > 'Full Order Notes'

Extract this report for a summary of all product notes. Your product note tags can be used to filter this report

Default Columns Present in the 'Full Order Notes' Report:

Season
Ac
SO-Number
Customer Name
Store Country
Order Tag
Order Priority
Order Reference
Customer Reference
Order Currency
Payment Terms
Sales Order Note Date
Sales Order Note Tag
Sales Order Note
Attachment File Name
Client

Reports can have columns hidden/moved, and filtered before extracting from Zedonk if needed.

You are also able to save custom reports. These reports can then be scheduled if required.

To add records from other seasons/ to view all records throughout your system, please reference the following Zedonkopedia chapter:

Reports - Include Multiple Seasons

Previous Article Reports - Products Reports - Types and Uses Summary

Next Article Reports - Production Reports - Types and Uses Summary

Zedonkopedia

Reports - Sales Reports - Types and Uses Summary

System Reports

Sales

Message

Reports

Other Resources