MYOXIMPORT ServiceSales - Revision history

Nic at 05:38, 17 November 2016

2016-11-17T05:38:32Z

← Older revision		Revision as of 00:38, 17 November 2016
Line 5:		Line 5:
	== Fields ==		== Fields ==

	* '''~~SaleNumber~~''' ~~is an ''~~'~~optional~~''' ~~field which allows you to specify the invoice number~~.		The following fields allow you to import data. Fields that are mandatory are in '''bold'''. Fields that are optional are in ''italics''.
	* '''~~CustomerPurchaseOrderNumber~~''' ~~is an '~~''~~optional''' field which allows you to specify the customer purchase order number.~~
	* '''SaleDate''' ~~is a '''mandatory''' field which allows you to specify the date of the invoice.~~		* ''SaleNumber''
	* '''PromisedDate''~~' is an '''optional''' field which allows you to specify the promised date.~~		* ''CustomerPurchaseOrderNumber''
	* '''CustomerUID''' ~~is a '''mandatory''' field which allows you to specify the UID of the customer.~~		* '''SaleDate'''
	* '''ShipToAddress''~~' is an '''optional''' field which allows you to specify the address on the invoice.~~		* ''PromisedDate''
	* '''LinesType''~~' is an '''optional''' field which allows you to specify the type of the invoice line~~ (''Transaction'', ''Header'', ''Subtotal'').		* '''CustomerUID'''
	* '''LinesDescription ~~is a '''mandatory''' field which allows you to specify the description of the invoice line.~~		* ''ShipToAddress''
	* '''LinesTotal''' ~~is a '''mandatory''' field which allows you to specify the amount of the invoice line.~~		* ''LinesType'' (possible values are ''Transaction'', ''Header'', ''Subtotal'').
	* '''LinesAccountUID''' ~~is a '''mandatory''' field which allows you to specify the UID of the account of the invoice line.~~		* '''LinesDescription
	* '''LinesJobUID''~~' is an '''optional''' field which allows you to specify the UID of the job of the invoice line.~~		* '''LinesTotal'''
	* '''LinesTaxCodeUID''' ~~is a '''mandatory''' field which allows you to specify the UID of the tax code of the invoice line.~~		* '''LinesAccountUID'''
	* '''TermsPaymentIsDue''~~' is an '''optional''' field which allows you to specify the payment terms~~ (''CashOnDelivery'', ''PrePaid'', ''InAGivenNumberOfDays'', ''OnADayOfTheMonth'', ''NumberOfDaysAfterEOM'', ''DayOfMonthAfterEOM'')		* ''LinesJobUID''
	* '''TermsBalanceDueDate''' is ~~an '''optional''' field which allows you to specify the balance~~ due ~~date.~~		* '''LinesTaxCodeUID'''
	* '''TermsDiscountDate''' ~~is an '''optional''' field which allows you~~ to ~~specify the~~ discount ~~date.~~		* ''TermsPaymentIsDue'' (possible values are ''CashOnDelivery'', ''PrePaid'', ''InAGivenNumberOfDays'', ''OnADayOfTheMonth'', ''NumberOfDaysAfterEOM'', ''DayOfMonthAfterEOM'')
	* '''TermsDiscountForEarlyPayment''~~' is an '''optional''' field which allows you to specify the discount for early payment.~~		* ''TermsBalanceDueDate'' (number of days until balance is due)
	* '''TermsMonthlyChargeForLatePayment''~~' is an '''optional''' field which allows you to specify the charge for late payment.~~		* ''TermsDiscountDate''' (number of days to receive discount)
	* '''IsTaxInclusive''~~' is an '''optional''' field which allows you to specify the if the invoice is inclusive of tax.~~		* ''TermsDiscountForEarlyPayment''
	* '''Freight''~~' is an '''optional''' field which allows you to specify the freight amount of the invoice.~~		* ''TermsMonthlyChargeForLatePayment''
	* '''FreightTaxCodeUID''' ~~is a '''mandatory''' field which allows you to specify the UID of the~~ tax code ~~used for~~ freight.		* ''IsTaxInclusive''
	* '''CategoryUID''~~' is an '''optional''' field which allows you to specify the UID of category or cost centre.~~		* ''Freight''
	* '''SalespersonUID''~~' is an '''optional''' field which allows you to specify the UID of sales person or employee.~~		* '''FreightTaxCodeUID''' (freight tax code must always be included even though freight might not apply)
	* '''Comment''~~' is an '''optional''' field which allows you to specify the comment.~~		* ''CategoryUID''
	* '''ShippingMethod''~~' is an '''optional''' field which allows you to specify the shipping method.~~		* ''SalespersonUID''
	* '''JournalMemo''~~' is an '''optional''' field which allows you to specify the journal memo.~~		* ''Comment''
	* '''ReferralSource''~~' is an '''optional''' field which allows you to specify the referral source.~~		* ''ShippingMethod''
	* '''InvoiceDeliveryStatus''~~' is an '''optional''' field which allows you to specify the delivery status~~ (''ToBePrinted'', ''ToBeEmailed'', ''ToBePrintedAndEmailed'', ''AlreadyPrintedOrSent'').		* ''JournalMemo''
	* '''OrderUID''~~' is an '''optional''' field which allows you to specify the UID of the order this invoice is linked to.~~		* ''ReferralSource''
			* ''InvoiceDeliveryStatus'' (possible values are ''ToBePrinted'', ''ToBeEmailed'', ''ToBePrintedAndEmailed'', ''AlreadyPrintedOrSent'')
			* ''OrderUID''

	== Notes ==		== Notes ==

Nic at 05:31, 17 November 2016

2016-11-17T05:31:18Z

← Older revision		Revision as of 00:31, 17 November 2016
Line 5:		Line 5:
	== Fields ==		== Fields ==

	* '''~~Number~~''' is an '''optional''' field which allows you to specify the invoice number.		* '''SaleNumber''' is an '''optional''' field which allows you to specify the invoice number.
	* '''CustomerPurchaseOrderNumber''' is an '''optional''' field which allows you to specify the customer purchase order number.		* '''CustomerPurchaseOrderNumber''' is an '''optional''' field which allows you to specify the customer purchase order number.
	* '''~~Date~~''' is a '''mandatory''' field which allows you to specify the date of the invoice.		* '''SaleDate''' is a '''mandatory''' field which allows you to specify the date of the invoice.
	* '''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.
	* '''CustomerUID''' is a '''mandatory''' field which allows you to specify the UID of the customer.		* '''CustomerUID''' is a '''mandatory''' field which allows you to specify the UID of the customer.

