Insert Into COMMON.DBO.ACCOUNT_MASTER Values('SGSTA/C','SGST A/C','GOODS AND SERVICES TAX','-DIRECT','-NONE','','','','',0,'','','','','','','','','','','',0,0,'','','NO','','',0,0,0,'',0,0,'','','','','',0,0,'',0,'',0,0,'','','','',0,0,0,0,0,0,'N','','NO','TAXABLE SUPPLY','','','',0,'','0','PAYMENT','','','')




-----------------RUN IN ALL FIRM IN SQL UTILITES IN TAMANNA SOFTWARE
insert into account_master
SELECT        AccCode, AccName, AccType, AccAgentCode, AccGroupCode, AccAdd1, AccAdd2, AccAdd3, AccCityName, AccCityPin, AccPhone, AccMobile, AccFax, AccEmail, AccResident, AccGSTNo, AccCSTNo, AccPANNo, AccVATNo, 
                         AccContPerson, AccRef, AccCrLimit, AccCrDays, 0, 'Dr', 0, AccTANNo, AccKSTNo, TDSYesNo, TDSAccount, JobType, DiscPerc, RDPerPcs, RDPerMts, InsPolicyNo, Dhara, DharaDays, 
                         TransName, AccAdd21, AccAdd22, AccAdd23, AccCityName2, AccCityPin2, BlackListed, BankDetail, ExcessRate, SeriesName, CommPerc, TDSLimit, BankName, AccountNo, IFSCCode, Branch, LessDays, PackPerPcs, 
                         BankCommPerc, BankCommLessPerc, PackPerMts, PostageCharge, Taxable, GSTIN, CompScheme, GSTCategory, ECommGSTIN, GSTRegDate, AccManager, CityDistanceKM, SMAccCode, TCSApplicable, TCSCollectFrom, 
                         UdyamRegNumber, EnterpriseType, EnterpriseActivity
FROM            common.dbo.ACCOUNT_MASTER where acccode = 'SGSTA/C' and acccode COLLATE DATABASE_DEFAULT not in (select acccode from account_master)




------------------------------------------------------------- 21-01-2026 RUN IN ALL FIRM
USE T26S001



UPDATE FIRM_ADDLESS_DETAIL SET EFFACC='SGSTA/C' WHERE FLDNAME = 'SGST'


BANK REC NO:214
BANK REC NO :215 , 219,220,214

GN SR NO 5 EDIT BILL