По-русски

I.T. Smart Systems has included the property of Volkswagen Group Rus in the balance sheet

28.02.2012

I.T. Smart Systems has included the property of Volkswagen Group Rus in the balance sheet
I.T. Smart Systems Company (I.T. Group) has completed the implementation of the solution for accounting and inventorying the property in Volkswagen Group Rus LLC. The system created in the course of the project allowed performing primary accounting of the property and collecting up-to-date data on its availability and state.

Volkswagen Group Rus LLC was established by Volkswagen AG at the beginning of 2003 and united two Russian affiliate companies of the group. One of them was registered in Moscow and acted as an import structure managing the car sales. The second one was founded in 2006 in Kaluga to manage a new plant where Volkswagen and Škoda cars are assembled.

Until recently, Volkswagen Group Rus LLC has been storing the information on telecommunication/IT equipment and other property subject to accounting in several systems, and these data had to be synchronized, sometimes manually. The customer was not satisfied with such situation, that was why it was decided to implement a specialized system which would allow the company management to have up-to-date and accurate information on material resources at any time. Moreover, moving into a new office allowed taking an effective inventory of the property and disposing of the accumulated surpluses and illiquid assets.

In the course of the project, the specialists of I.T. Smart Systems made the necessary inspection and relying on its results performed implementation of the system of property accounting and inventory automation. Besides, marking of 4.5 thousand units of equipments (using RFID-tags and stickers with two-dimensional bar codes) and initial inventory were performed. The results allowed the customer setting the requirements to new forms of reports, and I.T. Smart Systems specialists managed to make the required improvements.

Implementation of the property accounting and inventory system in Volkswagen Group Rus LLC enabled to solve several important tasks. Among them is the reduced time and simplification of the inventory process ensuring complete transparency in the area of the current accounting of the property, reduced quantity of errors in verification of the inventory results, as well as lower material expenses for the property acquisition.

In the near future, Volkswagen Group Rus LLC is going to perform full transfer of all its material resources to automated accounting. Besides, the company is planning to integrate the accounting and inventory system with the bookkeeping system.


Module: advertising
Class: CAdvBanner
File: /var/www/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetPageWeights_RS
Line: 943
MySQL Query Error: SELECT DISTINCT B.TYPE_SID, B.ID BANNER_ID, B.WEIGHT BANNER_WEIGHT, B.SHOWS_FOR_VISITOR, B.FIX_CLICK, B.FIX_SHOW, B.KEYWORDS BANNER_KEYWORDS, DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FIRST, DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, B.FLYUNIFORM FLYUNIFORM, B.MAX_SHOW_COUNT MAX_SHOW_COUNT, B.SHOW_COUNT SHOW_COUNT, C.ID CONTRACT_ID, C.WEIGHT CONTRACT_WEIGHT, C.KEYWORDS CONTRACT_KEYWORDS FROM b_adv_type T INNER JOIN b_adv_banner B ON ( B.ACTIVE='Y' and B.TYPE_SID = T.SID and B.STATUS_SID = 'PUBLISHED' and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='Y') and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_banner_2_site BS ON ( BS.BANNER_ID = B.ID and BS.SITE_ID = 'en') INNER JOIN b_adv_contract C ON ( C.ID = B.CONTRACT_ID and C.ACTIVE='Y' and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_contract_2_site CS ON ( CS.CONTRACT_ID = B.CONTRACT_ID and CS.SITE_ID = 'en') INNER JOIN b_adv_contract_2_type CT ON ( CT.CONTRACT_ID = C.ID and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID)) INNER JOIN b_adv_banner_2_weekday BW ON ( BW.BANNER_ID = B.ID and BW.C_WEEKDAY='FRIDAY' and BW.C_HOUR = '7') INNER JOIN b_adv_contract_2_weekday CW ON ( CW.CONTRACT_ID = C.ID and CW.C_WEEKDAY='FRIDAY' and CW.C_HOUR = '7') LEFT JOIN b_adv_banner_2_group UG1 ON ( (UG1.BANNER_ID = B.ID and UG1.GROUP_ID in (2) and UG1.GROUP_ID<>2) ) LEFT JOIN b_adv_banner_2_page BP1 ON ( BP1.BANNER_ID = B.ID and BP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_banner_2_page BP2 ON ( BP2.BANNER_ID = B.ID and BP2.SHOW_ON_PAGE='N' and '/en/media-center/news/3648/index.php' like concat(BP2.PAGE, '%')) LEFT JOIN b_adv_contract_2_page CP1 ON ( CP1.CONTRACT_ID = C.ID and CP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_contract_2_page CP2 ON ( CP2.CONTRACT_ID = C.ID and CP2.SHOW_ON_PAGE='N' and '/en/media-center/news/3648/index.php' like concat(CP2.PAGE, '%')) LEFT JOIN b_adv_banner_2_stat_adv BA ON BA.BANNER_ID = B.ID LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND ( ( (B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY') AND BC.COUNTRY_ID='' ) OR ( B.STAT_TYPE='REGION' AND BC.COUNTRY_ID='' AND BC.REGION='' ) OR ( B.STAT_TYPE='CITY' AND BC.CITY_ID='0' ) ) WHERE T.ACTIVE = 'Y' and ( B.STAT_COUNT is null or B.STAT_COUNT = 0 or BC.BANNER_ID is not null ) and BP2.ID is null and CP2.ID is null and (BP1.ID is null or '/en/media-center/news/3648/index.php' like concat(BP1.PAGE, '%')) and (CP1.ID is null or '/en/media-center/news/3648/index.php' like concat(CP1.PAGE, '%')) and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0') and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='') and ( (B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null) or (B.SHOW_USER_GROUP <> 'Y' and UG1.GROUP_ID is null) ) ORDER BY B.TYPE_SID desc, C.ID desc [Got error 28 from storage engine]

DB query error.
Please try later.