Configuring Accounts from A to Z

Configuring Accounts from A to Z

Configuring Accounts from A to Z

Accounts have be configured to meet your company’s needs. This chapter explains how to modify your chart of accounts, journals, access rights, initial account balances and default values for the initial configuration of your ATS-ERP accounts.

Good accounting software requires great usability and simplicity of data entry, as well as flexibility in configuring its different components. You should be able to easily modify the accounting module to meet your own needs, so that you can optimise it for the way you want to use it.

ATS-ERP lets you adapt and reconfigure many functions to ease the task of data entry:

  • adding controls for data entry,

  • customising the screens,

  • filling fields automatically during data entry with data that is already known to the system.

Banking Systems

Banking Systems


A comprehensive, integrated yet modular agile business solution
Addresses all the core needs of the bank, in easy-to-configure modules
Multi entity capabilities to support multiple legal entities, across various geographies, currencies and time zones on a single instance of application

Easy to configure modules and components


Core Banking Systems

Web Banking
Term Deposits


User Guide

Fixed Assets

Fixed Assets


This ERP-Solution business process supports both Preventive and Corrective Maintenance. It was developed with integration of current ERP-Solution objects in mind. Equipment maintenance is required for mobile equipment (e.g. buses, trucks, etc.) and fixed plant equipment (e.g. conveyor belts, crushers, etc.). Mobile equipment maintenance is a much more complex business process than fixed plant maintenance due to the rather randomly operational environment where maintenance occurs, fixed plant maintenance requirements is mostly considered a subset of mobile equipment maintenance requirements. This development was designed to cover mobile equipment maintenance and, hence, supports most fixed plant maintenance requirements.


Asset Group

Customer Service

  • Deliver Assets
  • Customer Assets
  • Asset Delivery Details
  • Registration Attributes
  • Registration
  • Asset Delivery Month

Asset Transactions

  • Project Create Asset
  • Asset Addition
  • Asset Disposal

Depreciation Processing

  • Depreciation Expense Entry
  • Post Depreciation Entry
Manufacturing Management

Manufacturing Management


Manage bill of materials, plan manufacturing orders, track work orders

ATS-ERP Solution Manufacturing provides functionality to support the manufacturing requirements of the small to mid-sized discrete manufacturing industry. It was introduced to Compiere in version 3.6
It enables you to manufacture items, sub-assemblies and finished goods requiring multiple mandatory and optional manufacturing operations. You can track moves and costs related to labor, material and scrap at each step.

ATS-ERP Solution Compiere Manufacturing helps companies to streamline and automate critical business functions resulting in lower manufacturing cost and improved efficiencies. It is a tightly integrated manufacturing solution providing tight production control, cost management and reporting.

Parts and BOMs
Validate BOM Flags
Verify BOM Structure
Rollup BOM Cost
BOM Viewer
Quality Test
Part Type
Universal substitution
Indented Bill of Material
Replenish Report incl.

Bill of Materials and Components

Using Bills of Materials

Bills of Materials are documents that describe the list of raw materials used to make a finished product. To illustrate the concept of specification, you will work on a shelf (or cabinet) where the manufacturing plan is given by the figure


To see the bill of materials in tree view, use the menu Manufacturing ‣ Products ‣ Products then select the product and choose Product BOM Structure from more button


Use ATS-ERP Solution to manage all your assembly and/or manufacturing operations. Schedule manufacturing orders and work orders automatically. Review planning with the smart kanban and gantt views. Use the advanced analytics features to detect bottlenecks in resources capacities and inventory locations.

Efficient Scheduling of Manufacturing Orders

Automatically schedule manufacturing orders and work orders based on your procurement rules, quantities forecast and dependent demand

Have the flexibility to create multi-level bills of materials, optional routing, version changes and phantom bills of materials. You can use BoM for kits or for manufacturing orders.


Flexibility In All Operations

Manually edit all operations at any stage of the process. With Odoo, you won’t be frustrated by a rigid system. You can design specific templates for each operation and use the set of tools to find solutions for any issue.






Schedule Work Orders
Check resource capacities and fix bottlenecks

Define routings and plan the working time and capacity of your resources. Quickly identify resource requirements and bottlenecks to ensure your production meets your delivery schedule dates.

A Productive User Interface
Work with lists, calendars or Gantt charts

This ATS-ERP Business Solutions software allows you to organize manufacturing orders and work orders in any way you like. Process upcoming orders from the list view, control in the calendar view and edit the proposed schedule in the Gantt view.

mrp-work-orders planning


Fully Integrated with Operations

Sales, purchases, inventory and accounting integration
Fully integrated with sales, purchases and inventory modules and programs to make manufacturing resource planning accurate. The accounting integration allows real time accounting valuation and deeper reporting on costs and revenues on your manufacturing operations.




product-01 img_03

img_01   penproduct

delivery_scrap    test-gridcusst

300px-POEEvolution01    po-01


bill_of_material-01  mrp_routing

mrp_05   mrp_stock_location_form





The Purchasing Process in ERP Business Solutions covers the business processes required for the creation of requisitions, purchase orders, receipt of vendor invoices, and payment processing. The functionality is tightly integrated with Material Management. In traditional systems, this functionality is typically found in modules entitled purchasing and accounts payables.


  • Material Receipt
  • Purchase Order
  • Invoice (Vendor)
  • Matching PO-Receipt-Invoice
  • Matched Invoices
  • Matched Purchase Orders
  • RfQ Topic
  • RfQ
  • Requisition
  • RfQ Response
  • RfQ Unanswered
  • Open Requisitions
  • Material Receipt Details
  • Invoice Batch
  • Create PO from Requisition
Material Management

Material Management

Material Management Rules

  • Unit of Measure
  • Warehouse & Locators
  • Product
  • Shipper
  • Product Category
  • Price List
  • Vendor Details
  • Shipping Processor
  • Shipping Processor Configuration
  • Shipper Configuration
  • Product/Component Where Used
  • Vendor Selection
  • Price List Setup
  • Product Setup
  • Discount Schema
  • Freight Category
  • Product Organization
  • Warehouse Organization
  • Price List Schema
  • Promotion Group
  • Promotion
  • Physical Inventory
  • Inventory Move
  • Replenish Report
  • Product Transaction Summary
  • Cost Adjustment
  • Material Transactions
  • Product Transaction Value
  • Inventory Valuation Report

Product Attributes

  • Attribute Set
  • Serial No Control
  • Lot Control
  • Lot
  • Attribute
  • Attribute Set Instance
  • Product Attribute Grid
  • Storage Detail
  • Transaction Detail
  • BOM Drop
  • Ship/Receipt Confirm
  • Open Confirmation Details
  • Open Confirmations
  • Move Confirmation
  • Internal Use Inventory
  • Material Reference
  • Storage per Product
  • Storage Cleanup


Marketing Campaign

  • Marketing Channel
  • Sales Region
  • POS Tender Typ
  • Commission
  • Commission Run
  • Sales Setup
  • Commission Run Detail
  • Order Source

Sales Orders

  • Sales Order
  • Open Orders
  • POS Payment
  • Generate PO from Sales Order PROCESS
  • RePrice Order/Invoice
  • Quote convert
  • POS
  • Reopen Order
  • POS Terminal
  • POS Key Layout
  • Order Batch Process
  • Order Transactions
  • POS Key Generate
  • Order Detail

Sales Invoices

  • Invoice (Customer)
  • Generate Invoices
  • Generate Invoices (manual)
  • Print Invoices
  • Invoice Payment Schedule


  • Shipment (Customer)
  • Generate Shipments
  • Shipment Package
  • Commodity Shipment
  • Shipping Transaction
  • Generate Shipments (manual)
  • Shipment Details
Financial Accounting

Financial Accounting

Financial Analysis

This chapter is dedicated to statutory taxation and financial reporting from ATS ERP Business Solutions. Whether you need reports about customers and suppliers, or statements for various statutory purposes, ATS ERP Business Solutions enables you to carry out a whole range of parametric analyses regarding the financial health of your company.

Whether you want to analyze the general health of your company or review the status of an Account Receivable in detail, your company’s accounts are the place to define your various business indicators.

