collmex_list_customers
List customers
Search Collmex customers (record CUSTOMER_GET): by customer number, free text (name, city, e-mail ...), postal code or country. Returns address, contact, bank (IBAN/BIC), VAT id, payment terms, agent and status fields. Inactive customers are left out unless asked for.
輸入參數textlimitoffsetcompany_nocustomer_noaddress_groupfollow_up_dueinclude_inactivepostcode_country
collmex_list_vendors
List vendors
Search Collmex vendors/suppliers (record VENDOR_GET): by vendor number, free text, postal code or country. Returns address, contact, bank, VAT id, payment terms and expense account fields.
輸入參數textlimitoffsetvendor_nocompany_nofollow_up_duepostcode_country
collmex_list_addresses
List addresses
Search the Collmex address book (record ADDRESS_GET): customers, vendors and address-book entries in one list, optionally with their contact persons. address_type: 0 all, 1 customers, 2 vendors, 3 address-book entries.
輸入參數textlimitoffsetaddress_nocompany_noaddress_typeaddress_groupfollow_up_dueinclude_contactsinclude_inactivepostcode_country
collmex_list_products
List products
Search Collmex products (record PRODUCT_GET): by product number, product group, free text (number, description, remark, GTIN, manufacturer) or price group. Returns description, unit, tax class, sales price, purchase data and stock settings.
輸入參數textlimitoffsetcompany_noproduct_noprice_groupproduct_grouponly_with_price
collmex_get_available_stock
Get available stock
Currently available stock per product (record STOCK_AVAILABLE_GET): on-hand stock of the available stock types minus demand due today or earlier. A service product shows (NULL). Leave product_no empty for every product.
輸入參數limitoffsetcompany_noproduct_no
collmex_list_invoices
List invoices
Search Collmex customer invoices and credit notes (record INVOICE_GET): by invoice number, customer, invoice date range, customer order or product. Each invoice has its header (customer address, dates, payment terms, status code: 0 new, 10 to be posted, 20 open, 30 dunned, 40 settled, 100 deleted) and its positions with quantities, prices and values. Reads only; no PDF/XML export.
輸入參數limitoffsetdate_todate_fromcompany_noinvoice_noproduct_nocustomer_noonly_issuedcustomer_order_no
collmex_list_sales_orders
List sales orders
Search Collmex customer orders (record SALES_ORDER_GET): by order number, customer, order date range or the customer's own order number. Each order has its header (customer address, dates, payment terms, status code: 0 new, 10 confirmed, 30 paid, 50 delivered, 90 invoiced, 100 done, 1000 cancelled) and its positions. Reads only; no PDF export.
輸入參數limitoffsetdate_toorder_nodate_fromcompany_nocustomer_nocustomer_purchase_order_no
collmex_list_payment_terms
List payment terms
The payment terms defined in Collmex (record TERMS_OF_PAYMENT_GET): number, description, payment method and discount periods. The number is what customers, vendors and invoices refer to as payment_terms.
輸入參數limitoffset
collmex_list_open_items
List open items
Open items (unpaid invoices) from the Collmex accounting (record OPEN_ITEMS_GET), for customers (receivables, default) or vendors (payables). Returns invoice number, document and due date, days overdue, dunning level, amount, paid and outstanding. Optionally as of a key date.
輸入參數kindlimitoffsetkey_datevendor_nocompany_nocustomer_no
collmex_list_accounting_documents
List accounting postings
Accounting postings (record ACCDOC_GET), one row per posting position: posting number, date, text, account, debit/credit (0 debit, 1 credit), amount, customer/vendor, invoice number. Filter by fiscal year, account, cost centre, customer, vendor, invoice or document date range. Cancelled postings are excluded unless asked for.
輸入參數textlimitoffsetdate_todate_fromvendor_noaccount_nocompany_noinvoice_noposting_nocost_centercustomer_no另有 2 個
collmex_get_account_balances
Get account balances
Account balances from the Collmex accounting (record ACCBAL_GET) for a fiscal year: account number, name and balance. Filter by account, account group (1 other, 2 fixed assets, 3 bank/cash, 4 income, 5 expenses, 6 output VAT, 7 input VAT, 8 receivables, 9 payables, 10 depreciation, 11 provisions, 12 inventory, 13 private, 14 non-deductible expenses), cost centre or an up-to date. With a customer or vendor given, the date is ignored.
輸入參數limitoffsetdate_tovendor_noaccount_nocompany_nocost_centercustomer_nofiscal_year必填account_group
collmex_list_projects
List projects
Collmex projects (record PROJECT_GET) with customer, budget, value of recorded activities, completion state and the project's rates (rate number, description, product, hourly or daily rate).
輸入參數limitoffsetstatuscompany_noproject_nocustomer_no
collmex_list_activities
List project activities
Recorded time-tracking activities (record ACTIVITIES_GET): project, employee, date, from/to times, breaks, description, and the invoice that billed it. Filter by project, employee (needs company), date range, only not-yet-billed or only invoice-relevant activities.
輸入參數limitoffsetdate_todate_fromcompany_nonot_billedproject_noemployee_nobillable_only
collmex_create_customer
Create customer
WRITE: create a NEW customer in Collmex (record CMXKND without a customer number, so Collmex assigns the next number; an existing customer is never overwritten). Each call creates another customer: check collmex_list_customers first to avoid duplicates. Nothing is sent to the customer. Give at least a company or a last name. Returns the new customer number.
輸入參數faxcityemailphonetitleremarkstreetvat_idcompanycountrycurrencylast_name另有 6 個
collmex_create_address
Create address-book entry
WRITE: create a NEW entry in the Collmex address book (record CMXADR, address type 3, no address number so Collmex assigns one; existing addresses are never overwritten). Each call creates another entry: check collmex_list_addresses first to avoid duplicates. Nothing is sent to the person. Give at least a company or a last name. Returns the new address number.
輸入參數faxurlcityemailphonetitleremarkstreetcompanycountrylast_namedepartment另有 4 個
