Exercise 10

Purchase Vouchers With Multiple Items

Published 8 Oct 2026

---

This exercise imports Purchase Invoices that carry several stock items. Rows sharing the same Invoice No. become one voucher with one stock item line per row. It builds on the previous exercise, using SCROLL to loop through all the rows for each record, and sum the Invoice Amount using curly braces {}.

The Excel sheet

---

Step 1 — Create the masters

The voucher refers to four masters: the Supplier Ledger (Column C), the Purchase Ledger (Column D), the Unit (Column G) and the Stock Item (Column E). udiMagic processes MASTER tags before VOUCHER tags, so anything that doesn't exist yet in Tally is created in the same import. The UNIT master must come before the STOCKITEM, because the Stock Item uses the Unit as its base unit.

<!-- Create Supplier LEDGER Master (Column C) -->
<MASTER TYPE="LEDGER">
  <NAME.LIST>
    <NAME COLUMNREFERENCE="C"/>
  </NAME.LIST>
  <!-- Group is hard coded -->
  <PARENT>Sundry Creditors</PARENT>
  <ISBILLWISEON>Yes</ISBILLWISEON>
  <AFFECTSSTOCK>No</AFFECTSSTOCK>
  <ISCOSTCENTRESON>No</ISCOSTCENTRESON>
</MASTER>

<!-- Create Purchase LEDGER Master (Column D) -->
<MASTER TYPE="LEDGER">
  <NAME.LIST>
    <NAME COLUMNREFERENCE="D"/>
  </NAME.LIST>
  <PARENT>Purchase Accounts</PARENT>
  <ISBILLWISEON>No</ISBILLWISEON>
  <ISCOSTCENTRESON>No</ISCOSTCENTRESON>
  <!-- Yes, because this ledger is used with Stock Items -->
  <AFFECTSSTOCK>Yes</AFFECTSSTOCK>
  <USEFORVAT>No</USEFORVAT>
</MASTER>

<!-- Create UNIT Master (Column G). Must come before the StockItem. -->
<MASTER TYPE="UNIT">
  <!-- The UNIT Master does not support Aliases : use NAME directly -->
  <NAME COLUMNREFERENCE="G"/>
  <ISSIMPLEUNIT>Yes</ISSIMPLEUNIT>
</MASTER>

<!-- Create STOCKITEM Master (Column E) -->
<MASTER TYPE="STOCKITEM">
  <NAME.LIST>
    <NAME COLUMNREFERENCE="E"/>
  </NAME.LIST>
  <!-- Empty PARENT = no Stock Group (udiMagic default) -->
  <PARENT/>
  <BASEUNITS COLUMNREFERENCE="G"/>
</MASTER>

Step 2 — Declare the key column and scroll the stock items

CELLREFERENCE="A1" on XMLTAGS declares Column A (Invoice No.) as the key field. SCROLL="YES" on ALLINVENTORYENTRIES.LIST then tells udiMagic to keep adding one stock-item block for every following row that carries the same Invoice No. (see udiMagic XML tags).

<XMLTAGS xmlns:UDF="TallyUDF" CELLREFERENCE="A1">
...
<ALLINVENTORYENTRIES.LIST SCROLL="YES">

Invoice No.	Excel rows	Stock item lines in the voucher
4817	2–4	3 (Silk Thread, Cotton Fabric, Embroidery Needle)
7392	5	1
2658	6–7	2 (Silk Thread, Cotton Fabric)
9143	8	1
6025	9	1

Step 3 — Write the Voucher tags

The Supplier Ledger is credited under LEDGERENTRIES.LIST with the total of all item amounts of the invoice using curly braces {}, both in the ledger entry and in its bill allocation. Each scrolled stock-item block carries the Stock Item, Qty, Rate and Amount of its own row, and debits the Purchase Ledger through its ACCOUNTINGALLOCATIONS.LIST.

<!-- VOUCHER : one invoice can contain multiple stock-item rows -->
<VOUCHER>
  <!-- Unique voucher ID from Invoice No. (Column A) -->
  <GUID FORMULA="=+&quot;udi-PRCHSE-MULTI&quot; &amp; A#"/>
  <DATE COLUMNREFERENCE="B"/>
  <EFFECTIVEDATE COLUMNREFERENCE="B"/>
  <VOUCHERTYPENAME>Purchase</VOUCHERTYPENAME>
  <VOUCHERNUMBER COLUMNREFERENCE="A"/>
  <REFERENCE COLUMNREFERENCE="A"/>
  <!-- Narration mapped directly from Column J -->
  <NARRATION COLUMNREFERENCE="J"/>
  <ISINVOICE>Yes</ISINVOICE>
  <PERSISTEDVIEW>Invoice Voucher View</PERSISTEDVIEW>

  <!-- Party (Supplier) from Column C -->
  <PARTYNAME COLUMNREFERENCE="C"/>
  <PARTYLEDGERNAME COLUMNREFERENCE="C"/>
  <BASICBASEPARTYNAME COLUMNREFERENCE="C"/>
  <BASICBUYERNAME COLUMNREFERENCE="C"/>

  <!--
    Supplier total:
    accumulated for all item rows belonging to the invoice.
  -->
  <LEDGERENTRIES.LIST>
    <LEDGERNAME COLUMNREFERENCE="C"/>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <AMOUNT FORMULA="={Round(I#,2)}"/>
    <BILLALLOCATIONS.LIST SKIP="=Len(trim(A#))=0">
      <NAME COLUMNREFERENCE="A"/>
      <BILLTYPE>New Ref</BILLTYPE>
      <AMOUNT FORMULA="={Round(I#,2)}"/>
    </BILLALLOCATIONS.LIST>
  </LEDGERENTRIES.LIST>

  <!--
    Stock-item rows are scrolled according to Invoice No. in Column A.
    Therefore:
      Invoice 4817 -> 3 item rows
      Invoice 2658 -> 2 item rows
    while invoices with one row remain one-item vouchers.
  -->
  <ALLINVENTORYENTRIES.LIST SCROLL="YES">
    <STOCKITEMNAME COLUMNREFERENCE="E"/>
    <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
    <RATE COLUMNREFERENCE="H"/>
    <AMOUNT FORMULA="=+I#*-1"/>
    <ACTUALQTY COLUMNREFERENCE="F"/>
    <BILLEDQTY COLUMNREFERENCE="F"/>
    <!-- Purchase Ledger from Column D -->
    <ACCOUNTINGALLOCATIONS.LIST>
      <LEDGERNAME COLUMNREFERENCE="D"/>
      <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
      <AMOUNT FORMULA="=+I#*-1"/>
    </ACCOUNTINGALLOCATIONS.LIST>
    <!-- Existing inventory/godown structure retained -->
    <BATCHALLOCATIONS.LIST>
      <GODOWNNAME>Main Location</GODOWNNAME>
      <BATCHNAME>Primary Batch</BATCHNAME>
      <DESTINATIONGODOWNNAME>Main Location</DESTINATIONGODOWNNAME>
      <AMOUNT FORMULA="=+I#*-1"/>
      <ACTUALQTY COLUMNREFERENCE="F"/>
      <BILLEDQTY COLUMNREFERENCE="F"/>
    </BATCHALLOCATIONS.LIST>
  </ALLINVENTORYENTRIES.LIST>
</VOUCHER>

---