To show you the most accurate picture of your business, ATS ERP Business Solutions‘s accounting reports are flexible, and the results are calculated in real time. This enables you to automate recurring actions and to change your operations quickly when a company-wide problem (such as cash reserves dropping too low or receivables climbing too high) or a local problem (a customer that has not paid, or a project budget overspend) occurs.

This chapter describes the various reports and financial statements supplied by ATS ERP Business Solutions‘s accounting modules. It also describes how ATS ERP Business Solutions handles purchase and sales taxation, and the related tax reporting.

For this section you should start with a fresh database that includes demo data, with sale and its dependencies installed and no particular chart of accounts configured.

  • General Ledger and Trial Balance
  • Balance Sheet and Profit & Loss Report
  • The Accounting Journals
  • Tax Declaration
  • Management Indicators
  • Good Management Budgeting
  • The Accounting Dashboard
  • Analytic Analysis
    • The Cost Ledger
    • Inverted Analytic Balance
    • The Cost Ledger (Quantities Only)
    • Analytic Balance
    • Analytic Journals
    • Analytic Entries Analysis

General Ledger and Trial Balance

A general ledger includes accounts with their debits and credits, and shows all transactions in an account, for one period, for several periods or for a financial year.


Select the proper options and journal(s) from the above wizard to print the General Ledger. The report can also be filtered by date or by period. When you choose to print the general ledger from one date to another, or for one or more periods, you can also have the initial balances printed for the periods preceding the periods you selected. You can sort the report by date or by journal / partner


To print the Trial Balance, go to the menu Accounting ‣ Reporting ‣ Legal Reports ‣ Accounting Reports ‣ Trial Balance. This report allows you to print or generate a PDF of your trial balance, allowing you to quickly check the balance of each of your accounts in a single report. A trial balance may include all accounts (even the ones without balance), only accounts with transactions or accounts of which the balance is not equal to zero. You can print a trial balance for all posted entries (meaning entries with a Valid state) or all entries, in which case the report will also print entries in a draft state. This option is useful, for instance, when your new financial year has just been opened, and you are preparing miscellaneous entries in the previous financial year.


Balance Sheet and Profit & Loss Report

ATS ERP Business Solutions also offers a Balance Sheet and a Profit & Loss Report.

A Balance Sheet is a financial statement that summarises the assets, liabilities and shareholders’ equity of a company at a specific point in time. These three balance sheet segments give investors an idea as to what the company owns and owes, as well as the amount invested by the shareholders.


The Accounting Journals

A journal allows you to list entries in chronological order (by default according to date). Each entry posted in ATS ERP Business Solutions is recorded in such a journal. To configure the different accounting journals, go to the menuAccounting ‣ Configuration ‣ Journals ‣ Journals.


To print a Journal, use the menu Accounting ‣ Reporting ‣ Legal Reports ‣ Journals ‣ Journals. This report will show all entries per journal, e.g. sales entries, purchase entries, etc. Each transaction is mentioned, with date, reference, document number, account, partner, description and debit and credit amount. The Journal report can be printed per period and per journal


To print a General Journal, use the menu Accounting ‣ Reporting ‣ Legal Reports ‣ Journals ‣ General Journals. A General Journal will print a page per period for any journal entries posted in that period, and totalised per journal. The report will show the period, the journal, debit, credit and balance, but no details of the related entries.


  • To print a Centralizing Journal, use the menu Accounting ‣ Reporting ‣ Legal Reports ‣ Journals ‣ Centralizing Journal. A centralizing journal gives a summary per account for each journal and period of debit, credit and balance.


Tax Declaration

Information required for a tax declaration is automatically generated by OpenERP from invoices. In the section on invoicing, you will have seen that you can get details of tax information from the area at the bottom left of an invoice.

You can also get the tax information when you open a journal entry by looking at the columns to the right of each line. In the following figure , you can see the example of Journal Entry with VAT, from menuAccounting ‣ Journal Entries ‣ Journal Entries


OpenERP keeps a tax chart that you can reach from the menu Accounting ‣ Charts ‣ Chart of Taxes. The wizard will propose to display entries for the current period only, but you can also leave the period empty to see a complete financial year. The structure of the chart is for calculating the VAT declaration, but all the other taxes can be calculated as well (such as the French DEEE).


Management Indicators

With OpenERP you can also create your own financial reports. This feature is now included in standard OpenERP. Go to Accounting ‣ Configuration ‣ Financial Reports ‣ Account Reports and click Create.

Suppose we would like to create our company Balance Sheet. The first report to be created, should be a View report which will contain the final details.


To print the results, go to Accounting ‣ Reporting ‣ Legal Reports ‣ Accounting Reports ‣ Financial Report. Select the report you want to print (only reports of the View type will be displayed in the list). You can also print a report for specific periods or dates. If you select the Enable Comparison checkbox, an extraComparison tab will appear in which you can, for instance, select periods from a previous financial year. You have to give the comparison column a name through the Column Label field.



Match Order and Invoice

Match Order and Invoice

Match Order
Everything that is ordered arrives
To keep track WHEN ordered items arrives
Order lines are matched against receipt lines and invoice lines. Match Order doesn’t effect actual accounting. If commitment accounting is enabled, Match Order, effects commitment accounting.

Matched purchase orders can be viewed in the following ways:

Menu -> Requisition-to-Invoice -> Matched Purchase orders
(Window) Purchase Order -> PO Line -> Matching
(Window) Material Receipt -> Receipt Line -> Matched POs
(Window) Invoice (Vendor) -> Invoice Line -> Matched POs
Menu -> Matching PO-Receipt-Invoice
Match orderline to receipt
When an order line is matched to a receipt the following happens:

The delivered quantity of the order line is updated.
This affects the “available to promise” / “Ordered Quantity” of the product. The ordered quantity is used to determine when products are available for sale.

A Match Order document is created. If commitment accounting is enabled commitment accounting is performed.

Match Invoice
To make sure we get invoiced for what is ordered
To make sure that everything that is invoiced is received.
Invoice lines are matched against receipt lines and order lines. Match Invoice effects the accounting and to have the balance accounts correct it is crucial that this matching is done.

Match invoice line to receipt
When an invoice line is matched to a receipt the following happens

Clearing of non matched items
In current versions of iDempiere and ADempiere there’s no easy way to clear non matching items.

Some reasons for non matching items are:

We haven’t actually received everything ordered and never will.
Vendor sent wrong item (wrong size, wrong color etc)
Clearing of Match PO
There are some different cases when clearing purchase orders.

They are as follows:

Goods ordered but not received nor invoiced.
Goods ordered, not received but invoiced.
Goods ordered, partially received, not invoiced.
Goods ordered, partially received, partially invoiced.
Goods ordered, not received, partially invoiced.
As longs are the goods is fully ordered and fully received the Match PO has fulfilled it’s purpose. The order line displays Quantity invoiced as well. One question about that is that information is probably redundant and makes the matching processes more difficult.

Two tier enterprise resource planning

Two tier enterprise resource planning

Two-tier ERP software and hardware lets companies run the equivalent of two ERP systems at once: one at the corporate level and one at the division or subsidiary level. For example, a manufacturing company[who?] uses an ERP system to manage across the organization. This company uses independent global or regional distribution, production or sales centers, and service providers to support the main company’s customers. Each independent center or subsidiary may have its own business models, workflows, and business processes.

Given the realities of globalization, enterprises continuously evaluate how to optimize their regional, divisional, and product or manufacturing strategies to support strategic goals and reduce time-to-market while increasing profitability and delivering value.[30] With two-tier ERP, the regional distribution, production, or sales centers and service providers continue operating under their own business model—separate from the main company, using their own ERP systems. Since these smaller companies’ processes and workflows are not tied to main company’s processes and workflows, they can respond to local business requirements in multiple locations.[31]

Factors that affect enterprises’ adoption of two-tier ERP systems include:

Manufacturing globalization, the economics of sourcing in emerging economies
Potential for quicker, less costly ERP implementations at subsidiaries, based on selecting software more suited to smaller companies
Extra effort, (often involving the use of Enterprise application integration[32]) is required where data must pass between two ERP systems[33] Two-tier ERP strategies give enterprises agility in responding to market demands and in aligning IT systems at a corporate level while inevitably resulting in more systems as compared to one ERP system used throughout the organization.[34]