AppleScripts

AppleScripts can be used to import and export data to and from your software, and to search your company file.

Note that any open windows that are related to the AppleScript routine will be automatically closed during the import and export.

To learn more about AppleScript, see your Macintosh documentation.

Exporting accounts

Use these scripts to export account data from your software. Terms displayed in brackets are optional.

Value syntax

to string

Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[balances from month of january/february/march/april/may/june/july/august/september/october/november/december]
Indicates from which month you want to export data. Default is the current month.

[in this year/last year]
Indicates from which financial year you want to export data. Default is ’this year.’

Exporting activities

Use these scripts to export activity data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting activity slips

Use these scripts to export activity slips data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[identifiers string]
Specify which transactions to export by their identifiers. No default.

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

Exporting budgets

Use these scripts to export budget data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting cards

Use these scripts to export card data from your software. Terms displayed in brackets are optional.

Value syntax

of type customer/vendor/employee/personal
Type of card to export

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[identifiers string]
Specify which cards to export by their identifiers. No default.

[zip from string]
Specify which cards to export by their zips. Must also use until parameter (below) with this parameter.

[until string]
Specifies the end range of zips. Must be used with zip from parameter above.

[custom list 1 string]
Specifies what cards to export by the contents of their ’custom list 1’ fields. No default.

[custom list 2 string]
Specifies what cards to export by the contents of their ’custom list 2’ fields. No default.

[custom list 3 string]
Specifies what cards to export by the contents of their ’custom list 3’ fields. No default.

Exporting one card

Use these scripts to export one card from your software.

Value syntax

 

Of type customer, vendor, employee, personal
Type of card to export

record id integer
Unique id of record to be exported

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting custom lists

Use these scripts to export custom list data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting inventory adjustments

Use these scripts to export inventory adjustment data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.

Exporting items

Use these scripts to export item data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting one item

Use these scripts to export one item from your software.

Value syntax

 

record id integer
Unique id of record to be exported

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting jobs

Use these scripts to export job data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting journal entries

Use these scripts to export journal entry data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[source journal general/sales/purchases/disbursements/receipts/inventory/all]
Specifies the source journal to export. Default is ’general.’

[type disbursements all/spend money/employee paycheques/vendor payments/customer refunds/transfer money]
Indicates the type of disbursements to export. Default is ’all.’ 5

[type receipts all/receive money/customer payments/vendor refunds]
Indicates the type of receipts to export. Default is ’all.’

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.

Exporting purchases

Use these scripts to export purchase data from your software. Terms displayed in brackets are optional.

Value syntax

of type service/item/professional/miscellaneous
Type of purchases to export.

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[status opened/debit/closed/all bills/orders/quotes/all purchases]
Specifies what sales to export by their status. Default is ’all invoices.’

[identifiers string]
Specifies what purchases to export by their identifiers. No default.

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

Exporting one purchase

Use these scripts to export one purchase from your software.

Value syntax

 

Of type service, item, professional, miscellaneous
Type of purchase to export

record id integer
Unique id of record to be exported

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting receive money transactions

Use these scripts to export receive money data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.

Exporting reminder logs

Use these scripts to export reminder log data from your software. Terms displayed in brackets are optional.

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[identifiers string]
Specifies how to identify records. No default.

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

Exporting sales

Use these scripts to export sales data from your software. Terms displayed in brackets are optional.

Value syntax

of type service/item/professional/timebilling/miscellaneous
Type of sales to export.

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[status opened/credit/closed/all invoices/orders/quotes/all sales]
Specifies what sales to export by their status. Default is ’all invoices.’

[identifiers string]
Specifies what sales to export by their identifiers. No default.

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

Exporting one sale

Use these scripts to export one sale from your software.

Of type service, item, professional, timebilling, miscellaneous
Type of sale to export

record id integer
Unique id of record to be exported.

Value syntax to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting tax code list

