Posts

Showing posts from September, 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 ...

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

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

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