Algotech

CZECH LEGISLATIVE LOCALIZATIONS
ORACLE JD EDWARDS

All proposed Algotech Czech localizations for JD Edwards EnterpriseOne have required outputs (printed or in XML) in Czech language (Balance Sheet, Income Statement, Cash Flow Statement, Statement of Changes in Equity, Statutory VAT Statement, VAT Control Statement, EC Sales List, Intrastat). User interface of JD Edwards Enterprise customized applications used for Czech localizations could be in Czech or English language.

STATUTORY FINANCIAL STATEMENTS

The Czech law requires a special form of 2 main statutory statements for Balance Sheet and Income Statement. The product allows specific mapping of each row, rounding up to whole crowns or thousands (according to the rules in the Czech Republic) and hiding zero rows. Output is selectable into PDF and XLS format or official form of financial authority. This product is also able to work with Accounts defined as a supplement Chart of Accounts in Account category.

STATUTORY VAT STATEMENT

The product provides country specific statement for VAT report, which is required by Czech Financial Authority and can be generated as detailed report or in summarized mode to be exported into xml format to be manually uploaded on the Tax Portal. Extended product contains field DUZP (Date of taxable supply) that requires Czech Tax Reporting.

VAT CONTROL STATEMENT

This product fulfils Czech legislative requirements, that all taxable persons are obliged to submit the so-called “VAT Control Statement”. Report can be generated into PDF and XLS for controlling purposes and into XML in order to be uploaded on the Tax Portal. Extended product contains field DUZP/DPPD (Date of taxable supply) and DUZP od the Supplier that requires Czech Tax Reporting.

EC SALES LIST

In addition to VAT Statement and VAT Control Statement, the European and Czech Authorities require to submit EC Sales List Report which is relevant for all the exported goods and services within the European Community. The product contains 2 print options – in Detail mode to list all the corresponding transactions of defined VAT Tax ID, in Summary mode to list the total amount of the transactions corresponding to defined VAT ID. Summary mode can be also exported into XML in order to be uploaded on the Tax Portal.

TRIAL BALANCE

Trial balance report is generated as a supporting document of all accounts for Czech Year-End Closing and is mostly used for a controlling purpose. It shows individual ledger account balances and debit and credit turnovers for a period and YTD. This report can also work with additional Chart of Accounts defined in a category and can be exported into PDF and XLS Format.

CASH FLOW REPORT

According to Czech legislative requirements, this statement is mandatory part of Closing Financial Statement for all entities. The Cash Flow statement provides information about company's cash receipts and cash payments within an accounting period, showing how these cash flows link the ending cash balance to the beginning balance.

STATEMENT OF CHANGES IN EQUITY

According to Czech legislative requirements, this statement is mandatory part of Closing Financial Statement for all entities. Statement of changes in equity shows the status of the equity and its individual components on the first day of the fiscal year, the increases and decreases during the reporting period and the status on the last day of the period.

INTRASTAT

The "Intrastat" is a compulsory report for European Community countries, but each country requires specific structure of this report. The report shows the weights and amounts of purchases and respective sales between EC countries and has to be reported to Czech Authorities at the end of each month. Our solution is prepared in format requested by Czech Authorities and includes permanent maintenance of all statistic Intrastat codes (more than 10 000 codes) in accordance to the Czech legislation.

ALGOTECH PRODUCTS JD EDWARDS
ENTERPRISEONE

Expand your JD Edwards ERP system with our new products

FIXED ASSETS DEPRECIATION METHODS

Our product extends a predefined set of elements which are used to create depreciation pattern by the ones which can calculate depreciation from the net book value of an asset which is required by Czech Authorities. Moreover, as standard program can implement only mathematical rounding, our product offers rounding to whole CZK which is also requested by Czech legislation.

ASSET ITEM CARD

This product was designed to print detailed information for each individual asset (Identification, Description and Classification, Cost and accounting information, Depreciation accounting information, Summarized historical information) according to Czech legal requirements.

PAYMENT ORDERS

