How to Fetch Itemwise details in Exploded Line

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@GSTTaxAnalysisItemLedKey:GSTTaxAnalysiAlongWithSummary ;;$CGSTAmount
Compute : GSTItemTaxSGSTTaxAmt : $SGSTAmount
Compute : GSTItemTaxIGSTTaxAmt : $IGSTAmount
Compute : GSTItemTaxCessGSTTaxAmt : $$NettAmount:$CessOnValGSTAmount:$CessOnQtyGSTAmount
Compute : GSTItemTaxStateCessAmt : $StateCessAmount

 

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

 

Screenshot Attached..

 

Sir But I think It is working Right?

 

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

I want Item wise Statutory details also...

 

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

 

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

 

Yes....

 

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

 

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

Sir Try To Learn From This Syntax

 

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

 

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

 

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

 

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 $$AsDrAmtsgsttaxamt Else $$AsCrAmtsgsttaxamt
sgsttaxamt : $$ReportObject:$$CollectionFieldByKey:$GSTItemTaxSGSTTaxAmt@GSTTaxAnalysisItemLedKey:GSTTaxAnalysiAlongWithSummary
Invisible : ##GSTFirstTransNatureType != 1 OR (NOT ##IsRevChargeAppl AND $$IsEmpty:##GSTActualSGSTAmount)




sgsttaxamt : $$ReportObject:$$CollectionFieldByKey:$GSTItemTaxSGSTTaxAmt@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.....

 

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

 

Sir, Did u Got The Solution?

 

No not yet....

 

I got your mail..will revert you

 

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

 

Send tdl on my mail id is pankaj78bhondle@gmail.com

 

this report

 

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

 

Taufeeq Shaikh, Other Field is Invisible

 

Hsn wise report

 

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