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