Integration of 1C and SAP 3PL warehouse system

Client

Activity: Wholesale of products for fast food restaurants. More than 100 shipments per day. 3PL warehouse services are provided by a specialized company.

Objectives

Automate the exchange of data on warehouse operations in Moscow and St. Petersburg:

  • receipts
  • shipments
  • interstore transfers
  • returns
  • daily stocktaking
  • delivery routes

Automate the exchange of counterparty and nomenclature data.

Methods of integration

  • Exchange of xml files via the logistics partner portal. The exchange takes place in the background in both directions.

Results:

  • Real-time information exchange with 3PL warehouse
  • Real-time tracking of information shipment statuses
  • Ability to plan and control shipments taking into account current information from the warehouse

by Konsu Administrator

Integration of 1C and Oracle Opera

Client

Russian company with foreign participation.

Activity: Hospitality business.

Objectives

Opera is an accounting system for collecting data on guest stays and related services.

Tasks:

  • Uploading data on invoices issued to guests for accommodation services to 1C:BP
  • Daily receipt of revenue data from all hotel terminals

Methods of integration

  • Exchange of csv files via ftp. Control of changes in previous periods.

Result:

  • Reduced communication between back office and accounting staff
  • No need to enter data twice in different systems
  • Daily collection of voluminous data in the context of various revenue analytics
  • Automatic issuance of sales documents for buyers of legal entities

by Konsu Administrator

Integration of 1С & Oracle Materials Control

Client

International company.

Activity: Hotels.

Objectives

Oracle Materials Control – product accounting system for hotel catering.

Requirements:

  • Upload from Oracle Materials Control to 1C data on written-off products, alcohol for correct cost accounting
  • Accounting by nomenclature is performed in Oracle Materials Control. In 1C - simplified accounting only for calculation purposes
  • Collection of cost accounting data in the context of restaurants, hotel bars and in the context of types of expenses

Implemented solution

  • Exchange of csv files via sftp.
  • Control of changes in previous periods.

Result:

  • Reduced communication between back office and accounting staff
  • No need to enter data twice in different systems
  • Timely receipt of information on inventory and shortages by the accounting department

by Konsu Administrator

Integration of 1C and Cargowise

Client

International logistics company: road, rail, air transport.

Objectives

Cargowise - a system for operational accounting of logistics operations. Required:

  • Upload of invoicing data to 1C BP
  • Upload to 1C BP data on sales by analytics of individual shipments
  • Maintain accounting and grouping of Revenues/Expense by transportation numbers from Cargowise
  • Upload to 1C BP data on invoices of transportation service providers, including agency contracts

Integration solutions

  • Exchange of xml files via ftp.
  • Control of changes in previous periods.

Results:

  • Reduced communication between back office and accounting staff
  • No need to enter data twice in different systems
  • Timely receipt of information on realizations by accounting department
  • Tracking of transportation profitability in 1C BP

by Konsu Administrator

Customization in “1C:Comprehensive automation” of invoice file upload and customs cargo declaration at import

Client

A Russian company with foreign founders.

Activity: Wholesale trade in machinery, equipment and tools for agriculture.

Objectives

Develop and implement in 1C:Integrated Automation a block for uploading Excel file with invoice and XML file with GTC from customs.

Term: 1 month.

Work stages

  • Development of a file template for uploading.
  • Agreeing the file format with the broker.
  • Setting up the upload in 1C:CA.
  • Connection of users to the upload.

Reduction of labor costs and minimization of errors in the process of receipt of goods on more than 100 items from the supplier-importer and automatic loading of GTE with a breakdown by sections.

by Konsu Administrator

Upgrade from 1cupp 1cka outsourcing functions en konsu outsourci

Upgrade from 1C:UPP to 1C:KA, outsourcing IT functions, automation of IFRS reports

Client

  • Supplying fast food outlets
  • Accounting in 1C:UPP (1C:management of production companies)
  • 100 employees
  • More than 8000 documents per month

Objective

Requirements:

  • Upgrade had to be performed without disruption of services and operating activities of the client

Implementation stages

  • Development of scripts for transfer of directories and balances from 1C:UPP into 1C:KA
  • Analysis of client processes in 1C:UPP. Adaptation of all custom modules for the new version of 1C software including IFRS modules
  • Adjustment and automation of all integrations: 1C:Document management, 1C: Payroll&HR, EDM, EDI and other client services
  • Daily support through ticketing tool, which allows client to optimize costs for IT administration

by Konsu Administrator