This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| business:import_invoices [2022/09/30 15:32] – external edit 127.0.0.1 | 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. | ||