Use this script to export a tax code list from your software. Terms displayed in brackets are optional.

of type non consolidated/consolidated: type
Type of to export

to string
Name of file to export to.

username string
Username for company file.

password string
Password for company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

Exporting spend money transactions

Use these scripts to export spend money data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.

Exporting timesheets

Use these scripts to export timesheet data from your software. Terms displayed in brackets are optional.

Value syntax

to string
Name of file to which to export data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[identifiers string]
Specify which transactions to export by their identifiers. No default.

[dated from date]
Beginning date of a range of transactions to export.

[until date]
Ending date of a range of transactions to export.

Importing accounts

Use these scripts to import account data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing activities

Use these scripts to import activity data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing activity slips

Use these scripts to import activity slip data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing budgets

Use these scripts to import budget transaction data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing cards

Use these scripts to import card data into your software. Terms displayed in brackets are optional.

Value syntax

of type customer/vendor/employee/personal
Type of cards to import.

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing one card

Use these scripts to import the data from one card into your software. Terms displayed in brackets are optional.

Value syntax

of type customer/vendor/employee/personal
Type of cards to import.

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

Importing custom lists

Use these scripts to import custom lists data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/update existing record/delete existing record]
Indicates what to do with duplicate records. Default is ’reject them.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing inventory adjustments

Use these scripts to import inventory adjustment data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing items

Use these scripts to import item data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing one item

Use these scripts to import one item into your software.

From Alias
Name of file from which to import data.

record id integer
Unique id of record to be imported

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject/update existing record]
Indicates what to do with duplicate records. Default is ’reject.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A unique record id of item; zero if item could not be found

Importing jobs

Use these scripts to import job data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing journal entries transactions

Use these scripts to import journal entries transaction data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing pay bills transactions

Use these scripts to import pay bill data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing purchases

Use these scripts to import purchase data into your software. Terms displayed in brackets are optional.

Value syntax

of type service/item/professional/miscellaneous
Type of purchases to import.

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

[add card false/true]
Indicates whether to add card. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing one purchase

Use these scripts to import one purchase to your software.

Of type service, item, professional, miscellaneous
Type of purchase to import

From alias
Name of file from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/ record id]
How record will be identified. Default is card id.

[automatch false/true]
Only used when first record is header. Default is false.

[add card false/true]
Indicates whether to add card. Default is false

Result

A unique record id of purchase; zero if purchase could not be imported.

Importing receive money transactions

Use these scripts to import receive money transaction data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing receive payments transactions

Use these scripts to import receive payment transaction data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing reminder logs

Use these scripts to import reminder logs data into your software. Terms displayed in brackets are optional.

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them/update existing record/delete existing record]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/record id]
Indicates how to identify record. Default is card name.

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing sales

Use these scripts to import sale data into your software. Terms displayed in brackets are optional.

Value syntax

of type service/item/professional/timebilling/miscellaneous
Type of sales to import.

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

[add card false/true]
Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing one sale

Use these scripts to import one sale to your software.

Of type service, item, professional, miscellaneous
Type of sale to import

From alias
Name of file from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/ record id]
How record will be identified. Default is card id

[automatch false/true]
Only used when first record is header. Default is false.

[add card false/true]
Indicates whether to add card. Default is false

Result

A unique record id of sale; zero if sale could not be imported.

Importing spend money transactions

Use these scripts to import spend money transaction data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Importing list

Use this script to import a list into your software. Terms displayed in brackets are optional.

of type non consolidated/consolidated: type
Type of GST to export

from alias
Name of file to import from.

username string
Username for company file.

password string
Password for company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

List containing records imported without errors, skipped, and imported with warnings.

Importing timesheets

Use these scripts to import timesheet transaction data into your software. Terms displayed in brackets are optional.

Value syntax

from alias
File from which to import data.

username string
Username of the company file.

password string
Password for the company file.

[separated by tabs/commas]
How data will be separated. Default is ’tabs.’

