Friday, October 4, 2013

UDIMAGIC v5.0 Release 1.2


Computing Totals using curly braces {}
In earlier versions (i.e. v4.0 or lower), we had to use Macros (VBA) for computing totals of Excel Sheet data where ever required. Now from Release 1.2 onwards, we can use curly braces {} within XML tags to compute totals .

Fist, let us have a look at a simple Excel Formula as shown underneath:-

Formula:     =Round(H#,2)
The aforesaid Formula gives the rounded-value of a specific cell (say cell H2). The # symbol is replaced with Excel sheet row no at run-time. 

Now, let us have a look at the new syntax wherein curly braces are used:-

Formula with Totals:   ={Round(H#,2)}
The aforesaid Formula gives the running totals. Say a voucher starts from row 2 and ends at row 5, then this formula gives total of  cells H2 to H5.

This new feature is used to compute totals for Excel sheet data in following formats :-

You can use the aforesaid formats with UDIMagic v5.0 Release 1.2 onwards. Following are the noteworthy points :-

a) Sales and Purchase formats with StockItems; Multiple VAT rates.
Ex: VAT 5%,VAT6%,VAT7%......etc. You can have any number of VAT types in these formats and can use any number of Columns.

b) Other Ledgers like Frieght, Cash Discount....etc can also be specified.

There is no limit and you can use all Columns in the Excel sheet.

These formats can be downloaded from folder

No comments: