taken from the
This facility is in addition to the powerful Report Export
facility, in which all reports for Stock items in TurboCASH may be exported and
saved in any available format on your system, such as Word Processing (Text),
Spreadsheets, etc. Using this facility, you may also export the data of your
Stock Items in an open Set of Books to XML Database format or any available
format on your system. You may then open the other applications to which the
exported data is saved and work in the applications, such as OpenOffice.org Calc, Lotus 123,
Microsoft Excel, etc. You may edit the data for your Stock Items in a Lotus123
(*WK1) file format and import it in the Input Adjust Stock menu option.
All the information regarding each stock item as entered in the Edit - Stock Items (Stock Code, Barcode, Description, Re-order levels, Apply Invoice Discount, Selling Prices, Unit Description, Cost of Sales Account, Sales Account, Input and Output Tax Accounts) will be displayed. In the same export file, the latest updated information regarding any adjustments and transactions (Quantity on hand and Average Cost) would also be included into the selected export file format.
You may edit the data for your Stock Items in a Lotus123 (*WK1) file format and import it in the Input Adjust Stock menu option.
To Export Data for your Stock Items:
Click on Tools - Export menu option or press the 
and 
and 
keys on your keyboard. The Export
Data to File (Documents tab) screen will be displayed. Select the Stock tab if
not selected. The screen will change to display the options for the Stock
Options.
Select and enter the following for the options
to create an export data file.
Click on the 
button. TurboCASH will create the export file and save it in the specified
directory.
- XML Database file
- OpenOffice.org
Spreadsheet
- Lotus 123 Spreadsheet
file
- Microsoft Excel
Workbook (Spreadsheet).
- Comma Separated Value
All the information regarding each stock item as entered in the Edit - Stock Items (Stock Code, Barcode, Description, Re-order levels, Apply Invoice Discount, Selling Prices, Unit Description, Cost of Sales Account, Sales Account, Input and Output Tax Accounts) will be displayed. In the same export file, the latest updated information regarding any adjustments and transactions (Quantity on hand and Average Cost) would also be included into the selected export file format.
You may edit the data for your Stock Items in a Lotus123 (*WK1) file format and import it in the Input Adjust Stock menu option.
To Export Data for your Stock Items:
Click on Tools - Export menu option or press the and and keys on your keyboard. The Export
Data to File (Documents tab) screen will be displayed. Select the Stock tab if
not selected. The screen will change to display the options for the Stock
Options.
Select and enter the following for the options
to create an export data file. | Option | Description |
| Export to |
The installation directory in which TurboCASH is
installed will be displayed. You may click on the Browse  icon to select a
folder on the Browse for Folder screen on
which you may select any available folder or drive on your system into
which you wish to export the documents to. |
| File Type | You may select to export the file in the XML Database (*XML), Comma Delimited File (*CSV), Lotus Spreadsheet File (*WK1), MS Excel Spreadsheet (*XLS) or any other format available on your system from the dropdown list. |
| Export File Name | Enter the File name. You need to select this file at a later stage when you wish to Import the File or analyse the data in a spreadsheet. |
| Log File | Enter the Log File name. |
| Range From and To | The Stock Item search facility will be automatically initiated. Select any range of codes. |
Click on the button. TurboCASH will create the export file and save it in the specified
directory.
- XML Database file - OpenOffice.org
Spreadsheet - Lotus 123 Spreadsheet
file - Microsoft Excel
Workbook (Spreadsheet). - Comma Separated Value
