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

Wednesday, July 12, 2017

HSN code not printed in Tally Invoice

The aforesaid problem has been resolved by Tally Solutions in Tally ERP 9 Release 6.0.2 

View this video; or

Read the release notes of Tally ERP 9 Release 6.0.2 as shown below :

Release Notes
The HSN/SAC was not displayed in the printed invoice when it was recorded with:
o     Stock items predefined with HSN/SAC.
o     Sales/purchase ledgers predefined only with tax rate and not the HSN/SAC.

This issue is resolved. Now, if the HSN/SAC is not defined in the sales/purchase ledger, but is available in any of the masters linked to the transaction, the same will be printed in the invoice.

Sunday, July 9, 2017

New templates (added/removed)

Applicable to : udi-Magic v8.0 Release 2.1

The following changes have been done in the Standard templates :

NEW TEMPLATEs (Added)
1. Vouchers-V8-Sales-Purchase-Basic.xls
2. Master-CostCategoryMaster.xls
3. Master-CostCentreMaster.xls
4. Master-Update-StockItem-Name.xls
5. Master-Update-Ledger-Name.xls

OLD TEMPLATEs (removed)
1. Vouchers-V7-Sales-Purchase-Basic.xls

TEMPLATEs MODIFIED
1. Master-StockItemMaster.xls (GST Classification Name column added)

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

PS:
For more details in GST features in udi-Magic, please visit https://www.rtslink.com/gst/


Thursday, June 29, 2017

New templates (added/removed)

Applicable to : udi-Magic v8.0 Release 2.0

The following changes have been done in the Standard templates with regards to GST features :

NEW TEMPLATEs (Added)
1. Vouchers-V8-Sales-Purchase-Advanced.xls
2. Vouchers-V8-Sales-Horizontal-format-without-stockitems.xls
3. Vouchers-V8-Purchase-Horizontal-format-without-stockitems.xls

OLD TEMPLATEs (removed)
1. Vouchers-V7-Sales-Purchase-Advanced.xls
2. Vouchers-V7-Sales-Horizontal-format-with-VAT-without-stockitems.xls
3. Vouchers-V7-Purchase-Horizontal-format-with-VAT-without-stockitems.xls

TEMPLATEs MODIFIED
1. Master-LedgerMaster.xls
2. Master-StockItemMaster.xls

PS:
For more details in GST features in udi-Magic, please visit https://www.rtslink.com/gst/

Thursday, June 15, 2017

Template modifications

Excel to Tally templates - Modifications
The following changes have been done in udi-Magic Standard templates :

Template-Name : Master-StockItemMaster.xls

1. New fields / columns for VAT and Excise
2. If Alternate units are used, the Opening Stock is not displayed in alternate units - Now fixed.

Template-Name : Master-LedgerMaster.xls

1. New fields / columns related to VAT
2. New field ISCOSTCENTREAPPLICABLE

Template-Name : Voucher-Physical-Stock-Journal.xls

1. New columns for Base-Voucher-Type and Voucher-Type
2. Voucher Number not imported - Now corrected.

Template-Name : Voucher-Stock-Journal.xls

1.. New VoucherTypes not created as given in the XLS - Now corrected

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


Saturday, May 20, 2017

INTRODUCING UDIMAGIC V8.0

We are pleased to announce the launch of udi-Magic v8.0. The details are as under :-

NEW TEMPLATE(s)
A new template for Flipkart Settlement / Receipts has been included in udi-Magic v8.0 as shown below :

Template Name: Vouchers-Flipkart-Receipts-and-Journal.xls
XML-File Name : Vouchers-Flipkart-Receipts-and-Journal-xml-tags.xml

Steps:
1. Download and install udi-Magic v8.0
2. Copy/paste your Flipkart settlement data into aforesaid template / xls.
3. Start udi-Magic v8.0
4. Go to "Excel to Tally >> Import data into Tally"
5. Select files :
Excel File: Vouchers-Flipkart-Receipts-and-Journal.xls
XML-File : Vouchers-Flipkart-Receipts-and-Journal-xml-tags.xml 

6. Click the Start button to import data into Tally.

Remarks:
For each Settlement Number, two entries are posted in Tally .i.e.one entry for Receipt voucher and another for Journal voucher.

SUPPORT FOR TALLY ERP 9 RELEASE 5.5.8 AND GST
udi-Magic v8.0 works with Tally ERP 9 Release 5.5.8 (latest release at the time of this post).