[first record is header/data]
Record type of first record in the file. Default is ’header.’

[identify by card name/card id/record id]
How record will be identified. Default is ’card name.’

[automatch false/true]
Only used when first record is header. Default is false.

Result

A list containing records imported without errors, skipped and imported with warnings

Determine company file name

Use this script to determine the name of the company file currently open.

company name

Result

The name of currently open company file.

Determine company file path

Use this script to determine the filepath of the company file currently open.

company file path

Result

The filepath to currently open company file.

Determine country version of company file

Use this script to determine the country version of the company file currently open.

country version

Result

The country version of currently open company file.

Determine if open company file contains multiple currencies

Use this script to determine if the open company file contains multiple currencies.

multiple currencies

Result

Boolean return [false/true]
True if company file contains multiple currencies; false if not.

Determine current user

Use this script to determine the current user of the company file.

Result

The user ID of the current user of the company file.

Determine valid user account

Use this script to determine if the user has a valid user account.

company file alias
The name of the company file.

username string
Username of the company file.

password string
Password for the company file.

Result

True is the user account of the company file is valid; false if not.

Show me card

Open a particular card in AccountEdge

show me card

record id integer
unique record id of card to open

username string
username for company file

password string
password for company file

Show me item

Open a particular item in AccountEdge

show me item

record id integer
unique record id of item to open

username string
username for company file

password string
password for company file

Show me purchase

Open a particular purchase in AccountEdge

show me purchase

record id integer
unique record id of purchase to open

username string
username for company file

password string
password for company file

Show me sale

Open a particular sale in AccountEdge

show me sale

record id integer
unique record id of sale to open

username string
username for company file

password string
password for company file

Card exists

Determine if specified card exists

card exists

record id integer
unique record id of card to test for existence

username string
username for company file

password string
password for company file

of type [customer/vendor/employee/personal]
type of card to test for existence

boolean return [true if card exists, false if not]

Card id exists

Determine if specified card id exists

card id exists

card id string
card id of card to test for existence

username string
username for company file

password string
password for company file

of type [customer/vendor/employee/personal]
type of card to test for existence

integer
negative count if multiple cards with same card id; zero if no card with card

id exists
positive number is record id if only one card with card id exists

Card name exists

Determine if specified card name exists

card name exists

name string
company/last name of card to test for existence

first name string
first name of card to test for existence

username string
username for company file

password string
password for company file

of type [customer/vendor/employee/personal]
type of card to test for existence

integer
negative count if multiple cards with same card name; zero if no card with

card name exists
positive number is record id if only one card with card name exists

item exists

Determine if specified item exists

item exists

record id integer
unique record id of item to test for existence

username string
username for company file

password string
password for company file

boolean return
true if item exists, false if not

Item name exists

Determine if specified item name exists

item name exists

name string
name of item to test for existence

username string
username for company file

password string
password for company file

integer
negative count if multiple items with same name; zero if no item with name exists
positive number is record id if only one item with name exists

Item number exists

Determine if specified item number exists

item number exists

number string
unique number of item to test for existence

username string
username for company file

password string
password for company file

boolean return
true if item number exists, false if not

Purchase exists

Determine if specified purchase exists

purchase exists

record id integer
unique record id of purchase to test for existence

username string
username for company file

password string
password for company file

boolean return
true if purchase exists, false if not

Sale exists

Determine if specified sale exists

sale exists

record id integer
unique record id of sale to test for existence

username string
username for company file

password string
password for company file

boolean return
true if sale exists, false if not

Error returns

1	An invalid record id was specified.

2	A company file is not currently open.

3	The requested card does not exist.

The requested item does not exist.

The requested purchase does not exist.

The requested sale does not exist.

4	A window associated with this cannot be closed.

A window associated with this export cannot be closed.

5	No card name was specified.

6	No item name was specified.

7	No item number was specified.

8	No card id was specified.

9	An invalid card type was specified.