Excel Import

Help me to Correct the code, the attached code works fine for a a Voucher with Single Ledger Entry, Facing problem with Voucher with Multi Ledger Entry.
In Excel Sheet : SSL with Single Entry,
SL with Single Voucher with Multi Ledgers,
and Sheet : ML with Multi Ledger

 

you should put the tally data also..


You have not specified the problem faced by you..

how would other experiment with the code ?

 

Please find the attachment of Excel, TDL and Zip Tally Data Folder. The attached TDL works Fine only with One Voucher & Only with One Line of Purchase Ledger. (Refer Excel Sheet SL).
In Case of Multi Line of Purchase it getting DrCr mismatch Error while importing.

 

Plz Check your list variable definition.

Data Types are wrongly set..

Also inside function you have again set wrong data types.

Why so.. first correct them

also use $$Number , $$String and $$Date at appropriate place... as you are reading excel file.. and from my experience I tell you that it is wise to do this while setting values in variables

after you do this.. we will move to error in collection.

you need to use group and aggregate at appropriate level as voucher total will be total of all ledger values in it.. same way in your other collection...

Code:

[Collection : TrInvNoColl]
    Source Collection    : XLDataColl
   
    Fetch                : TASSVCHNOInvNoLV, TASSVCHNOInvDateLV, TASSVCHNOPartyNameLV,TASSVCHNOInvTotalLV
    Fetch                : TASSVCHNOPurLedgerLV, TASSVCHNOTaxableValueLV, TASSVCHNOCGSTLV,TASSVCHNOSGSTLv
   
    By                    : TASSVCHNOInvNoLv            : $$String:$TASSVCHNOInvNoLv
   
    Aggr Compute        : TASSVCHNOInvTotalLV         : Sum: $TASSVCHNOInvTotalLV
   
    Aggr Compute        : TrTotalCGST                : Sum:$TASSVCHNOCGSTLV
    Aggr Compute        : TrTotalSGST                : Sum: $TASSVCHNOSGSTLV
   
[Collection : TrInvNoFilteredColl]
    Source Collection    : TrInvNoColl
   
    Fetch            : TASSVCHNOInvNoLV, TASSVCHNOInvDateLV, TASSVCHNOPartyNameLV,TASSVCHNOInvTotalLV
    Fetch            : TASSVCHNOPurLedgerLV, TASSVCHNOTaxableValueLV, TASSVCHNOCGSTLV,TASSVCHNOSGSTLv
       
    Compute            : TASSVCHNOInvNoLV            : $$String:$TASSVCHNOInvNoLV
    By                : TASSVCHNOPurLedgerLV         : $$String:$TASSVCHNOPurLedgerLV
    Aggr Compute    : TASSVCHNOTaxableValueLV    :Sum: $TASSVCHNOTaxableValueLV
       
    Filter            : TrInvNoFilter
       
[System: Formula]

    TrInvNoFilter : $TASSVCHNOInvNoLV =$$TgtObject:$TASSVCHNOInvNoLv