The GST related updations shall be made available in udi-Magic v8.0 as and when the GST features are made available in the Tally ERP.

SUPPORT FOR EXCEL 2016
udi-Magic v8.0 works with Excel 2016 (32-bit and 64-bit)

Note
1. Customer(s) who have purchased udi-Magic v7.0 on or after 01/01/2017 shall be provided free upgrade to udi-Magic v8.0.
2. Customer(s) who have upgraded to udi-Magic v7.0 on or after 21/02/2017 shall be provided free upgrade to udi-Magic v8.0
3. All eligible customers can get the link to download udi-Magic v8.0, from here: https://www.rtslink.com/customer/forgot/

Wednesday, May 17, 2017

How to fetch the Tally Serial Number ?

SQL SELECT Statement

SELECT $$SerialNumber FROM Company

Remarks:
You can use the aforesaid SELECT Statement to fetch the Tally Serial using "Tally ODBC" or "Calculator panel" in Tally.

Monday, May 8, 2017

Template modifications

Template Name : Master-V6-StockItem-Multiple-price-levels

Bug fixes
1. StockItem ALIAS gets overwritten/removed when the Price List is imported - Now fixed.

Template Name : Master-StockItemMaster

New Field
"Inclusive of Tax" column has been included. Refer blog article : http://www.udimagic.com/2017/04/inclusive-of-vat.html

Remarks
Calc VAT on MRP
Refer blog article : http://www.udimagic.com/2017/04/calculate-vat-on-mrp.html

Sunday, April 30, 2017

Calculate VAT on MRP

Applicable to : Tally ERP 9 Release 5.5.6

Recently, we noticed some issues while using the "Calc VAT on MRP" feature. We posted two SALES INVOICEs in Tally, the details being as follows :

Sale Invoice 1

Stockitem Master Name: Item CX
MRP : Rs 250.
Calc VAT on MRP : Yes
MRP Incl of VAT : Yes
Is Inclusive of duties and taxes : Yes
VAT : 5%

Sale Voucher
StockItem Name : Item CX
Qty : 1
Rate : Rs 238.09 (Auto computed in Tally)
Amount : Rs 238.09 (Auto computed in Tally)
VAT Amount : Rs 11.91 (Auto computed in Tally)

Sale Invoice 2

Stockitem Master Name : Item DX

MRP : Rs 250.
Calc VAT on MRP : Yes
MRP Incl of VAT : Yes
Is Inclusive of duties and taxes : Yes
VAT : 4%
Addl Tax : 1%

Sale Voucher
StockItem Name : Item DX
Qty : 1
Rate : Rs 237.98 (Auto computed in Tally)
Amount : Rs 237.98 (Auto computed in Tally)
VAT Amount : Rs 9.62 (Auto computed in Tally)
Addl VAT Amt: Rs 2.40 (Auto computed in Tally)

Remarks
As it can be seen, the VAT amount is incorrectly computed when we specify VAT + Addl Tax in the StockItem Master and "Calc VAT on MRP" is enabled.

VAT 5% => Rs 11.91 (Correct VAT in Sale Voucher 1)
VAT 4+1% => Rs 12.02 (Incorrect VAT in Sale Voucher 2)

Workaround
A workaround is to disable the "Calc VAT on MRP"  and enable "Is Inclusive of duties and taxes" only in the StockItem Master. This way, VAT is computed correctly in both the situations as mentioned above.

Saturday, April 29, 2017

Inclusive of VAT

A new option "Allow inclusive of tax for stock Items" has been included in Tally ERP 9 Release 5.0 onwards. This allows you to prepare Sales Invoice with Rate inclusive of VAT.

Tally ERP 9 Release 5.0
1. Go to Stockitem creation/alteration
2. Press F12 [Config]. This displays the Stockitem Configuration screen as shown underneath :

Tally ERP 9 Release 5.0

3. Enable "Allow inclusive of tax for stock items" as shown above.

4. Back in the Stockitem screen, enable VAT Applicable and specify the VAT Rate using "Set/alter VAT details"
5. Next, set "Is inclusive of duties and taxes" to Yes


Tally ERP 9 Release 5.0



Tally ERP 9 Release 4.92 or lower
1. Go to Stockitem creation/alteration
2. Press F12 [Config]

This displays the Stockitem Configuration screen as shown underneath (without the Inclusive option) :

Tally ERP 9 Release 4.92
Remarks:
The "Is inclusive of duties and taxes" is NOT there in Tally ERP 9 Release 4.92

Sunday, April 23, 2017

