Hi is it possible that when the third party provides ledger in excel format we can directly import the entries in my tally and get all the entries without physically needing to enter each entry keeping in mind that their debit entry will my credit entry and with narrations.
Yes with help of customization and rules to be made its possible to do the same the format has to be fixed or mapped properly the rules has to be made for import properly like his sales is your purchase and his receipt is your payment and as mentioned banks or ledgers can be different hence that you need to map as per your ledger tables
Thank you sir So I have this code but now want your experts help in modifying it now to ledger entries and for both debit and credit. Also not renaming the company name such as source and target. In this there is no need to export data to excel. Vouchers gets directly posted in target company from source company. Can experts help in this regarding [#Menu: Gateway of Tally] Add : Key Item : Before: @@locQuit : "Inter Company Data Transfer" : N : CALL : TSPL FFE InterCompany Data Transfer Control : "Inter Company Data Transfer" : NOT $$IsRemoteCompany ;; Function Definition [Function: TSPL FFE Inter Company Data Transfer] Variable : PSVCurrentCompany : String : "Source Company" Variable : SVCurrentCompany : String Variable : SrcCompanyOpen : Logical Variable : TgtCompanyOpen : Logical 00 : SET : SrcCompanyOpen : $$FilterCount:Company:TSPLFFEInterBranchSource > 0 01 : SET : TgtCompanyOpen : $$FilterCount:Company:TSPLFFEInterBranchTarget > 0 02 : IF : ##SrcCompanyOpen AND ##TgtCompanyOpen 05 : SET : SVCurrentCompany : ##PSVCurrentCompany 10 : WALK COLLECTION : TSPL FFE Pymt Vouchers 20 : SET : SVCurrentCompany : "Target Company" 30 : SET TARGET 40 : SET VALUE : VoucherTypeName : "Receipt" 50 : SET VALUE : VoucherNumber : $VoucherNumber 60 : WALK COLLECTION : LedgerEntries 70 : SET TARGET : LedgerEntries[$$LoopIndex] 80 : SET VALUE : Amount : if $$IsDr:$Amount then $$AsCrAmt:$Amount else $$AsDrAmt:$Amount 90 : SET VALUE : IsDeemedPositive : NOT $IsDeemedPositive 100 : SET TARGET : .. 110 : END WALK 120 : SAVE TARGET 130 : SET : SVCurrentCompany : ##PSVCurrentCompany 140 : END WALK 150 : ELSE : 160 : MSGBOX : "Error" : "Both Source and Target Companies must be Opened" 170 : ENDIF ;; Collection Definition [Collection: TSPL FFE Pymt Vouchers] Type : Vouchers : Voucher Type Child Of: "Payment" ;; System Formula [System: Formula] TSPL FFE InterBranchSource : $Name = "Source Company" TSPL FFE InterBranchTarget : $Name = "Target Company"
Shreyas but above code is copied from the tally standard avaiable ... Secondly its not at all near from the one you want this is different.... Try to write proper codes and then come for help