This product enables user to generate electronic payment orders into text file which is easy to define and which meets related bank demands. The format setup does not require any program changes and it allows both, domestic and foreign currency payment orders.

BANK STATEMENTS PROCESSING

The Bank Statement Processing product enables user to import electronic bank statements received from the banks. Moreover, it automatically generates incoming cash receipts and outgoing payments in the system which are matched to related customer invoices or supplier vouchers (if matching criteria are found). The product allows to define new electronic bank statement format with minimal additional development.

CASH DESK

Cash Desk Module is fully integrated with Oracle JD Edwards EnterpriseOne Financial Module. Every accounting document created in Cash Desk is directly transferred to General Ledger, Payables, Receivables or Fixed Assets modules according to the origin of each transaction. Cash Desk module can handle unlimited amount of cash accounts, in domestic or in foreign currency.

VOUCHER REGISTRATION BOOK

Voucher Registration Book (VRB) ensures the Workflow of Supplier Vouchers within the Company before they are posted to Accounts Payable Ledger. This functionality includes registration and simple flow of Vouchers through the Company with approval process included. VRB is fully integrated with Accounts Payable Module.

INTERFACE FOR PAYROLL SYSTEM

This product is designed to integrate Accounting data received from any Payroll System used in Czech Republic with JD Edwards EnterpriseOne General Ledger. It works with predefined format of text file and is supposed to be run each month after Payroll processing is done.

INTERNET EXCHANGE RATES IMPORT

According to Czech legislative requirements, Exchange Rates defined by Czech National Bank (CNB) should be used to post transactions in foreign currencies. Our product was created in order to integrate CNB Exchange Rates with Oracle JD Edwards. The whole process is fully automated, does not require any user interaction and can be set to be run regularly according to user preferences (daily, weekly, monthly...).

ARES INTERFACE

ARES Interface allows user to verify Czech Identification Number (IC) of the partner originated from Czech Republic on ARES Portal and automatically imports his basic data into appropriate fields in Oracle JD Edwards. The whole verification is done online when user creates a new entry of the partner in Address Book.

WIP ACCOUNTING

Due to the specific requirements in Manufacturing WIP Accounting defined by Czech Law, we have created modifications of standard applications for Journal entries (P31802) and Variances (P31804) which ensure correct posting of all transactions. These modifications can be used for batch versions R31802A and R31804, too.

INVENTORY CYCLE COUNT UPDATE

According to Czech legislation, Cycle Count Variances cannot be posted to the same Offset Account, positive and negative variances should be posted separately. This requirement cannot be fulfilled by standard program for Cycle Count Update, as it books both positive and negative variances to the same account in General Ledger. The product extends standard Cycle count update program to allow this requirement to be fulfilled.

UNRELIABLE VAT PAYER VALIDATION

According to Czech legislative requirements, it is not possible to pay to the Bank Account of an entity if this Bank Account is not published on Reliable VAT Payer Register. Our product of Unreliable VAT Payer Validation was created in order to validate bank account of a partner before the Payment Order is created. In case of any deviation, user is able to reset the payment from the payment group as our product is implemented as a supplement to standard application for Payment Orders.

INVOICE PRINTING FROM AR MODULE

The Invoice Print Report from AR module was created in order to fulfil all Czech business requirements. In addition to standard Invoice Print Program, it automatically prints all necessary phrases which should be used according to the origin of products or services, it works with advanced payments, tax documents and prints necessary tax summarization.

GDPR – DATA ANONYMIZATION

Based on the GDPR Regulation, we prepared a solution to anonymize personal data within Oracle JD Edwards. Our so called "GDPR Module" solves the issue of personal data storage in the database of Oracle JD Edwards, searches and identifies the data according to the relevant criteria and processes the data anonymization itself. Supporting report of the anonymized data is included.

ACCRUALS PROCESSING

