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

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).

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".

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

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.