[HELP]B2B AND B2C ATTACH IN 1 REPORT

HI
PLZ HELP ON THIS REPORT
I WANT 3 PART IN A REPORT B2C +B2B+ GSTR2

 

Monthly Report B2B & B2C in Sale Voucher

 

Monthly Report - B2B & B2C IN Credit note Voucher

 

ऊपर txt फाइल में 2 रिपोर्ट है उसको जोड़ना है उसका उपाय बताये

हां मेरे को भी ऐसी ही रिपोर्ट बनानी है पर दो अलग अलग रिपोर्ट को जोड़ना कैसे है वो समझ नहीं आ रहा है

 

Create a Part and under that Part Create Two more parts and just repeat lines and more stuff which are required

 

EK REPORT MEIN 2 BAAR VARIABLE KAISE USE KARTE HAI
PART MEIN

B2B KE LIYE Variable


Variable : vGSTCompFromDate, vGSTCompToDate
Variable : vGSTCompMonthName
Variable : vGSTReportName : String : "B2B supplies to registered persons including credit/debit note"
Variable : vGSTNatureCode : String : "B2B"
Variable : vGSTTransType : String : ""
Variable : vDrillDownType : String : "Partywise"
Variable : vCollType : String : "ADVINWARD"
Variable : IsJrnlAdj : Logical : "no"
Variable : IsIMPGdsJrnlAdj : Logical : "no"
Variable : IsAllOtherITC : Logical : "no"
Variable : IsGSTVchInclAdj : Logical : "no"
Variable : IsGSTJrnlAdjRCFlag : Logical : "no"
Variable : IsOutWard : Logical : "YES"
Variable : IsGSTJrnlAdjIMPSFlag : Logical : "NO"
Variable : IsGSTJrnlAdjIMPSLiabFlag : Logical : "NO"


Variable : IsGSTCompIMPGoodsJVExist
Set : IsGSTCompIMPGoodsJVExist : @@IsGSTCompIMPGoodsJVExist




AUR B2C KE LIYE VARIABLE


Variable : vGSTCompMonthName
Variable : vGSTReportName : String : "B2C Supplies to Unregistered Persons"
Variable : vGSTNatureCode : String : "B2C"
Variable : vGSTTransType : String : ""
Variable : vDrillDownType : String : "Poswise"
Variable : vCollType : String :"ADVINWARD"
Variable : IsJrnlAdj : Logical : "no"
Variable : IsIMPGdsJrnlAdj : Logical : "no"
Variable : IsAllOtherITC : Logical : "no"
Variable : IsGSTVchInclAdj : Logical : "no"
Variable : IsGSTJrnlAdjRCFlag: Logical : "no"
Variable : IsOutWard : Logical : "YES"
Variable : IsGSTJrnlAdjIMPSFlag : Logical : "NO"
Variable : IsGSTJrnlAdjIMPSLiabFlag : Logical :"NO"


Variable : IsGSTCompIMPGoodsJVExist
Set : IsGSTCompIMPGoodsJVExist : @@IsGSTCompIMPGoodsJVExist

Set : SVFromDate : ##SVFromDate
Set : SVToDate : ##SVToDate

 

Sir 2 baar variable kyu use karna hai?

 

Simple 2 collection bana lo ek b2b aur ek b2c ke liye aur compute karke use karlo

 

SAMPLE CODE HO TO PLZ DE DE MEIN SAMJH LUGA YA KOI SAMPLE Tally.Developer 9 ME HO TO NAME BATA DO MEIN USMEIN DEKH LUGA

 

AGRE AAP MODIFY KAR SAKTE HAI CODE KO VO KAR KE BATA DEVE

 

Sir Sample Code Tally Developer mein hai ya nahi..I don't know but aap ye chiz bohot simply kar sakte hai bas 2 Collection banao aur two parts mein repeat kar do but usse pehle aap sirf B2B ka hi report bana ke try karo uske baad B2C try karna after that dono ko combine karne ke baar mein puchna main bata dunga

 

OK

 

thodi help karo nahi ban pa raha mere se

 

[Collection: collzx01]
Object : SupplieForRegDealerB2B
Fetch:Name,Naturecode,SortIndex,TaxableValue,CGSTTaxValue,SGSTTaxValue,IGSTTaxValue,CessTaxValue,InvoiceValue,GroupName,DrilldownReport,IsOutWard


aise hi banega kya isse aage samjh mein nahi aa raha hai

 

