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 DOCUMENTS TO A XML FILE
  
The Document 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 Documents tab and the XML File Type is selected. Once the data for Documents 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 or to Import Documents. If Documents are exported, two files are created, i.e.
  1. Header File - contains the information generated, selected and entered on the Document Entry Header screen. This information includes an unique ID number created for each document, document type (Invoice, Credit Note, Purchase, Goods Returned document, Quotes and Orders), as well as the Total amount of the Document Inclusive of VAT, the VAT amount and the status of the document (printed and posted or not), etc.

  2. Lines File - contains information regarding the transactions and comments selected and entered on the Document Entry Details screen.
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. SDocNo="OR000001").

The respective fields are as follows:

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



Col. Field Details Value
A WDocID TurboCASH generates a unique Document identification number for each document created. Numeric
B WTypeID Invoice=10

Credit Note=11

Purchase=12

Goods Returned=13

Quotes=14

Orders=15
Numeric
C DDate Date when document is created. Date
D DAllocatedDate Allocated Date. Date
E SDocNo Document number generated by TurboCASH Alpha-numeric
F SReference Reference as entered in the Your Reference field. Alpha-numeric
G BPrinted Printed=True or Unprinted=False True/False
H BPosted Posted=True or Unposted=False True/False
I BExclusive Exclusive=True or Inclusive=False mode. True/False
J FInvoiceDiscount Full Invoice Discount amount Amount
K FDocAmount Full Document amount Amount
L FTaxAmount Full Tax amount Amount
M WAccountID Account ID for Debtors / Creditors accounts Numeric
N WPaymentTypeID Payment Type ID  
O WPaymentGroupID Payment Group ID  
P BRepeating Repeating Invoice True
Q SAccountCode Debtor account or Creditor account number. Alpha-numeric
R WAccountTypeID Account Type ID - 1=Debtor and 2=Creditor 1 or 2
S SPost1 Postal Address line 1 Alpha-numeric
T SPost2 Postal Address line 2 Alpha-numeric
U SPost3 Postal Address line 3 Alpha-numeric
V SPostCode Postal Address Postal Code Alpha-numeric
W SMsg 1 Message line 1 Alpha-numeric
X SMsg 2 Message line 2 Alpha-numeric
Y SMsg 3 Message line 3 Alpha-numeric
Z SSalesperson Selected for Invoices, Credit Notes and Quotes only. Alpha-numeric
AA SDel1 Delivery Address line 1 Alpha-numeric
AB SDel2 Delivery Address line 2 Alpha-numeric
AC SDel3 Delivery Address line 3 Alpha-numeric
AD SDelCode Delivery Address Postal Code Alpha-numeric
AE SGroup1 Document Group 1 Alpha-numeric
AF SGroup2 Document Group 2 Alpha-numeric
AG SCurrency Currency Alpha-numeric
AH SUserName User Name if users were created. Alpha-numeric

To access the XML Lines 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 Documents 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. SDescription="Drill Press").

The respective fields are as follows:

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



Col. Field Details Value
A WDocID TurboCASH generates a unique Document identification number for each document created. Numeric
B WLineTypeID Transaction=90

Comment=91
Numeric
C WLineID Line number for each transaction in documents. Numeric
D WStockID Numeric ID created by TurboCASH for each Stock Item in the Stock Item code file. Numeric
E FQtyOrder Quantity entered in the Order column. Alpha-numeric
F FQtyShipped Quantity entered in the Shipped column. Alpha-numeric
G FSellingPrice Selected or edited selling price Amount
H FItemDiscount Amount of Discount for the transaction / line. Amount
I WTaxID VAT or Tax account ID number. Numeric
J FInclusiveAmt Invoice Discount amount Amount
K FExclusiveAmt Full Document amount Amount
L FTaxAmount Full Tax amount Amount
M SDescription Stock Item description or name. Alpha-numeric
N SAccountCode Tax account code Alpha-numeric
O SStockCode Stock Item code Alpha-numeric