---
title: "Colour - Size (Attributes)"
canonical: "https://wiki.soft1.eu/space/SS5EN/12060101/Colour%20-%20Size%20(Attributes)"
format: markdown
---
## Basic configuration

### **Item types [attributes]**

From Parameters - Inventory - Item Attributes you can set the Item attributes (old Menu: Inventory -Set up).

- Code /Name: in code you set the ascending numbering of the entry and the name of the type, i.e. Color.
- Item attribute title: provide the code or name option. The format of the item attribute stated is the one to be displayed in invoicing, prints, etc.
- Field length: select the field length of the title.
- Default attributes: for example state a color palette as the default one for the specific type.
- Inactive new item attributes: in case a new item attribute is added to the item attributes to be linked to this type, then for the items already entered in the application such new item attribute shall be inactive.

![image](media://abcddbb6-2da5-43e9-9280-288a2318bfd9)

### Item attributes

From Parameters -Inventory –Item Attributes (old Menu: Inventory -Set up) specify the item attributes (Color palettes - sizes).

![image](media://b3aba781-7073-4688-97ad-fb679cc0afee)

 

When making a new item attribute entry, i.e. color palette, you must complete the type related to the specific item attribute. The lines provide analysis of item attributes (colors - sizes).

### Insert attributes method - Inventory Parameters

In Inventory Parameters and specifically on page <Properties> set the default method for inserting attributes to items. You must pay special attention when completing <Insert mode> for each item attribute type.

![image](media://bd79150b-2bd7-42b9-8003-b4ab630686a2)

 

**<Per item> **select it when for the item attributes with regard to the first type, i.e. color, it is not necessary to connect with the entire color table. In this case complete the colors in the items, either manually, or selecting them from one or more color palettes.

In the items file create a new entry and click on word <attributes>. In the the table that opens, type the colors, or select the ones desired from a color palette.

![image](media://3c8999bf-78ac-49cd-bad2-f67c2adf60ad)

 

**<Per selection> **it is common to use it as an insertion method for item attributes per size, given that this usually refers to a limited number of entries per methodology that apply jointly to a wide range of items.

(**** Read below about Item attributes limitation).

In a new item entry, click on the magnifying glass and select the group of sizes for the item.

 

![image](media://506b1329-88b7-43ef-9c87-77c29b15a898)

###  **Item attributes limitation**

The correlation of an item with a color palette (especially one with a large number of colors) can create administrative difficulties if the item is not available in all colors listed in the colors palette. That is, it is common to connect a "guide" with a color palette, which contains much more colors than those actually used by the item. This will result in document line quantity entries displaying a huge table of colors, which is significantly longer than necessary and likely to lead to mistakes, if you type a color indication for which no "guide" is available. The same problem can occur in methodology lists.  To solve the above issues two solutions are available:

- 1st Solution <Inactive item attributes>

In the constant Item data (of the guides in which unnecessary colors must be limited) use parameter <Inactive>. For the specific guide (Item) this will result in the respective limitation of the indications in the detailed table, when creating quantity entries in document lines.

![image](media://f9105a35-9355-443d-ad83-5785def912c5)

 

- 2nd Solution <Select per item>

In job Inventory Parameters, in parameter <Insertion mode> (which is relevant to each item attribute type) specify indication <Per item>. In this case, you wont have the ability to select inactive attributes, but in item, instead of Color palette (or group of sizes, respectively) opens a table in order to directly enter the attributes for the specific item.        

### Organizational issues

The special attributes capabilities refer only to the analysis and information on quantities (per color - size). If there are different cost values, if the general financial monitoring must be different, then the recommended solution is to use a different Inventory item code.

This means that you must make timely management decisions about which analyses must be included in the "Special attributes of item qty" and which analyses must be set to different codes. Installations set up per color - size (or other similar "leverage" attributes) must always weigh the ease of management provided by the "attributes" with the completeness of financial analyzes offered by the analysis per code. These apply in order to compare the advantages of each option

## Operation

### **Correlation of items with color-size.**

For the items analyzed per color-size the following must apply:

- In the special data of the item, parameter <Item Attributes> must be selected.
- You must use fields Type 1, Type 2 (or, and type 3) in order to specify the inclusion of the inventory item to those analyzed per color-size.
- You must complete fields Item attribute 1, Item attribute 2 (or, and Item attribute 3) in order to correlate the item with specific Color Palettes and Sizes.

 

![image](media://51594be8-95d8-4b2b-bb06-f94fedbb0817)

 

The method for setting Type 1 - Type 2 indicates also the display format of the attributes analysis.

Example

If in Type 1 you set Color and in Type 2 you set Size, the color palette shall display vertically in the table and the Sizes shall display horizontally.

![image](media://094b7e53-ec9f-49ee-b457-4f72d6e30dd0)

 

In option "Inactive" specify which of the attributes connected to the item will be inactive.

### Alternative codes - Barcodes of the items per attributes

In the items file, after entering attributes, go to page 'Identity'  at the lower part and specify the alternative codes that essentially determine the unique item code for a specific combination of attributes.

Insertion can be executed manually, importing from a file, or using EAN codes generation job.

**1. Manual import:**Enter the code and name, the default quantity and complete attributes respectively.

![image](media://f9659cf6-40de-45c5-b7b5-633dc56f5ff9)

**2.  Import from file:** You must have in a file, even in excel format, the item codes, the alternative codes (barcode) and the attribute codes. I.e. 

|  |  |  |  |
| --- | --- | --- | --- |
| **Item code** | **Alternative code** | **Color code** | **Size code** |
| 101-004 | 1111111111111 | 100 | XS |
| 101-004 | 1111111111112 | 100 | S |
| 101-004 | 1111111111113 | 100 | M |
| 101-004 | Etc. |  |  |

 

Then design import using the tools and run the job.

![image](media://9935ef6c-7e70-4646-90db-8830925d369b)

 

**3.Generate EAN codes:** The specific job generates alternative EAN codes for all combinations of active attributes, according to the selection criteria, during the execution process. The specific job can also be executed automatically, if you set in Inventory Parameters, page Barcode, the value <Yes> in the Automatic EAN code generation field. Here, you can also complete the default value of the prefix of EAN code, in order to be provided by default when running the job and, of course, during automatic code generation. 

![image](media://7e23af28-3759-4d9f-9824-a5ff5794acd5)

Job generate EAN codes is found in menu Inventory - EAN Cash. 

You can run the job for a range of codes, or selecting a season. In field "Without attributes> check indication <Yes / No> depending on whether you want the job to generate codes for the items not monitored per attributes.

As stated, the prefix of code is provided by default, as long as it is completed in inventory parameters. This can be changed and the same applies for indication From number, which respectively provides by default the next number stored in the memory of the counter.

When you are finished, check <Yes> to confirm the job and click 'Run' button. When the job is completed, a relevant message 'End of alternative codes import', the total entries and canceled entries, if any, will be displayed.

 

![image](media://f54ee3e3-8615-409a-8b86-4751c1b142c0)

Moreover, If you wish to batch-delete the alternative codes created for some items, select items <Yes> in the field with the corresponding indication for data deletion.

### Prices per attributes

In order to complete the posting of a new item in the system, you must check the update method of the prices. 

If the price does not vary with the attribute (usually size), then simply enter in fields 'Wholesale' - 'Retail' the corresponding prices. Otherwise, you must click on the word 'wholesale' or 'Retail' to open the list of attributes, where you can set the different prices for each combination. If you do not enter a price for some combinations, then during invoicing the price of the item in total in the respective price field of the items file will be used.

For example, the following item has price 100 for sizes 1 & 2, 110 for 3 and 115 for 4 & 5.

 

![image](media://5303384e-fab9-43c0-a36c-013b5b83c401)

Additionally, if you right-click on the table you can zero the data of the selected line or column, or you can a rule for the completion in the combination data, selecting the augmentation per attribute.  

 

![image](media://d09185da-d5da-460d-8563-66038d99a087)

![image](media://a7e99811-74ba-452a-a4cd-5b62896ce078)

 

### Using the system - Document posting

Depending on the Type of the transaction and the use of each document, the posting method of the items in documents may vary. There are 2 methods for posting quantities in document lines.

- In quantity field, if you click on symbol
  > Macro (inline-media-image)

 opens a small table to fill in the quantities in the desired combination of attributes for each item on the document lines.

![image](media://9c9085e0-ad1f-4ead-8fc3-683b72e799fc)

 

- Selecting the attributes in the lines, where each combination for an item is posted on separate lines.

![image](media://194e9d18-ae84-4804-8aef-49b136e4d5c9)

 

The second method requires the design of columns and connection to the document Type, in order to display the attributes on the lines.

 

![image](media://16ad985a-da3f-4142-898c-cc70a1bcbeab)

 

### Tips

- On document lines, in the table for the completion of quantities and depending on the cell in which the cursor is located, you can see additional information on the quantities and pending items of the attributes, if you check indication <Analysis>. Thus, you can get information on the item balance in the specific Color/Size, the nominal balance (Balance + expected - reserved), the actual available (Balance - reserved) and the reserved elements of the document customer.

![image](media://2af771a0-ee2a-4bc6-8f58-fcb5436849f4)

- In the items analyzed per attributes, all fields showing quantitative data in the Item financial data, are labeled  with
  > Macro (inline-media-image)

, you can display the table analyzing the cumulative indications in quantities per attributes.

 

![image](media://c93f095e-606e-4b24-b336-e71fcaea37e1)

- In item data per WH and using related jobs, right-click on quantity to select imports only or exports only in order to display the Balance with attributes analysis.

![image](media://ff18f2fa-17bf-4a4f-9c04-095d5a752a50)

 

### Standardization and acceleration of new guides (inventory items) posting jobs

In the analysis table, the indications of the 1st attribute type are displayed in the lines of the 1st column, while the indications of the 2nd attribute type are displayed in column headers. Assuming that colors are usually more than sizes, then you probably prefer to set colors on the lines of the 1st column and sizes on the column headers. In order to accelerate common posting and to standardize the location at which each attribute will be displayed, using job Inventory Parameters, and in parameters <Type 1>, <Type 2> (and <Type 3>), select the "default" indications for posting a new guide/item. The indications will be provided automatically during new Inventory Item posts, as soon as you set parameter <Attributes> to <Yes>.

![image](media://d53c6384-d546-4a90-9ec1-2f94e3d9478e)

## **Reports/printouts**

Inventory includes reports developed exclusively for items monitored per attributes. These are:

- Quantity per attribute
- Balance per attribute
- Negative balance per attribute

Moreover, the reports that include in their filters the relevant indication <Attributes analysis> and a filter for attribute code, provide a respective development.

![image](media://50fd58ad-84fc-4ac8-8007-7c5bd71c8430)

 

## Special barcodes of attributes 

In Inventory parameters you can set the method for the creation of a barcode with attributes per item line.

![image](media://c9185d3e-0d3a-4efe-8ab5-4d999906e5bf)

In items including analysis by attributes, when posting a document, type in field <Search code> the item code type and the attribute code, in order to directly insert the item in the line. At the same time, there shall be automatic recommendation of quantity 1 for the attributes' combination that corresponds to the barcode.

To activate the use of Barcode in items with attributes, you must do the following: 

- In Inventory Parameters, page <Barcode> check indication "Activate item attribute Barcodes".
- In basics, search order, enter barcode as a search method.
- Define the format of barcode code using the Latin characters C,X,Y,Z where:

C : Item code digit

X: Item attribute 1 code digit

Y: Item attribute 2 code digit 

Z: Item attribute 3 code digit 

Example: if the format is CCCCCXXYY and you type in the search code 111110401, the document line shall present item 11111 with quantity in color 04 and size 01.

- In parameter "Field separator", enter the symbol to be used for barcode groups separation. I.e. between the item code group and attribute 1.
- Check the indication for the.0 "Numerical attribute correspondence" if you wish during typing to use the serial number of the series for posting the attribute in the related table. I.e 600360201 indicates preference for item with code 60036 in the 2nd color per order in the color table and in the 1st size respectively of the sizes table.