[#Menu: Gateway of Tally]

Add : Item : 144 : Display: REPORTAA01 : NOT $$IsEmpty:$$SelectedCmps


[Report: REPORTAA01]
use : GSTComp MonthlySummary
Form : FORMAA01


[Form: FORMAA01]
Parts : PARTAA01,PARTAB01
Height : 100% Screen
Width : 100% Screen



[Part: PARTAA01]
Line : LINEAA01
Repeat : LINEAA01 : collzx01
Scroll : Vertical
Common Border : Yes
Space Top : if $$InPrintMode then 0.5 else 0
Space Bottom : if $$InPrintMode then 0.5 else 0


[Line: LINEAA01]

Border : Thin Top Bottom
Fields : FIELDSAA01,/*GSTComp SlNo, */ GSTComp Particulars, GSTComp NatureCode, GSTComp DrillDownType, GSTComp ITCRuleName, GSTComp GroupName,

GSTComp IsOutWard
Fields : FIELDSAA01,FIELDSAA02,FIELDSAA03,FIELDSAA04,FIELDSAA05,FIELDSAA06,FIELDSAA07,FIELDSAA08,FIELDSAA09,FIELDSAA10

Local : Field : Default : Align : Center
Local : Field : Default : Style : Normal Bold

Border : Thin Top Bottom
Local : Field : FIELDSAA01 : Display : GSTComp MonthlySummary ;; : NOT $$IsEmpty:#vInvoiceAValNaturVal




[Field: FIELDSAA01]

Use : NameField
Set as : $Name
Style : Small
Align :CENTER
Border : Thin Left
COLOR : RED
[Field: FIELDSAA02]

Use : Field01x01
Set as :$Naturecode
Style : Small
Align :CENTER
Border : Thin Left
[Field: FIELDSAA03]

Use : Field01x01
Set as :$SortIndex
Style : Small
Align :CENTER
Border : Thin Left
[Field: FIELDSAA04]

Use : Field01x01
Set as :$Naturecode
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSAA05]

Use : Field01x01
Set as :$TaxableValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSAA06]

Use : Field01x01
Set as :$CGSTTaxValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSAA07]

Use : Field01x01
Set as :$SGSTTaxValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSAA08]

Use : Field01x01
Set as :$IGSTTaxValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSAA09]

Use : Field01x01
Set as :$InvoiceValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSAA10]

Use : Field01x01
Set as :$IsOutWard
Style : Small
Align :CENTER
Border : Thin Left




[Collection: collzx01]

Object : SupplieForRegDealerB2B
Fetch:Name,Naturecode,SortIndex,TaxableValue,CGSTTaxValue,SGSTTaxValue,IGSTTaxValue,CessTaxValue,InvoiceValue,GroupName,DrilldownReport,IsOutWard

Compute : vRepNatureCode : $Naturecode
Compute : IsOutWardType : $IsOutWard
Compute : VchTransType : $GSTVchTransType
Compute : IsOutWardType : $IsOutWard
Compute : IsOutWardType : $IsOutWard


;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[Part: PARTAB01]
Line : LINEAB01
Repeat : LINEAB01 :collzx02
Scroll : Vertical
Common Border : Yes
Space Top : if $$InPrintMode then 0.5 else 0
Space Bottom : if $$InPrintMode then 0.5 else 0


[Line: LINEAB01]
Border : Thin Top Bottom
; Fields : /*GSTComp SlNo, */ GSTComp Particulars, GSTComp NatureCode, GSTComp DrillDownType, GSTComp ITCRuleName, GSTComp GroupName, GSTComp

IsOutWard


Fields : FIELDSAB01,FIELDSAB02,FIELDSAB03,FIELDSAB04,FIELDSAB05,FIELDSAB06,FIELDSAB07,FIELDSAB08,FIELDSAB09,FIELDSAA10

Local : Field : Default : Align : Center
Local : Field : Default : Style : Normal Bold

Border : Thin Top Bottom
Local : Field : FIELDSAB01 : Display : GSTComp MonthlySummary ;; : NOT $$IsEmpty:#vInvoiceAValNaturVal




[Field: FIELDSab01]

Use : NameField
Set as : $Name
Style : Small
Align :CENTER
Border : Thin Left
COLOR : RED
[Field: FIELDSab02]

Use : Field01x01
Set as :$Naturecode
Style : Small
Align :CENTER
Border : Thin Left
[Field: FIELDSab03]

Use : Field01x01
Set as :$SortIndex
Style : Small
Align :CENTER
Border : Thin Left
[Field: FIELDSab04]

Use : Field01x01
Set as :$Naturecode
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSab05]

Use : Field01x01
Set as :$TaxableValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSab06]

Use : Field01x01
Set as :$CGSTTaxValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSab07]

Use : Field01x01
Set as :$SGSTTaxValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSab08]

Use : Field01x01
Set as :$IGSTTaxValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSab09]

Use : Field01x01
Set as :$InvoiceValue
Style : Small
Align :CENTER
Border : Thin Left

[Field: FIELDSAb10]

Use : Field01x01
Set as :$IsOutWard
Style : Small
Align :CENTER
Border : Thin Left


[Collection: collzx02]
Object : SupplieForRegDealerB2c
Fetch:Name,Naturecode,SortIndex,TaxableValue,CGSTTaxValue,SGSTTaxValue,IGSTTaxValue,CessTaxValue,InvoiceValue,GroupName,DrilldownReport,IsOutWard

Compute : vRepNatureCode : $Naturecode
Compute : IsOutWardType : $IsOutWard
Compute : VchTransType : $GSTVchTransType
Compute : IsOutWardType : $IsOutWard
Compute : IsOutWardType : $IsOutWard

 

Kishan sir aapko TDL ke basics aata hai?

 

nahi aata sikh rahe hai .... sample read kar kar ke

 

koi online sikhata hai to plz uska bhi bataye