Pages

Tuesday, March 29, 2016

Purchase and Sales Horizontal formats

In udiMagic v7.0 Release 1.4 onwards, the Horizontal formats for Sales and Purchase have been removed and a common new format for Sales and Purchase is introduced.

For those using the udiMagic v7.0 Release 1.0 to Release 1.3, the Sales and Purchase Horizontal formats need to be updated as shown below :

1) Vouchers-V7-Sales-Horizontal-format-with-VAT-with-stockitems.xls
Changes in cell Z1  (Specify column V in the Round function)
Changes in cell AA1 (Specify column W in the Round function)
Changes in cell AB1 (Specify column X in the Round function)

2) Vouchers-V7-Purchase-Horizontal-format-with-VAT-with-stockitems.xls
Changes in cell AF5  (Specify column AB in the Round function)
Changes in cell AG5 (Specify column AC in the Round function)
Changes in cell AH5 (Specify column AD in the Round function)

3) Vouchers-V7-Purchase-Horizontal-format-with-VAT-without-stockitems.xls
Changes in cell N1  (Specify column M in the Round function)
Changes in cell P1 (Specify column O in the Round function)