Raw Materials

Report 3 Downloads 495 Views
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