Saturday, September 2, 2017

Template modifications

Excel to Tally templates
Applicable to : udi-Magic v8.0 Release 2.9
Description : Compatible with Tally ERP 9 Release 6.1

TEMPLATEs  (Modifications)

1. Vouchers-V8-Sales-Purchase.xls
The following new fields/features have been added in this template :

Additional GST details (Nature of Return for Debit/Credit Notes)
a. Nature of Return
b. Supplier's Debit/Credit Note No
c. Date
Buyer details
a. State
b. Place of Supply
c. GST Regn Type
d. GSTIN
Other Settings
a. IsCancelled
b. IsOptional
Overwrite/Update existing Masters (Warning : May result in data loss)
a. Update StockItem Masters

Remarks:
The template Vouchers-V8-Sales-Purchase.xls contains macros. You must enable macros to hide / show the columns using the EnableDisableFeatures sheet.

2. Master-UnitMaster.xls
The following new fields/features have been added in this template :
a. Decimal Places
b. UQC (Unit Quantity Code)

3. Master-LedgerMaster.xls
a. Re-grouping of fields/columns
b. Hide or Show fields/columns

4. Vouchers-V8-Sales-Purchase-Basic.xls  &  Vouchers-V8-Sales-Purchase.xls
To specify Freight or other ledger(s) before Taxes :
   - Keep the Item-Name and PartNo empty/blank;
   - Specify the Amount; and the Sale/Purchase LedgerName
   - Refer sample data in the aforesaid templates

You can download (all latest templates for udi-Magic v8.0) the zip file from this link :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip





No comments: