Tuesday, August 22, 2017

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/

Tuesday, August 8, 2017

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.


Thursday, August 3, 2017

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.


Wednesday, July 26, 2017

Templates modification

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

The following new features have been added in the Master-StockItemMaster.xls template.

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

2. Default Accounting Allocations
Separate columns for "Default Accounting Allocation for Sales" and "Default Accounting Allocation for Purchase" have now been kept.

3. New column for MRP Effective date
You can now specify the MRP Rate and the effective date. Please read the remarks in the template regarding MRP.

PS:
The data starts from Row No 3 (instead of Row no 2) in this template.

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

Monday, July 17, 2017

Tax Analysis not printed in Tally Invoice

Query
I have imported the StockItems using the Master-StockItemMaster.xls template; but while printing the Invoice, the Tax Computation (at the bottom) is NOT displayed / printed.

Solution
In the Master-StockItemMaster.xls file, put 0 (zero) in the Column CESS-RATE (Column AV) and then re-import the data from Master-StockItemMaster.xls.

Next, re-print the Invoice.

Friday, July 14, 2017

Templates modification

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

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

Auto Rounding-Off

This feature allows automatic "Rounding off" to the nearest rupee. The default value is Yes.

Common Ledgers for IGST; CGST; SGST
The GST tax ledgers are now created without the tax-rates in Ledger Master. This allows you to have one common GST Tax ledger instead of multiple GST Tax ledgers in Invoice.

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

Thursday, July 13, 2017

Templates modification

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

The following new fields have been added in the Master-StockItemMaster.xls template.

Field
: Old Name
Description : Specify the StockItem Name or Part Number for which you want to update / set GST Taxes and other values.
Remarks:
1. If you already have StockItems in Tally and want to set / update the GST details or other fields, you can specify the Part Number or Item Name, and other details as required.
2. Mandatory for modifying StockItem and optional while creating new StockItems.

Field : UT Tax
Description : Specify the UT Tax rate (i.e. union territory tax)
Remarks : As STATE TAX is for States, the UT-TAX is for Union territories.

Issues Fixed : Tax Computation not displayed / printed in Invoice printing
Remarks : The Tax Analysis was not displayed (at the bottom) in the Invoice printing, if CESS-RATE field is kept empty. This issue has been fixed now.

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