Error while importing sales voucher from excel

Discussion in 'Free Source Codes' started by Jignesh Negandhi, Jul 6, 2022.

    
  1. Jignesh Negandhi

    Jignesh Negandhi New Member


    Dear Experts

    I have written code to import Sales bill into Tally Prime as Sales Voucher with Inventory.
    There is an error reflected as "Voucher totals do not match".
    The amount of mismatch is total of Inventory.

    The code relating to inventory part is as follows

    100 : INSERT COLLECTION OBJECT : All InventoryEntries
    100a : Set : Stock Item Name : ##StockItemName
    100b: Set : InQty : ($$FileReadCell:##RowCtr:5)
    100c: Set : ItemRate : ($$FileReadCell:##RowCtr:6)
    100d: Set : ItemValue : ($$FileReadCell:##RowCtr:7)
    100e: Set : OutQty : (##InQty)

    101: SET VALUE : StockItemName : ##StockItemName
    101a: SET VALUE : IsDeemedPositive : No
    101b: SET VALUE : ActualQty : ($$TgtObject:($$AsQty:##OutQty))
    101c: SET VALUE : BilledQty : ($$TgtObject:($$AsQty:##OutQty))
    101d: SET VALUE : Rate : ($$TgtObject:($$AsRate:##ItemRate))
    101f: SET VALUE : Amount : ($$TgtObject:($$AsAmount:(##ItemValue)))
    101g: Log : 'Inventory Colln inserted ' + ##StockItemName + " Value " + $$String:##ItemValue
    115 : Set : NetItemValue : ##NetItemValue + ##ItemValue

    130 : INSERT COLLECTION OBJECT : ACCOUNTING ALLOCATIONS
    131 : SET VALUE : LedgerName : ##InventoryLedger ;
    131a: Set Value : GSTOVRDNNATURE : "Interstate Sales Taxable"
    131b: Set Value : IsDeemedPositive : No
    131c: Set Value : RemoveZeroEntries : No
    132 : SET VALUE : Amount : ($$TgtObject:$$AsAmount:(##ItemValue))
    132a: Set Value : IsPartyLedger : No


    Will someone point out my mistake, which causes the mismatch error
     


Share This Page