MYOXIMPORT ServicePurchases - Revision history

Nic at 05:43, 17 November 2016

2016-11-17T05:43:13Z

← Older revision		Revision as of 00:43, 17 November 2016
Line 32:		Line 32:
	* ''ShippingMethod''		* ''ShippingMethod''
	* ''JournalMemo''		* ''JournalMemo''
	* ''BillDeliveryStatus'' possible values are (''ToBePrinted'', ''ToBeEmailed'', ''ToBePrintedAndEmailed'', ''AlreadyPrintedOrSent'')		* ''BillDeliveryStatus'' (possible values are ''ToBePrinted'', ''ToBeEmailed'', ''ToBePrintedAndEmailed'', ''AlreadyPrintedOrSent'')
	* ''OrderUID''		* ''OrderUID''

Nic at 05:42, 17 November 2016

2016-11-17T05:42:58Z

← Older revision		Revision as of 00:42, 17 November 2016
Line 32:		Line 32:
	* ''ShippingMethod''		* ''ShippingMethod''
	* ''JournalMemo''		* ''JournalMemo''
	* ''BillDeliveryStatus''		* ''BillDeliveryStatus'' possible values are (''ToBePrinted'', ''ToBeEmailed'', ''ToBePrintedAndEmailed'', ''AlreadyPrintedOrSent'')
	* ''OrderUID''		* ''OrderUID''

Nic at 05:41, 17 November 2016

2016-11-17T05:41:34Z

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

	* '''~~PurchaseNumber~~''' ~~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''.
	* '''~~SupplierInvoiceNumber~~''' ~~is an '''optional'~~'' ~~field which allows you to specify the supplier invoice number.~~
	* '''PurchaseDate''' ~~is a '''mandatory''' field which allows you to specify the date of the invoice.~~		* ''PurchaseNumber''
	* '''PromisedDate''~~' is an '''optional''' field which allows you to specify the promised date.~~		* ''SupplierInvoiceNumber''
	* '''SupplierUID''' ~~is a '''mandatory''' field which allows you to specify the UID of the supplier.~~		* '''PurchaseDate'''
	* '''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'').		* '''SupplierUID'''
	* '''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''
	* '''IsReportable''~~' is an '''optional''' field which allows you to specify the if the invoice is reportable.~~		* ''TermsMonthlyChargeForLatePayment''
	* '''Freight''~~' is an '''optional''' field which allows you to specify the freight amount of the invoice.~~		* ''IsTaxInclusive''
	* '''FreightTaxCodeUID''' is a ~~'''mandatory''' field which allows you to specify the UID of the tax code used for~~ freight.		* ''IsReportable''
	* '''CategoryUID''~~' is an '''optional''' field which allows you to specify the UID of category or cost centre.~~		* ''Freight''
	* '''Comment''~~' is an '''optional''' field which allows you to specify the comment.~~		* '''FreightTaxCodeUID''' (this field must always be populated with a value regardless if freight applies or not)
	* '''ShippingMethod''~~' is an '''optional''' field which allows you to specify the shipping method.~~		* ''CategoryUID''
	* '''JournalMemo''~~' is an '''optional''' field which allows you to specify the journal memo.~~		* ''Comment''
	* '''BillDeliveryStatus''~~' is an '''optional''' field which allows you to specify the delivery status (''ToBePrinted'', ''ToBeEmailed'', ''ToBePrintedAndEmailed'', ''AlreadyPrintedOrSent'').~~		* ''ShippingMethod''
	* '''OrderUID''~~' is an '''optional''' field which allows you to specify the UID of the order this invoice is linked to.~~		* ''JournalMemo''
			* ''BillDeliveryStatus''
			* ''OrderUID''

	== Notes ==		== Notes ==

Nic at 05:31, 17 November 2016

2016-11-17T05:31:10Z

← 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.		* '''PurchaseNumber''' is an '''optional''' field which allows you to specify the invoice number.
	* '''SupplierInvoiceNumber''' is an '''optional''' field which allows you to specify the supplier invoice number.		* '''SupplierInvoiceNumber''' is an '''optional''' field which allows you to specify the supplier invoice number.
	* '''~~Date~~''' is a '''mandatory''' field which allows you to specify the date of the invoice.		* '''PurchaseDate''' 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.
	* '''SupplierUID''' is a '''mandatory''' field which allows you to specify the UID of the supplier.		* '''SupplierUID''' is a '''mandatory''' field which allows you to specify the UID of the supplier.

Nic at 02:31, 15 November 2016

2016-11-15T02:31:54Z

← Older revision		Revision as of 21:31, 14 November 2016
Line 42:		Line 42:

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

Nic at 02:31, 15 November 2016

2016-11-15T02:31:39Z

← Older revision		Revision as of 21:31, 14 November 2016
Line 9:		Line 9:
	* '''Date''' is a '''mandatory''' field which allows you to specify the date of the invoice.		* '''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.		* '''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 a '''mandatory''' field which allows you to specify the UID of the supplier.
	* '''ShipToAddress''' is an '''optional''' field which allows you to specify the address on the invoice.		* '''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'').		* '''LinesType''' is an '''optional''' field which allows you to specify the type of the invoice line (''Transaction'', ''Header'', ''Subtotal'').
Line 37:		Line 37:
	* 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.		* 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 part of the transaction.

	== Related Topics ==		== Related Topics ==

	* [[Import Tables]]		* [[Import Tables]]

Nic at 01:08, 15 November 2016

2016-11-15T01:08:27Z

← Older revision		Revision as of 20:08, 14 November 2016
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 a '''optional''' field which allows you to specify the address on the invoice.		* '''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]]

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

2016-11-15T00:52:57Z

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

New page

== Overview ==

MYOXIMPORT_ServicePurchases allows you to import service purchases (invoice only) into MYOB.

== Fields ==

* '''Number''' is an '''optional''' field which allows you to specify the invoice number.
* '''SupplierInvoiceNumber''' is an '''optional''' field which allows you to specify the supplier invoice 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.
* '''SupplierUID''' is an '''mandatory''' field which allows you to specify the UID of the supplier.
* '''ShipToAddress''' is a '''optional''' field which allows you to specify the address on the invoice.

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

== Related Topics ==

* [[Import Tables]]