Friday, October 20, 2017

Map excel and import in Tally ERP 9

How to map your excel file and import it into Tally ERP 9?

Here's a video on how to map excel file and import it in Tally ERP 9

For reference, the steps are given underneath :

Steps to Map your Excel file
  1. Start udi-Magic converter
  2. Select the option Excel to Tally > Create a Custom template
  3. Select the files :
    • udi-Magic Standard Excel template
    • Your Excel file
  4. Map the columns
  5. Save the Mapping file

Steps to Import data into Tally
  1. Start Tally ERP 9 and Open a Company.
  2. Start udi-Magic software.
  3. Select the option Excel to Tally > Import data into Tally.
  4. Select the files
    • Your Excel file
    • Xml file (Mapping file generated in the mapping process)
  5. Click the Start button.

Wednesday, October 18, 2017

udi-Magic v8.0 Release 3.4

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

NEW FEATURES
udi-Magic v8.0 Release 3.4
 now supports Trade Discount feature which allows you to specify the discount value for each item in the invoice, and the discount value is considered as part of the assessable value of an item.

The Trade discount feature is available in the following Excel formats :
a. Vouchers-V8-Sales-Purchase-Basic.xls
b. Vouchers-V8-Sales-Purchase.xls

In addition to the Trade discount feature, some modifications are done in other templates as shown underneath.

TEMPLATEs  (Modifications)

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

Field : IsAlternateUnitApplicable
Desc : This is useful when you are using alternate units in Tally ERP 9. You must specify Yes to use alternate units.

Values : Yes or No
Default Value : No

Remarks:
a. This option comes under "Other Settings"
b. You must use the EnableDisableFeatures sheet to show / display the columns for "Other Settings"

2. Vouchers-V8-Sales-horizontal-format-without-stockitems.xls
The following new fields/features have been added in this template :
  • Buyer Name
  • Addr Line1
  • Addr Line2
  • Addr Line3
  • State
  • Place of Supply
  • GST Regn Type
  • GSTIN
3. Vouchers-V8-Purchase-horizontal-format-without-stockitems.xls
The following new fields/features have been added in this template :
  • Supplier Name
  • Addr Line1
  • Addr Line2
  • Addr Line3
  • State
  • Place of Supply
  • GST Regn Type
  • GSTIN
4. Vouchers-V8-Journal-with-multiple-references.xls
This template now supports 10 ledgers with references. Earlier there was provision to specify 5 ledgers only.

Old template Name : Vouchers-V7-Journal-with-multiple-references.xls
New template Name : Vouchers-V8-Journal-with-multiple-references.xls



Saturday, September 30, 2017

udi-Magic v8.0 Release 3.3

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

TEMPLATEs  (Modifications)

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

1. Group Names
This allows you to specify the Group/parent Name for Party Ledgers, Sales/Purchase and Taxes ledgers; and StockItems. The default values are :

Party Ledgers : Default group is Sundry Debtors (or Sundry Creditors)
Sales Ledgers : Default group is Sales Accounts
Purchase Ledgers : Default group is Purchase Accounts
Tax Ledgers : Default group is Duties & Taxes
StockItems : There is no default StockGroup (i.e. it is kept empty)

2. Tax Classification details (Override at Voucher level)
This feature allows you to specify / override the Tax-type and Tax-rates at the Voucher-level.

Notes
a. Tally ERP 9 allows you to define / specify the tax rates at different levels viz Ledger level; StockItem level; Company level etc.
b. If you are using Sales / Purchase with Inventory, then it is advised that you specify the tax-rates at the StockItem level.
c. If you are using Sales / Purchase without Inventory, then the tax-rates must be specified at the ledger level.
d. You can override the tax-type; tax-rate; taxable amount at the Voucher level using this feature.

3. Voucher Class
A new column has been kept to specify the Voucher class.

Wednesday, September 20, 2017

udi-Magic v8.0 Release 3.2

Bugs Fixed

1. Error : "Voucher totals do not match"

Applicable to (Template-Names)
Vouchers-V8-Sales-Purchase.xls
Vouchers-V8-Sales-Purchase-basic.xls

Cause of Error
The aforesaid error occurs when Freight / Courier / shipping charges ledger is specified in Sales Invoice which has different tax-rate from the tax-rate applicable to the Stockitems in that Sales Invoice,

Solution
The aforesaid bug has been rectified and the revised templates are available in udi-Magic v8.0 Release 3.2

References:
How to add Freight, Courier, Service charges along with StockItems in Sales Invoice in Tally ERP?

PS:
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

Saturday, September 16, 2017

Duplicate States in B2C (Small) Invoices in GSTR-1 in Tally ERP

Recently, we noticed that the GSTR-1 report displays duplicate State names in the table B2C (Small) Invoices. Here's a screen snapshot of it.



The aforesaid problem occurs when Sales data is imported using udi-Magic Software wherein the State Name is specified in mixed letters. Example: GUJARAT, Gujarat, gujarat.

Solution
This problem has been rectified in the udi-Magic v8.0 Release 3.1

Templates Modified
The following templates have been modified :
Vouchers-V8-Sales-Purchase.xls
Vouchers-V8-Sales-Purchase-basic.xls
Vouchers-V8-Sales-Horizontal-format-without-stockitems.xls
Vouchers-V8-Purchase-Horizontal-format-without-stockitems.xls

Important Note
Though it is not yet confirmed by Tally Solutions-Bangalore, this problem prima facie, looks likes a bug in the GST Reports (as Tally ERP is not case sensitive).


Tuesday, September 12, 2017

Template modifications

Excel to Tally templates
Applicable to : udi-Magic v8.0 Release 3.0
Description : Compatible with Tally ERP 9 Release 6.1 - Original Sales details not specified error rectified

TEMPLATEs  (Modifications)

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

a. URD-ORIGINAL-SALE-VALUE (under Additional GST details for Credit / Debit Notes)
b. If the Party GSTIN is NOT specified, then the GST Registration type (in Tally) is set as Unregistered (instead of empty)

2. Master-StockItemMaster.xls
The following new fields/features have been added in this template :

a. Price levels (upto 10 price levels)

Remarks:
You can now upload Price levels using the Masters-StockItem sheet itself. However, the Price-levels must exist in Tally and are NOT created automatically.

3. The following templates include facility to hide / show columns and are now protected (no password required to unprotect) :

a. Vouchers-V8-Sales-Purchase.xls
b. Masters-StockItemMasters.xls
b. Masters-LedgerMaster.xls

Remark:
You must enable Macros to hide / show columns in the aforesaid templates

TEMPLATEs  (removed)

1. Master-V6-StockItem-Multiple-price-levels.xls
2. Vouchers-Flipkart-Receipts-and-Journal.xls

Remarks:
Though these template are discontinued, they are still available within the sub-folder named "templates-discontinued".

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





Friday, August 25, 2017

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

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.