This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
business:import_invoices [2018/07/24 18:21] – external edit 127.0.0.1 | business:import_invoices [2022/09/30 15:33] (current) – emoreno | ||
---|---|---|---|
Line 9: | Line 9: | ||
|Customer Number|6|Numeric|Required; | |Customer Number|6|Numeric|Required; | ||
|Requested By|35|Character|Required if Customer PO Number is blank| | |Requested By|35|Character|Required if Customer PO Number is blank| | ||
- | |Customer PO Number|20|Numeric|Required if Requested By field is blank| | + | |Customer PO Number|20|Alphanumeric|Required if Requested By field is blank| |
|Date Requested|8|YYYYMMDD|Optional; | |Date Requested|8|YYYYMMDD|Optional; | ||
|Description (Invoice)|80|Character|Required; | |Description (Invoice)|80|Character|Required; | ||
|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. | ||