Import - Stock items
This option will allow you to import data for Stock items from a valid file format into an existing Set of Books. To be able to import the data for Stock items, you need to have created a valid XML Database File format or a valid Lotus Spreadsheet file format on your system in the Export option on the Setup ribbon.
To import Stock items:
1.On the Setup ribbon, select Import. The "Import Data into TurboCASH" screen is displayed:
2.Select Stock as the "Data type to import" option.
3.Select one of the following file types in which the data to import, is saved on your system:
a)Tab delimited (*.txt) (used in this example)
b)Comma Separated Values (*.CSV)
c)XML Database File (*.XML)
d)Lotus Spreadsheet File (*.WK1)
4.Click on the button to locate the data file. The following screen is displayed:
5.Click on the button to locate the data file.
You may click on the View file button to open the file in the default program on your System which is associated with the selected file type. In this example the text file is opened in "Notepad":
6.Click on the button. The following screen is displayed:
7.Click on the Import button. The "ImportCheck" screen is displayed:
8.You may use the record buttons to add, delete or change the stock records on the "ImportCheck" screen. You may then click on the All or OK buttons to import the stock file.
9.Once the import process is finished an information message "Data file import completed!" will be displayed. Click on the OK button.
10.Go to the Reports ribbon and select Reports → Stock → Stock item listing to check the stock items.
11.Go to the Action ribbon and select Stock items to edit the stock items, if necessary.