You can use udiMagic software to import Sales and Purchases with alternate units in Tally ERP.

  1. Open the XLS named "Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls"
  2. Use the EnableDisabledFeatures sheet to Show the "Other Settings" columns.
  3. Specify Yes in the Column IsAlternateUnitApplicable for all the rows which you want to import in Tally.
  4. Save the XLS


Import excel data in Tally

  1. Start Tally and open your Company
  2. Start udiMagic Software
  3. Select option "Excel to Tally"
  4. Select option "Import data in Tally"
  5. Select the XLS i.e. Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls
  6. Click the Start button


Here's a screen snapshot of the XLS wherein you must specify YES in the column "IsAlternateUnitApplicable".