; ************************ ******************** ; Document : Address book ; Created on : 11 NOV 2019, 10:25:20 AM ; Author : CHANDRESH GAUR (9634523861) [Menu: Gateway of Tally] Add: Item: Before : @@locDisplay : Address Book :Alter Collection: GSTMultiExtractLedger [Collection: GSTMultiExtractLedger] Option : GSTMultiExtractLedger Server : NOT $$IsRemoteCompany [!Collection: GSTMultiExtractLedger Server] Use : GSTMultiLedger [Collection: GSTMultiLedger] Use : GSTListofGroups Collection : All Items Include : Group:$$GroupSundryDebtors, Group:$$GroupSundryCreditors Report : GSTMultiLedger Variable : MGroup Trigger : MGroup [Collection: GSTListofGroups] Include : Group:$$GroupSundryDebtors, Group:$$GroupSundryCreditors Title : $$LocaleString:"List of Groups" Type : Group Report : Group Variable : Group Name Trigger : SGroup Fetch : Name, Language Name Fetch : Parent, ReserveName, IsRevenue Fetch : ParentStructure Compute : PrimaryGrpParent : $Parent:Group:$_PrimaryGroup ;****************** Report ****************** [Report: GSTMultiLedger] Use : Multi Master Report Family : $$Translate:"Accounts Masters" Title : $$SPrintf:@@MultiLedgerCreateModeFormat:@@ModeName:@@SubModeName Variables : MGroup Set : SVAccounts : Yes Set : SVInventory : No Set : SVStatutory : No Set : SVTallyShop : No Multi Objects : Ledger Under MGroup [Form: GSTMultiLedger] Use : DSP Template Height : 100% Screen Width : 100% Screen Background : PETAL PINK;ReportLightColor Part : CompTit, GSTMLEDBody Space Bottom : 0 Local : Button : Multi Master Ledger : Inactive : Yes Local : Field : MSTSortPosition : Set as : 1000 Delete : Button : ExplodeFlag, F2ChangePeriod, ChangeCompany Delete : Keys : ChangePeriod Delete : BottomButton: DSPAutoColumns, BudgetAnalysis, BlankButton, RelReports, InvReports, AcctReports, ReportOperations, ReportConfig, FilterButton, ValueButton ; ***************** Title part ******************** [Part: CompTit] Invisible : $$InPrintMode or $$InExportMode ;Height : 0.7 Inch Local : Field : Default :Skip: Yes Line : CompTit;,CMP Invisible : $$InPrintMode or $$InExportMode [Line: CompTit] Field: CompTit [Field: CompTit] Use : Name Field Set as : @@CMPMAILNAME +" "+"ADDRESS BOOK" Full Width : Yes Style : CompTitStyle Align : Centre Border:THICK BOX ; *************** Body part ************** [Part: GSTMLEDBody] Lines : GSTMLED Titles, GSTMLEDBody Repeat : GSTMLEDBody : Ledger Under MGroup Break On : $$IsEmpty:$Name Scrolled : Vertical Common Border : Yes [Line: GSTMLED Titles] Fields : GSTGSTINTit,Multi MST NameTit,GSTLED CountryTit,GSTLED StateTit,GSTLED ContactTit,GSTLED MobileTit,GSTLED EMailTit,MST ParentTit,GSTLEDADD Border : Column Titles Local : Field : Default :Style : Normal [Field: GSTGSTINTIt] Use : Namefield Set as : "GSTIN" [Field: Multi MST NameTit] Use : Namefield Set as : "Particulars" Width : 33 [Field: GSTLED CountryTit] Use : Namefield Set as : "Country" [Field: GSTLED StateTit] Use : Namefield Set as : "State" [Field: GSTLED ContactTit] Use : Namefield Set as : "Contact" [Field: GSTLED MobileTit] Use : Namefield Set as : "Mobile" [Field: GSTLED EMailTit] Use : Namefield Set as : "Email ID" [Field: MST ParentTit] Use : Namefield Set as : "Parent" [Field:GSTLEDADD] Use : Namefield Set as : "ADDRESS" [Line: GSTMLEDBody] Fields : GSTGSTIN,Multi MST Name,GSTLED Country,GSTLED State,GSTLED Contact,GSTLED Mobile,GSTLED EMail,MST Parent,MSTLEDD Local : Field : MST Parent : Delete : Dynamic Local : Field : MST Parent : Delete : CommonTable Local : Field : MST Parent : Table : Group Stock MExtract : $$InAlterMode AND $LedIsStockLedger Local : Field : MST Parent : Table : Non Stock NonRevenue Groups MExtract: $$InAlterMode AND ($CurrencyName != $$CompanyBaseCurrency) Local : Field : MST Parent : Table : Non Stock Groups MExtract: $$InAlterMode AND NOT $IsReserved Local : Field : MST Parent : Table : List of Groups MExtract : NOT $IsReserved Local : Field : MST Parent : Table : Primary : $IsReserved Local : Field : MST Parent : Key : Create Group, Alter Group Local : Field : MST Parent : Variable: SV Group Local : Field : MST Parent : Skip On : ($IsReserved) OR ((##SkipParentField AND ($CurrencyName = $$CompanyBaseCurrency)) OR ($$InCreateMode AND NOT $$IsSysName:#MMDefParent)) OR $ForPayroll Local : Field : MST Parent : Fetch Object: Group : $$Value : Parent, SortPosition, ReserveName, ReservedName, IsDeemedPositive, + IsRevenue, IsBillWiseOn, AffectsStock, IsCostCentresOn, BasicGroupIsCalculable Local : Field : Multi Master Name: Width : 33 [Field : GSTGSTIN] Use : Name Field Use : Upper Case Field Storage : PartyGSTIN Style : Small Bold Notify : PartyGSTINStructureValidation : NOT ($$IsSysNameEqual:EmbassyUNBodies:#LEDGSTPartyType OR $$IsSysNameEqual:GovernmentEntity:#LEDGSTPartyType) AND ($$IsEmpty:$$Value OR (NOT $$FuncIsValidGSTIN:$$Value) OR $$StringPart:$$Value:0:2 != $$getGSTStateCode:@@GSTLedPlaceOfSupply) Notify : MSTGSTINEmbassyStructureValidation : ($$IsSysNameEqual:EmbassyUNBodies:#LEDGSTPartyType OR $$IsSysNameEqual:GovernmentEntity:#LEDGSTPartyType) AND ($$IsEmpty:$$Value OR (NOT $$FuncIsValidGSTIN:$$Value:#LEDGSTPartyType) OR $$StringPart:$$Value:0:2 != $$getGSTStateCode:@@GSTLedPlaceOfSupply) Ascii Only : Yes KBLanguage : @@EnglishLanguageID Max : 15 Set Always : Yes Border : Thin Right [Field: GSTLED Country] Use : Name Field Set as : #LEDInvisibleCountry Storage : CountryofResidence Table : List Of Countries, Not Applicable Show Table : Always ResType : $$LocaleString:$TDSDeducteeType Width : @@NameWidth; + 17 Skip : @@SkipMailingDetails ;Invisible : Yes Set Always : Yes Border : THin left Style : Normal [Field: GSTLED State] Use : Name Field Set as : If $$InCreateMode AND $$IsEmpty:$$Value Then $$LocaleString:@CMPState Else + If NOT $$IsEmpty:$StateName Then $$LocaleString:($$SetLedStateName) Else + $$LocaleString:$LedStateName Storage : LedStateName Show Table : Always Table : Indian States, Not Applicable CMPState : $StateName:Company:##SVCurrentCompany Inactive : (NOT @@MailableGroup) OR (NOT $$IsEmpty:$TDSDeducteeType AND $IsNonResdient:DeducteeType:$TDSDeducteeType AND NOT ($$LocaleString:$Countryofresidence = $$LocaleString:"India" OR $$IsEmpty:$Countryofresidence)) OR (NOT $$IsTDSOn AND @@NotMailableGroup) Skip : @@SkipMailingDetails Set Always : Yes Border : THin left Style : Normal [Field: GSTLED Contact] Use : Name Field Style : Normal Storage : LedgerContact Skip : @@SkipMailingDetails Border : THin left RIght [Field: GSTLED Mobile] Use : Name Field Style : Normal Storage : LedgerMobile Border : THin RIght [Field: GSTLED EMail] Use : Name Field Case : Normal Style : Normal Storage : EMail ASCIIOnly : Yes Border : THin RIght [Field:MSTLEDD] Use : Name Field Set Always : Yes Style : Small Bold Storage : Address ;Inactive : $$IsEmpty:#LEDMailingName ;Invisible : ##MVInMultiMode /* to increase the visibility of address */ Set Always:Yes Width : @@NameWidth + 17 Skip : $IsBehaveAsDuty OR (($$Owner:@@IsRevenueGroup) AND NOT ##UseAddressforRevenue) Border : THin LEFT RIght ;Background:RED ; *************** Color ********** [Color:ReportLightColor] RGB:255,255,255 ;240,255,255;248,248,245 [Style: CompTitStyle] Height : 16 Font : "Calibri" Bold : Yes ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;