User Tools

Site Tools


accountsreceivable:utilities:importinvoices

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
accountsreceivable:utilities:importinvoices [2022/04/26 20:19] emorenoaccountsreceivable:utilities:importinvoices [2022/06/01 12:54] (current) emoreno
Line 10: Line 10:
   * 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.
   * Commas may only be used in the file to separate data values, not within a field (e.g., (Invoice) Description field).   * Commas may only be used in the file to separate data values, not within a field (e.g., (Invoice) Description field).
 +  * The current system date will populate any blank **Date Requested** fields. If there are any invalid dates, an error is displayed on the report and the import is not completed. 
   * 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.   * 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.   * Account codes are validated on the Finance > Maintenance > Create Chart of Accounts page.
Line 18: Line 19:
 ====Import invoices:==== ====Import invoices:====
  
-^Number of Days for Due Date|Type the number of days to be added to the requested date of the invoice and generate the applicable due date. If zero or blank, no days are added.\\  \\ For example, if you type 10 in this field for an invoice with a requested date of 4/18/2022, then the due date for the imported invoice will be 4/28/2022.  |+^Number of Days for Due Date|Type the number of days for the invoice due date. This number of days is added to the requested date of the invoice to generate the invoice due date. If zero or blank, no days are added.\\  \\ For example, if you type 10 in this field and an invoice has a requested date of 4/18/2022, then the due date for the invoice will be 4/28/2022.|
  
 VCV Click **Choose File** to select a file to be imported.  VCV Click **Choose File** to select a file to be imported. 
accountsreceivable/utilities/importinvoices.1651004381.txt.gz · Last modified: 2022/04/26 15:19 (external edit)