• Introduction

    Jiwa Financials

    Jiwa Financials is an Australian owned and operated company. First implemented in 1995, the Jiwa software has continually evolved in its functionality to meet customer requirements and to take advantage of the latest technologies.

     

  • Things You Should Know

    Understanding the Benefits

    Fundamentally, Jiwa Financials is going to be different to the system you are using now. It has been built by a different team and is most likely aimed at different market from your current software. But that difference is a good thing

  • Online Demonstrations

  • Reports in Jiwa

  • Jiwa in the Cloud

    Jiwa Anywhere Anytime

    JBy hosting Jiwa in the cloud, your ERP system will be available to you Anywhere and at Anytime.

     

  • Our Clients

    Our Partnership with you

    Austlink has been in business in one form or another  for over 28 years. A number of our clients have been with us that entire time. We see our role as a partner in your business helping you to become more efficient and to grow.

     

  • Your Investment

    Options for Finance

    Obtaining finance for your new business or accounting software can be a very wise decision. Not only will you free cash to grow your business but you can claim the GST for the whole purchase up front at your next BAS Return.

     

  • Generate Your Own Proposal

    Help Us Understand Your Business

    Would you like us to provide you with an initial proposal? To do this we need to ask you a couple of questions about your business. The more information you give us the better our estimation will be.

     

  • The Implementation Process

    A Step by Step Approach

    Once you have decided to go ahead, we start the process with an Implementation Plan. This takes the form of a Requirement Scoping and Review of current processes. Once we are both happy with the plan we will move to a phase of software installation and training..

     

  • Ongoing Support

    Our Partnership with You

    The end of the implementation is just the beginning for us. We are here to support you each day with any issues you may want help with.

     

Integration and Customisation

I have created a video below on how to extract data from Jiwa Financials to Excel.

 

There are two methods, a simple copy and paste method and a more complected direct SQL connection method.

Extract Data from Jiwa Financials - Simple Method

This first method is a simple copy and paste from any of the Jiwa Transaction Grids.

 

Just right click on the grid header and choose "Select All"

 

Then use Ctrl-C (the Control Key and the "C" Key together) to copy the selected data

Now open Excel, right click on a cell and select to paste.

 

The contents of the Jiwa Transaction grid will now be available to you inside Excel

Extracting Data from Jiwa Financials via a Report - Simple Method

Another way to extract data from Jiwa is to use the report system which is based on Crystal Reports.

 

Select a report from the menu, tick "Print to Screen" and press the printer icon

From the report tab click on the export button

Select a location, a file name and choose a type of "Microsoft Excel"

Now locate the file you saved and open it. Your data will now be in Excel

Extract Data from Jiwa Financials - Advanced Method

Another way to extract data from MYOB Exo or indeed any other Microsoft SQL data source is to us the data connectivity features within Excel to create a direct connection to the Microsoft SQL database.

 

In Excel select the data tab and the "from Other Sources" button

Select "From SQL Server"

Enter in your SQL Server Name and Credentials

Select your Jiwa SQL database and the table you want data from and press "Finish"

Select the cell you want the data to be copied into and press "OK"

Enter in your credentials again and press "OK"

The data from the chosen table will automatically flow into Excel

If you know a bit of SQL you can edit the Query. Right click on your data and select "Table" and "Edit Query"

Modifying the SQL Query

To update your data just right click anywhere on the data and select "Refresh"

Change the "Command Type" to "SQL" and enter in your SQL statement in the "Command Text" box below

Enter in your Credentials and press "OK"

The data returned will now be modified in line with your new SQL Query

The data returned will now be modified in line with your new SQL Query

Austlink Plus Pty Ltd

2017 © Copyright All Rights Reserved

1300 766 812