This product was created in order to solve the requirement of Accruals processing within Oracle JD Edwards, as standard functionality does not allow user to connect accruals to the original documents. The product solves the possibility to create additional documents for existing records (invoices) in General Ledger so the simple link of the original invoice to the corrective document is preserved. Moreover, it ensures an automated journal entry processing for the accrued amounts which means periodic (monthly) accounting entries spread over a specified number of months.

AP/AR NETTING

The product for AP/AR Netting was created as modification of standard AP/AR Netting application which has been changed in order to meet Czech legislative requirements. In Czech Republic, it is not allowed to transfer invoices between AP and AR Ledgers and to create Netting before it is approved by both partners. Our product ensures that the invoices are blocked for payment until the approval is received, close the invoices in their original ledger and allows users to print the official letter of the proposed netting clearing.

CONFIRMATION LETTERS

At the end of the period (usually at the end of the year), suppliers send the confirmation letters to its customers in order to confirm the status of its receivables. In order to simplify this process, we have created new program which automatically generates confirmation letters for the selected customers in different languages and form defined by the user.

AS OF REPORT FOR OPEN RECEIPTS

According to the Czech legislative requirements, it is necessary to list all the open receipts at the end of the period and book them to accruals accounts. Standard Open Receipts report cannot perform As of date processing which is required in this case. Our product was created in order to track the history of the receipts processing which ensures that As of day report can be produced.

ALGORADAR

Due to the increasing demand coming from Czech Authorities to regularly check all Business partners, we have created a product which can help our users to automate a review of the Business Partners existing in Oracle JD Edwards. This product includes: Data collection from official registers (Register of VAT payers, ARES, VIES, Insolvency Register, Collection of instruments), Continuous Controls according to selected parameters, Audit and Reporting.

REGLETTE – STOCK MOVEMENTS

The product called "Reglette" is a stock report frequently used in Czech Republic (France, Germany, etc.). It shows amounts and quantities of stock movements within a specified period.

ALGOTECH JD EDWARDS SUPPORT SERVICES

Algotech has a long-term model of providing JD Edwards Support Services for several companies located in the region of Central Europe. Our support is provided by default in English language and is operated from Czech Republic.

JD Edwards Service Desk

Our Service Desk will take care of all your requests and problems

Single point of contact with customer

24x7 accessibility via phone, email or Web Service Desk application

Solution of the customer tickets or further escalation to next tier

Escalation and communication with Oracle

Ability to match customer processes needs

JD Edwards system reporting

Regular and ad-hoc reports make you sure, that your system is running perfect

Regular and ad-hoc reporting

Customer’s tickets overview

SLA reports

Performance and issue reports

JD Edwards technical consulting

Everything you need to know for developing, using and administration of your system

CNC work, packaging

Database migrations

Software installation, updates (ESUs) and upgrades (ASUs)

Software foundation updates (Tools Releases)

Technical upgrades

Clustering and Load Balancing

Architecture and design

Server sizing

JD Edwards server’s virtualization

Administration

Process optimization

Workflow optimization

JD Edwards system proactive monitoring

Can you imagine that any technical issue connected to your JD Edwards can be solved before you knew it has ever existed? With our monitoring tools we know what is going on with your JD Edwards at any time. When there is a sign of nonstandard conditions or behavior we can immediately respond and avoid further failures leading to more serious issues.

JD Edwards systems are monitored in our central support center 24x7x365 in the Czech Republic.

JD Edwards system performance review

We can monitor and evaluate JD Edwards’ s performance indicators, so you know the load of your system and where the bottlenecks are. Based on gained information we can prepare further steps to remove these bottlenecks.

Detailed analysis of performance issues

Performance indicators evaluation

Steps for bottlenecks removal

JD Edwards system changes and support administration

Packages installation

Backups

User administration

Security rules setup

JD Edwards system run control

JD Edwards periodic checks by administrator make sure everything goes fine

Disk space validation

Systems’ logs validation

Database shrinks

JD Edwards integrity checks

Disaster recovery plan

Data archiving and purging

JD Edwards system security administration

Long user ID's and passwords support

HTTPS communication

LDAP and Single Sign-on configuration

Encrypting sensitive data in EnterpriseOne