General Ledger Settings

This screen allows you to record all the data required to work with the respective Accounting Systems’ API (e.g. Xero, MYOB Account Right Live, MoneyWorks, etc.). Setting up this record correctly is pre-requisite to enabling the link to the accounting package.

Entry & Display Fields

Accounting Link:  This drop-down allows you to select the Accounting System you are linking to.

URL or Path:  This is the URL required when GETting or POSTing data to the linked Accounting system.

Common Connection: If Accounting Link is Sage Evolution Live, then this replaces the URL or Path.

Username:  This is the Username required for access to the company file in the Accounting System. (Not required for Xero)

Password:  Password required to the company file in the Accounting System. (Not required for Xero)

API Token:  Consumer Key required for access to Xero.

Private Key:  The name of the privatekey file used for authentication when accessing Xero.   This file must be stored in the Ostendo folder.  (Note:  If Accounting Link is Sage Evolution Live, then  Database Connection replaces the Private Key)

Version:  This is a display-only field. It shows the Ledger Script version number you are using.

DebugMode:  Tick this box if you want to save a debug file to the Ostendo folder each time a batch of financial records are posted to the Accounting system.

Database Path:  This is a display-only field. It shows the actual path of the Ostendo database that this link is set up for.

Buttons

Close: This will close the General Ledger Settings screen.

Add:  This allows you to add a new General Ledger Settings record. You need just one record.

Save:  This will save the current data without exiting the screen.

Cancel:  Any changes made since the last time the ‘Save’ Button was pressed will be lost.

Delete:  Deletes the General Ledger Settings record.

Set Default:  Sets the current record as the default General Ledger Settings record.

Connect:  This button allows you to test the connection to the Company File in the Accounting system.  Use this button after you have loaded all the scripts using the Update button.

Import:  This button is a drop-down menu to enable you to import General Ledger Codes, Customers, and Suppliers from the Accounting system into Ostendo.

Export:  This button is a drop-down menu to enable you to export Customers and Suppliers from Ostendo to the Accounting system.

Update:  Press this button when you are creating a new General Ledger Settings record. This loads or updates all the scripts required for the Accounting Link.

Setup:  This button will appear only if you are linking to MYOB AccountRight Live (Cloud or Desktop). Pressing this button will help you populate the above General Ledger Settings fields via a series of prompts.