Nic at 02:32, 15 November 2016

2016-11-15T02:32:21Z

← Older revision		Revision as of 21:32, 14 November 2016
Line 43:		Line 43:

	* [[Import Tables]]		* [[Import Tables]]
			* [[Writing Data]]

Nic: Created page with "== Overview == MYOXIMPORT_ServiceSales allows you to import service sales (invoice only) into MYOB. == Fields == * '''Number''' is an '''optional''' field which allows you ..."

2016-11-15T02:31:13Z

Created page with "== Overview == MYOXIMPORT_ServiceSales allows you to import service sales (invoice only) into MYOB. == Fields == * '''Number''' is an '''optional''' field which allows you ..."

New page

== Overview ==

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

== Fields ==

* '''Number''' is an '''optional''' field which allows you to specify the invoice number.
* '''CustomerPurchaseOrderNumber''' is an '''optional''' field which allows you to specify the customer purchase order number.
* '''Date''' is a '''mandatory''' field which allows you to specify the date of the invoice.
* '''PromisedDate''' is an '''optional''' field which allows you to specify the promised date.
* '''CustomerUID''' is a '''mandatory''' field which allows you to specify the UID of the customer.
* '''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.
* '''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.
* '''SalespersonUID''' is an '''optional''' field which allows you to specify the UID of sales person or employee.
* '''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.
* '''ReferralSource''' is an '''optional''' field which allows you to specify the referral source.
* '''InvoiceDeliveryStatus''' 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 ==

* 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.

== Related Topics ==

* [[Import Tables]]