full source code of payment & receipt vch from excel to tally

DEAR SIR,
KINDLY REFER ATTACHMENTS.

SIR PLEASE RESOLVED ERRORS



TDL CODE WORK PROPERLY WHEN RUN SINGLE SINGLE PROJECT , BUT RUN COMBINED PROJECT (LEDGER+PAYMENT+RECEIPT), I AM FACING SOME ERRORS

PLEASE PLEASE RESOLVED THIS ERRORs.
ASAP

 

What is the error u r getting...

 

SIR I WANNA SOME DOUBTS CAN U GAVE ME UR MAIL ID OR CONTACT NO SIR

 

SIR I WANNA SOME DOUBTS CAN U GAVE ME UR MAIL ID OR CONTACT NO SIR

 

sir, i am not able to give you exact error details thats why i give u full source code now u can check this code and fix my problems..........

otherwise, if run one by one project my project work properly and successfully export excel to tally.
But run combined project like (LEDGER+PAYMENT+RECEIPT), I AM FACING SOME ERRORS


[System : Formula]

locImportofXLData : "Excel Import"

[#menu : Import Direct]

Add : Key item : After : @@locImportofData : @@locImportofXLData : X : menu : Excel Data Import


[Menu: Excel Data Import]

Indent: "EXCEL TO TALLY"
Item: Blank
Item: Ledgers Master : call SD Import Of Ledger
Item: Payments VCH : call : Import Payment
Item: Receipts VCH : call : Import Receipt

[Include: importLEDGERS.txt]
[Include: importPAYMENTS.txt]
[Include: importRECEIPTS.txt]

sir download (first post) full source code and resolved errors.

 

my email id: gvijay_72@yahoo.com

 

=================================================================================
use unique [System : Formula] name for all the functions

hope it will solve the problem

 

Dear Aditi Arora,

At first view, i can find one major problem in your all tdl files that you have mentioned same names for all our system formula "Mater ODBC Excel Path" and "Mater ODBC Excel Sheet". Kindly rename those paths to relative formula name, like in receipt tdl "Rcpt Mater ODBC Excel Sheet" and in payment tdl "pymt Mater ODBC Excel Sheet".

Try above mentioned changes in if still getting error, then I have to search for it.

 

;;-------------------------------

Hi Aditi Arora,

I Corrected your files and tested also. As per you query here with i attached the updated tdl's kindly check it.

Main file is ledger file i include the both payment & Receipt tdl's in ledger tdl..

 

new zip file not running ,, if this file is correct one please send me snapshot,,

Nara Sir.

 

Sir,,,

show error ; Invalid no of step
please tell sir

 

Sir,
Please help to solve the the above errror in screen shot in 4 & 5 Thanks.

 

Dear Sir Voucher number should be Manual........

 

sorry,
please explain in detail.

 

Thank Your . ..

it's pick only one entry . how can enter multi Dr. & Cr. one voucher

Exp:- Dr 500 , Dr 400 , Cr 900

Please suggest me sir

 

Sir, getting error
Function : "payment import" Label :70: variable 'SVViewName' could not be found!
Function : "payment import" Label :70: Action execution failed!

Please guide me ..

 

Hi sir How can i import Double entry in jv For exp

Dr. Ram kumar = 5000
Cr. Ram kumar = 4000
Cr. Ram kumar = 1000

TOTAL = 5000 5000

 

Hi sir How can i import Double entry in jv For exp

Dr. Ram kumar = 5000
Cr. Ram kumar = 4000
Cr. Ram kumar = 1000

TOTAL = 5000 5000

 

but how to use it Sir?
I haved loaded tdl file but i'm unable to find the importing option... please help.

 

check this thread

http://tdlexperts.org/index.php?thr...purchase-vouchers-with-stock-from-excel.5293/

 

Check this thread...

http://tdlexperts.org/index.php?thr...purchase-vouchers-with-stock-from-excel.5293/