RAW MATERIALS
Table of Contents Raw Materials ............................................................................................................................................ 3 About Raw Materials..................................................................................................................... 4 Raw Materials - The List View Explained .................................................................................... 5 Raw Materials - Add a new raw material.................................................................................... 8 Raw Materials - Add Variant/Colour .........................................................................................12 Raw Materials - Copy Variant/Colour........................................................................................15 Raw Materials - Bulk Edit all Variant/Colours or a selection of Variant/Colours .................18 Raw Materials - All my Variants/Colours - Show Invisible and Show Inactive......................21 How to copy a Raw Material with all its Variants/Colours......................................................24 Update exchange rate - Single Raw Material / Variant ...........................................................26 Update exchange rate - Multiple Raw Materials / Variants....................................................28 Update costs by a percentage - Multiple Raw Materials / Variants ......................................31 Print Options - with or without colour breakdown .................................................................34 Raw Materials - Image List .........................................................................................................37 Raw Materials - Do I need to raise any purchase orders ?.....................................................40 I have started a new season, where are all my old raw materials? ......................................45 When I carry forward a raw material the price shown is zero and the Memo Card is not showing! ....................................................................................................................................... 48 The cost fields and memo card of a Raw Material are pink...................................................53 Raw Materials - 2 or 3 decimal places ......................................................................................55 Can I find out which products costings are using a particular raw material? .....................56 Bulk Upload Raw Materials Images ..........................................................................................57 Where can I find a breakdown of raw material quantity required by product? .................62
Raw Materials
Raw Materials
Page 3
About Raw Materials The Raw Materials section is used to manage your materials and their details. Raw Materials can have different costs, different exchange rates and different memo cards, in different seasons.
The Raw Material breakdown of a product is used for two purposes: To manage the production and to help analyse the cost (and hence the price) of the product. For production management: The materials will have to be obtained or purchased (Purchase Orders). A stock of the materials may need to be managed (Raw Material Stock Inventory). The correct quantity of the correct materials must be provided to the manufacturer (Dispatch Notes). For product costing pricing: Each raw material used to make the product will contribute to the cost. The sum of the costs of all the raw materials and the manufacturing will be marked up to arrive at the price of the product.
Raw Materials
Page 4
Raw Materials - The List View Explained You may add, edit or copy a material. Filter your raw materials list by raw material ID, reference, fabric, category, supplier, colour even using partial words.
The screen shows all your materials, active and visible in this season.
Select COLOUR BREAKDOWN if you want to see each variant/ colour, and wait for the page to reload.
Raw Materials
Page 5
If you use MULTI CURRENCY, the purchasing currency cost will show in brakets next to the converted home currency cost.
If you have brought this forward from another season, the exchange rate will be the one from the previous season - you should consider if you want to change this , read more
A red YES in the 'Awaiting PO' field means you have a requirement to purchase this material. Click on the yes to check the quantity needed.
From this screen you can ADD NEW RAW MATERIAL
Raw Materials
Page 6
SELECT AN ACTION from the dropdown menu
Print, Copy or Edit a Raw Material
The "Copy" button only shows if Colour Breakdown is not selected and it is used to copy a raw material with all its variants/colours.
Raw Materials
Page 7
Raw Materials - Add a new raw material How to add a new Raw Material
From the HOME SCREEN, Click on RAW MATERIALS
Enter the RAW MATERIAL ID - (What the supplier calls it)
Enter your internal ID - (What you call it)
click VALIDATE - Zedonk checks that this material does not already exist
Complete the fields with the material Master Details
Raw Materials
Page 8
Select the supplier from the drop down menu and the category and currency will prefill
Enter the other details
N.B. If it is a fabric, TICK to allow fabric quantities to appear in PRODUCTION ANALYSIS Fabrics reports
You can click SAVE before going down to Variant Details
Replace "NO COLOUR" with your first colour variant name and/ or code
N.B. Enter your colour name first then the supplier reference
Raw Materials
Page 9
Enter the cost. The exchange rate pulls though from settings. This can be overridden if required. Cost and exchange rate are independent in each season.
If you want to revert to the exchange rate in settings, click UPDATE RATE and it will change back.
Add info to the Memo Card. This is independent in each season, therefore you can use it for general or seasonal information.
Active and Visible in the current season
Upload an Image for the Raw Material - IMAGE > CHOOSE FILE > select file > SAVE
PLEASE ENSURE YOUR UPLOAD IMAGES ARE ""RGB JPEG"" UP TO 100K AND MAX 900 X 600 @ MAX 300 DPI.
Raw Materials
Page 10
Now you can ADD VARIANT to add a new colour option from scratch or COPY VARIANT to add a new color option with same costs, currency, exchange rate and memo card
For more info about ADD VARIANT click here For more info about COPY VARIANT click here
Save and Close on top-right to return to list view.
Raw Materials
Page 11
Raw Materials - Add Variant/Colour You can easily add new colour options to your existing raw material
From Raw Materials list view click on the Raw Material ID
Click on ADD VARIANT
Existing colour options are shown the left hand side.
Raw Materials
Page 12
Enter the required details for the new Variant/Colour and click SAVE
N.B. Enter your colour name first then the supplier reference.
The new Colour is now showing in your list of Variants
Raw Materials
Page 13
if you want to add an image: IMAGE > Choose File > Select File > Save
(PLEASE NOTE: SWITCHING BETWEEN VARIANTS AUTOSAVES THE DETAILS INPUTTED)
Raw Materials
Page 14
Raw Materials - Copy Variant/Colour You can easily add a new colour options to your existing raw material, copying it from an existing one.
From Raw Materials list view click on the Raw Material ID
Select the Variant/Colour you want to copy from
Click on COPY VARIANT
Raw Materials
Page 15
Enter the name of the NEW COLOUR in the pop up window and click OK
N.B. Enter your colour name first then the supplier reference.
The new Colour is now showing in your list of Variants, with the same cost, rate and memo card.
Raw Materials
Page 16
if you want to add an image: IMAGE > Choose File > Select File > Save
(PLEASE NOTE: SWITCHING BETWEEN VARIANTS AUTOSAVES THE DETAILS INPUTTED)
Raw Materials
Page 17
Raw Materials - Bulk Edit all Variant/Colours or a selection of Variant/Colours You can change the price, currency, rate, memo card or image on multiple variants/colours at once.
From Raw Materials list view click on the Raw Material ID
Click on BULK EDIT
Raw Materials
Page 18
ONLY ENTER DETAILS IN THE FIELDS YOU WANT UPDATED
In this example there is a price increase....
if you want to update all visible variants/colours click UPDATE ALL VARIANTS or...
...select only the variants/colours you want to update and click UPDATE SELECTED VARIANTS
Raw Materials
Page 19
This action will change the price for Black 01 and White 08 only.
The updated details are now showing for those variants/colours
Raw Materials
Page 20
Raw Materials - All my Variants/Colours - Show Invisible and Show Inactive On the Raw Material page you can show all the Variants/Colours ever created, including the ones not visible in this season and the ones previously made inactive.
From Raw Materials list view click on the Raw Material ID
Variant Details section - Select SHOW INVISIBLE to include all variants/colours from all seasons..
Raw Materials
Page 21
..and SHOW INACTIVE to include variants/colours previously inactivated.
Orange and Bold - Variant/Colour currently selected Pink - Variant/Colour invisible in this season Line Through - Variant/Colour inactive
Select the Variant and flag the check boxes accordingly to make it active and visible in this season > SAVE
Raw Materials
Page 22
Set your seasons up correctly to ensure prices come through, for more information read this
Add or Amend details on the Variant/Colour card > SAVE
(PLEASE NOTE: SWITCHING BETWEEN VARIANTS AUTOSAVES THE DETAILS INPUTTED)
Raw Materials
Page 23
How to copy a Raw Material with all its Variants/ Colours You can copy a raw material and all its Variants/Colours
Raw Materials List View with Colour Breakdown NOT selected search for the raw material you want to copy > click COPY
You are presented with a dialogue. If you want to continue, press OK.
EDIT the RAW MATERIAL ID and the OUR REF and click VALIDATE
Raw Materials
Page 24
You are now presented with the rest of the Raw Material Card
All the Master Details have been copied over as well as all the variants and the variants details.
When you have finished editing > Save and Close.
Raw Materials
Page 25
Update exchange rate - Single Raw Material / Variant You can update the exchange rate on an individual raw material e.g. you have brought forward a raw material from a previous season and there is a different exchange rate in the new season. Any exchange rate updates are seasonal and will not carry through to other seasons where this raw materials is visible.
SEARCH for the RAW MATERIAL and click on it
On the RAW MATERIAL card, each Variant/Colour has its own Exchange Rate
Raw Materials
Page 26
1. This is the currency you previously selected for this RAW MATERIAL 2. This is the existing rate 3. This is the date the rate was set either in SETTINGS or manually changed in this record
To UPDATE RATE click on button
The new rate will pull through from EXCHANGE RATE for that season that you created in SETTINGS - to find out more about this, click here
The EXCHANGE RATE and converted cost are now updated.
SAVE and CLOSE You can use BULK EDIT to update multiple variants/colours at once click here for more info
Raw Materials
Page 27
Update exchange rate - Multiple Raw Materials / Variants You can apply an updated exchange rate to multiple raw materials / variants in the list view.
From the Raw Materials List View, Select An Action, UPDATE EXCHANGE RATE
Select the Currency that you wish to update and press SEARCH
You will be presented with a list of Raw Materials in that currency.
Raw Materials
Page 28
You can display each variant/colour > Select COLOUR BREAKDOWN
...or grouped by raw material > Deselect COLOUR BREAKDOWN
Raw Materials
Page 29
Select the raw materials that you wish to update (or click SELECT ALL)
Enter the NEW EXCHANGE RATE and press UPDATE
The new rate will be applied
Updated prices will appear in relevant Product Costings . N.B You might check that your WHOLESALE PRICE is still acceptable
Raw Materials
Page 30
Update costs by a percentage - Multiple Raw Materials / Variants It is possible to apply a percentage price increase to all the raw materials / variants in a list view.
From the Raw Materials List View, Select An Action, UPDATE COST
Select the Supplier and press SEARCH
You will be presented with a list of Raw Materials from that Supplier You can display each variant/colour > Select COLOUR BREAKDOWN
Raw Materials
Page 31
...or grouped by raw material > Deselect COLOUR BREAKDOWN
Select the raw materials that you wish to update (or click SELECT ALL)
Enter the percentage and press UPDATE
Raw Materials
Page 32
The new cost of the raw materials will be recorded
Updated prices will appear in relevant Product Costings in this season N.B You might check that your WHOLESALE PRICE is still acceptable
Raw Materials
Page 33
Print Options - with or without colour breakdown You can print your Raw Materials Records
From the HOME PAGE go to RAW MATERIALS
You can SELECT the RAW MATERIAL you want to print and click on PRINT SINGLE
Raw Materials
Page 34
You can now print all RAW MATERIAL information with all the colour variants, prices, memo details and images.
If you want to print just one colour options ....click on COLOUR BREAKDOWN
You will now see all the colour variants listed
Raw Materials
Page 35
Select the colour you want to print and click on PRNT SINGLE
You can now print the single RAW MATERIAL with price, memo card info and image
Raw Materials
Page 36
Raw Materials - Image List Display and Print a list of Raw Materials with images
in your RAW MATERIAL section > SELECT AN ACTION > IMAGE LIST
Now displayed is a list of all your visible raw materials in each variant/colour and their images
Raw Materials
Page 37
Filter/Search if required and select the items you wish to print or click SELECT ALL
You can now print them with or without showing the costs
SELECT AN ACTION > PRINT SELECTED or SELECT AN ACTION > PRINT SELECTED (NO VALUES)
Raw Materials
Page 38
A PDF file is now generated with your selected materials
This version show prices - you can generate report without prices.
Raw Materials
Page 39
Raw Materials - Do I need to raise any purchase orders ? Standard Package - How will I know how many raw materials to order to cover my production ? Inventory Users - you can use this method or go to Raw Materials Inventory
If there is a requirement to raise a purchase orders, then YES will be displayed in the column AWAITING PO ..with Colour Breakdown
..or without
Preview the raw materials requirement by clicking on the red YES
Raw Materials
Page 40
To create the PO: Select one or more raw materials > SELECT AN ACTION > Raise Purchase Order
Are you sure, yes, click OK
Chose if the delivery is to MANUFACTURER or to LOCAL (yourself or your warehouse)
click CREATE
Raw Materials
Page 41
A Purchase Order template will open
The Quantities displayed in RED are what you require.
Inventory Users - Please check your Unallocated Stock at Manufactuers before you order - read this for more information
Raw Materials
Page 42
Enter what the actual ORDER QUANTITY > Amend the ACTUAL COST if needed > select APPLY VAT if needed > SAVE AND CLOSE
The final pdf purchase order will only show those raw materials that you gave a quantity for. Any zero quantity materials will not show.
Print or Print with Images
Raw Materials
Page 43
PRINT
PRINT+IMAGES
Raw Materials
Page 44
I have started a new season, where are all my old raw materials? When you first log into a new season raw material file there are NO raw materials visible - you need to ' set season/raw materials' N.B. You must ensure that you have selected the season whose prices you wish to reference for brought forward raw materials - to learn about this this, click here. N.B.If you have MULTI CURRENCY LICENCES - you MUST READ THIS If these raw materials were originally created in a currency, the exchange rate will be the one from the season you referenced for brought forward raw materials. You should consider if you want to make a global change to all exchange rates used in raw materials in this season - read this or You can change individual exchange rates in raw materials - read this You can change the cost price at any time and this action is season specific, therefore not effecting previous seasons.
N.B. Make an existing PRODUCT visible in this season, and all the RAW MATERIALS needed will automatically be visible. Alternatively make raw materials visible here in order to create new products...
From the HOME PAGE, Click on RAW MATERIALS Select an Action, SET SEASON/RAW MATERIALS
The list will be showing all your materials from all your existing seasons.
Raw Materials
Page 45
Use the filters to narrow down your search. I.E. Filter to see only the materials already visible in a specific previous season.
with COLOUR BREAKDOWN you see one line per each colour option - SELECT the ones you want visible in this season.
without COLOUR BREAKDOWN you see only one line per material and the count of visible colours over the total colours option - i.e. (1 OF 4)
Raw Materials
Page 46
SELECT to make ALL colours/variables for this material visible i this season
(Deselect to make them all invisible)
If you want to carry through all the raw materials displayed, click MAKE ALL VISIBLE
Save is automatic, to return to the Raw Materials list view click on RAW MATERIALS
Raw Materials
Page 47
When I carry forward a raw material the price shown is zero and the Memo Card is not showing! You are setting a material visible in your new season but the price shown is Zero ?!? When you check in your old season the price shows correctly ?!? The price is not pulling through !
Your Season Settings needs to be adjusted Here the reason why !! Zedonk allows materials to have different prices and different memo cards in different seasons. When you make a new season, Zedonk needs to know what season to carry this information from. Make sure each season is set up correctly and "Previous Season" is always specified. When you carry a material forward, Zedonk will look for its price in the "previous season", then the previous to that one and so on, up the chain until it finds it. If this field is not set correctly, Zedonk will not find the previous price for the material and this will be shown as 0 in the new season.
Raw Materials
Page 48
SETTINGS
SEASON > EDIT
Start from your latest season
Raw Materials
Page 49
Make sure the correct "PREVIOUS SEASON" is selected from the drop down
SAVE AND CLOSE
Check the other seasons to make sure they have been set up correctly
(Go back at least a few seasons in case you are carrying forward old raw materials you have not used in a while)
Raw Materials
Page 50
The cost is now pulling through, as well as your Memo Card.
Raw Materials
Page 51
Your raw material was already visible before fixing your Season Settings and it is still showing 0? To update the price, make the material invisible / save / then visible again
Raw Materials
Page 52
The cost fields and memo card of a Raw Material are pink This is what you see....
This Variant/Colour is invisible in this season (and maybe others too) --> select SHOW INVISIBLE
Raw Materials
Page 53
If you want this variant to be visible in this season, select it VISIBLE and SAVE
Raw Materials
Page 54
Raw Materials - 2 or 3 decimal places Some users need to enter their raw material components to 3dp. This is now possible
1. Go to SETTINGS,
COMPANY DETAILS - EDIT
Scroll Down to "Raw Materials Decimal Places"
SAVE & CLOSE
Raw Materials
Page 55
Can I find out which products costings are using a particular raw material? Can I find out which products costings are using a particular raw material?
From the HOME SCREEN, Click on PRODUCT COSTINGS Enter the "OUR REF" ID of the RAW MATERIAL Into the search field, press search
Zedonk will find all the products which contain this raw material.
Raw Materials
Page 56
Bulk Upload Raw Materials Images Upload multiple Raw Materials images at once
You must prepare your images first...
1. Files should be .jpeg / .jpg 2. Size 900 x 600 up to 100KB 3. File name should be: 'RAW MATERIAL ID' 'COLOUR' or 'OUR REF' 'COLOUR'
Raw Materials
Page 57
You can easily access the 'RAW MATERIAL ID' ' COLOUR' by going to REPORTS, MATERIALS, RAW MATERIALS LIST - export the report and copy and paste the 'RAW MATERIAL ID' and ' COLOUR' to your image file
Compress all your images in a zipped folder .zip
Go to RAW MATERIALS and from SELECT AN ACTION , click on IMPORT DATA
Raw Materials
Page 58
CHOOSE FILE > select you zipped folder
N.B. READ THE RULES - it makes the difference between success and frustrating failure!
You can VALIDATE: runs a check on the file names and format without importing the images ..or IMPORT: imports the images and attaches them to the correct material/variant
Raw Materials
Page 59
You will need to wait between 30 seconds and a few minutes depending on the number of images, then click REFRESH
You are back to the main screen - click on PREVIOUS IMPORT PROGRESS
The reports tells you if there are any errors matching images to product costings.
That file should have been named COTTON SATIN SMOKETAUPE 02 I can import this image individually or correct the file name and repeat the process.
Raw Materials
Page 60
Images are now visible.
Raw Materials
Page 61
Where can I find a breakdown of raw material quantity required by product? You might want to see a report of the raw materials and ratings that have been attached to a product costing
From the HOME PAGE, go to REPORTS Click on PRODUCTS and then select PRODUCT RAW MATERIAL LIST
Raw Materials
Page 62
Click DISPLAY REPORT and the data appears
The report is pre -grouped by product and shows each raw material that is attached to that product and the rating
You can also export the report
Raw Materials
Page 63