This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
business:import_invoices [2020/10/19 20:37] – 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 | ||
+ | |||
+ | |||
- | <WRAP Box>**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. | ||
+ | * A separate invoice record is created for each row of data in the file, and the Invoice Numbers are assigned in sequential order. | ||
+ | * Commas may only be used in the file to separate data values, not within a field (e.g., (Invoice) Description field). | ||
+ | * Decimal places are not implied for amounts (e.g., 6789 indicates $6,789.00 and 67.89 indicates $67.89). You can enter 11 numeric characters with two decimal places, or if using whole numbers, you can enter nine numeric characters. | ||
+ | * Account codes are validated on the Finance > Maintenance > Create Chart of Accounts page. | ||