Incorrect Unit (UOM) when importing data into Tally

Query:
I am importing Sales/Purchase Vouchers with StockItems  using one of the Standard templates provided with udi-Magic. For a specific voucher in the XLS file, the UOM is specified as "Nos", but when I check the entry imported in Tally, it shows the UOM incorrectly as "Kgs".
Ans:
This would happen if the StockItem already exists in Tally with UOM as Kgs.

You must manually change the UOM in the StockItem Master. And this is only possible if there are no vouchers entries for that StockItem.

Friday, April 21, 2017

Template modifications

Of late, the following modifications have been done in the Standard templates :

Date : 22nd April 2017
Template : Vouchers-Bank-Statement.xls
New Column : Group-Name for Other Ledger
Remarks : If the Group-Name is not specified, then the Ledgers are created under group "New Ledgers"

Previous Changes

Date : 3rd April 2017
Template : Vouchers-V7-Sales-Purchase-Adavanced.xls
New columns in the Settings / CSV file :
NATUREOFTRANSACTION
TYPEOFINVOICE
CSTFORMRECVTYPE

Date : 3rd April 2017
Template : Master-LedgerMaster.xls
New columns for :
TaxType
NatureOfTransaction
VATRate
AdditionalTax

Date : 30th March 2017
Template : Master-LedgerMaster.xls
New fields added for :
VATDEALERTYPE, VAT Reg Date, CST Reg Date

Date : 28th March 2017
Template : Master-LedgerMaster
New column for COUNTRY

Download link (all templates) :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip

Tuesday, April 4, 2017

Cannot alter unit for Item x

The aforesaid error generally appears while :

Uploading "StockItem Masters" into a Tally Company; which already contains the same StockItem but with a different unit of measurement.

Here's a example :

StockItem with name "Item A" exists in Tally Company having Unit of Measurement (UOM) as "Nos". Let's now try to modify it's UOM to Kgs. As you can see below, the cursor does NOT go the the Unit field.



Remarks:
This is a restriction in Tally Software. You cannot alter the UOM of a StockItem if one or more records / vouchers exist which contain that StockItem

Tuesday, March 21, 2017

Additional Tax in Tally ERP 9

Of late, we noticed some changes in the Ledger Entry screen while creating "Additional Tax" ledger. The same is as follows :

Tally ERP 9 Release 5.4



As you can see, in Tally ERP 9 Release 5.4, the "Type of duty" is to be set as "Additional Tax".

Tally ERP 9 Release 4.93



In Tally ERP 9 Release 4.93, the "Type of duty" is to be set as "VAT" and "Additional Tax" is to be specified in another field "Method of Calculation".

And here is the difference in the XML tags :

Tally ERP 9 Release 5.4
TAXTYPE : Additional Tax
SUBTAXTYPE : Output VAT

Tally ERP 9 Release 4.93
TAXTYPE : VAT
BASICTYPEOFDUTY : Additional Tax
SUBTAXTYPE : Output VAT

Monday, February 27, 2017

Activate license with USB Flash / Pen drive

This video shows how to activate the udi-Magic license with USB Flash drive.

If you face any have problems using the above link, you can watch the video at Youtube:
https://www.youtube.com/watch?v=jMSNjfG2Igk


PS:
Applicable to udi-Magic v6.0 and higher versions.

Tuesday, January 10, 2017

udi-Magic v3.0 / v4.0

This message is ONLY for udi-Magic v3.0 and v4.0 users. Others, please ignore it.

  • Upgradation of udi-Magic v3.0 / v4.0 to udi-Magic v7.0 has been discontinued since 1/1/2017. Users are required to buy new license of udi-Magic, if they wish to use the new features/version.
  • No support (telephonic, email, or otherwise) shall be available for udi-Magic v3.0 / v4.0.

Email intimations about the same were sent on 3rd Dec 2016 and 29th Dec 2016 to the email ids  registered with us at the time of buying udi-Magic (or updated by the users thereafter).

To verify or update your email ids registered with us, login using the underneath link and select tab/option "Update email".
https://www.rtslink.com/customer

Team
Shweta Softwares

Sunday, January 1, 2017

Free Support Services & Upgrades w.e.f 1/1/2017

All udi-Magic licenses purchased on or after 1st Jan., 2017  will include Free Support Services & Upgrades for a period 365 days. Free upgrades includes both minor and major Software upgrades.

Support is provided using Ticket system. For any help / assistance, open a ticket.

Remarks:
Earlier, the "Free support services & upgrades" period was 90 days.