Banana 9

Introduction

This walkthrough provides step-by-step guidance for creating a simple extension that uses JavaScript API to interact with Banana Accounting software.

The more powerful extensions in packaged format are used for the development of extensions. But it is also possible to create an extension that is composed of just a single Javascript file. We will use this simple approach to explain how extensions work.

The Items columns in the Transactions table are used to enter quantity and price.
The amount of the transaction is calculated based on the value of the quantity and unit price column.

Add the Items columns in the Transactions table

The Items columns are added to the Transactions table from the Tools menu → Add new functionalities → Add Items Columns in Transaction table.

The columns are the following:

Introduction

All the following code samples are used in the embedded_javascript_tutorial1.ac2 file as embedded BananaApps. This file contains a list of complete and working examples that can be run.

Another complete and working example of BananaApp that use a table can be found here.

In order to install an Extension in an offline mode proceed as follows:

The steps below walk you through all the setup to run the Banana Office Add-ins for Microsoft Office 2016 or more recent.

Minimum requirements:

With this add-in you can create Excel sheet that are filled with Banana Accounting data. Once you have added transactions to the accounting file you just need to click on the Update Button of the add-in and your spreadsheet content will be updated with the new data.
Your existing formatting and formula will be preserved.

▶ Video: How to start a Cash Manager (Cash book) file. Learn how to enter and monitor the movements of your money of your cash account.

Creating an accounting file, starting from a template

Here is how to start choosing a template directly from the program:

In the following we will explain what need to be considered when creating a new BananaApps for a journal reporting.

Customization is a display or printout with customized settings that can stored. If necessary, customized documents can be resumed without repeating the settings.

Customizations is obtained from the following menus and for the following documents:

This section appears in various dialogues (eg in the account card, in the balance sheets ...) and has the function of limiting the display or processing of data only for a specified period.
If, for example, you enter a quarter, only the transactions for the quarter will be displayed in the account card and the results for the quarter will appear in the Balance Sheet.