Fetching the Statutory Values of Vouchers

Dear All,

Just to revise my learning am Trying to make a report same as GSTR-1 for Sales Voucher, I just need to know that whether i can directly fetch the value of (Taxable, IGST, CGST,SGST) TAX wise from Voucher or by referring a Predefined cell or will have to compulsory make a collection.

Please Guide.

 

Create a main Collection and later walk through to get values

 

Dear All,

Finally i succeeded one more time by practicing and revising the tdl's....

Achieved the goal...................

 

This is it....

 

I still need to add Tax Classification for each transaction (i.e) B2B, B2C, Export, Non GST, NillRated, Exempt.... Etc...... in the column GST type.

My only aim is to get the RAW Data from Tally to Excel and then Making different reports for GST Assessment through Pivot Tables and Formulas....

LedgerWise i had succeeded now i am working for ITEM Wise too.... So that i can prepare most of the reports...

 

Congrats Sir

 

Am trying to get my result but still cant achieve it. (i.e.) The Tag for Sales Type

Please help me to get the Nature of Sales Transaction (Table Name) in my UDF report.. the reference of GSTR-1 is as follows :-


[Line: GSTR1 TrglTableWiseDetails]

Local : Field : GST VchParticulars : Set as : $$StringRemWord:1:$Value
Local : Field : GST VchParticulars : Variable : vGSTTableName


[Field: GST VchParticulars]

Use : Name Field
Set as : $GSTTransactionNature
Full Width : Yes
Variable : vGSTDetails


[Field: GST TransNatureInv]

Use : Name Field
Set as : $GSTTransactionNature
Variable : vGSTTransNature
Invisible : Yes



My Coding is as follows :-


[Field : tgpartytype]

Use : Name Field
Set as : $TSGsttype ;;$Naturecode
Variable : vGSTTableName
Width : 10
Border : Thin Right
Style : Small



[Collection : trsgstcollection]

Type : Vouchers

Fetch : AllLedgerEntries.GSTEntryLedgerName, AllLedgerEntries.FirstAccName, AllInventoryEntries.GSTEntryLedgerName, AllLedgerEntries.GSTTransactionNature, AllInventoryEntries.GSTTransactionNature, GSTTransactionNature

Compute : TSGsttype : $GSTTransactionNature

 

Sir Can U Please Post Collection Details For Getting CGST and SGST Values Directly into Collection?
I M Also Trying to Achieve the same but i m using Predefined Ledgers to find the value.
It would Be Great help if i can see the code.