Auto-can

Robotic Process Automation

Renault Mais:

Dealer Code Change on As400 System:

When done manually:

Hundreds of lines were creating new dealer codes by manually entering their dealer codes one by one into the as400 system.

When done by the robot:

They keep the old dealer codes and new dealer codes in an excel.
We taught the robot to take the old dealer codes from the relevant excel, enter it into the as400 system, and print the new dealer code to a column in the relevant excel.
Thus, the error rate due to manual human doing this job was reduced to zero.
And by performing this process by the robot, the process was completed very quickly.

Placing an Order on the French System (Website):

When done manually:

There was a lot of time spent every day for spare parts orders that were transferred from the spare parts warehouse to France in Bursa. And this job took an employee all the time.

When done by the robot:

A list of the orders to be sent to France was collected in an excel, and the robot was able to read the lines in this excel one by one, enter the relevant website and create an order.
Performing this job with the robot has become very useful in terms of time and in terms of reducing the margin of error to zero.

Projects We Realized

Sepaş:

Invoice Post Field Study:

A process that runs a badge in SAP in the monthly invoicing process of Sepaş

Subscription Transactions:

The process that receives the relevant month-related information from SAP, downloads it in XML Format, checks and updates it in XML Tags

Invoice Transactions:

The process that receives the relevant month-related information from SAP, downloads them in XML Format, checks and updates XML Tags and divides them into 4 parts

Btrans Loading:

The process that uploads the files generated at the end of the Subscription and Invoice Processes to the Btrans website

Osos Data Extraction:

The process that receives data from the Osos website at 7 o'clock in the morning, saves it in Excel, and then sends it to the relevant people as excellence

Lüy Invoice Process:

The process that enters the SAP System by reading the information from Excel and saves the SAP output to the Excel file

Lüy Invoice Process Mailing:

Sending e-mails individually or collectively to people who have information in excel for lines in the same Excel

Completing the Lüy Invoice Process:

The process that checks the data previously created in SAP and takes action if an update has arrived and informs the different department after all excel jobs are finished

Akkim:

Hedef Araç Kiralama Faturalarının Girilmesi :

efatura sistemine gelen ilgili faturaları indiren, indirdiği faturaları tiplerine göre ayrıştırıp farklı tipler için Oracle üzerinde farklı işlemler yapan process.

Setur Faturalarının Girilmesi :

efatura sistemine gelen ilgili faturaları indiren, indirdiği faturaları tiplerine göre ayrıştırıp farklı tipler için Oracle üzerinde farklı işlemler yapan process.

Mal Kabullü Faturların Girilmesi :

efatura sistemine gelen faturalardan mal kabulünün yapılmış olanların bilgilerinin Database’den sorgulanıp dönen cevaba göre Oracle ve efatura sisteminde işlemler yapan process.

Akpa Faturalarının Aktarılması ve Girilmesi :

Oracle sistemine gelen Akpa faturalarının efatura sistemi üzerinden kontrol edilmesi ve eğer efatura sisteminde varsa dosyanın XML formatının indirilerek Oracle girişlerinin kontrol edilmesi ve kurala göre farklı tiplerde ki faturalarda Oracle üzerinde farklı işlemler yapılmasını sağlayan süreç.

Aksa Akrilik:

Aksa Accounting BA / BS process:

Data is entered into Oracle by the robot.
BA and BS forms are created for the month entered in Oracle by reading the relevant period information from the txt file.
The created pdfs are divided according to the company names and saved in a folder.
Then the recorded files are sent to the e-mail address in the relevant pdf.
Returns are taken from the web interface and saved in an excel file.
When the robot is restarted, the previously stored pdfs are separated according to their categories according to the IDs in the existing excel and mail is sent again.

Aksa Purchase (iSupplier) Process:

Data is entered into Oracle by the robot.
After the relevant Oracle form is opened, the category information to be processed is read from excel and entered into the relevant field on Oracle.
After selecting the items, the purchase requisition is created and the iSupplier (web) page opens.
The purchase request is created by filling the relevant fields on this page.

Aksa Release Process: :

Data is entered into Oracle by the robot.
After the relevant Oracle form is opened, the information in the excel is entered into the Oracle form with certain rules.

Akkök Holding:

E-Invoice - Oracle XML Introduction:

The data to be matched according to the relevant XMLs and XML information are included in an excel. After logging into Oracle with the robot, the fields are filled in the framework of certain rules and the taxes are calculated and entered.

Akpa:

Oracle XML Introduction:

İlgili XML’ler bir klasörden okunarak Oracle’a girişleri yapılır.

Oracle ERGO Invoices Introduction:

Information is read from digital pdfs and entered to Oracle.

Oracle Invoice Collection Matching (3 units):

Data is read from Excel and logged into Oracle.

Oracle Bank Charge Invoicing (2 units):

Data is read from Excel and logged into Oracle.

UNSPED Customs Directorate:

TPS Registration:

The data are read in excel and entered to the relevant website.

Declaration Entry:

The data are read from Excel and the relevant website is entered.

Tareks Registration:

XML file is created from excels according to certain rules and added to the website.