Template modifications

Excel to Tally templates
Applicable to : udi-Magic v8.0 Release 2.8

TEMPLATEs  (Modifications)

1. Vouchers-V8-Sales-Purchase.xls

The following new fields/features have been added in this template.
a. Place of Supply [This field is optional]
b. Consignee State [This field is optional]
c. Consignee GSTIN [This field is optional]

2. Master-LedgerMaster.xls

The following new fields/features have been added in this template.
a. Price level  [This field is optional]

NEW TEMPLATEs (Added)
A new template named Master-VoucherTypeMaster.xls has been added for creating VoucherTypes.

OLD TEMPLATEs (removed)

The template Vouchers-V7-Sales-E-Commerce-Amazon.xls has been removed. However, this template is still available within the v70 folder in the Standard templates zip file. 

Clarifications on udi-Magic Upgradation

For udi-Magic Customers only

Applicable to : udi-Magic v8.0

If you have recently upgraded or wish to upgrade to udi-Magic v8.0, please read the following point carefully :

1. Upgradation includes udi-Magic v8.0 with latest Standard templates as available currently, but does NOT include any modifications in the Standard templates or Customized templates provided earlier.

2. Here's an example :

Customer A purchased udi-Magic in 2012 and got some customization done. The Customer paid for udi-Magic Software and also for the Customization work. Now, the Customer wants to upgrade to udi-Magic v8.0.

Clarifications

a. Upgradation will allow Customer A to use the latest version with the latest Standard templates. However, this does NOT include any modifications in the Standard templates or Customized templates provided to the user earlier.

b. Modifications in the Standard or Customized templates will on chargeable basis. However, due to the workload, we are currently unable to provide modifications or customization (on chargeable basis) and request Customers to use the available Standard templates.

It is requested that you read the terms and conditions at https://www.rtslink.com/terms/

Template modifications

Excel to Tally templates - Modifications
Applicable to : udi-Magic v8.0 Release 2.7

The following new features have been added in the Vouchers-V8-Sales-Purchase.xls template.

1. Party Alias 
You can specify the Party Code in the field. [This field is optional]

2. Part Number
You can specify the StockItem Part Number here. [This field is optional]

3. Bill-wise details
You can enter the Bill No; Date; Amount and Credit period when "Maintain Bill-wise details" is enabled in Tally. [These fields are optional]

The precedence for assigning Bill-wise details in Tally is as follows :
a. If Bill-wise details are specified in XLS, then these values are set in Tally.
b. If Bill-wise details are NOT specified in XLS, then :

For Sales: The VCHNO and VCHDATE are taken as the Bill-No and Bill-Date
For Purchase: The REFNO and REFDATE are taken as the Bill-No and Bill-Date

4. Payment and Receipt entries
Now payment and receipt entries are also supported in this template. The payment and receipt entries can be recorded with or without Stockitems.

Example of Payment
You can now record a purchase transaction using the "Purchase or Payment" voucher-type. This is generally useful for recording Cash Payment transactions.

Example of Receipt
You can now record a sales transaction using the "Sales or Receipt" voucher-type. This is generally useful for recording Cash Receipt transactions.

New Templates (added/removed)

Excel to Tally templates
Applicable to : udi-Magic v8.0 Release 2.6

The following changes have been done in the Standard templates :

NEW TEMPLATEs (Added)
A new template named Vouchers-V8-Sales-Purchase.xls is added having the following features :

1. Provision to hide or show columns
You can now hide or show columns using the sheet "EnableDisableFeatures" from within the template itself.

2. Other Ledgers before GST Taxes
You can now specify Freight, Packing and other ledgers before the GST Taxes so that they are included in computation of GST Taxes. However, this can be done if there is only one StockItem in the Invoice or all StockItems have the same GST rate.

3. Includes

• Godown and Item Batch details; 
• Cost Category and Cost Centre; 
• Order and Tracking details;
• Actual and Billed Qty;
• Buyer and Consignee details;
• GST Taxes including UT Tax and Cess;
• Auto-Round off.

4. Supports the following Voucher types :

• Sales Order, Delivery note, Sales, Credit Note;
• Purchase Order, Receipt Note, Purchase, Debit Note

5. Replaces
This templates substitutes the template "Vouchers-V8-Sales-Purchase-Advanced.xls" which is now discontintued. However, the Vouchers-V8-Sales-Purchase-Advanced.xls template is still available in the  folder "c:\udi-Magic\templates-discontinued"

PS:
The template Vouchers-V8-Sales-Purchase.xls will ONLY work with udi-Magic v8.0 Release 2.6 or higher.

OLD TEMPLATEs (removed)

The template Vouchers-V8-Sales-Purchase-Advanced.xls has been removed.