Inter-Database Trading

When parts of your organization trade with one another, especially across databases, the paperwork can be excessive and wasteful. Abel’s inter-company and inter-database documents both minimize and automate your trading and financial transactions

Print Page

Abel features

  • Inter-Database Trading

    Inter-Database Trading

    Abel’s Inter-database trading means you can create a document in one database, and Abel automatically creates a corresponding document in another database, reducing manual work normally required and therefore reducing errors.

    Abel’s inter-database trading can be used between any two organizations that trade with one another provided they both use Abel. They are most often used between different databases within the same Abel installation but can also be used to trade business to business with your customers or suppliers if they also run Abel.

    As any multi-location business knows, separate locations or business units often have a very high degree of interdependence and share multiple inter-company transactions. These include buying goods for each other and also often locations transferring inventory, manufacturing goods, paying creditors, receiving debtor payments or paying for goods on behalf of each other.

    All these transactions require specialized accounting processes. To simplify and unify this process, Abel provides inter-company documents that are automatically produced in the host location and subsequently transferred to the remote location. Each document performs the correct accounting necessary to balance the accounts on consolidation.

  • Branch Transfers

    Branch Transfers

    Abel’s Inter Branch documents can be used for both stock and non stock transactions. They use an inter-company accounting approach and can move stock or make adjustments between two databases e.g. Corporate Office can post a payroll total to a branch.

    A Branch Invoice document can create a Branch Transfer document in another database. This can be used for stock transactions as stock is moved between branches. The Branch Invoice / Branch Transfer may be part of a larger document chain as shown in the below diagram. In this example, when the Branch Transfer is posted, it links back up with the original Supplier Purchase Order.

    Branch Invoice / Branch Transfer can also be used for non stock transactions – adjusting anything between two databases e.g. Corporate Office charging a payroll figure to a branch. While inter database documents for stock transactions are posted immediately, inter-database documents for non-stock financial adjustments can be kept open. Users or system processes can add lines for adjustments / transfers as they are needed. At the end of the month (or week or day) click Post then click Transfer to create the reciprocal document in the remote database. Staff in the remote database can review the Branch Transfer before posting it. You can optionally use a Branch Debtor and Branch Creditor for inter-branch settlement.

    Abel’s Branch Transfer architecture can handle different currencies and different tax regimes.

  • Inter-Database Stock Processes

    Inter-Database Stock Processes

    Abel’s inter-database client documents are used for inter-database stock processes and manufacture-for-stock processes between databases. They can be used to complete customer orders using stock from other branches or for other stock processes between branches. They can also be used between an installation and its customers or suppliers if they also run Abel.

    The inter-database stock processes are an alternative to the Branch Invoice / Branch Transfer approach. They can accomplish similar results. The Inter-Database Stock Processes can be configured in two different ways:

    • With invoicing or
    • With inter-company accounting

    With Invoicing

    Inter-Database Stock with Invoicing uses a “sale and purchase” accounting approach and does not perform inter-company accounting. The inter-database documents used for this configuration are:

    • Supplier Order to Customer Order
      A Supplier Order creates a Customer Order in another database.
    • Customer Despatch to Supplier Delivery
      A Customer Despatch creates a Supplier Delivery in the other database.
    • Customer Invoice to Supplier Invoice
      A Customer Invoice creates a Supplier Invoice in the other database.

    With Inter-Company Accounting

    This option for managing inter-database stock uses an inter-company accounting approach. The inter-database documents used for this configuration are:

    • Supplier Order to Customer Order
      A Supplier Order creates a Customer Order in another database.
    • Customer Despatch to Supplier Delivery
      A Customer Despatch creates a Supplier Delivery in the other database.

  • Inter-Database Customer Invoices

    Inter-Database Customer Invoices

    Abel’s inter-database Customer Invoice Transfer enables you to copy a customer invoice to another database where it will complete its life-cycle. It is most often used for managing large debtor accounts that are managed centrally or nationally.


    • A Branch raises an invoice and then transfers it to a central debtor where it will complete its life-cycle.
    • The transfer process settles the customer invoice in the branch and creates it in the central database.
    • Staff in the central database send all invoices to the customer and the customer makes one payment.

    The invoices are then settled in the Central database debtors.

What our customers say:

  • Paul Brown

    co-founder - Deep Creek Brewing Company

    "“Working with Abel went as well as I could expect. We changed from three different software systems to one integrated system and it was working perfectly within a month.”"

  • Gavin Thwaites

    Chief Executive Officer - Dairy Technology Services

    "We couldn’t be happier with Abel,” he says. “Automating our processes has made us so much more efficient. We have fewer people working on manual tasks, we’ve cut costs and we now have the traceability and visibility we needed across our business. That’s making it easier for the whole organization to succeed."

  • Kyle Osborne

    Director - NZ Drinks

    "For NZ Drinks, automation was a great decision, and Abel’s robustness and flexibility provides us with a great foundation for growth,” Kyle says. “If we wanted to quadruple our business tomorrow, we wouldn’t have to change anything."

  • Peter O’Connor

    General Manager - Disc Brakes Australia

    "Once you configure Abel to suit your business processes, it just delivers. You get a system that can handle a very high level of complexity which would cost a lot more if you went anywhere else. I hate to think where we might have been today without Abel."

  • Cory Nielson

    Director of Information Technology - Alsco

    "Abel spent time getting to know how our business works and how to make us better. Our accountants are all amazingly surprised how much the new system has simplified their lives. We’ve already reduced the time for closing our monthly reports from nine or ten business days to four."

View Our Case Studies
Latest Abel News

The Right Stock Types Help you Manage Stock Efficiently.

September 18, 2020

Having the right groupings of stock can streamline workflows and support differentiated processing, for example in stock takes and in reorder processing, helping you manage your stock more efficiently. Abel ERP’s stock types are configurable to suit most requirements. They… Read more »


Read More >