Reports are a useful tool to extract the information you require in spreadsheet format. This lesson will summarises the details and uses of each Materials report in its default format.
The order of this list matches the order present on Zedonk for easy reference.
System Reports
Materials
'Reports' > 'System Reports' > 'Materials' > 'Materials' > 'Full Supplier'
Extract this report for a full summary of your supplier records.
- Ac
- Supplier
- Category
- Currency
- Payment Terms
- Shipper
- Shipping Terms
- Website
- External Reference
- Comments
- Full Address
- Address 1
- Address 2
- Address 3
- Town
- State
- Postcode
- Country
- Contact 1
- Email 1
- Telephone 1
- Mobile
- Fax
- Contact 2
- Email 2
- Telephone 2
- Agent
- Agent Address 1
- Agent Address 2
- Agent Address 3
- Agent Town
- Agent State
- Agent Postcode
- Agent Country
- Agent Contact
- Agent Email
- Agent Telephone
- Agent Mobile
- Agent Fax
- Accounts Name
- Accounts Address 1
- Accounts Address 2
- Accounts Address 3
- Accounts Town
- Accounts State
- Accounts Postcode
- Accounts Country
- Accounts Contact
- Accounts Email
- Accounts Telephone
- Accounts Mobile
- Accounts Fax
- Bank
- Date Created
- Created By
- Date Last Modified
- Modified By
- PO Quantity
- Value (GBP)
- VAT (GBP)
- Total Value (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Materials' > 'Full Raw Materials'
Extract this report for a detailed summary of your raw materials present in your system and their ordered units/ required units for production
- Ac
- IS
- Material Category
- RM ID
- Our Ref
- Colour
- UIM
- Ccy Symbol
- Ccy
- Cost
- FX Rate
- Rate Date
- Cost (GBP)
- Memo Card
- Inventory Item
- Sales Required
- Production Required
- Combined Required
- PO Quantity
- PO Cost (GBP)
- Composition
- Care Instructions
- Width Size
- Type for Product Costings
- External Reference
- Intrastat
- Supplier Category
- Supplier Name
- Supplier Full Address
- Supplier Country
- Supplier Contact 1
- Supplier Telephone 1
- Supplier Email 1
- Payment Terms
- Shipper
- Shipping Terms
- Agent
- Agent Telephone
- Agent Email
- Date Created
- Created By
- Date Last Modified
- Modified By
- Image Path
- Image
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Materials' > 'Raw Materials'
Extract this report for a summary of your raw materials present in your system.
- Ac
- IS
- Material Category
- RM ID
- Our Ref
- Colour
- UM
- Ccy Symbol
- Ccy
- Cost
- FX Rate
- Rate Date
- Cost (GBP)
- Memo Card
- Composition
- Care Instructions
- Width Size
- Supplier Category
- Supplier Name
- Date Created
- Created By
- Date Last Modified
- Modified By
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Materials' > 'Full Raw Material Notes'
Extract this report for a summary of your raw material notes. Raw Material note tags created in your settings will assist with filtering the note type.
- Ac
- IS
- Raw Material ID
- Our Reference
- Material Category
- Supplier
- Raw Material Note Date
- Raw Material Note Tag
- Raw Material Note
- Attachment File Name
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Materials' > 'Full Raw Materials by Manufacturer'
Extract this report to view a summary of your raw material requirements per manufacturer.
- Season
- Ac
- IS
- Manufacturer
- Supplier Category
- Supplier
- Supplier Country
- Material Category
- RM ID
- Our Ref
- Composition
- Memo Card
- Colour
- Ccy
- Cost
- FX Rate
- Cost (GBP)
- UM
- Sold Required
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Purchase Order' > 'Full PO'
Extract this report for a full summary of all purchase orders within your selected season/s.
- Ac
- CS
- Season
- PO Number
- PO Reference
- Date
- Confirmed
- Confirmed Date
- Locked
- Closed
- Complete
- Supplier
- Supplier Category
- Supplier Country
- Supplier Full Address
- Ship To
- Shipper
- Shipping Terms
- Payment Terms
- Apply Tax
- Delivery From
- Delivery To
- PO Comments
- Total PO Quantity
- Total Cost
- FX Rate
- Total Cost (GBP)
- Total Received Quantity
- Total Pending Quantity
- Book In Status
- Date Created
- Created By
- Date Last Modified
- Modified By
- Material Category
- RM ID
- Supplier Colour Ref
- Our Ref
- Colour
- UM
- PO Quantity
- Memo Card
- Ccy Symbol
- PO Ccy
- Actual Unit Cost
- Received Quantity
- Closed Quantity
- Pending Quantity
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Purchase Order' > 'Full PO Material'
Extract this report for a summary of the raw materials present on your purchase orders, and the quantities and values of the ordered amount
- Ac
- CS
- Season
- PO Number
- PO Reference
- Date
- Confirmed
- Confirmed Date
- Locked
- Closed
- Complete
- Supplier
- Supplier Category
- Supplier Country
- Supplier Full Address
- Ship To
- Shipper
- Shipping Terms
- Payment Terms
- Apply Tax
- Delivery From
- Delivery To
- PO Comments
- Total PO Quantity
- Total Cost
- FX Rate
- Total Cost (GBP)
- Total Received Quantity
- Total Pending Quantity
- Book In Status
- Date Created
- Created By
- Date Last Modified
- Modified By
- Material Category
- RM ID
- Our Ref
- Colour
- UM
- PO Quantity
- Memo Card
- Ccy Symbol
- PO Ccy
- Actual Unit Cost
- Line Complete
- Received Quantity
- Closed Quantity
- Pending Quantity
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Purchase Order' > 'Full PO Book Out Material'
Extract this report for a summary of your booked out raw materials and the supplier details. This will be similar to the 'Full PO Raw Material' report as Booking out is the equivalent of raising a purchase order.
- Ac
- CS
- Season
- PO Number
- PO Reference
- Date
- Confirmed
- Confirmed Date
- Locked
- Closed
- Complete
- Supplier
- Supplier Category
- Supplier Country
- Supplier External Reference
- Supplier Full Address
- Ship To
- Shipper
- Shipping Terms
- Payment Terms
- Apply Tax
- Total PO Quantity
- Total Cost
- Total Cost (GBP)
- Delivery From
- Delivery To
- PO Comments
- Material Category
- RM External Reference
- RM ID
- Supplier Colour Ref
- Our Ref
- Colour
- UM
- PO Quantity
- Ccy Symbol
- PO Ccy
- Unit Cost
- Unit Actual Cost
- FX Rate
- Unit Actual Cost (GBP)
- Actual Cost (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Purchase Order' > 'Full PO Book In Material'
Extract this report to view a summary of your booking in raw materials. This will only be available to those with the inventory module enabled.
- Ac
- CS
- Season
- PO Number
- PO Reference
- Date
- Confirmed
- Confirmed Date
- Closed
- Complete
- Supplier
- Supplier Category
- Supplier Country
- Supplier External Reference
- Supplier Full Address
- Ship To
- Shipper
- Shipping Terms
- Payment Terms
- Apply Tax
- Delivery From
- Delivery To
- PO Comments
- Book In Number
- Type
- Book In Date
- Book In Ref
- Created By
- Material Category
- Raw Material External Reference
- RM ID
- Supplier Colour Ref
- Our Ref
- Colour
- UM
- Book In Quantity
- Ccy Symbol
- PO Ccy
- Unit Actual Cost
- FX Rate
- Unit Actual Cost (GBP)
- Line Comments
- Book In Status
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Purchase Order' > 'Full Purchase Order Notes'
Extract this report for a summary of your purchase order notes. Purchase order note tags will assist in filtering your note types if required.
- Season
- Ac
- PO Number
- PO Date
- PO Reference
- Supplier
- Ship To
- PO Note Date
- PO Note Tag
- PO Note
- Attachment File Name
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Full Raw Material Inventory'
Extract this report for a full summary of your raw material inventory
- Season
- Ac
- IS
- ZM
- Material Category
- RM ID
- Our Ref
- Colour
- UM
- Ccy Symbol
- Ccy
- Cost
- FX Rate
- Cost (GBP)
- Memo Card
- Inventory Item
- Width Size
- Composition
- Care Instructions
- Date Created
- Created By
- Date Last Modified
- Modified By
- Supplier Category
- Supplier Name
- Supplier Full Address
- Supplier Country
- Supplier Contact 1
- Supplier Telephone 1
- Supplier Email 1
- Payment Terms
- Shipper
- Agent
- Agent Telephone
- Agent Email
- Opening
- Opening Cost (GBP)
- Adjustments
- Sold Required
- Production Required
- Combined Required
- Purchase Order
- Received
- Received Cost (GBP)
- Dispatched Out
- Transferred In
- Closing
- Closing Cost (GBP)
- Projected
- MFR Stock
- Stock Alert
- Stock Alert (Closing)
- Stock Alert (Projected)
- Moved To Another Season
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Raw Material Inventory'
Extract this report for a summarised report of your raw material inventory.
- Season
- Ac
- IS
- ZM
- Material Category
- RM ID
- Our Ref
- Colour
- UM
- Supplier Category
- Supplier Name
- Ccy Symbol
- Ccy
- Cost
- FX Rate
- Cost (GBP)
- Opening
- Opening Cost (GBP)
- Adjustments
- Sold Required
- Production Required
- Combined Required
- Purchase Order
- Received
- Received Cost (GBP)
- Dispatched Out
- Transferred In
- Closing
- Closing Cost (GBP)
- Projected
- MFR Stock
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Raw Material Inventory (ZM)'
Extract this report to view your raw material inventory. As the 'ZM' (Zero Movement) column is ticked - the report will exclude items with no movement in the report. If unticked it will include all RM.
- Season
- Ac
- IS
- ZM
- Material Category
- RM ID
- Our Ref
- Colour
- UM
- Supplier Category
- Supplier Name
- Ccy Symbol
- Ccy
- Cost
- FX Rate
- Cost (GBP)
- Opening
- Opening Cost (GBP)
- Adjustments
- Sold Required
- Production Required
- Combined Required
- Purchase Order
- Received
- Received Cost (GBP)
- Dispatched Out
- Transferred In
- Closing
- Closing Cost (GBP)
- Projected
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Full Material Adjustments'
Extract this report for a summary of your Raw Material adjustments.
- Season
- Ac
- IS
- Date Created
- Created By
- Date Modified
- Modified By
- Our Ref
- RM ID
- Colour
- UM
- Adjustment
- Adjustment Description
- Method
- Unit Cost (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Full Material Moved To Another Season Log'
Extract this report for a summary of your Raw Material movements out of your current/chosen season/s.
- Season
- Our Ref
- RM ID
- Colour
- UM
- User Date
- Username
- Log Description
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Full Material Opening Log'
Extract this report for a summary of your Material opening log.
- Season
- Our Ref
- RM ID
- Colour
- UM
- User Date
- Username
- Log Description
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Purchasing Required by Supplier'
Extract this report for a summary of the raw materials you need to order. This is based on your Product SO Qty's (and raw material stock and manufacturer material stock)
This report will be grouped by Supplier
- Season
- Ac
- Material Category
- Our Ref
- RM ID
- Colour
- UM
- Sold Required
- Production Required
- Combined Required
- Purchase Order
- Received
- Dispatched Out
- Transferred In
- Closing
- Projected
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Full Manufacturer Raw Materials'
Extract this report for a summary of all raw materials required for products by manufacturer
- Season
- Ac
- IS
- Manufacturer
- Supplier
- Supplier Country
- Supplier Category
- Material Category
- RM ID
- Our Ref
- Composition
- Memo Card
- Colour
- Ccy
- Cost
- Exchange Rate
- Cost (GBP)
- UM
- Opening
- Adjustments
- Production Required
- Transferred In
- Dispatched Out
- Production Received
- Unallocated
- Pending Transfer In
- Pending PO to MFR
- Image Path
- Image
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Manufacturer Raw Materials'
Extract this report for a summary of your manufacturers raw material stock
- Season
- Ac
- IS
- Manufacturer
- Supplier
- Material Category
- Our Ref
- RM ID
- Colour
- Cost (GBP)
- UM
- Opening
- Adjustments
- Production Required
- Transferred In
- Dispatched Out
- Unallocated
- Pending PO In
- Pending PO to MFR
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Full Manufacturer Material Adjustments'
Extract this report for a summary of your manufacturer's raw material adjustments.
- Season
- Ac
- IS
- Manufacturer
- Date Created
- Created By
- Date Modified
- Modified By
- Our Ref
- RM ID
- Colour
- UM
- Adjustment
- Adjustment Description
- Method
- Unit Cost (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Full Manufacturer Material Moved To Another Season Log'
Extract this report for a summary of Manufacturer Raw Materials moved to another season
- Season
- Manufacturer
- Our Ref
- RM ID
- Colour
- UM
- User Date
- Username
- Log Description
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Materials' > 'Inventory' > 'Full Manufacturer Material Opening Log'
Extract this report for a summary of the opening stock log of your raw materials by manufacturer
- Season
- Manufacturer
- Our Ref
- RM ID
- Colour
- UM
- User Date
- Username
- Log Description
- TemplateColumn
- TemplateColumn1
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: