Export - Inventory items

Parent Previous Next

This feature is additional to the powerful Report Export facility in which all reports for Inventory 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 Inventory 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 Inventory items in a Lotus123 (*WK1) file format and import it in Action → Inventory items.

All the information regarding each inventory item as entered in the Action → Inventory items (Inventory code, Barcode, Description, Re-order levels, Apply invoice discount, Selling prices, Unit Description, Cost of sales account, Sales account, Input Tax 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 Inventory items in a Lotus123 (*WK1) file format and import it in the Action → Inventory items menu.

To export Inventory items:

1.On the Setup ribbon, select Export. The Export Data to File screen will be displayed.

2.Click on the Inventory button, if not selected. The screen will change to display the options for the Inventory:

3.Select and / or enter the following:

a)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. You may then select any available folder, or drive, on your system into which you wish to export the data.

b)File type - Select to export the file in the XML Database (*XML), Comma Separated Variable (*CSV), Lotus Spreadsheet File (*WK1), MS Excel Spreadsheet (*XLS), or any other format available on your system from the list.

"Import file format not implemented!" information message is displayed for the following file types:

TXF TurboCASH Exchange File

SXC OpenOffice Spreadsheet

The XML Database (*XML) file format export can only be imported in Setup → Import. It cannot be imported in Action → Inventory items.

c)Export files name - Enter the File name. You need to select this file at a later stage when you wish to import the file, or analyze the data in a spreadsheet.

d)Log file - Enter the Log file name.

e)Range - From ... To - The Inventory lookup will be automatically initiated. Select any range of accounts to include in the export file.

4.Click on the Export button. TurboCASH will create the export file, and save it in the specified directory.

The information for the Inventory items, which will be exported, is:

Inventory code

Inventory item type



Quantity on hand

Reorder quantity

Apply invoice discount

Selling price 1 amount

Selling price 2 amount

Selling price 3 amount

Unit average cost amount

Unit cost amount

Unit description

Inventory group 1

Inventory group 2

Cost of sales account

Sales account code

Inventory account

Input Tax account

Output Tax account

Created with the Personal Edition of HelpNDoc: What is a Help Authoring tool?