Change in Export Files in the Quick Books Format
Reference No: 24999
(V 02.00.14-00)
Details
In CR2, some changes have been made to the files which are exported in the Quick Books format. The changes are as explained in Table 1.0.
Table 1.0 Changes Made to Export Files in Quick Books Format
Quick Books File Name | Column Number | Column Name | Description |
General.csv | 7 | Class | This column will be blank. |
10 | Report Group | This column will be populated with the Report Group field value. | |
11 | SiteID | This column will be populated with the Site's ID where the transaction was done. | |
Purchase.csv | 22 | Sales Tax Code | The Tax Region selected in the Voucher is populated here. |
23 | Tax Type | If value entered in this column is 2, it means that the item is non-taxable. Any other value entered in this column means the item is taxable. | |
24 | Report Group | This column will be populated with the Report Group field value. | |
25 | SiteID | This column will be populated with the Site's ID where the transaction was done. | |
26 | Is Credit | This column gets used only while processing a Voucher Credit Memo. This column will have the value as "True" if the Voucher Credit Memo is true. If not it will have the value as "False". | |
Sales.csv | 33 | Report Group | This column will be populated with the Report Group field value. |
34 | SiteID | This column will be populated with the Site's ID where the transaction was done. |
Note: All the columns listed in the Table 1.0 are newly added to the respective files except the column named Class within the General.csv file.