osfinancials version 2.0.3.3 (Beta)

osF

We realy made some steps forward again in bringing you the best accounting software.

fixed

*Pos float movement has been improved. Link to documents selected is retained.
*Unlink cash bank or pos payment has been improved.
*Opening a document made 3 requests to the full debtor table. We now use pure sql with makes it a lot faster.
*Pos discount with barcode enabled did not return to the barcode field.

Added

*Html file can now contain SQL list,s or SQL values. The following syntax can be used.
<!--#osflist sql="select first 10 WDocid ,SDocno TRN126 from dochead where Sdocno <> '' order by Sdocno" border="1" cellspacing="0" cellpadding="0" align="center" --> <BR>Total invoice : <!--#osfselect sql="select sum(FDocAmount) Total from dochead where WTypeId = 10" --> With the osflist the alias of a field can have a translation TRN126 will use translation 126 for the column. If it finds the field WDOCID it can make a HTML link to the print of that document. Also you can use @Filename so it will use the SQL in the file Filename in the folder bin\welcome\Sql (for those hard ones with link sin it). It can also handle parameters (divided by a space) so the Sql can be used to view details. There is a example to show debtor creditor info but anything is possible here. You can even use HTML form for input parameters on your Queries. Example page is included.

*Rebuild groups to just look at the types table to create group edit features. This makes adding a type (drop down list) easy.
*Types can now be edited at the languages screen (extra->language settings)
*Group status history is saved for documents and projects and can be viewed at the details of a document by hovering over the Reporting group 1 and 2 control. A hint will show with the group status.
*Simple Project management. By enabling projects on the Setup->preferences->Data parameters you can add documents to a project. Also calculations of purchase and sales documents can be viewed as a report. But as this is reportman any report can be build.
*Added images to groups. You can now add you image to the groups. This will be used for building buttons in the new button view for stock items. If no text is needed (just the image) make sure its width=120 height=40 so it will cover the whole button.
*Added images to stock items. On the new extra tab you can select a image for this stock item This will be used for building buttons in the new button view for stock items. If no text is needed (just the image) make sure its width=120 height=40 so it will cover the whole button.
*Added Button view (Setup->System parameters->Stock information) By enabling button view your selection screen for stock items is transformed to something you can use in a touch screen. For each group that has no parent a button will appear

Full install
http://downloads.sourceforge.net/osfinancials/osf2-0-2-0Full.exe?use_mirror=osdn

update this with the new version
http://downloads.sourceforge.net/osfinancials/osF2-0-3-3Upd.exe?use_mirror=osdn