Write, Bureaucrats, Administrators
1,349
edits
Difference between revisions of "MYOXIMPORT ServicePurchases"
MYOXIMPORT ServicePurchases (view source)
Revision as of 19:08, 14 November 2016
, 19:08, 14 November 2016no edit summary
(Created page with "== Overview == MYOXIMPORT_ServicePurchases allows you to import service purchases (invoice only) into MYOB. == Fields == * '''Number''' is an '''optional''' field which all...") |
|||
| Line 10: | Line 10: | ||
* '''PromisedDate''' is an '''optional''' field which allows you to specify the promised date. | * '''PromisedDate''' is an '''optional''' field which allows you to specify the promised date. | ||
* '''SupplierUID''' is an '''mandatory''' field which allows you to specify the UID of the supplier. | * '''SupplierUID''' is an '''mandatory''' field which allows you to specify the UID of the supplier. | ||
* '''ShipToAddress''' is | * '''ShipToAddress''' is an '''optional''' field which allows you to specify the address on the invoice. | ||
* '''LinesType''' is an '''optional''' field which allows you to specify the type of the invoice line (''Transaction'', ''Header'', ''Subtotal''). | |||
* '''LinesDescription is a '''mandatory''' field which allows you to specify the description of the invoice line. | |||
* '''LinesTotal''' is a '''mandatory''' field which allows you to specify the amount of the invoice line. | |||
* '''LinesAccountUID''' is a '''mandatory''' field which allows you to specify the UID of the account of the invoice line. | |||
* '''LinesJobUID''' is an '''optional''' field which allows you to specify the UID of the job of the invoice line. | |||
* '''LinesTaxCodeUID''' is a '''mandatory''' field which allows you to specify the UID of the tax code of the invoice line. | |||
* '''TermsPaymentIsDue''' is an '''optional''' field which allows you to specify the payment terms (''CashOnDelivery'', ''PrePaid'', ''InAGivenNumberOfDays'', ''OnADayOfTheMonth'', ''NumberOfDaysAfterEOM'', ''DayOfMonthAfterEOM'') | |||
* '''TermsBalanceDueDate''' is an '''optional''' field which allows you to specify the balance due date. | |||
* '''TermsDiscountDate''' is an '''optional''' field which allows you to specify the discount date. | |||
* '''TermsDiscountForEarlyPayment''' is an '''optional''' field which allows you to specify the discount for early payment. | |||
* '''TermsMonthlyChargeForLatePayment''' is an '''optional''' field which allows you to specify the charge for late payment. | |||
* '''IsTaxInclusive''' is an '''optional''' field which allows you to specify the if the invoice is inclusive of tax. | |||
* '''IsReportable''' is an '''optional''' field which allows you to specify the if the invoice is reportable. | |||
* '''Freight''' is an '''optional''' field which allows you to specify the freight amount of the invoice. | |||
* '''FreightTaxCodeUID''' is a '''mandatory''' field which allows you to specify the UID of the tax code used for freight. | |||
* '''CategoryUID''' is an '''optional''' field which allows you to specify the UID of category or cost centre. | |||
* '''Comment''' is an '''optional''' field which allows you to specify the comment. | |||
* '''ShippingMethod''' is an '''optional''' field which allows you to specify the shipping method. | |||
* '''JournalMemo''' is an '''optional''' field which allows you to specify the journal memo. | |||
* '''BillDeliveryStatus''' is an '''optional''' field which allows you to specify the delivery status (''ToBePrinted'', ''ToBeEmailed'', ''ToBePrintedAndEmailed'', ''AlreadyPrintedOrSent''). | |||
* '''OrderUID''' is an '''optional''' field which allows you to specify the UID of the order this invoice is linked to. | |||
== Notes == | == Notes == | ||
* While MYOB will automatically generate an invoice number, we strongly recommend you include either the '''Number''' or '''SupplierInvoiceNumber''' 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 '''SupplierInvoiceNumber''' that is unique, MYOB will not be able to return the UID or RowVersion of the recorded transaction. | * While MYOB will automatically generate an invoice number, we strongly recommend you include either the '''Number''' or '''SupplierInvoiceNumber''' 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 '''SupplierInvoiceNumber''' 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. | |||
== Related Topics == | == Related Topics == | ||
* [[Import Tables]] | * [[Import Tables]] | ||