Sales Voucher Import Using Excel

Sir
How to import sales vouchers with multiple inventory entries

 

Hi Mohan,


Try this code & Excel.

 

HI mohan

PFA

 

Hai Logesh
Thanking you i will check it and revert back to you.

 

Dear lokesh

i found ur sales import from excel very handy. but have few errors.

1) When put zero for VAT/CST ledgers for eg Only CST 5% is applicable so rest i put zero & import i get in voucher all the vat ledger capture the tax (output vat 5%, output vat 14.5% output cst 14.5%) amt but not zero.

2) how to capture voucher reference no along with voucher inv no ? also that ref no need to be used as new ref for bill allocations. i tried adding item 31 in excel sheet to capture ref no but it didn work.

3) how to capture 5/6 inventories for a single voucher itself ?

 

im getting this error
function: 'sales import" label: 670 : Action execution failed!

Pls help.
THanks

 

Dear Sir ,,,

Show ERROR ,,,,PFA

 

show error this sales import?

 

Dear Vyadav,

Plz upload both excel and code file so that i can help u......

 

Please check sir

 

an error code shows -
Error in TDL
'VariablearName'
Could not find description!

 

Experts please help me to add 2 fields, which i am importing from Excel
foloowing is the part of code where i am trying to add field,

200 : INSERT COLLECTION OBJECT : LEDGERENTRIES
210 : SET TARGET : LedgerEntries
220 : SET VALUE : LedgerName :$PLedName
230 : SET VALUE : IsDeemedPositive : No
240 : SET VALUE : IsPartyLedger : Yes
250 : SET VALUE : Amount : $$AsAmount($Pamt) + ($AdvAmt))

above code is working good for only one field, but for addition it is not working.
please help me

 

Hi Sir,

im facing attached screen issue, while import Sales invoice details.

Please correct my TDL.

[System : Formula]

locImportofXLData : "Import Sales From Excel"

[#menu : Gateway of Tally]

Add : Key item : After : @@locImportofData : @@locImportofXLData : X : CALL : ImportS

[Function : ImportS]
001 : Call : ImportSVC

[Function : ImportSVC]
Variable : Counterx : Number
Variable : ParName : String : 0

00 : SET : Counterx : 0
01 : START PROGRESS : ($$NumItems:SalesInfo) : "Importing Vouchers" : @@CmpMailName : "Importing Sales Vouchers ..."
02 : WALK COLLECTION : Sales Info

;;-------------------------------------------------
;;Create Party Ledger under Sundry Debtors if party ledger name not found

40 : Set : ParName : $DSDCName
41 : IF :$$IsEmpty:$Name:Ledger:##parName
42 : NEW OBJECT : Ledger
43 : Set Value : Name : ##ParName
44 : Set Value : Parent : "Sundry Debtors"
45 : CREATE TARGET
46 : END IF

;;-------------------------------------------------
;;Basic Info

49 : SET : SVViewName : $$SysName:AcctgVchView
50 : NEW OBJECT : Voucher
51 : SET VALUE : Date : $$Date@EVchDatePost
52 : SET VALUE : VoucherTypeName : "New Sales"
53 : SET VALUE : Narration : $DSDNarr
57 : SET VALUE : VoucherNumber : $$RoundUp:$DSDVchNo
58 : SET VALUE : Reference : $$RoundUp:$DSDVchNo

;;---------------------------------------------------------
;;BY Entry

60 : INSERT COLLECTION OBJECT : LedgerEntries
61 : SET TARGET : LedgerEntries
62 : SET VALUE : LedgerName : $DSDCName
63 : SET VALUE : AMount : $DSDTotale
64 : SET VALUE : Is Deemed Positive : "Yes"
65 : SET TARGET : ..

;;---------------------------------------------------------
;;TO SALES Entry

66 : IF : NOT :$$IsEmpty:$DSDVchAmt14
70 : INSERT COLLECTION OBJECT : LedgerEntries
71 : SET TARGET : LedgerEntries
72 : SET VALUE : LedgerName : "Sales @ 14%"
73 : SET VALUE : Amount : $DSDVchAmt14
73A : Set Value : TaxClassificationName : $TaxClassificationName:Ledger:$$String:"Sales @ 14%"
73B : Set Value : VATAssessableValue : $$AsAmount$DSDTotal14)*(-1)
74 : SET VALUE : Is Deemed Positive : "No"
76 : SET TARGET : ..

;;---------------------------------------------------------
;;TO VAT Enty

