to string
username string
Username of the company file.
Username of the company file.
[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.
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.’
Indicates from which financial year you want to export data. Default is ’this year.’
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
of type customer/supplier/employee/personal
Type of card to export
Type of card to export
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
[zip from string]
Specify which cards to export by their zips. Must also use until parameter (below) with this parameter.
Specify which cards to export by their zips. Must also use until parameter (below) with this parameter.
[custom list 1 string]
Specifies what cards to export by the contents of their ’custom list 1’ fields. No default.
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.
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.
Specifies what cards to export by the contents of their ’custom list 3’ fields. No default.
Of type customer, supplier, employee, personal
Type of card to export
Type of card to export
record id integer
Unique id of record to be exported
Unique id of record to be exported
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
Exporting stock adjustments
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
Indicates whether the date range specified above is in the 13th period.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
record id integer
Unique id of record to be exported
Unique id of record to be exported
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[identify item by item number/ item record id]: default item number
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
[source journal general/sales/purchases/disbursements/receipts/stock/all]
Specifies the source journal to export. Default is ’general.’
Specifies the source journal to export. Default is ’general.’
[type disbursements all/spend money/employee paycheques/supplier payments/customer refunds/transfer money]
Indicates the type of disbursements to export. Default is ’all.’ 5
Indicates the type of disbursements to export. Default is ’all.’ 5
[type receipts all/receive money/customer payments/supplier refunds]
Indicates the type of receipts to export. Default is ’all.’
Indicates the type of receipts to export. Default is ’all.’
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
Indicates whether the date range specified above is in the 13th period.
Exporting nominal journal entries
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
Indicates whether the date range specified above is in the 13th period.
of type service/item/professional/miscellaneous
Type of purchases to export.
Type of purchases to export.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
[status opened/debit/closed/all bills/orders/quotes/all purchases]
Specifies what sales to export by their status. Default is ’all invoices.’
Specifies what sales to export by their status. Default is ’all invoices.’
Of type service, item, professional, miscellaneous
Type of purchase to export
Type of purchase to export
record id integer
Unique id of record to be exported
Unique id of record to be exported
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
Indicates whether the date range specified above is in the 13th period.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
Use these scripts to export sales data from your software. Terms displayed in brackets are optional.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
[status opened/credit/closed/all invoices/orders/quotes/all sales]
Specifies what sales to export by their status. Default is ’all invoices.’
Specifies what sales to export by their status. Default is ’all invoices.’
Of type service, item, professional, timebilling, miscellaneous
Type of sale to export
Type of sale to export
record id integer
Unique id of record to be exported.
Unique id of record to be exported.
Value syntax to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
of type non consolidated/consolidated: type
Type of to export
Type of to export
to string
Name of file to export to.
Name of file to export to.
username string
Username for company file.
Username for company file.
password string
Password for company file.
Password for company file.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
Indicates whether the date range specified above is in the 13th period.
to string
Name of file to which to export data.
Name of file to which to export data.
username string
Username of the company file.
Username of the company file.
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
of type customer/supplier/employee/personal
Type of cards to import.
Type of cards to import.
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
of type customer/supplier/employee/personal
Type of cards to import.
Type of cards to import.
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/update existing record/delete existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
Importing stock adjustments
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
[identify item by item number/ item record id]: default item number
From Alias
Name of file from which to import data.
Name of file from which to import data.
record id integer
Unique id of record to be imported
Unique id of record to be imported
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject/update existing record]
Indicates what to do with duplicate records. Default is ’reject.’
Indicates what to do with duplicate records. Default is ’reject.’
[identify item by item number/ item record id]: default item number
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
Importing nominal journal entries transactions
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
of type service/item/professional/miscellaneous
Type of purchases to import.
Type of purchases to import.
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
Of type service, item, professional, miscellaneous
Type of purchase to import
Type of purchase to import
From alias
Name of file from which to import data.
Name of file from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
[add card false/true]
Indicates whether to add card. Default is false
Indicates whether to add card. Default is false
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them/update existing record/delete existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
of type service/item/professional/timebilling/miscellaneous
Type of sales to import.
Type of sales to import.
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
Of type service, item, professional, miscellaneous
Type of sale to import
Type of sale to import
From alias
Name of file from which to import data.
Name of file from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
[add card false/true]
Indicates whether to add card. Default is false
Indicates whether to add card. Default is false
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
of type non consolidated/consolidated: type
Type of GST to export
Type of GST to export
from alias
Name of file to import from.
Name of file to import from.
username string
Username for company file.
Username for company file.
password string
Password for company file.
Password for company file.
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
Indicates what to do with duplicate records. Default is ’reject them.’
from alias
File from which to import data.
File from which to import data.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
company file alias
The name of the company file.
The name of the company file.
username string
Username of the company file.
Username of the company file.
password string
Password for the company file.
Password for the company file.
record id integer
unique record id of card to open
unique record id of card to open
username string
username for company file
username for company file
record id integer
unique record id of item to open
unique record id of item to open
username string
username for company file
username for company file
record id integer
unique record id of purchase to open
unique record id of purchase to open
username string
username for company file
username for company file
username string
username for company file
username for company file
username string
username for company file
username for company file
card id string
card id of card to test for existence
card id of card to test for existence
username string
username for company file
username for company file
name string
company/last name of card to test for existence
company/last name of card to test for existence
first name string
first name of card to test for existence
first name of card to test for existence
username string
username for company file
username for company file
username string
username for company file
username for company file
username string
username for company file
username for company file
username string
username for company file
username for company file
username string
username for company file
username for company file
record id integer
unique record id of sale to test for existence
unique record id of sale to test for existence
username string
username for company file
username for company file
