MYOB Endpoint: SalesItemInvoices
Overview
The MYOB SalesItemInvoices endpoint allows you to get access to item sales invoices within MYOB.
Fields
The following fields are available for the SalesItemInvoices endpoint.
- UID
- A GUID field representing the internal id of this record. This field can be used to link to other endpoints.
- Number
- A text field that provides the invoice number.
- Date
- A date field that indicates the date of the transaction.
- CustomerPurchaseOrderNumber
- A text field that provides the customer purchase order number.
- Customer
- A record field that provides the customer associated with this transaction.
- PromisedDate
- A date field that provides the promised date of the transaction.
- BalanceDueAmount
- A decimal field that provides the outstanding balance of this transaction.
- BalanceDueAmountForeign
- A decimal field that provides the outstanding balance of this transaction for foreign currency transactions.
- Status
- A text field that provides the status of this transaction.
- Possible values are:
- Open: Indicates the invoice has an outstanding amount owing.
- Closed: Indicates the invoice is paid in full.
- Credit: Indicates the invoice is negative or overpaid and not settled or refunded.
- Lines
- A table field that provides the lines of this transaction.
- See Lines Fields for more information.
- ShipToAddress
- A text field that provides the complete address.
- Terms
- A record field that provides the terms of this transaction.
- IsTaxInclusive
- A true/false field that indicates if the amounts are tax inclusive or not.
- Subtotal
- A decimal field that provides the total of all the lines.
- SubtotalForeign
- A decimal field that provides the total of all the lines for foreign currency transactions.
- Freight
- A decimal field that provides the freight amount for this transaction.
- FreightForeign
- A decimal field that provides the freight amount for this transaction for foreign currency transactions.
- FreightTaxCode
- A record field that provides the tax code used for freight.
- TotalTax
- A decimal field that provides the total tax amount.
- TotalTaxForeign
- A decimal field that provides the total tax amount for foreign currency transactions.
- TotalAmount
- A decimal field that provides the total amount of this transaction.
- TotalAmountForeign
- A decimal field that provides the total amount of this transaction for foreign currency transactions.
- Category
- A record field that provides the category associated with this transaction.
- Salesperson
- A record field that provides the salesperson / employee associated with this transaction.
- Comment
- A text field that provides the comment for the transaction.
- ShippingMethod
- A text field that provides the shipping method for the transaction.
- JournalMemo
- A text field that provides the memo for the transaction.
- ReferralSource
- A text field that provides the referral source for the transaction.
- InvoiceDeliveryStatus
- A text field that provides the delivery status of this transaction.
- Possible values are:
- PrintAndEmail
- Nothing
- LastPaymentDate
- A date field that provides the last payment date applied to the transaction.
- Order
- A record field that provides the order which originally was used to create this invoice.
- OnlinePaymentMethod
- A text field that provides the method of payment used for online payments.
- ForeignCurrency
- A record field that provides the currency associated with this transaction.
- CurrencyExchangeRate
- A decimal field that provides exchange rate for foreign currency transactions.
- LastModified
- A date time field that indicates the date and time it was last modified.
- RowVersion
- A row version field.
Lines Fields
The Lines field contains the following sub-fields.
- RowID
- A integer field representing the internal id of this row.
- Type
- A text field that indicates the type of line.
- Possible values are:
- Header
- Transaction
- Subtotal
- Description
- A text field that provides the line memo for the transaction.
- ShipQuantity
- A decimal field that provides the quantity for this line.
- UnitOfMeasure
- A text field that provides the unit of measure for this line.
- This only applies to MYOB Essentials.
- UnitCount
- A decimal field that provides the unit count for this line.
- This only applies to MYOB Essentials.
- UnitPrice
- A decimal field that provides the unit price for this line.
- UnitPriceForeign
- A decimal field that provides the unit price for this line for foreign currency transactions.
- DiscountPercent
- A decimal field that provides the percentage discount for this line.
- CostOfGoodsSold
- A decimal field that provides the cost of sales amount for this line.
- Total
- A decimal field that provides the total amount for this line.
- TotalForeign
- A decimal field that provides the total amount for this line for foreign currency transactions.
- Item
- A record field that provides the item for this line.
- Account
- A record field that provides the account for this line.
- This only applies to MYOB Essentials.
- Location
- A record field that provides the location for this line.
- Job
- A record field that provides the job for this line.
- TaxCode
- A record field that provides the tax code for this line.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Fields
Related Endpoints