MYOB Endpoint: SalesItemInvoices
Jump to navigation
Jump to search
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