Dear Sir, kindly help me, how to add expenses HSN/SAC code in any summary. I am giving below the sample code below :- [Field: HSNCodeSS] Use : Number Field Set As : $GSTHSNCode:StockItem:$StockItemName Style : Small Italic Border : Thin Right Align:Center Width : 10 ;How to add HSN/SAC for direct & indirect expenses in above code. Please help me.
I have tried the below :- [Field: HSNCodeSS] Use : Number Field Set As : $GSTHSNCode:StockItem:$StockItemName :GroupDirectExpenses:$LedgerName Style : Small Italic Border : Thin Right Align:Center Width : 10
Sir, when I add your code, its show "0" [Field: HSNCodeSS1] Use : Number Field Set As : $GSTHSNCode:Ledger:$LedgerName Style : Small Italic Border : Thin Right Align:Center Width : 10
Then try ##Ledgername..... or the Field name where your partyname is showing.....e.g. #myPartyfieldname without looking at the code, there is no easy answer..... Might be... it is not coming due to lack of variable or not specified in the ledger........ the answer depends on how the report code has been structured.
Amit Sir, it's my humble request kindly resolve this issue. I am attaching below the code :- [#Menu : Gateway of Tally] Add : Item : GST Report1 : Menu : GST Report [Menu : GST Report] Add : Item : All GST Purchase : Display : GST Purchase Add : Item :"" [Report : GST Purchase] Title: GST Purchase Variables : SV CurrentCompany Form :GST Purchase Variable : SVFromDate,SVToDate Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Set : Is Day Book : Yes [Form :GST Purchase] Space Right : 1.5 Space left : 1.5 ;Space tOP : 1.5 ;Space Bottom : 1.5 Part SP AccTitles, daybookheadbb2, GST Purchase,daybookbottam2 ;;,daybookhead22 ;;;daybookhead2, Buttons : ExplodeFlag,ChangeDybkDate,ChangePeriod BottomButton: BlankButton, RelReports, InvReports, AcctReports, Report Operations, FilterButton, ValueButton Buttons : PrintButton, ExportButton, UploadButton, MailButton Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn2_EditVch, BottomToolBarBtn3, BottomToolBarBtn4, BottomToolBarBtn5, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12 Background : white Page Break : UsCs GI ClPgBrk2 , UsCs GI OpPgBrk2 [Part: UsCs GI ClPgBrk2] Lines : UsCs GI ClPgBrk2 [Line: UsCs GI ClPgBrk2] Fields : Simple Field Local : Field : Simple Field : Set As : "Continued..." Local : Field : Simple Field : FullWidth : Yes Local : Field : Simple Field : Align : Right Border : Full Thin Top [Part: UsCs GI OpPgBrk2] Parts : SD Title2, daybookheadbb2 ;;;;, UsCs GI Inventory Title Vertical : Yes [Part: SD Title2] Line: SD Title2, daybookheadB2 [Line: SD Title2] Fields : Simple Field Local : Field : Simple Field : Set As : @@CmpMailName Local : Field : Simple Field : Align : Center Local : Field : Simple Field : FullWidth : Yes Local : Field : Simple Field : WideSpaced: Yes SpaceBottom : 1 [Line :daybookheadB2] Field : Simple Field Local : Field : Simple Field : Info : "GST Purchase from " + $$String:##SVFromDate +" to " + $$String:##SVToDate ;;==================GST Purchase============================== [Part : daybookheadbb2] Use : GST Purchase Delete : Repeat Delete : Scroll Border : ColumnTitles Local : Field : Default : Type : string Local : Field : My Voucher Srl2 : Set As : "Sr.No" Local : Field : MyVoucherParty2: Set As : "Party Name" Local : Field : MyVchTIN2 : Set As : "GST No" Local : Field : MyVchNo2 : Set As : "Bill No" Local : Field : My Voucher Date2 : Set As : "Bill Date" Local : Field : IGST PER:Set as:"%" Local : Field : HSNCodeSS : Set As : "HSN CODE" Local : Field : HSNCodeSS1 : Set As : "SAC CODE" Local : Field : MyVchAmount2x : Set As : "Basic Amount" Local : Field : MyVchfNo2 : Set As : "CGST " Local : Field : MyVchfNo3 : Set As : "SGST " Local : Field : MyVchfNo4 : Set As : "IGST " Local : Field : MyVchTotAmount2x : Set As : "Total Amount" Local :Field : Default : Style : Normal Local: Field: Default: Align: Center [Part :GST Purchase] Line : GST Purchase Repeat :GST Purchase :My Voucher Rep Collection2 tOTAL : My Voucher Srl2,MyVchAmount2x,MyVchfNo4,MyVchfNo2,MyVchfNo3,MyVchfNo4,MyVchTotAmount2x Common Border : Yes Scroll : Vertical [Line :GST Purchase] Field :My Voucher Srl2,MyVoucherParty2,MyVchTIN2,MyVchNo2,My Voucher Date2,IGST PER,HSNCodeSS, HSNCodeSS1, MyVchAmount2x,MyVchfNo4,MyVchfNo2,MyVchfNo3,MyVchfNo4,MyVchTotAmount2x Option : Alter on enter Option : DisplayOnAltEnter Explode : My TB Inv Explosion : ##ExplodeFlag or $$KeyExplode Option:Colorfull display:$amount>10000 [!Line:Colorfull Display] Local:Field:MyVoucherParty2:ColorARK red Local:Field:MyVchAmount2x:Color:dark red [Part: My TB Inv Explosion] Lines : My TB Inv Explosion Repeat : My TB Inv Explosion : ledger Entries;Inventory Entries Scroll : Vertical [Line : My TB Inv Explosion] Field : My TB Inv ExplosionItem ; here add other fields Indent : 5 [Field: My TB Inv ExplosionItem] USe : Name field Set as : $LedgerName;$StockItemName ;Option : Alter On Enter [Field :My Voucher Srl2] Use : Number Field SET AS:$$LINE Width : 4% Screen Align: Right Border : Thin LEFT Right [Field :My Voucher Date2] Use : Short Date Field Set As : $Date Border : Thin Right Format:"Short Date" [Field : MyVoucherParty2] Use : NAme Field Set As : $LedgerName ;;;$BASICBUYERNAME Width : 35 Border : Thin Right Alter : Voucher Display : Ledger Vouchers:$$ISLedger Variable: Ledger Name [Field : MyVchTIN2] Use : Name Field Set As :$PartyGSTIN:Ledger:$PartyLedgerName Width : 11 Border : Thin Right [Field : MyVchNo2] Use : NAme Field Set As : $REFERENCE Width : 10 Border : Thin Right Align:Center [Field:IGST PER] Use: Number Field Set as:$(Stockitem,$stockitem).GSTIGSTRate Format : "NoZero,Percentage" Set Always: Yes Border : Thin Right Align:Center Width:4 [Field: HSNCodeSS] Use : Number Field Set As : $GSTHSNCode:StockItem:$StockItemName Style : Small Italic Border : Thin Right Align:Center Width : 10 [Field: HSNCodeSS1] Use : Name Field Set As : $GSTHSNCode:Ledger:$LedgerName Style : Small Italic Border : Thin Right Align:Center Width : 10 [Field : MyVchAmount2x] Use : Amount Field ;Set as:$$FilterAmtTotal:allLedgerEntries:2:$Amount ;Set as : $$NettAmount:$GSTExpTaxableAmt:$GSTIncTaxableAmt Set As: $$CollAmtTotal:allinventoryEntries:$Amount ; THIS SEA ALSO LEDGER ENTRY which this field Border : Thin Right ;*********************** [Field : MyVchfNo2] Use : Amount Forex Field Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount; $CGSTAmount is ok Border : Thin Right Width : 10 ;*********************** [Field : MyVchfNo3] Use : Amount Forex Field Set as : $$FilterAmtTotal:LedgerEntries:SGST1:$Amount;$SGSTAmount Border : Thin Right Width : 10 ;*********************** [Field : MyVchfNo4] Use : Amount Forex Field Set as : $$FilterAmtTotal:LedgerEntries:IGST1:$Amount;$IGSTAMOUNT ; this problems Border : Thin Right Width : 10 ;*********************** [Field : MyVchTotAmount2x] Use : Amount Field Set As : $Amount Border : Thin Right ;*********************** [System: Formula] SGST :$$FilterAmtTotal:LedgerEntries:SGST1:$Amount SGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST" CGST :$$FilterAmtTotal:LedgerEntries:CGST1:$Amount CGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST" IGST :$$FilterAmtTotal:LedgerEntries:IGST1:$Amount IGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"IGST" [Collection : My Voucher Rep Collection2] Type : Ledger ;Sort : Default : $BASICBUYERNAME Type : Vouchers Walk : allLedgerEntries Filter : IsSalesVT2 ;;;;,CSTFilter2 ;;,Recfiltee2 Fetch : Date,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber,REFERENCE,ReferenceDate, HSNCodeSS, HSNCodeSS1, GSTDutyAmount,BASICBUYERNAME,CGSTAmount,SGSTAmount,IGSTAmount Fetch : *.* Compute:IGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100 ; ledger entries Compute:CGSTAmount :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2 Compute:SGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2 [Part: daybookbottam2] Lines : daybookTotalLine2 [Line: daybookTotalLine2] Use : GST Purchase Local: Field: Default : Style : Small Bold ;Local: Field: Default: Type: String Local: Field: Default: Align: Right Local : Field : My Voucher Srl2 : Set as:$$NumItems:MyVoucherRepCollection2;$$PrevLine:#MyVoucherSrl2 Local : Field : MyVoucherParty2: Set As : "Total" Local : Field : MyVchNo2 : Set As : "" Local : Field : MyVchAmount2x : Set As : $$Total:MyVchAmount2x LOCAL : FIELD: MyVchfNo2:Set as:$$Total:MyVchfNo2 LOCAL : FIELD: MyVchfNo3:Set as:$$Total:MyVchfNo3 LOCAL : FIELD: MyVchfNo4:Set as:$$Total:MyVchfNo4 LOCAL : FIELD: MyVchTotAmount2x:Set as:$$Total:MyVchTotAmount2x Border : Totals [System: Formula] IsSalesVT2 : $$IsPurchase:$VoucherTypeName CSTFilter2 : not ##IsRevChargeAppl
explain, by way of screenshot.....what code you want??? from ledger or stockitem?? post screens with remarks.
[Field: HSNCodeSS1] Use : Name Field Set As : $GSTHSNCode:Ledger$$FuncDSPLedAccName:$IsPayroll:##DSPNameStyle) Style : Small Italic Border : Thin Right Align:Center Width : 10
Code: [Field: HSNCodeSS1] Use : Name Field Set As : $GSTHSNCode:Ledger:($$FuncDSPLedAccName:$IsPayroll:##DSPNameStyle) Style : Small Italic Border : Thin Right Align:Center Width : 10
Sir, "When using the code don't forget to give the credit to the Maker" This is one of the bad things of some member of this forem.
Good thinking..... if you know the name of the creator, kindly share and maybe @Rakesh Kumar will appreciate his/her contribution.
Thanking you so much to Amit Sir also Bidyut Ji. Specially Amit Sir, you are a great motivational guide. Once again Thanks a lot Amit Sir.
Dear Amit Jee, Thanks a lot for your appreciation. The same was created by me and send some member of this forums over mail.
Respected Amit Sir, I have tried a lot, but not able to show the quantity in "QTY" column. Please guide me. [Field:InvQty] Use: Number Field Set as: $BilledQty Style:Small Italic Aling: Right Border:Thin left right
You have to try on your own............ you have already computed IGST/CGST/SGST.... then what is the problem? What have you tried? how you tried to compute? If we all give ready solutions for all things, it would mean that you are making code in bits and pieces through others. You will not learn anything on your own. So this problem you must and you really should do on your own. You do not expect the KBC host to supply answers. But at least they give you 4 options and few lifelines. So here we give guidance.....
Amit Sir, thanks for your valuable guidance. I have learned a lot and becoming better & better by day to day. Moreover, I have tried the below code, but Sir not get the result, please give me some hints :- [Field:BilledQuantity] Use: Number Field Set as: $BilledQuantity:StockItem:$StockItemName Style:Small Italic Align : Right Border:Thin left right [Collection : BilledQuantity] Type : Ledger, Inventory Walk : allLedgerEntries, allInventoryEntries Fetch : CGSTAmount,SGSTAmount,IGSTAmount, BilledQuantity Fetch : *.* Compute:IGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100 ; ledger entries Compute:CGSTAmount :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2 Compute:SGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2 Compute:BilledQuantity:$$CollQtyTotal:InventoryEntries:$Quantity * $(Stockitem,$stockitem).Stockitem