How to Fetch Itemwise details in Exploded Line

Discussion in 'Tally Developer' started by Taufeeq Shaikh, Dec 15, 2020.

    
  1. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear All,

    Can anyone help me in getting Itemwise details at explode level..


    [#Part: DBC QtyDetails]

    Local : Field : DBC HSNSAC : Set as : $GSTItemHSNCodeEx
    Local : Field : DBC HSNSAC : Style : Small Italic

    Local : Field : DBC LEDGERNP : Set as : $GSTEntryLedgerName
    Local : Field : DBC LEDGERNP : Style : Small Italic

    Local : Field : DBC GSTRATE : Set as : $GSTLedItemIGSTRateEx
    Local : Field : DBC GSTRATE : Style : Small Italic

    Local : Field : DBC TAXABLE : Set as : $GSTInvoice_GSTAssesableValue
    Local : Field : DBC TAXABLE : Style : Small Italic

    Local : Field : DBC IGST : Set as : $$CollectionField:$$GSTItemTaxIGSTTaxAmt:1:InventoryAllocations ;;$GSTItemTaxIGSTTaxAmt
    Local : Field : DBC IGST : Style : Small Italic

    Local : Field : DBC CGST : Set as : $GSTItemTaxCGSTTaxAmt
    Local : Field : DBC CGST : Style : Small Italic

    Local : Field : DBC SGST : Set as : $GSTItemTaxSGSTTaxAmt
    Local : Field : DBC SGST : Style : Small Italic

    Local : Field : DBC CESS : Set as : $GSTItemTaxCessGSTTaxAmt
    Local : Field : DBC CESS : Style : Small Italic




    [System : Formulae]

    GSTTaxAnalysisItemLedKey : @@GSTTaxAnalysisItemLedName+$$SeparatorChar+($$String:$GSTVchItemSerialNum)
    GSTTaxAnalysisItemLedName : If $$IsEmpty:$StockItemName Then $LedgerNAme Else $StockItemName





    [#Collection: Columnar Vouchers of Company]

    Fetch : AllInventoryEntries.GSTLedItemIGSTRateEx, AllInventoryEntries.GSTItemHSNCodeEx, AllInventoryEntries.GSTEntryLedgerName,

    Fetch : AllInventoryEntries.Amount, AllInventoryEntries.GSTInvoice_GSTAssesableValue, AllInventoryEntries.GSTItemTaxCGSTTaxAmt, AllInventoryEntries.GSTItemTaxIGSTTaxAmt,

    Fetch : AllInventoryEntries.GSTItemTaxSGSTTaxAmt, AllInventoryEntries.GSTItemTaxCessGSTTaxAmt,



    [#Collection: Columnar Exploded Vouchers]

    Fetch : AllInventoryEntries.GSTLedItemIGSTRateEx, AllInventoryEntries.GSTItemHSNCodeEx, AllInventoryEntries.GSTEntryLedgerName,HSN, HSNCODE

    Fetch : AllInventoryEntries.Amount, AllInventoryEntries.GSTInvoice_GSTAssesableValue, AllInventoryEntries.GSTItemTaxCGSTTaxAmt, AllInventoryEntries.GSTItemTaxIGSTTaxAmt,

    Fetch : AllInventoryEntries.GSTItemTaxSGSTTaxAmt, AllInventoryEntries.GSTItemTaxCessGSTTaxAmt,


    Compute : GSTItemTaxCGSTTaxAmt : $$ReportObject:$$CollectionFieldByKey:$GSTItemTaxCGSTTaxAmt:mad:@GSTTaxAnalysisItemLedKey:GSTTaxAnalysiAlongWithSummary ;;$CGSTAmount
    Compute : GSTItemTaxSGSTTaxAmt : $SGSTAmount
    Compute : GSTItemTaxIGSTTaxAmt : $IGSTAmount
    Compute : GSTItemTaxCessGSTTaxAmt : $$NettAmount:$CessOnValGSTAmount:$CessOnQtyGSTAmount
    Compute : GSTItemTaxStateCessAmt : $StateCessAmount
     


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Sir Please post a screenshot where you are trying to add details
     


  3. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Screenshot Attached..


    upload_2020-12-22_19-43-7.png
     


  4. Himanshu-2002

    Himanshu-2002 Active Member


    Sir But I think It is working Right?
     


  5. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    No its not working at Item Level in Explode...

    I want Item wise Statutory details also...
     


  6. Himanshu-2002

    Himanshu-2002 Active Member


    Oo... I got it so, Basically you want GST Details of Stock Item Right?
    If yes then Give me time till next day... I will give you syntax to fetch those details
     


  7. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    I had worked on different format too... But don't know where am i making mistake... Since it had been long gap for me i had forgot too much....



    upload_2020-12-22_20-25-2.png
     


  8. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Yes....
     


  9. Himanshu-2002

    Himanshu-2002 Active Member


    That's Completely Normal Sir... You will retain all things very soon... Just Believe Yourself... I also learnt from your answers... So, It is a pleasure to help my teacher
     


  10. Himanshu-2002

    Himanshu-2002 Active Member


    SGST : $(StockItem, $StockItemName).GSTDetails[Last].StatewiseDetails[1, @@IsAnyState].RateDetails[1, @@IsIGST].GSTRate

    Sir Try To Learn From This Syntax
     


  11. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Can you please give me reference of any field or place in tally developer... Am still not getting it...

    Got the logic that it is picking up the rate from GSTDetails table/object..

    From Statewise And Last edited from RateDetails Table/Object...

    Had spent lot of time for this...
     


  12. Himanshu-2002

    Himanshu-2002 Active Member


    Sir What Details Or Methods You want to fetch?? So, I can give a proper solution
     


  13. Himanshu-2002

    Himanshu-2002 Active Member


    And I guess... You are having confusion between Tables, Object and Collection So, I suggest you to read the definition one more time
     


  14. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Can any one help me for achieving my result. I am referring the field which diplays itemwise GST analysis in Invoice.....

    [Field: EXPINV SGSTAmt]

    Use : EXPINV GSTAmtTemp
    Set as : If NOT $GSTIsTransLedEx Then "" Else If ##vIsDebit Then $$AsDrAmt:mad:sgsttaxamt Else $$AsCrAmt:mad:sgsttaxamt
    sgsttaxamt : $$ReportObject:$$CollectionFieldByKey:$GSTItemTaxSGSTTaxAmt:mad:@GSTTaxAnalysisItemLedKey:GSTTaxAnalysiAlongWithSummary
    Invisible : ##GSTFirstTransNatureType != 1 OR (NOT ##IsRevChargeAppl AND $$IsEmpty:##GSTActualSGSTAmount)




    sgsttaxamt : $$ReportObject:$$CollectionFieldByKey:$GSTItemTaxSGSTTaxAmt:mad:@GSTTaxAnalysisItemLedKey:GSTTaxAnalysiAlongWithSummary


    $GSTItemTaxSGSTTaxAmt -> it is a value that will be derived

    @@GSTTaxAnalysisItemLedKey -> it is a filter that will filter whether it is Item or Ledger

    GSTTaxAnalysiAlongWithSummary -> it is a collection from the value will be computed and fetched


    How can i derive result in my UDF report or Columnar Exploded Sales Vouchers.....
     


  15. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear Himanshu i will be utterly thankful for your help in getting my solution..
     


  16. Himanshu-2002

    Himanshu-2002 Active Member


    Sir, Did u Got The Solution?
     


  17. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    No not yet....
     


  18. Himanshu-2002

    Himanshu-2002 Active Member


    I got your mail..will revert you
     


  19. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    No one from the forum have any idea to get me Itemwise Statutory details.... ??

    Amit Sir --->> The King of the Ring....

    My only hope is you now...
     


  20. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  21. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2020-12-30_13-39-36.png

    this report
     


  22. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    It seems to be the LedgerWise / Partywise Report where is Item Name, HSN, GST Rate, Qty Etc.... In Short Item Details are not there in your report..
     


  23. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Taufeeq Shaikh, Other Field is Invisible
     


  24. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2020-12-30_14-5-5.png
    Hsn wise report
     
    Taufeeq Shaikh likes this.


  25. garima

    garima Well-Known Member


    Kindly use default tally functions, list variables and Collection

    In your report..

    walk through voucher collection..
    for every voucher call this default tally function : [Function: Load GST Tax AnalysisDetails] (by default.. this function works when you click tax analysis on voucher report for single voucher]
    this will give you required information in list variable in lvGSTTaxAnalysisDetails .. use VchGST TaxAnalysis Itemwise [Collection ] based on List Variable lvGSTTaxAnalysisDetails in your exploded Part posted by you.

    ..do this for every voucher in your report...

    Fucntion Load GST Tax AnalysisDetails .. calls another function getGSTTaxAmount function.. which may some have unnecessary calls to other functions or loops into other collections ..

    you can go through all this functions, collections and reports , copy them in one place and modifying them according to your requirement.

    Keep in mind.. there is no default Item gst rate wise details available in Tally objects.. basically what you require is default Vch GST Tax analysis report . in exploded mode .. but that is for single voucher.. how to get there .. I have mentioned in first part of my answer
     
    Last edited: Jan 9, 2021


Share This Page