business:import_jv_transactions
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision |
business:import_jv_transactions [2018/07/24 18:21] – external edit 127.0.0.1 | business:import_jv_transactions [2023/11/29 20:49] (current) – emoreno |
---|
<WRAP round intro> | <WRAP round intro> |
This file layout is used to import general journal transactions. | This file layout is used to import general journal transactions. |
| |
| {{:business:import_jv_transactions_template.xlsx|- Import JV Transactions Template}} |
</WRAP> | </WRAP> |
| |
| |
<WRAP Box> | <WRAP Box> |
**Notes**:\\ \\ This is a comma-delimited file format, which means that commas are not allowed within a field. For example, there should not be any commas in the **JV Number Description** or the **GL Account Description** fields.\\ \\ For amounts, decimal places not implied. For example, 6789 indicates $6,789, and 67.89 indicates $67.89. Eleven numeric characters can be entered with two decimal places, or when whole number are entered, nine numeric characters are allowed.\\ \\ Credit amounts should start with a minus sign (e.g., -).\\ \\ Amount fields with no data should be empty in the file; do not use zeros.\\ \\ Newly created accounts will be validated by each component within the Finance > Tables > Account Codes tabs and will contain the same edits as found on the Finance > Maintenance > Create Chart of Accounts page. | **Notes**:\\ \\ This is a comma-delimited file format, which means that commas are not allowed within a field. For example, there should not be any commas in the **JV Number Description** or the **GL Account Description** fields.\\ \\ For amounts, decimal places not implied. For example, 6789 indicates $6,789, and 67.89 indicates $67.89. Eleven numeric characters can be entered with two decimal places, or when whole numbers are entered, nine numeric characters are allowed.\\ \\ Credit amounts should start with a minus sign (e.g., -).\\ \\ Amount fields with no data should be empty in the file; do not use zeros.\\ \\ Newly created accounts will be validated by each component within the Finance > Tables > Account Codes tabs and will contain the same edits as found on the Finance > Maintenance > Create Chart of Accounts page. |
</WRAP> | </WRAP> |
business/import_jv_transactions.1532456492.txt.gz · Last modified: 2018/07/24 13:21 (external edit)