MYOB Endpoint: PurchasesItemInvoices

Overview

The MYOB PurchasesItemInvoices endpoint allows you to get access to item purchase invoices within MYOB.


Fields

The following fields are available for the PurchasesItemInvoices 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.
SupplierInvoiceNumber
A text field that provides the supplier invoice number.
Supplier
A record field that provides the supplier associated with this transaction.
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.
IsReportable
A true/false field that indicates if the transaction is a reportable taxable payment.
Note this applies to Australia only.
Lines
A table field that provides the lines of this transaction.
See Lines Fields for more information.
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.
Comment
A text field that provides the comment for the transaction.
ShippingMethod
A text field that provides the shipping method for the transaction.
PromisedDate
A date field that provides the promised date of the transaction.
JournalMemo
A text field that provides the memo for the transaction.
BillDeliveryStatus
A text field that provides the delivery status of this transaction.
Possible values are:
  • Email
  • Print
  • PrintAndEmail
  • Nothing
AppliedToDate
A decimal field that provides the total amount paid on this transaction.
AppliedToDateForeign
A decimal field that provides the total amount paid on this transaction for foreign currency transactions.
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.
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.
ForeignCurrency
A record field that provides the currency associated with this transaction.
CurrencyExchangeRate
A decimal field that provides exchange rate for foreign currency transactions.
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.
BillQuantity
A decimal field that provides the quantity billed for this line.
ReceivedQuantity
A decimal field that provides the quantity received for this line.
BackorderQuantity
A decimal field that provides the quantity on back order 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.
UnitsOfMeasure
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.
This only applies to MYOB Essentials.
UnitPriceForeign
A decimal field that provides the unit price for this line for foreign currency transactions.
This only applies to MYOB Essentials.
Job
A record field that provides the job for this line.
DiscountPercent
A decimal field that provides the percentage discount for this line.
TaxCode
A record field that provides the tax code for this line.
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.
RowVersion
A row version field.


MYOB API

For a detailed run through of the endpoint, you can see the MYOB API.


Related Fields

Accounts
Cards
Categories
Items
Jobs
Locations
Purchases
TaxCodes


Related Endpoints

JournalTransactions
PurchasesItemOrders


Related Topics

MYOB Models
MYOB Endpoints