80 : INSERT COLLECTION OBJECT : LedgerEntries
81 : SET TARGET : LedgerEntries
82 : SET VALUE : LedgerName : "Output VAT @ 14%"
82A : Set Value : TaxClassificationName : $TaxClassificationName:Ledger:$$String:"Output VAT @ 14%"
82B : Set Value : VATAssessableValue : $$AsAmount:$DSDVATAmt14
84 : SET VALUE : Amount : $DSDVATAmt14
85 : SET VALUE : Is Deemed Positive : "No"
86 : SET TARGET : ..
87 : END IF

;;---------------------------------------------------------
;;TO SALES Entry

99 : IF : NOT :$$IsEmpty:$DSDVchAmt5
100 : INSERT COLLECTION OBJECT : LedgerEntries
101 : SET TARGET : LedgerEntries
102 : SET VALUE : LedgerName : "Sales @ 5%"
103 : SET VALUE : Amount : $DSDVchAmt5
103A : Set Value : TaxClassificationName : $TaxClassificationName:Ledger:$$String:"Sales @ 5%"
103B : Set Value : VATAssessableValue : $$AsAmount$DSDTotal5)*(-1)
104 : SET VALUE : Is Deemed Positive : "No"
105 : SET TARGET : ..

;;---------------------------------------------------------
;;TO VAT Enty

110 : INSERT COLLECTION OBJECT : LedgerEntries
111 : SET TARGET : LedgerEntries
112 : SET VALUE : LedgerName : "Output VAT @ 5%"
112A : Set Value : TaxClassificationName : $TaxClassificationName:Ledger:$$String:"Output VAT @ 5%"
112B : Set Value : VATAssessableValue : $$AsAmount:$DSDVATAmt5
113 : SET VALUE : Amount : $DSDVATAmt5
114 : SET VALUE : Is Deemed Positive : "No"
115 : SET TARGET : ..
116 : END IF

;;---------------------------------------------------------
;;TO SALES Entry

199 : IF : NOT :$$IsEmpty:$DSDVchAmt0
200 : INSERT COLLECTION OBJECT : LedgerEntries
201 : SET TARGET : LedgerEntries
202 : SET VALUE : LedgerName : "Sales Exempted"
202A : Set Value : TaxClassificationName : $TaxClassificationName:Ledger:$$String:"Sales Exempted"
202B : Set Value : VATAssessableValue : $$AsAmount$DSDVchAmt0)*(-1)
203 : SET VALUE : Amount : $DSDVchAmt0
204 : SET VALUE : Is Deemed Positive : "No"
205 : SET TARGET : ..
206 : END IF

;;---------------------------------------------------------
900 : CREATE TARGET
;;---------------------------------------------------------

910 : SET VALUE : PersistedView : ##SVViewname
930 : INCREMENT : Counterx
940 : SHOW PROGRESS : ##Counterx
950 : END WALK
960 : END PROGRESS
970 : RETURN

[Collection: Sales Info]

ODBC : "Driver={Microsoft Excel Driver (*.xls)};Dbq=" + @@MaterODBCExcelPath+""
SQL : "SELECT * FROM ["+@@MaterODBCExcelSheet+"$]"

SQLObject : Sales Info Obj

[Object : Sales Info Obj]

DSDDatex : $_1
DSDVchNo : $_2
DSDCName : $_3
DSDVchAmt0 : $_4
DSDVATAmt0 : $_5
DSDVchAmt5 : $_6
DSDVATAmt5 : $_7
DSDVchAmt14 : $_8
DSDVATAmt14 : $_9
DSDTotale : $_10
DSDTotal5 : $_11
DSDTotal14 : $_12
DSDNarr : $_13

[System : Formula]

EVchNoPost : $_1
EVchDatePost : $$Date@EVchDateStrPost
EVchDateStrPost : ($$StringPart:$_1:8:2) + "-" + +
($$StringPart:$_1:5:2) + "-" + +
($$StringPart:$_1:0:4)

[System : Formula]
Mater ODBC Excel Path : "D:\TDL path\05112016-Release\08112016\Sales-18.xls" ;; The Excel Sheet Path
Mater ODBC Excel Sheet : "SalesVCH" ;; Sheet name in That Excel File

;;End-of-File

 

Dear Sir,
how to import deferential type of date format.
For Ex.
Each bank are given deferent type of date format in their statement.
Like (DD/mm/YY) or (DD/MMM/YYYY) or (DD/MM/YYYY)

how to we write the common code for all date format import from excel to tally.

any body help me.

 

if in excell dr and credit in multiple line what is the proceedure to import it in excell.
please go to sheet1 in excell sheet.

 

IT Says while importing says Bad formula! ODBC Driver error

 

can a get a tdl where in exempted goods can be imported as this file is not running