To add Expenses HSN/SAC code

Discussion in 'Free Source Codes' started by Rakesh Kumar, Jun 4, 2019.

    
  1. Rakesh Kumar

    Rakesh Kumar Member


    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.
     


  2. Rakesh Kumar

    Rakesh Kumar Member


    I have added stock item code but unable to add expenses code.
     


  3. Rakesh Kumar

    Rakesh Kumar Member


    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
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $GSTHSNCode:Ledger:$LedgerName OR
    $GSTHSNCode:Ledger:##LedgerName
     


  5. Rakesh Kumar

    Rakesh Kumar Member


    Amit sir, how to add your code in 3rd line of my code
     


  6. Rakesh Kumar

    Rakesh Kumar Member


    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
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use : Name Field
     


  8. Rakesh Kumar

    Rakesh Kumar Member


    Sir, it is showing "Not Found"

    upload_2019-6-4_21-1-16.png
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     


  10. Rakesh Kumar

    Rakesh Kumar Member


    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 :DSP 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:Color:DARK 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
     
    Muhammadhaneef likes this.


  11. Rakesh Kumar

    Rakesh Kumar Member


    Amit Sir, please guide me.
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    explain, by way of screenshot.....what code you want??? from ledger or stockitem?? post screens with remarks.
     


  13. Rakesh Kumar

    Rakesh Kumar Member


    I required both Ledger and Stock Item
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field: HSNCodeSS1]
    Use : Name Field
    Set As : $GSTHSNCode:Ledger:($$FuncDSPLedAccName:$IsPayroll:##DSPNameStyle)
    Style : Small Italic
    Border : Thin Right
    Align:Center
    Width : 10
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code:
    [Field: HSNCodeSS1]
    Use : Name Field
    Set As : $GSTHSNCode:Ledger:($$FuncDSPLedAccName:$IsPayroll:##DSPNameStyle)
    Style : Small Italic
    Border : Thin Right
    Align:Center
    Width : 10
    
     



  16. 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.
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Good thinking..... if you know the name of the creator, kindly share and maybe @Rakesh Kumar will appreciate his/her contribution.
     


  18. Rakesh Kumar

    Rakesh Kumar Member


    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.
     



  19. Dear Amit Jee,

    Thanks a lot for your appreciation.

    The same was created by me and send some member of this forums over mail.
     
    Frz and Amit Kamdar like this.


  20. Rakesh Kumar

    Rakesh Kumar Member


    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



    upload_2019-6-17_19-49-19.png
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Compute the QTY in your Collection and then call for in that field.
     


  22. Rakesh Kumar

    Rakesh Kumar Member


    Sir, I am unable to compute the Qty. Please help me to give some more hints
     


  23. Rakesh Kumar

    Rakesh Kumar Member


    Amit Sir, I request you, please help me.
     


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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..... :)
     


  25. Rakesh Kumar

    Rakesh Kumar Member


    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
     


Share This Page