Export Invoice data

In the Professional and the Enterprise editions you have the option to export your invoice data

This feature is great when your accountant is doing your books, he will not have to enter all the details into his software, meaning you will save money, or at the very least get your books done faster. The feature can be found by clicking File–>Export Invoice Data’

The program will write a line in an Ascii file for each invoice being locked.

The filename is InvData.Csv and the file is found here: C:\Users\Public\Documents\All-Round Invoice
This file is not part of the software backup routines.

In this file you have a line for each locked Invoice or Creditnote. Each line is separated by CR LF.
Each field in the line is limited with quotation marks.

Each field in the line is separated with a semicolon

The fields is:
Invoice date in the format mm/dd/yyyy
Invoice number or Creditnote number
A text: Either ‘Invoice’ or ‘CreditNote’
Customer number
Invoice total amount in the format x,xxx.yy

TAX amount in the format x,xxx.yy
Freight amount in the format x,xxx.yy
Currency description

Here is an example of 2 lines in the file:
“18.10.2008″;”31″;”Invoice”;”2″;”290.75″;”58.15″;”0.00″;”£”

“19.10.2008″;”15″;”Creditnote”;”1″;”1,459.45″;”276.89″;”75.00″;”£”

IMPORTANT!!

The program is writing to the file, but it is never deleting it.
Take care that the file is not write protected as it will result in missing data in the file. This will happen if f.ex. the file is open in Microsoft Excel while the program is trying to write to the file. This is because Excel is opening the file in Exclusive mode.
The correct use of the file is:
1: Rename the file
2: Use the renamed file
3: Delete the renamed file.

It is your own responsibility to secure that InvData.Csv is not being used when the program needs to write to it.