Interfaces

User Tools

Site Tools

Trace: • Import Invoices File Layout
business:import_invoices

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
business:import_invoices [2020/10/19 20:37] – emorenobusiness: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|  |  |Optional, populated from list.|
 +|Product Type|  |  |Optional, populated from product number.|
 +|Unit Price|11|Numeric|Optional  |
 +
 +
   
-<WRAP Box>**Notes**:\\  \\  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. +**Notes**: 
-</WRAP>+ 
 +  * 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. 
  
  
business/import_invoices.1603139834.txt.gz · Last modified: 2020/10/19 15:37 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.