Hide last authors
Administrator 71.2 1 StockM administration module is only in English language. StockM administration module is created to change system settings, create new users and warehouses, analyze user actions, repeat data exchanges, upload data via files help.
Administrator 50.2 2
Administrator 47.1 3 {{toc/}}
Administrator 1.1 4
Administrator 71.2 5 == **Login** ==
Administrator 1.1 6
Administrator 71.2 7 ~1. You can login into StockM administration module straight from StockM (only for users, who have the rights for it):
Administrator 1.1 8
Administrator 71.2 9 [[image:71_Login.png]]
Administrator 1.1 10
11
Administrator 71.2 12 2. Address (if you write “/admin/index.html” near usual StockM address): [[http:~~/~~/company_name.stockm.net>>url:http://company_name.stockm.net/]]__/admin/index.html.__
Administrator 1.1 13
Administrator 71.2 14 Login name and password are the same as login to StockM:
Administrator 1.1 15
Administrator 71.2 16 [[image:1.jpg]]
Administrator 1.1 17
Administrator 71.2 18 == **Log out** ==
Administrator 1.1 19
Administrator 71.2 20 [[image:72_LogOut.png]]
Administrator 1.1 21
Administrator 71.2 22 We recommend to log out in this way, from StockM window, when there work several users and they log in to the same computer with different login details.
Administrator 1.1 23
Administrator 71.2 24 == **Settings** ==
Administrator 1.1 25
Administrator 71.2 26 ~1. "Parameters":
Administrator 1.1 27
Administrator 71.2 28 [[image:92_table.png]]
Administrator 1.1 29
Administrator 71.2 30 1) Settings
Administrator 1.1 31
Administrator 71.2 32 [[image:73pav.png]]
Administrator 1.1 33
34
Administrator 71.2 35 - Default SKU graph (days) – number of days in item SKU graph, which show the information. This period is showed every time when you open an item graph.
Administrator 1.1 36
Administrator 71.2 37 - Default analytics graph length (weeks) – number of weeks in StockM reports: Inventory Dynamics, Buffers Dynamics, Level of Inventory (DTA). This period is showed in StockM reports.
Administrator 1.1 38
Administrator 71.2 39 - Manager ID for SKUs with missed manager – user, who is responsible for items, which are not assigned to anymone.
Administrator 1.1 40
41
Administrator 71.2 42 2) Labels – names of additional columns, editing. Fill in the names of all used columns (such names you will see in the StockM system):
Administrator 1.1 43
Administrator 71.2 44 [[image:74pav.png]]
Administrator 1.1 45
46
Administrator 71.2 47 - Additional global data field names;
Administrator 1.1 48
Administrator 71.2 49 Extra 1-10 – additional columns via company. Format of the value is only text and it doesnt‘t matter if transferred information is in text or in numbers.
Administrator 1.1 50
Administrator 71.2 51 - Additional local data field names:
Administrator 1.1 52
Administrator 71.2 53 Wextra 1-7 - additional columns via warehouse. Format of the value is only text and it doesnt‘t matter if transferred information is in text or in numbers.
Administrator 1.1 54
Administrator 71.2 55 - Safety buffer names:
Administrator 1.1 56
Administrator 71.2 57 SB 2-4 – additional safety buffer columns.
Administrator 1.1 58
Administrator 71.2 59 - SBX Safety buffer name:
Administrator 1.1 60
Administrator 71.2 61 SBx 2-4 – safety buffer fields, which can be updated daily according to data, which are received via file sbx.csv.
Administrator 1.1 62
Administrator 71.2 63 - Measurement unit names:
Administrator 1.1 64
Administrator 71.2 65 Weight (Measure1)
Administrator 1.1 66
Administrator 71.2 67 Volume (Measure2)
Administrator 1.1 68
Administrator 71.2 69 - Show (hide) additional global data fields in excell reports:
Administrator 1.1 70
Administrator 71.2 71 Extra 1-10 – additional fields in reports. All these fields are in the reports, however they are hidden (you can open them if you need). If you put check marks on this setting, marked fields will be visible at the same time when you open it (will not be hidden).
Administrator 1.1 72
Administrator 71.2 73 - Show (hide) additional local data fields in excel reports:
Administrator 1.1 74
Administrator 71.2 75 Wextra 1-7 - additional fields in reports. . All these fields are in the reports, however they are hidden (you can open them if you need). If you put check marks on this setting, marked fields will be visible at the same time when you open it (will not be hidden).
Administrator 1.1 76
Administrator 71.2 77 - Show(hide) safety buffers in excell reports:
Administrator 1.1 78
Administrator 71.2 79 Safety buffer 1-3 – safety buffers in reports. When you put the check marks, the fields will be visible in the reports, when you open it (will not be hidden by default).
Administrator 1.1 80
Administrator 71.2 81 - Show(hide) safety buffers from sbx.csv in excell reports:
Administrator 1.1 82
Administrator 71.2 83 Sbx 1-3 safety buffers from sbx.csv in reports. When you put the check marks, the fields will be visible in the reports, when you open it (will not be hidden by default).
Administrator 1.1 84
Administrator 71.2 85 - Show(hide) peak coefficients in excell reports:
Administrator 1.1 86
Administrator 71.2 87 Peak coefficient 1-7 peak coefficient visibility in reports. When you put the check marks, the fields will be visible in the reports, when you open it (will not be hidden by default).
Administrator 1.1 88
Administrator 71.2 89 1) Dashboard – there are visible settings of parameters scales in the primary window of StockM („Today“):
Administrator 1.1 90
Administrator 71.2 91 [[image:75_Dashboard.png]]
Administrator 1.1 92
93
Administrator 71.2 94 -Overstock gauge size – there is a visible breakdownd by percentage of overstock scale in the primary StockM window („Today“). About parts which is agreed in the process of project. It is determined on a company scale.
Administrator 1.1 95
Administrator 71.2 96 -Lost sales gauge size – there is a visible breakdownd by percentage of lost sales scale in the primary StockM window („Today“). About parts which is agreed in the process of project. It is determined on a company scale.
Administrator 1.1 97
Administrator 71.2 98 -Turnover gauge size - there is a visible breakdownd by days of turnover scale in the primary StockM window („Today“). About parts which is agreed in the process of project. It is determined on a company scale.
Administrator 1.1 99
Administrator 71.2 100 2. User groups:
Administrator 1.1 101
Administrator 71.2 102 [[image:76_Settings.png]]
Administrator 1.1 103
Administrator 71.2 104 [[image:77_UserGroups.png]]
Administrator 1.1 105
Administrator 71.2 106 Users are divided into groups (the same rights are given to all users, which are in one group):
Administrator 1.1 107
Administrator 71.2 108 -Admins: assigned employees, which work with the StockM assortment management system, who can make all changes/corrections, create new users, assign and change the rights, warehouses for users, complete other settings (users, who have most rights)
Administrator 1.1 109
Administrator 71.2 110 -Disabled: not active users.
Administrator 1.1 111
Administrator 71.2 112 -Manufacturer: user/producer, who can see only his own goods.
Administrator 1.1 113
Administrator 71.2 114 -Power users: assigned employees, which work with the StockM assortment management system and can make all changes/corrections.
Administrator 1.1 115
Administrator 71.2 116 -Support or other: possible to create a group of users with separate rights. Click the button „New“, choose the name of user group and level of administration. Click the button „Save“, after entering all information.
Administrator 1.1 117
Administrator 71.2 118 -„Users“: assigned employees, which work with the StockM assortment management system, can make certain changes (users, who have less rights).
Administrator 1.1 119
Administrator 71.2 120 -Watchers: assigned employees, which can review/analyze/read an information, which is in StockM assortment management system, however can‘t make any changes (users, which have less rights – the right to „read“).
Administrator 1.1 121
Administrator 71.2 122 If you want to remove the group, click the button „Delete“ (Remove).
Administrator 1.1 123
Administrator 71.2 124 If you want to change/edit the rights of the user group, click ..... in the user group list and click „Save“ after changing the rights.
Administrator 1.1 125
Administrator 71.2 126 __Rights for group of users:__
Administrator 1.1 127
Administrator 71.2 128 //General data~://
Administrator 1.1 129
Administrator 71.2 130 -User group name
Administrator 1.1 131
Administrator 71.2 132 -Administration level
Administrator 1.1 133
Administrator 71.2 134 //Users visibility on DashBoard~://
Administrator 1.1 135
Administrator 71.2 136 -All users are visible (in system warnings, tasks and window “Today”), include all users, which are marked/ticked “show in dashboard”.
Administrator 1.1 137
Administrator 71.2 138 //Buffer access~://
Administrator 1.1 139
Administrator 71.2 140 -Edit buffer: after placing a check mark, user can edit the value of buffer in all windows, which have such possibility (it is possible to change buffer value, when you change buffer quantity, in the new order).
Administrator 1.1 141
Administrator 71.2 142 -Buffer increase menu (view – see that menu; no access – no permission to see the menu).
Administrator 1.1 143
Administrator 71.2 144 -Buffer decrease menu (view – see that menu; no access – no permission to see the menu).
Administrator 1.1 145
Administrator 71.2 146 -Buffer incomplete menu (view – see that menu; no access – no permission to see the menu).
Administrator 1.1 147
Administrator 71.2 148 -Buffer questionable menu (view – see that menu; no access – no permission to see the menu).
Administrator 1.1 149
Administrator 71.2 150 -Buffer safety menu (view – see that menu; no access – no permission to see the menu).
Administrator 1.1 151
152
Administrator 71.2 153 //Order access//
Administrator 1.1 154
Administrator 71.2 155 -Create regular order (user will be able to create a regular order after placing the check mark).
Administrator 1.1 156
Administrator 71.2 157 -Create special order (user will be able to create a special order after placing the check mark).
Administrator 1.1 158
Administrator 71.2 159 -Orders unlimited (user will be able to place orders, without limiting quantities of orders).
Administrator 1.1 160
Administrator 71.2 161 -Place special order (user will be able to send a special order after placing the check mark).
Administrator 1.1 162
Administrator 71.2 163 -Placed order menu (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 164
Administrator 71.2 165 -New order menu (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 166
Administrator 71.2 167 -Closed orders menu view – (view - see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 168
Administrator 71.2 169 -PTO orders menu (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 170
171
Administrator 71.2 172 //Assortment access~://
Administrator 1.1 173
Administrator 71.2 174 -SKU data menu (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 175
Administrator 71.2 176 -Alt items (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 177
Administrator 71.2 178 -SKU by warehouse (WSKU) data (full access – get all rights to manage; view – only see this menu, information).
Administrator 1.1 179
Administrator 71.2 180 -Prices field visibility (after placing the check mark, user can see the prices).
Administrator 1.1 181
Administrator 71.2 182 -Inventory menu (full access – get all rights to manage; view – only see this menu, information).
Administrator 1.1 183
184
Administrator 71.2 185 //Supplier access//
Administrator 1.1 186
Administrator 71.2 187 -Supplier data menu (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 188
Administrator 71.2 189 -Supply schedule menu (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 190
Administrator 71.2 191 -SKU by warehouse by supplier (SWSKU) data (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 192
Administrator 71.2 193 Manufacturer field (after placing the check mark, user can see the producer).
Administrator 1.1 194
195
Administrator 71.2 196 //Report access~://
Administrator 1.1 197
Administrator 71.2 198 -Inventory dynamics (after placing the check mark, user will be able to see inventory dynamics report in StockM). If you want to manage, it is necessary to have visibility of SKU, suppliers and users lists.
Administrator 1.1 199
Administrator 71.2 200 -Buffer status (after placing the check mark, user will be able to see buffer dynamics report in StockM). If you want to manage, it is necessary to have visibility of SKU, suppliers and users lists.
Administrator 1.1 201
Administrator 71.2 202 -Service status (DTA) (after placing the check mark, user will be able to see service status (DTA) report in StockM). If you want to manage, it is necessary to have visibility of SKU, suppliers and users lists.
Administrator 1.1 203
204
Administrator 71.2 205 //Other access//
Administrator 1.1 206
Administrator 71.2 207 -Split mark (full access – get all rights to manage; view – see only the information).
Administrator 1.1 208
Administrator 71.2 209 -Dimensions (full access – get all rights to manage; view – see only the information).
Administrator 1.1 210
Administrator 71.2 211 -Reasons (full access – get all rights to manage; view – see only the information). It is asked to show the reason, when you change ordered quantity manually or change the buffers.
Administrator 1.1 212
Administrator 71.2 213 -Currencies (full access – get all rights to manage; view – see only the information).
Administrator 1.1 214
Administrator 71.2 215 -Period (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu). Periods are used for seasonal change of buffers.
Administrator 1.1 216
Administrator 71.2 217 -Promo (full access – get all rights to manage; view – see only the information).
Administrator 1.1 218
Administrator 71.2 219 // //
Administrator 1.1 220
Administrator 71.2 221 //Warning access~://
Administrator 1.1 222
Administrator 71.2 223 -Warnings (full access – get all rights to manage; view – only see this menu, information; no access – have no permission to see the menu).
Administrator 1.1 224
Administrator 71.2 225 3. Users:
Administrator 1.1 226
Administrator 71.2 227 [[image:78_users.png]]
Administrator 1.1 228
Administrator 71.2 229 [[image:79_us.png]]
Administrator 1.1 230
231
Administrator 71.2 232 In the window you can see employees of the company, which work with the StockM assortment management system. If you want to create a new user, click the button “New” in the left corner. Fill in all the information in the user card:
Administrator 1.1 233
Administrator 71.2 234 [[image:new_user.png]]
Administrator 1.1 235
236
Administrator 71.2 237 -Active: check mark of user activity
Administrator 1.1 238
Administrator 71.2 239 -Username: enter the name, by which user will log in to StockM assortment management system.
Administrator 1.1 240
Administrator 71.2 241 -Password: enter the password, by which user will log in to StockM assortment management system.
Administrator 1.1 242
Administrator 71.2 243 -User group name: select user group from the drop-down list, for which you want to assign the user.
Administrator 1.1 244
Administrator 71.2 245 Recommendation for the users:
Administrator 1.1 246
Administrator 71.2 247 * When the user no longer works with the program, he needs to be deactivated and all his items will be assigned to an Unassigned Manager or to an indicated responsible manager instead of Unassigned.
248 * If you want user to be disconnected temporarily, but the items must remain assigned to him, then assign the user group Disabled.
Administrator 1.1 249
Administrator 71.2 250 -First name: enter the name of user.
Administrator 1.1 251
Administrator 71.2 252 -Last name: enter the last name of user.
Administrator 1.1 253
Administrator 71.2 254 -E-mail: enter the e-mail of user, where will be send the copy of placed order (via StockM system) and specified e-mail will be used as backward contact from the direct order receiver.
Administrator 1.1 255
Administrator 71.2 256 -Show on dashboard: after placing the check mark, you can select users (name, surname) in the first StockM window (tasks and indicators of the selected user will be showed).
Administrator 1.1 257
Administrator 71.2 258 - Show managed items only - if the check mark is placed, the user will only see his / her items (which he / she manages).
Administrator 1.1 259
Administrator 71.2 260 * The user will see the items assigned to him in the StockM windows: Inventory, Buffers to increase, Buffers to decrease, Incompleted SKU data, Questionable buffers, Supplier SKU info.
261 * In the Inventory window, when creating new SKU cards, user will be able to select only himself as the assigned manager.
262 * This restriction will not work in the windows Promotions, Periods, Orders, SKU groups – the user will see the items of all managers because in these windows information can be entered for the items of more than just one manager (for example, an order to the same supplier can contain items belonging to several managers).
Administrator 1.1 263
Administrator 71.2 264 -Language: letters about user tasks will be sent in specified language.
Administrator 1.1 265
Administrator 71.2 266 -Manufacturer: if producer of goods wants to log in into StockM, so it is created user and assigned producer for him. Such user will be able to see only his goods in StockM.
Administrator 1.1 267
Administrator 71.2 268 -Reference code: manager‘s code which is responsible for the product/item (it is used when manager‘s code is renewed from the customer‘s accounting system for each item).
Administrator 1.1 269
Administrator 71.2 270 -Visible warehouses: specified warehouses, which user must see in the StockM (if the information was specified in the warehouse‘s card, you will see it here).
Administrator 1.1 271
272
Administrator 71.2 273 Click the button „Save“, after entering all the information.
Administrator 1.1 274
Administrator 71.2 275 Click the button „Delete“, after removing the user.
Administrator 1.1 276
Administrator 71.2 277 If you want to change/edit user‘s information, click ..... in the users list and click „Save“ after changing the required information.
Administrator 1.1 278
Administrator 71.2 279 ~1. Warehouses:
Administrator 1.1 280
Administrator 71.2 281 [[image:80_Warehouses.png]]
Administrator 1.1 282
283
Administrator 71.2 284 [[image:81_warehouses2.png]]
Administrator 1.1 285
286
287
Administrator 71.2 288 It is necessary to create and describe the warehouse before starting to manage the assortiment and get the data regularly from the customer‘s accounting system.
Administrator 1.1 289
Administrator 71.2 290 Click the button „New“ in the left corner in the window that opens. Fill in the necessary information in the warehouse card:
Administrator 1.1 291
Administrator 71.2 292 [[image:94_pav.png]]
Administrator 56.1 293
Administrator 57.1 294
Administrator 1.1 295
296
Administrator 71.2 297 - Active: warehouse activity check mark. The data is updated only for active warehouse from customer‘s accounting program, also you will see only active warehouse in StockM.
Administrator 1.1 298
Administrator 71.2 299 - Warehouse Code: enter the code according which data will be updated from customer‘s accounting program.
Administrator 1.1 300
Administrator 71.2 301 - Warehouse Name: enter the name of the warehouse.
Administrator 53.1 302
Administrator 71.2 303 - Warehouse groups: select from the list, which group of the warehouses this warehouse belongs to, according which you will manage the assortment of goods (see. [[Assortment management rules>>doc:User_Manual.Assortment_Management.WebHome]]). The group shows warehouse size, specific, uniquiness and etc. (inside order of customer‘s company). If the group of the warehouses is not used, then the level „All“ is assigned for all warehouses.
Administrator 54.1 304
Administrator 71.2 305 - Internal: place the check mark near the warehouse, which is the inner warehouse of the company (managed warehouse, belongs to company).
Administrator 1.1 306
Administrator 71.2 307 - Center: place the check mark near the warehouse, which is the central warehouse of the company, i.e. from which further chain warehouses are filled in (when you assign the mark OUT for an item – the system transfers such items state to DTO automatically in the central warehouse, i.e. an item is not ordered anymore from the external supplier, see. [[Assortment management rules>>doc:User_Manual.Assortment_Management.WebHome]]).
Administrator 1.1 308
Administrator 71.2 309 - Name: enter the name of the warehouse which is created as new (you will see this information in the standard form of order).
Administrator 1.1 310
Administrator 71.2 311 - Address: enter the name of the warehouse which is created as new (you will see this information in the standard form of order).
Administrator 1.1 312
Administrator 71.2 313 - Tax ID“ (Tax code): VAT payer code (you will see this information in the standard form of order).
Administrator 1.1 314
Administrator 71.2 315 - Code: company code (you will see this information in the standard form of order).
Administrator 1.1 316
Administrator 71.2 317 - City: city, where is the warehouse (you will see this information in the standard form of order).
Administrator 1.1 318
Administrator 71.2 319 - Country: country, where is the warehouse (you will see this information in the standard form of order).
Administrator 1.1 320
Administrator 71.2 321 - Phone: contact phone number of the warehouse (you will see this information in the standard form of order).
Administrator 1.1 322
Administrator 71.2 323 - Fax: fax number of the warehouse (you will see this information in the standard form of order).
Administrator 1.1 324
Administrator 71.2 325 - Email: contact e-mail of the warehouse (you will see this information in the standard form of order).
Administrator 1.1 326
Administrator 71.2 327 - Email cc list“: receivers, which shall receive the orders from this warehouse.
Administrator 1.1 328
Administrator 71.2 329 - Delivery country: additional parameter of the warehouse, which marks in which country the warehouse is.
Administrator 1.1 330
Administrator 71.2 331 - Delivery code: additional parameter of the warehouse, which most often is the same as warehouse code.
Administrator 1.1 332
Administrator 71.2 333 - Extra (additional field): additional information, which must be visible in the standard form of order near the customer section.
Administrator 1.1 334
Administrator 71.2 335 - Format (Warehouse order credentials): write, what kind of information must be visible in the standard form of order near the CUSTOMER field.
Administrator 1.1 336
Administrator 71.2 337 - User visibility: specified users, which must see this warehouse in StockM (if the information was written in the user‘s card, you will see it here already).
Administrator 1.1 338
Administrator 71.2 339 Click the button „Save“ after entering all the information.
Administrator 1.1 340
Administrator 71.2 341 Click the button „Delete“ (Remove) if you want to remove the warehouse.
Administrator 1.1 342
Administrator 71.2 343 Click [[image:pencil.png]] if you want to change/edit warehouse information and click „Save“ after changing the required information.
Administrator 1.1 344
345
346
347
Administrator 71.2 348 **//4. Warehouse groups"~://**
Administrator 1.1 349
350
351
Administrator 71.2 352 [[image:82_WarehouseGroups.png]]
Administrator 1.1 353
Administrator 71.2 354 [[image:83_WG.png]]
Administrator 1.1 355
356
357
Administrator 71.2 358 Warehouse group – group, according which you will manage assortment of goods (see, Assortment management rules). The group tells about the size, specific, uniquiness and etc (internal order of customer‘s company).
Administrator 1.1 359
Administrator 71.2 360 New group is described by clicking the button „New“. In the window that opens, enter the name of the group, click the button „Create“.
Administrator 1.1 361
Administrator 71.2 362 5**. Report recipients:**
Administrator 1.1 363
Administrator 71.2 364 [[image:84_report.png]]
Administrator 1.1 365
366
367
Administrator 71.2 368 Specified the list of all available reports, which can be generated in StockM. E-mail addresses of users, which must get the reports, are uploaded. Receivers of reports are assigned step by step, according to steps of project implementation.
Administrator 1.1 369
Administrator 71.2 370 == **Actions** ==
Administrator 1.1 371
372
Administrator 71.2 373 ~1. „Import“ – data import into StockM:
Administrator 1.1 374
Administrator 71.2 375 [[image:20200917_1.png]]
Administrator 1.1 376
377
Administrator 71.2 378 It is possible to import information about goods into StockM in administration module (StockM). Information can be imported according to:
Administrator 1.1 379
Administrator 71.2 380 -SKU code or
Administrator 1.1 381
Administrator 71.2 382 -Extra1 field (if the customer doesn‘t use SKU code for recognizing the goods and into Extra1 field from the accounting program is given other customer‘s used code).
Administrator 1.1 383
Administrator 71.2 384 [[image:95_pav.png]]
Administrator 1.1 385
386
Administrator 71.2 387 There are two types of information of StockM item (SKU):
Administrator 1.1 388
Administrator 71.2 389 1) Import global SKU data – information for an item, which is common in the company (items „in head“) and doesn‘t change through warehouses, for example: extra fields, weight, volume and etc.
Administrator 1.1 390
Administrator 71.2 391 [[image:96_pav.png]]
Administrator 1.1 392
393
Administrator 71.2 394 When you click „Download template“, the template is sent in excel format, which must be filled in:
Administrator 1.1 395
Administrator 71.2 396 [[image:97_pav.png]]
Administrator 1.1 397
398
Administrator 71.2 399 When you Import global SKU data, the required field is: SKU code/Extra1.
Administrator 1.1 400
Administrator 71.2 401 - If the field is textual, for example, Extra fields, then must be entered text, which will be imported.
Administrator 1.1 402
Administrator 71.2 403 - If you need to remove the text, then you must put the „gap“ symbol into the field.
Administrator 1.1 404
Administrator 71.2 405 - If the field is numeric, then you must write the specific number.
Administrator 1.1 406
Administrator 71.2 407 - If you need to put/take out TOP/NON/OUT marks, then you must write the value 1(put) ir 0 (take out), accordingly.
Administrator 1.1 408
Administrator 71.2 409 Completed template must be saved and closed. You should select the completed file (Browse) in the window Import global SKU data and click „Import file data“. If there will be any mistakes in the completed file, the system will show it. All mistakes must be corrected.
Administrator 1.1 410
Administrator 71.2 411 1) Import SKU data in Warehouses – this information can be different through the warehouses, for example: MOQ, Supplier code and etc.
Administrator 1.1 412
Administrator 71.2 413 You can choose to import the information:
Administrator 1.1 414
Administrator 71.2 415 - For the specified warehouses (By warehouse code);
Administrator 1.1 416
Administrator 71.2 417 - For the specified warehouses levels, i.e. when the warehouses are grouped and you need to import the same information for all warehouses, which belong to the same group (By Warehouse group)
Administrator 1.1 418
Administrator 71.2 419 [[image:98_pav.png]]
Administrator 1.1 420
421
Administrator 71.2 422 When you click „Download template“, you will get the template in excel format, which must be filled in:
Administrator 1.1 423
Administrator 71.2 424 [[image:99_pav.png]]
Administrator 1.1 425
426
Administrator 71.2 427 When you upload Import SKU data in Warehouses, **SKU code/Extra1 code and Warehouse code/Warehouse level **are the required fields.
Administrator 1.1 428
Administrator 71.2 429 - if the field is textual, for example: Wextra fields, supplier SKU name, then the text, which will be uploaded, must be entered.
Administrator 1.1 430
Administrator 71.2 431 - If you need to remove the text, then you must put the „gap“ symbol into the field.
Administrator 1.1 432
Administrator 71.2 433 - If the field is numeric, then you must write the specific number.
Administrator 1.1 434
Administrator 71.2 435 - if you need ti define the status, then you must enter the DTA, DTO, NM, NA, accordingly.
Administrator 1.1 436
Administrator 71.2 437 - If you need to put/take out A/C/OUT marks, then you must write the value 1(put) ir 0 (take out), accordingly.
Administrator 1.1 438
Administrator 71.2 439 - the state doesn‘t change for the alternative goods.
Administrator 1.1 440
Administrator 71.2 441 The completed template must be saved and closed. In the window Import SKU data in Warehouses, select the completed file (Browse) and click "Import file data".
Administrator 1.1 442
Administrator 71.2 443 Information will be loaded from those rows that do not contain errors, and a list of errors will be shown to the user (errors can be exported to excel as before).
Administrator 1.1 444
Administrator 71.2 445 Once the errors are corrected, the data will have to be uploaded for specified rows once again by entering information into a new / separate L11 table template.
Administrator 1.1 446
447
Administrator 71.2 448 **//2. "Merge ALT groups"  //- mass combining into groups of alternative items (ALT).**
Administrator 1.1 449
Administrator 71.2 450 [[image:20200917_2.png]]
Administrator 1.1 451
Administrator 71.2 452 In the window there is a draft of the table for mass combining of the items into ALT groups.
Administrator 1.1 453
Administrator 71.2 454 [[image:20200918.jpg]]
Administrator 1.1 455
Administrator 71.2 456 * Main SKU code: SKU code of the main item in the group. 
457 * Parameters SKU code: SKU code of the item, which parameters will be assigned to the main SKU.
458 * Old Main SKU code: if the existing group of items is changed, indicate the existing (old) code of the main SKU in the group. The Main SKU code field must contain the new main SKU code.
Administrator 1.1 459
Administrator 71.2 460 If a new group is being combined, do not specify anything in this field.
Administrator 1.1 461
Administrator 71.2 462 * Alt SKU code: SKU code of alternative item
Administrator 1.1 463
Administrator 71.2 464 Note: If there is more than one ALT item code for the same main SKU code, they must be listed on separate rows, repeating the main SKU code on each row.
Administrator 1.1 465
Administrator 71.2 466 The completed table needs to be imported into StockM.
Administrator 1.1 467
468
Administrator 71.2 469 **//3. "Manual data exchange"  //**
Administrator 1.1 470
471
472
Administrator 71.2 473 [[image:20200917_3.png]]
Administrator 1.1 474
Administrator 51.1 475
Administrator 71.2 476 It is possible to run repeated data exchange in StockM administration module, if the data were not updated in time or were updated unsuccessfully.
Administrator 64.2 477
Administrator 71.2 478 **IMPORTANT:** data files must be formed from the accounting program, before completing that function, and sent to FTP or other agreed place.
Administrator 51.1 479
Administrator 71.2 480 -If you need to update the data, however it is not necessary to create orders according to set orders formation graph, then you have to mark „Exchange data without orders“ and click „Run“.
Administrator 1.1 481
Administrator 71.2 482 -If you need to update the data and create orders automatically according to set orders formation graph, then you have to mark „Exchange data and create orders“ and click „Run“. Data exchange will be started to execute and after it orders will be formed.
Administrator 60.2 483
484
Administrator 71.2 485 [[image:101_t.png]]
Administrator 60.2 486
487
Administrator 71.2 488 **4//. „Change SKU code~://**
Administrator 60.2 489
Administrator 71.2 490 [[image:20200917_4.png]]
Administrator 60.2 491
492
Administrator 71.2 493 You can change the SKU code of item in the SKU administration module (Change SKU code), i.e. when the new code is entered in accounting system instead of previous code.
Administrator 60.2 494
Administrator 71.2 495 **IMPORTANT:** Changes must be done the same day in the accounting program and in StockM.
Administrator 60.2 496
Administrator 71.2 497 If the code was changed earlier in the accounting program, then one more additional code will appear in StockM (will be old code and new code). In such case items/goods must be connected as alternatives (see, Combining alternative items)
Administrator 60.2 498
Administrator 71.2 499 ~1. Enter the current SKU code into the field „Currently SKU code“. Enter the code into field „New code for selected SKU“, which you want to change.
Administrator 1.1 500
Administrator 71.2 501 Save entered values.
Administrator 1.1 502
503
Administrator 71.2 504 [[image:102_pav.png]]
Administrator 1.1 505
506
Administrator 71.2 507 **5. //"OUT transactions count"  - report for the initial range setting~://**
Administrator 1.1 508
Administrator 71.2 509 //**[[image:20200917_5.png]]**//
Administrator 1.1 510
Administrator 71.2 511 When there is no experience in determining the range of products at the beginning of the project, we suggest to use a modified DTO >> DTA report. The report calculates the number of transactions during a specified period.
Administrator 1.1 512
Administrator 71.2 513 It is sorted by number of transactions. All active items (not NA) are involved.
Administrator 1.1 514
Administrator 71.2 515 It is necessary to specify the WExtra field in which you want to see the calculated information. Sales and transfers are included in the calculation of transactions.
Administrator 1.1 516
Administrator 71.2 517 == **Logs (Log reports)** ==
Administrator 1.1 518
519
520
521
522
Administrator 71.2 523 It is possible to check users log in and information about made changes in StockM administration module.
Administrator 64.2 524
Administrator 71.2 525 **//1. „System access log“//**
Administrator 64.2 526
Administrator 71.2 527 [[image:103_pav.png]]
Administrator 64.2 528
Administrator 65.1 529
530
531
Administrator 71.2 532 You will see information about user‘s log in into StockM or date and time of StockM administration module.
Administrator 65.1 533
Administrator 71.2 534 You can choose the filtration parameters in the window that opens:
Administrator 1.1 535
Administrator 71.2 536 - desired date/period. __This parameter is necessary;__
Administrator 1.1 537
Administrator 71.2 538 - user, which you are looking for;
Administrator 1.1 539
Administrator 71.2 540 - select only the date if you want to review only users logins;
Administrator 1.1 541
Administrator 71.2 542 - click „Show results“ after completing the settings;
Administrator 1.1 543
Administrator 71.2 544 - you can analyze filtered data in the window or export data into Excel.
Administrator 1.1 545
Administrator 71.2 546 [[image:88_pac.png]]
Administrator 1.1 547
548
549
Administrator 71.2 550 User was logged in successfully, in there is a value „1“ in the column.
Administrator 1.1 551
Administrator 71.2 552 **//2. „Inventory log“ – report of goods parameters change//**
Administrator 1.1 553
Administrator 71.2 554 [[image:104_t.png]]
Administrator 1.1 555
556
557
Administrator 71.2 558 You will see changes, which were done by users.
Administrator 1.1 559
Administrator 71.2 560 You can show filtering data in the window that opens:
Administrator 1.1 561
Administrator 71.2 562 - desired date/period. __This parameter is necessary;__
Administrator 1.1 563
Administrator 71.2 564 - user, if you know it;
Administrator 1.1 565
Administrator 71.2 566 - item (SKU code or SKU name);
Administrator 1.1 567
Administrator 71.2 568 - warehouse, where you want to see changes (Warehouse code or warehouse name);
Administrator 1.1 569
Administrator 71.2 570 - click „Show results“ after completing the settings;
Administrator 1.1 571
Administrator 71.2 572 - you can analyze filtered data in the window or export data into Excel.
Administrator 1.1 573
Administrator 71.2 574 [[image:88_pac.png]]
Administrator 1.1 575
576
577
Administrator 71.2 578 Part of changes do the StockM system automatically, then you can see in the User column for example: Period set – changes are made automatically by executing periodical actions.
Administrator 1.1 579
Administrator 71.2 580 In the column „Field“ you see what value has been changed, for example: Buffer value – the size of buffer.
Administrator 1.1 581
Administrator 71.2 582 In the columns „Before change“ and „After change“ you see what kind of information was before and after the change.
Administrator 1.1 583
Administrator 71.2 584 **3//. „Supplier settings log“ – report of supplier‘s parameters change.//**
Administrator 1.1 585
Administrator 71.2 586 [[image:105_t.png]]
Administrator 1.1 587
588
589
Administrator 71.2 590 You will see what parameters of supplier‘s were changed.
Administrator 1.1 591
Administrator 71.2 592 You can show filtration data in the window that opens:
Administrator 1.1 593
Administrator 71.2 594 - desired date/period. __This filtration parameter is necessary;__
Administrator 1.1 595
Administrator 71.2 596 - user, if you know it;
Administrator 1.1 597
Administrator 71.2 598 - supplier (Supplier code or supplier name);
Administrator 1.1 599
Administrator 71.2 600 - click „Show results“ after completing the settings;
Administrator 1.1 601
Administrator 71.2 602 - you can analyze filtered data in the window or export data into Excel.
Administrator 1.1 603
Administrator 71.2 604 [[image:89_pa.png]]
Administrator 1.1 605
606
607
Administrator 71.2 608 In the column „Field“ you can see what value was changed, for example: e-mail.
Administrator 1.1 609
Administrator 71.2 610 In the columns „Before change“ and „After change“ you see what kind of information was before and after change.
Administrator 1.1 611
Administrator 71.2 612 **//4. „Supplier schedule log“ – report of supplier‘s orders graphs change.//**
Administrator 1.1 613
Administrator 71.2 614 [[image:106_t.png]]
Administrator 1.1 615
616
617
Administrator 71.2 618 You will see changes, which were made in orders graphs.
Administrator 1.1 619
Administrator 71.2 620 You can show filtration data in the window that opens:
Administrator 1.1 621
Administrator 71.2 622 - desired date/period. __This filtration parameter is necessary;__
Administrator 1.1 623
Administrator 71.2 624 - user, if you know it;
Administrator 1.1 625
Administrator 71.2 626 - supplier (Supplier code or supplier name);
Administrator 1.1 627
Administrator 71.2 628 - warehouse (Warehouse code or warehouse name);
Administrator 1.1 629
Administrator 71.2 630 - click „Show results“ after completing the settings;
Administrator 1.1 631
Administrator 71.2 632 - you can analyze filtered data in the window or export data into Excel.
Administrator 1.1 633
Administrator 71.2 634 [[image:90_pav.png]]
Administrator 1.1 635
636
637
Administrator 71.2 638 In the column „Field“ you see what value was changed, for example: Active – activity of graph.
Administrator 1.1 639
Administrator 71.2 640 In the columns „Before change“ and „After change“ you see what kind of information was before and after change.
Administrator 1.1 641
Administrator 71.2 642 **//5. „Optimization parameters log“ – report of optimization parameters change.//**
Administrator 1.1 643
Administrator 71.2 644 [[image:107_p.png]]
Administrator 1.1 645
646
647
Administrator 71.2 648 You will changes, which were made in optimization parameters in supplier‘s cards.
Administrator 1.1 649
Administrator 71.2 650 You can show filtration data in the window that opens:
Administrator 1.1 651
Administrator 71.2 652 - desired date/period. __This filtration parameter is necessary;__
Administrator 1.1 653
Administrator 71.2 654 - user, if you know it;
Administrator 1.1 655
Administrator 71.2 656 - supplier (Supplier code or supplier name);
Administrator 1.1 657
Administrator 71.2 658 - warehouse (Warehouse code or warehouse name);
Administrator 1.1 659
Administrator 71.2 660 - click „Show results“ after completing the settings;
Administrator 1.1 661
Administrator 71.2 662 - you can analyze filtered data in the window or export data into Excel.
Administrator 1.1 663
Administrator 71.2 664 [[image:90_pav.png]]
Administrator 1.1 665
666
667
Administrator 71.2 668 In the column „Field“ you see what value was changed, for example: OptimaSize – Purpose.
Administrator 1.1 669
Administrator 71.2 670 In the columns „Before change“ and „After change“ you see what kind of information was before and after change.
Administrator 1.1 671
Administrator 71.2 672 **//6. „Orders log“ – report of actions with orders fixation.//**
Administrator 1.1 673
Administrator 71.2 674 [[image:108_t.png]]
Administrator 1.1 675
676
677
Administrator 71.2 678 You will see actions, which were made with orders.
Administrator 1.1 679
Administrator 71.2 680 You can show filtration data in the window that opens:
Administrator 1.1 681
Administrator 71.2 682 - desired date/period. __This filtration parameter is necessary;__
Administrator 1.1 683
Administrator 71.2 684 - user, if you know it;
Administrator 1.1 685
Administrator 71.2 686 - item (SKU code or SKU name);
Administrator 1.1 687
Administrator 71.2 688 - supplier (Supplier code or supplier name);
Administrator 1.1 689
Administrator 71.2 690 - warehouse (Warehouse code or warehouse name);
Administrator 1.1 691
Administrator 71.2 692 - Order number, if you know it.
Administrator 1.1 693
Administrator 71.2 694 - Etc.
Administrator 1.1 695
Administrator 71.2 696 - click „Show results“ after completing the settings;
697
698 you can analyze filtered data in the window or export data into Excel.
699
700 [[image:91_pa.png]]
701
702
703
704
705
706 In the column „Operation“ you see what action was made, for example: init – created; edit – edited; send.
707
708 In the column „Quantity“ you see the quantity, which was set.
This wiki is licensed under a Creative Commons 2.0 license
XWiki Enterprise 11.10.2 - Documentation