MYOXIMPORT ServiceSales

Overview

MYOXIMPORT_ServiceSales allows you to import service sales (invoice only) into MYOB.

The following fields allow you to import data. Fields that are mandatory are in bold. Fields that are optional are in italics.

SaleNumber
CustomerPurchaseOrderNumber
SaleDate
PromisedDate
CustomerUID
ShipToAddress
LinesType (possible values are Transaction, Header, Subtotal).
LinesDescription
LinesTotal
LinesAccountUID
LinesJobUID
LinesTaxCodeUID
TermsPaymentIsDue (possible values are CashOnDelivery, PrePaid, InAGivenNumberOfDays, OnADayOfTheMonth, NumberOfDaysAfterEOM, DayOfMonthAfterEOM)
TermsBalanceDueDate (number of days until balance is due)
TermsDiscountDate' (number of days to receive discount)
TermsDiscountForEarlyPayment
TermsMonthlyChargeForLatePayment
IsTaxInclusive
Freight
FreightTaxCodeUID (freight tax code must always be included even though freight might not apply)
CategoryUID
SalespersonUID
Comment
ShippingMethod
JournalMemo
ReferralSource
InvoiceDeliveryStatus (possible values are ToBePrinted, ToBeEmailed, ToBePrintedAndEmailed, AlreadyPrintedOrSent)
OrderUID

While MYOB will automatically generate an invoice number, we strongly recommend you include either the Number or CustomerPurchaseOrderNumber field when writing data back into MYOB in order to identify the transaction in the future. Furthermore, if you do not include a Number or CustomerPurchaseOrderNumber that is unique, MYOB will not be able to return the UID or RowVersion of the recorded transaction.

All fields other than those beginning with Lines relate to the invoice header and should have the same values for all lines of the invoice. Only the values of the first record are actually used for the header of the transaction.