Hi all my friends on this site can anybody tell me how i can enter inculsive vat sale entry in tally ples read full please help me out if any tdl source code can done this ple give the code (In Detail ) I have a bill no 001 in this bill 3 diff stock item are sale Item name qty rate amount diff vat rate on diff item The Vat amt (inclusive) Item A 1 100 100 5 % 4.72 Item B 1 100 100 12.5 % 11.11 Item C 1 100 100 Tax Free 0 Total bill Amount of 300 I try vat class but it not work proper the problem is that using vat class i cant enter a bill of diff types of vat rat in single entry Thanks
Dear friend, This can be acheieved by default tally only ,please find the attached data for your reference.
Hi vikram and Dinesh sir Thank for your support but i have still problem i attach a excel file for bill ref whole info in this sheet pls see and suggest something helpful for me
Dear sir, This above option is working fine but when i use discount ledger as user defined value in tax class its not taking vat after discount. please sugges me to correct the options.
hi, In the discount ledger you can setup the use for assessable value calculations set to yes and Method set to Value basis for VAT. Which solve your problem.
Hi Guys, Small code which allows Tax incl rate in Invoice *** need to put Vat rate in Item Master Creation - Enable - Tax Inclusive Rate from F11 - Accounting Features [#Part : CMP Acc Feat Right] Add : Line : CMP Final Rate [Line : CMP Final Rate] Fields : Long Prompt, Logical Field Local : Field : Long Prompt : Info : $$LocaleString:"Tax inclusive rates on Invoices ?" Local: Field : Logical Field : Storage: isFinalRateOn ;;Local : Field : Default: Tooltip: + Local : Field : Default: On : Focus : Yes : Set : SVERPFeatureDesc : + "This features allows a user to enter Tax Inclusive Rates while creation invoice. The module will automatically do the reverse calculation based on the defined Tax rates on item master." Space Top: 0.25 [System : UDF] isFinalRateOn: Logical : 23 [System : Formula] isFinalRateOn: $isFinalRateOn:Company:##SVCurrentCompany and @@isERPPlusModuleOn [#Line : VCH Batch Column One] add : option : My VCH Batch Column One : @@isSales and @@isFinalRateOn [#Line : VCH Batch Column Two] add : option : My VCH Batch Column Two : @@isSales and @@isFinalRateOn [!Line : My VCH Batch Columnone] Add : Right Field: Before : VCH RateTitle : MyFinalRateTitle [Field : My FinalRateTitle] Use:Name Field INfo: "Tax inc. Rate" Width: @@VCHRateWidth Lines: 2 Style: Normal Align: Centre [!Line : My VCH Batch Columntwo] Add : Right Field : Before : VCH RateTitle : MyFinalRateTitle Local : Field : MyFinalRateTitle : Info : "" [#Line : STKVCH Batch2] Add : Option : MyStkvch Batch2 : @@isSales and @@isFinalRateOn [!Line : MystkVCH Batch2] Add : Right Field : Before : VCHBATCH Rate : MyFinalRate [Field: MyFinalRate] Use: Rate Price Field ;;Fetch Object: Stockitem: $StockitemName: RateOfVAT Storage: MyFinalRate Skip: $$Line > 1 [system: UDF] MyFinalRate: Rate: 101 MyFinalRate2: Rate: 102 [#Field: VCHBATCH Rate] Add : Option : MyRate : @@isSales and @@isFinalRateOn [!Field : MyRate] Delete: Set as Delete: Set By Condition Add: Set By Condition : Yes : ($MyFinalRate *100 ) / (100 + $RateofVAT:Stockitem:$Stockitemname) [#Line : Ei ColumnOne] add : option : My VCH Batch Column One : @@isSales and @@isFinalRateOn [#Line : Ei ColumnTwo] add : option : My VCH Batch Column Two : @@isSales and @@isFinalRateOn [#Line : Ei InvInfo] Add : Option : My Ei Info : @@isSales and @@isFinalRateOn [#Line : Ci InvInfo] Add : Option : My Ei Info : @@isSales and @@isFinalRateOn [!Line : My ei info] Add : Right Field : Before : VCH Rate : MyFinalRate2 [Field : MyFinalRate2] Use: Rate Price Field Width: @@VCHRateWidth Storage: MyFinalRate2 ;;Set as: $$CollectionField:$MyFinalRate:1:BatchAllocations Set always: Yes inactive: $$isEnd:$Stockitemname Skip on: @@hasinvsuballoc AND NOT @@isPOSInvoice Setval : if @@HasInvSubAlloc then $$CollectionField:$MyFinalRate:1:BatchAllocations else + if $BilledQty = 0 then 0 else + if $$IsValidPriceLevel:$PriceLevel then $$ForexValue@StdVchRate else + if $StockItemName != #VCHPrevItem AND NOT $$IsStartupValue then $$ForexValue@StdVchRate else + if ($Amount != 0) AND ($Amount != @@CalcedAmt) then @@NrmlAmount / $BilledQty else + if $$IsFieldEdited OR $$InAlterMode then $$Value else + if $$IsEmpty:$$Value then $$ForexValue@StdVchRate else $$Value Set as : If #VCHBilledQty = 0 OR #VCHBilledQty != 0 then @Setval else @Setval [#Field: VCH NrmlRate] Add : Option : MyRate2 : @@isSales and @@isFinalRateOn [#Field: VCH POS Rate] Add : Option : MyRate2 : @@isSales and @@isFinalRateOn [!Field : MyRate2] Delete: Set as Add: Set as : ($MyFinalRate2 *100 ) / (100 + $RateofVAT:Stockitem:$Stockitemname)
this code was given by Mr Nirav. Why you copy the code & claim or showing the solutions was given by U. & stop blaming the others for coping the codes.
@ psjain_jal, I never claim any codes to my codes. Here also I am helping the user to provide above codes in text file, as pasting the codes convert some character to smilies. Please be patience.
Dear experts Tax Inclusive not working for Release 4.6 its working in Rel 4.5 please suggest me to update changes in release 4.6
this TDL doesn't work in tally erp 4.6 version kindly mail me the tdl for it piyush.um@gmail.com i will wait for your replay Nirav Merchant
"" Error T0027 - Attribute definition started without a valid description ''' This is the error I am getting while using the TDL in Tally 4.91 version stat 234. This is only for your information and for identifying the reasons. By the way, A very Happy New Year to You Mr. Nirav. I have come across many of your TDL, which are working excellent. I do not understand where I went wrong in using this TDL. Thank you for your contribution. Bye
how to print % symbol after Collecting rateofvat ($Rateofvat:StockItem:$StockItemName ). i am tried this below line but not working pls help me. $Rateofvat:StockItem:$StockItemName + "%"