Difference between revisions of "MYOXIMPORT ServicePurchases"

Jump to navigation Jump to search

MYOXIMPORT ServicePurchases (view source)

Revision as of 23:41, 16 November 2016

2,071 bytes removed ,  23:41, 16 November 2016
no edit summary
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
Write, Bureaucrats, Administrators
1,349

edits

Retrieved from "https://accountingaddons.com.au/wiki/odbclink/index.php?title=Special:MobileDiff/1344"

Navigation menu