TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







EXPORT DATA
EXPORT STOCK TO A XML FILE
  
The Stock Item records or data are saved in a XML (Extended Mark-up Language) file when the data is exported in the Tools - Export menu option on the Stock tab and the XML File Type is selected. Once the data for Stock Items have been saved to a file, you may access the file by locating it in the specific location and file name where you have saved this file on your system. You may use this XML file to store and to Import Stock Items.

To access the XML file:
Locate the file on your system. You may use the Windows Explorer .

Double-click on the icon with the name you have saved the specific data for the exported Stock Item file. The selected file will be displayed.

 



The exported data consists of 2 sections in the XML file, i.e. Metadata and Rowdata sections.

Metadata section of the file:

The data fields and their properties are defined in the Metadata section of the file. This is similar to that of row 1 (Headings) in an exported spreadsheet file.

Rowdata section of the file:

The individual details or data as entered in the Edit - Stock Items menu option are defined in each row after the field name starts with the tag "<" and ends with the tag ">". Each field for a transaction (e.g. Description, etc.) are displayed in a bold font type and is displayed between an identifier ("), (e.g. Description="Compressor").

The respective fields are as follows:

The data fields of the XML file is displayed on the screens in TurboCASH as follows:



Field Field Attributes Details Values
A Stock Code Stock Item code Alpha-numerical
B Barcode Barcode Alpha-numerical
C Description Description or name of the Stock Item Alpha-numerical
D Quantity on Hand Quantity or number of Items on Hand Numerical
E Re-Order Quantity Minimum Quantity on Hand to re-order new Stock Items Numerical
F Apply Invoice Discount Allow Discount on Invoices for Debtors / Customers. True= Allow Discount / False do not Allow Discount.
G Selling Price 1 Amount (Excluding VAT) Amount
H Selling Price 2 Amount (Excluding VAT) Amount
I Selling Price 3 Amount (Excluding VAT) Amount
J Unit Average Cost Amount (Excluding VAT) Amount
K Unit Cost Amount (Excluding VAT) Amount
L Unit Unit Description (e.g. each, litres, etc.) Amount
M Group 1 Stock Group 1 Alpha-numerical
N Group 2 Stock Group 2 Alpha-numerical
O Cost Account Cost of Sales Account Alpha-numerical
P Sales Account Sales Account (Income) Alpha-numerical
Q Stock Account Stock Control Account Alpha-numerical
R Input Tax Account Tax Account used for Input Tax on Purchase and Goods Returned documents. Alpha-numerical
S Output Tax Account Tax Account used for Output Tax on Invoices, Credit Notes and POS Invoices. Alpha-numerical