Nic at 04:24, 3 April 2025

2025-04-03T04:24:16Z

@@ Line 59: / Line 59: @@
 :A [[Field Type: Text|text field]] that provides the complete address.
-;Terms
+;TermsPaymentIsDue
-:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Terms|terms]] of this transaction.
+:A [[Field Type: Text|text field]] that represents the due date.
 ;IsTaxInclusive

Nic: Created page with "== Overview == The MYOB '''SalesAllInvoicesTable''' endpoint allows you to get access to all sales invoices regardless of type (Item, Miscellaneous, Profes..."

2025-04-03T03:59:41Z

Created page with "== Overview == The MYOB '''SalesAllInvoicesTable''' endpoint allows you to get access to all sales invoices regardless of type (Item, Miscellaneous, Profes..."

New page

== Overview ==

The MYOB '''SalesAllInvoicesTable''' [[MYOB Endpoints|endpoint]] allows you to get access to all sales invoices regardless of type (Item, Miscellaneous, Professional, Service, Time-Billing) within MYOB.

Note this endpoint is an alternate format of the [[MYOB Endpoint: SalesAllInvoices|SalesAllInvoices]] endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.

== Fields ==

The following fields are available for the SalesAllInvoicesTable endpoint.

;DataFileID
:A [[Field Type: GUID|guid field]] that provides the id of the data file as setup in OdataLink.

;DataFileName
:A [[Field Type: Text|text field]] that provides the name of the data file as setup in OdataLink.

;DataFileCode
:A [[Field Type: Text|text field]] that provides the code of the data file as setup in OdataLink.

;UID
:A [[Field Type: GUID|GUID field]] representing the internal id of this record. This field can be used to link to other endpoints.

;Number
:A [[Field Type: Text|text field]] that provides the invoice number.

;Date
:A [[Field Type: Date|date field]] that indicates the date of the transaction.

;CustomerPurchaseOrderNumber
:A [[Field Type: Text|text field]] that provides the customer purchase order number.

;CustomerUID
:A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Customers|customer]]. This field can be used to link to other endpoints.

;CustomerName
:A [[Field Type: Text|text field]] that provides the full name of the customer.

;CustomerDisplayID
:A [[Field Type: Text|text field]] that provides the Card ID of the customer.

;PromisedDate
:A [[Field Type: Date|date field]] that provides the promised date of the transaction.

;BalanceDueAmount
:A [[Field Type: Decimal|decimal field]] that provides the outstanding balance of this transaction.

;BalanceDueAmountForeign
:A [[Field Type: Decimal|decimal field]] that provides the outstanding balance of this transaction for foreign currency transactions.

;Status
:A [[Field Type: Text|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.

;ShipToAddress
:A [[Field Type: Text|text field]] that provides the complete address.

;Terms
:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Terms|terms]] of this transaction.

;IsTaxInclusive
:A [[Field Type: Boolean|true/false field]] that indicates if the amounts are tax inclusive or not.

;Subtotal
:A [[Field Type: Decimal|decimal field]] that provides the total of all the lines.

;SubtotalForeign
:A [[Field Type: Decimal|decimal field]] that provides the total of all the lines for foreign currency transactions.

;Freight
:A [[Field Type: Decimal|decimal field]] that provides the freight amount for this transaction.

;FreightForeign
:A [[Field Type: Decimal|decimal field]] that provides the freight amount for this transaction for foreign currency transactions.

;FreightTaxCodeUID
:A [[Field Type: GUID|guid field]] that provides the id of the [[MYOB Endpoint: TaxCodes|tax code]] for freeight.

;FreightTaxCode
:A [[Field Type: Text|text field]] that provides the [[MYOB Endpoint: TaxCodes|tax code]] for freight (e.g. GST or FRE).

;TotalTax
:A [[Field Type: Decimal|decimal field]] that provides the total tax amount.

;TotalTaxForeign
:A [[Field Type: Decimal|decimal field]] that provides the total tax amount for foreign currency transactions.

;TotalAmount
:A [[Field Type: Decimal|decimal field]] that provides the total amount of this transaction.

;TotalAmountForeign
:A [[Field Type: Decimal|decimal field]] that provides the total amount of this transaction for foreign currency transactions.

;CategoryUID
:A [[Field Type: GUID|GUID field]] that provides the internal id of a [[MYOB Endpoint: Categories|category]]. This field can be used to link to other endpoints.

;CategoryName
:A [[Field Type: Text|text field]] that provides the category name.

;CategoryDisplayID
:A [[Field Type: Text|text field]] that provides the category number.

;SalespersonUID
:A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Cards|sales person]]. This field can be used to link to other endpoints.

;SalespersonName
:A [[Field Type: Text|text field]] that provides the full name of the sales person.

;SalespersonDisplayID
:A [[Field Type: Text|text field]] that provides the Card ID of the sales person.

;Comment
:A [[Field Type: Text|text field]] that provides the comment for the transaction.

;ShippingMethod
:A [[Field Type: Text|text field]] that provides the shipping method for the transaction.

;JournalMemo
:A [[Field Type: Text|text field]] that provides the memo for the transaction.

;ReferralSource
:A [[Field Type: Text|text field]] that provides the referral source for the transaction.

;InvoiceDeliveryStatus
:A [[Field Type: Text|text field]] that provides the delivery status of this transaction.
:Possible values are:
:* Email
:* Print
:* PrintAndEmail
:* Nothing

;LastPaymentDate
:A [[Field Type: Date|date field]] that provides the last payment date applied to the transaction.

;InvoiceType
:A [[Field Type: Text|text field]] that indicates the type of invoice.
:Possible values are:
:* '''Item'''
:* '''Miscellaneous'''
:* '''Professional'''
:* '''Service'''
:* '''TimeBilling'''

;OrderUID
:A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: SalesAllOrders|order]]. This field can be used to link to other endpoints.

;OrderNumber
:A [[Field Type: Text|text field]] that provides the order number for the originating order (if applicable).

;OnlinePaymentMethod
:A [[Field Type: Text|text field]] that provides the method of payment used for online payments.

;ForeignCurrencyUID
:A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Currencies|currency]] linked to this transaction. This field can be used to link to other endpoints.

;ForeignCurrencyCode
:A [[Field Type: Text|text field]] that provides the currency ISO code.

;ForeignCurrencyName
:A [[Field Type: Text|text field]] that provides the currency name.

;CurrencyExchangeRate
:A [[Field Type: Decimal|decimal field]] that provides exchange rate for foreign currency transactions.

;LastModified
:A [[Field Type: DateTimeOffset|date time field]] that indicates the date and time it was last modified.

;RowVersion
:A [[Field Type: Row Version|row version field]].

== MYOB API ==

For a detailed run through of the endpoint, you can see the [https://developer.myob.com/api/accountright/v2/sale/invoice/ MYOB API].

== Related Endpoints==

:[[MYOB Endpoint: JournalTransactions|JournalTransactions]]
:[[MYOB Endpoint: SalesAllInvoices|SalesAllInvoices]]
:[[MYOB Endpoint: SalesAllOrders|SalesAllOrders]]
:[[MYOB Endpoint: SalesAllQuotes|SalesAllQuotes]]

== Related Topics ==

:[[MYOB Models]]
:[[MYOB Endpoints]]

MYOB Endpoint: SalesAllInvoicesTable - Revision history

Nic at 04:24, 3 April 2025

Nic: Created page with "== Overview == The MYOB '''SalesAllInvoicesTable''' endpoint allows you to get access to all sales invoices regardless of type (Item, Miscellaneous, Profes..."