This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
business:import_invoices [2022/06/28 16:20] – emoreno | business:import_invoices [2022/09/30 15:33] (current) – emoreno | ||
---|---|---|---|
Line 14: | Line 14: | ||
|Account Code|20|Alphanumeric|Required| | |Account Code|20|Alphanumeric|Required| | ||
|Amount|11|Numeric|If blank, the field is set to zero. Decimal places are not implied.| | |Amount|11|Numeric|If blank, the field is set to zero. Decimal places are not implied.| | ||
+ | |Reference|20|Character|Optional | ||
+ | |Due Date|8|YYYYMMDD|Optional | ||
+ | |Quantity|7|Numeric|Optional | ||
+ | |Unit of Issue| | ||
+ | |Product Type| | |Optional, populated from product number.| | ||
+ | |Unit Price|11|Numeric|Optional | ||
+ | |||
- | ---- | ||
**Notes**: | **Notes**: | ||
+ | * If the **Unit Price** and **Quantity** are entered, the amount is not automatically calculated. The actual amount entered is displayed. | ||
* Uploaded files must be in the comma-delimited text (.txt) or comma-separated values (.csv) format. | * Uploaded files must be in the comma-delimited text (.txt) or comma-separated values (.csv) format. | ||
* A separate invoice record is created for each row of data in the file, and the Invoice Numbers are assigned in sequential order. | * A separate invoice record is created for each row of data in the file, and the Invoice Numbers are assigned in sequential order. |