MFG Scripts of New Tables

----------------------------Invalid Party Query-----------------------------
SELECT partyid FROM invoice WHERE 
partyid NOT IN (SELECT partyid FROM Partymst) 
AND LEFT(yearinvoiceno,6) = '202425';

SELECT partyid FROM bill WHERE 
partyid NOT IN (SELECT partyid FROM Partymst) 
AND LEFT(yearbillno,6) = '202425';

SELECT partyid FROM debitcredit WHERE 
partyid NOT IN (SELECT partyid FROM Partymst) 
AND LEFT(yeardncnno,6) = '202425';

SELECT mainac+subac FROM journalvoucher1 WHERE 
mainac+subac NOT IN (SELECT controlac+partyid FROM Partymst) 
AND LEFT(yearjvno,6) = '202425' AND refdoc IN ('SI','OA','PB','AD');

SELECT mainac+subac FROM voucher1 WHERE 
mainac+subac NOT IN (SELECT controlac+partyid FROM Partymst) 
AND LEFT(yearvoucherno,6) = '202425' AND refdoc IN ('SI','OA','PB','AD');

---------------------Main & Line Level amount tallied------------------------------

WITH A(totalitemvalue, yearbillno)AS
(
    SELECT SUM(value),yearbillno FROM bill2
    GROUP BY yearbillno
),
B(yearbillno,tax1amt,stax2amt,exciseamt,rdg,cess2,FcAmount,freight,discount,totalitemvalue, [value],Systotalamt )AS
(
    SELECT B.yearbillno, stax1amt,stax2amt,exciseamt,rdg,cess2,FcAmount,freight,discount,totalitemvalue, [value],
    (stax1amt+stax2amt+exciseamt+rdg+cess2+freight-discount+totalitemvalue) AS Systotalamt FROM bill B--fcamount excluded
    LEFT JOIN A ON B.yearbillno = A.yearbillno
    WHERE CONVERT(DATE,dated) BETWEEN '01-Apr-25' AND '30-Jun-25' AND
    stax1amt+stax2amt+exciseamt+rdg+cess2+freight-discount+totalitemvalue != [value]
)
SELECT * FROM B;

WITH A(totalitemvalue, yearinvoiceno)AS
(
    SELECT SUM(value),yearinvoiceno FROM invoice2
    GROUP BY yearinvoiceno
),
B(yearbillno,tax1amt,stax2amt,exciseamt,rdg,cess2,FcAmount,freight,discount,totalitemvalue, [value],Systotalamt )AS
(
    SELECT B.yearinvoiceno, stax1amt,stax2amt,exciseamt,rdg,cess2,FcAmount,freight,discount,totalitemvalue, [value],
    (stax1amt+stax2amt+exciseamt-rdg+cess2+freight-discount+totalitemvalue) AS Systotalamt FROM invoice B--fcamount excluded
    LEFT JOIN A ON B.yearinvoiceno = A.yearinvoiceno
    WHERE CONVERT(DATE,dated) BETWEEN '01-Apr-25' AND '30-Jun-25' AND
    stax1amt+stax2amt+exciseamt-rdg+cess2+freight-discount+totalitemvalue != [value]
)
SELECT * FROM B;


WITH A(totalitemvalue, yeardncnno)AS
(
    SELECT SUM(value),yeardncnno FROM debitcredit1
    GROUP BY yeardncnno
),
B(yearbillno,tax1amt,stax2amt,exciseamt,rdg,cess2,FcAmount,freight,discount,totalitemvalue, [value],Systotalamt )AS
(
    SELECT B.yeardncnno, stax1amt,stax2amt,exciseamt,rdgdiff,cess2,FcAmount,freight,discount,totalitemvalue, [value],
    (stax1amt+stax2amt+exciseamt-rdgdiff+cess2+freight-discount+totalitemvalue) AS Systotalamt FROM debitcredit B--fcamount excluded
    LEFT JOIN A ON B.yeardncnno = A.yeardncnno
    WHERE CONVERT(DATE,dated) BETWEEN '01-Apr-25' AND '30-Jun-25' AND
    stax1amt+stax2amt+exciseamt-rdgdiff+cess2+freight-discount+totalitemvalue != [value]
)
SELECT * FROM B;

WITH A(totalitemvalue, yearvoucherno)AS
(
    SELECT ABS(SUM(IIF(drcr = 'D', amount * -1, amount))),yearvoucherno FROM voucher1
    GROUP BY yearvoucherno
),
B(yearvoucherno,[value],Systotalamt )AS
(
    SELECT B.yearvoucherno, B.[amount],
    A.totalitemvalue AS Systotalamt FROM voucher B--fcamount excluded
    LEFT JOIN A ON B.yearvoucherno = A.yearvoucherno
    WHERE CONVERT(DATE,dated) BETWEEN '01-Apr-25' AND '30-Jun-25' AND
    B.[amount] != A.totalitemvalue
)
SELECT * FROM B;

-----------------Invalid A/c Heads---------------
SELECT * FROM voucher1 WHERE mainac+subac NOT IN (SELECT mainac+subac FROM accounts1) AND refdoc = 'GL'

--PENDING FOR OTHER TABLES

--Already taken in migration
--UPDATE Bill2 SET Mainac = B1.mainac, Subac = B1.subac FROM bill1 B1
--WHERE Bill2.yearbillno = B1.yearbillno AND trntype != 50 AND B1.mainac != Bill2.mainac;

-- SELECT B1.yearbillno, B1.mainac, B1.subac, B2.Mainac,B2.subac, trntype FROM Bill1 B1
-- LEFT JOIN Bill2 B2 ON B1.yearbillno = B2.yearbillno 
-- WHERE trntype !='50' AND B1.mainac != B2.Mainac
-- ORDER BY B1.yearbillno DESC

-- UPDATE bill SET rdg = (B.value-Systotalamt)+B.rdg FROM B WHERE B.yearbillno = bill.yearbillno

DELETE FROM opgos WHERE yearlabel = '2023-24'


SELECT * INTO Zopgos FROM opgos WHERE yearlabel = '2023-24'


DROP TABLE Zopgos


SELECT COUNT(*) AS Cnt FROM opgos O
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE yearlabel = '2023-24' AND A.actype = 'C';
SELECT COUNT(*) AS Cnt FROM Zopgos O
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE yearlabel = '2023-24' AND A.actype = 'C';

SELECT COUNT(*) AS Cnt FROM opgos O
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE yearlabel = '2023-24' AND A.actype = 'S';
SELECT COUNT(*) AS Cnt FROM Zopgos O
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE yearlabel = '2023-24' AND A.actype = 'S';

SELECT SUM(Amount) FROM opgos O
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE yearlabel = '2023-24' AND A.actype = 'C';
SELECT SUM(Amount) FROM Zopgos O
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE yearlabel = '2023-24' AND A.actype = 'C';

SELECT SUM(IIF(O.drcr = 'D', amount * -1, amount)) FROM opgos O
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE yearlabel = '2023-24' AND A.actype = 'S';
SELECT SUM(IIF(O.drcr = 'D', amount * -1, amount)) FROM Zopgos O
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE yearlabel = '2023-24' AND A.actype = 'S';


SELECT O.* FROM Zopgos Z
LEFT JOIN opgos O ON Z.refdoc + Z.refno + Z.refdate + Z.mainac + Z.subac + Z.drcr = 
O.refdoc + O.refno + O.refdate + O.mainac + O.subac + O.drcr
AND Z.amount = O.Amount
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE O.yearlabel = '2023-24' AND O.id IS NULL  AND A.actype = 'C'


SELECT O.* FROM Zopgos Z
LEFT JOIN opgos O ON Z.refdoc + Z.refno + Z.refdate + Z.mainac + Z.subac + Z.drcr = 
O.refdoc + O.refno + O.refdate + O.mainac + O.subac + O.drcr
AND Z.amount = O.Amount
LEFT JOIN Accounts A ON O.mainac = A.mainac
WHERE O.yearlabel = '2023-24' AND O.id IS NULL  AND A.actype = 'S'

DROP DATABASE demo
-- UPDATE IncentivePerc SET Perc = 12 WHERE id IN (2, 4,6,7)
SELECT * FROM paydatesmst

UPDATE paydatesmst SET status = 'C' WHERE [paydate] = '30-Apr-25'

SELECT * INTO Zpaymst FROM Paymst WHERE paydate = '30-Apr-25'
SELECT * INTO Zsalary FROM salary WHERE paydate = '30-Apr-25'
SELECT * INTO ZworkdetailMst FROM workdetailMst WHERE paydate = '30-Apr-25'
SELECT * INTO Zbonus_Exgratia FROM bonus_Exgratia WHERE paydate = '30-Apr-25'

DROP TABLE Zpaymst
DROP TABLE Zsalary
DROP TABLE ZworkdetailMst
DROP TABLE Zbonus_Exgratia

SELECT * FROM incentiveheads

SELECT COUNT(*) AS Cnt FROM Paymst WHERE paydate = '30-Apr-25'
SELECT COUNT(*) AS Cnt FROM ZPaymst WHERE paydate = '30-Apr-25'
SELECT SUM(Amount) FROM Paymst WHERE paydate = '30-Apr-25'
SELECT SUM(Amount) FROM ZPaymst WHERE paydate = '30-Apr-25'

SELECT COUNT(*) AS Cnt FROM salary WHERE paydate = '30-Apr-25'
SELECT COUNT(*) AS Cnt FROM Zsalary WHERE paydate = '30-Apr-25'
SELECT SUM(Amount) FROM salary WHERE paydate = '30-Apr-25'
SELECT SUM(Amount) FROM Zsalary WHERE paydate = '30-Apr-25'

SELECT * FROM bonus_exgratia ORDER BY paydate DESC

SELECT SUM(Amount) FROM bonus_exgratia WHERE paydate = '30-Apr-25'
SELECT SUM(Amount) FROM zbonus_exgratia WHERE paydate = '30-Apr-25'

SELECT COUNT(*) AS Cnt FROM workdetailMst WHERE paydate = '30-Apr-25'
SELECT COUNT(*) AS Cnt FROM ZworkdetailMst WHERE paydate = '30-Apr-25'

SELECT SUM(hours), SUM(mts), SUM(days) ,SUM(Othours), SUM(Otmts) ,SUM(Latemts) , SUM(latededuction)   FROM workdetailMst WHERE paydate = '30-Apr-25'
SELECT SUM(hours), SUM(mts), SUM(days) ,SUM(Othours), SUM(Otmts) ,SUM(Latemts) , SUM(latededuction)   FROM zworkdetailMst WHERE paydate = '30-Apr-25'


SELECT P.* FROM ZPaymst Z
LEFT JOIN Paymst P ON 
Z.employeecode + Z.payheadcode + Z.paybasiscode = P.employeecode + P.payheadcode + P.paybasiscode
AND Z.paydate = P.paydate
AND Z.amount = P.Amount
WHERE Z.paydate = '30-Apr-25' AND P.id IS NULL

SELECT S.* FROM Zsalary Z
LEFT JOIN salary S ON Z.employeecode + Z.payheadcode = S.employeecode  + S.payheadcode
AND Z.amount = S.Amount
WHERE Z.paydate = '30-Apr-25' AND S.id IS NULL

SELECT  Z.* FROM ZworkdetailMst  Z
LEFT JOIN workdetailMst W ON 
Z.employeecode + Z.worktypecode = W.employeecode + W.worktypecode
AND Z.paydate = W.Paydate 
WHERE Z.paydate = '30-Apr-25' AND W.id IS NULL



SELECT S.* FROM salary S
LEFT JOIN Zsalary Z ON S.employeecode + S.payheadcode = Z.employeecode  + Z.payheadcode
AND S.amount = Z.Amount
WHERE S.paydate = '30-Apr-25' AND Z.id IS NULL

SELECT * FROM Payheadmst WHERE headcode = '032'--
SELECT * FROM Payheadmst WHERE headcode = '031'--
SELECT * FROM Payheadmst WHERE [sysname] = 'OT'--

UPDATE Payheadmst SET IsActive = 'Y' WHERE headcode IN ('032','031')

SELECT name AS DatabaseName, compatibility_level
FROM sys.databases
WHERE name = 'demo';


ALTER DATABASE demo
SET COMPATIBILITY_LEVEL = 110;

 
ADDL_PAY  

SELECT * FROM PtaxSlab
SELECT * FROM Ptaxslabmst
SELECT * FROM IncentivePerc


DROP DATABASE demo




SELECT * FROM Cheqpos1 WHERE labelname = 'Date_Box_Top_Padding'


SELECT * FROM shifthrs
SELECT * FROM company

SELECT DATEADD(DAY, 1, EOMONTH('30-Apr-25', -12)) AS BonusStartDate


SELECT * FROM sysparameters WHERE shortname = 'RelaxThirtyDaysRule'

SELECT * FROM salary WHERE paydate = '30-Apr-25'
SELECT * FROM workdetailMst WHERE paydate = '30-Apr-25' AND employeecode = '000001'
SELECT * FROM Paymst WHERE paydate = '30-Apr-25' AND employeecode = '000001'
UPDATE Paymst SET paybasiscode = '5' WHERE employeecode = '000001' AND  paydate = '30-Apr-25'

SELECT * FROM Paybasismst
 

UPDATE AuditTrailMetaData SET ind = 'MJ' WHERE tableName = 'journalvoucher'
UPDATE AuditTrailMetaData SET ind = 'LJ' WHERE tableName = 'journalvoucher1'

DELETE FROM audittrailmetadata WHERE tablename IN ('bill', 'bill1', 'bill2')

INSERT INTO audittrailmetadata (tableName, propertyname, displayname, ind, internalcolumn) VALUES
('bill', 'dated', 'Bill Date', 'MB', 'dated'),
('bill', 'partyid', 'Party Id', 'MB', 'partyid'),
('bill', 'supplierbillno', 'Ref No', 'MB', 'refno'),
('bill', 'supplierbilldate', 'Ref Date', 'MB', 'refdate'),
('bill', 'billamount', 'Bill Amount', 'MB', 'value'),
('bill', 'cgstamount', 'CGST Amount', 'MB', 'exciseamt'),
('bill', 'sgstamount', 'SGST Amount', 'MB', 'stax1amt'),
('bill', 'igstamount', 'IGST Amount', 'MB', 'stax2amt'),
('bill', 'freightamount', 'Freight Amount', 'MB', 'freight'),
('bill', 'tcsamount', 'TCS Amount', 'MB', 'cess2'),
('bill', 'supplierbillamount', 'Supplier Bill Value', 'MB', 'sbvalue'),
('bill', 'tdscode', 'TDS Code', 'MB', 'TDSCode'),
('bill', 'tdsamount', 'TDS Amount', 'MB', 'tdsamount'),
('bill', 'branchid', 'Branch Id', 'MB', 'branchid'),
('bill1', 'trntypecode', 'TRN Type Code', 'MB', 'trntype'),
('bill1', 'inputtaxcredit', 'Input Tax credit', 'MB', 'itctype'),
('bill2', 'itemid', 'ItemId', 'LB', 'itemid'),
('bill2', 'qty', 'Quantity', 'LB', 'Qty'),
('bill2', 'rate', 'Rate', 'LB', 'rate'),
('bill2', 'Amount', 'Amount', 'LB', 'value'),
('bill2', 'mainacnamecode', 'Main Ac Code', 'LB', 'mainac'),
('bill2', 'subacnamecode', 'Sub Ac Code', 'LB', 'subac'),
('bill2', 'taxableamount', 'Taxable Amount', 'LB', 'taxablevalue'),
('bill2', 'gstcode', 'GST Code', 'LB', 'gstcode'),
('bill', 'computedtdson', 'Compute TDS On', 'MB', 'applytdson');

CREATE TABLE dash.DashboardGrn (
    Id INT IDENTITY(1,1) PRIMARY KEY,
    grnno NVARCHAR(6),
    grndate DATETIME,
    UnitCodeName NVARCHAR(50),
    partyshortname NVARCHAR(50),
    partyname NVARCHAR(75),
    itemgroupname NVARCHAR(50),
    itemid NVARCHAR(6),
    itemshortname NVARCHAR(100),
    itemname NVARCHAR(150),
    pendingqty NUMERIC(13,3),
    indentrate NUMERIC(12,4),
    gstratename NVARCHAR(30),
    indentno NVARCHAR(6),
    indentdate DATETIME,
    challanno NVARCHAR(20),
    challandate DATETIME,
    grnnotes NVARCHAR(200),
    storename NVARCHAR(200),
    grnqty NUMERIC(13,3),
    partygroupname NVARCHAR(50),
    BillNo NVARCHAR(6),
    BillDate DATETIME,
    amount NUMERIC(15,2)
);
 
CREATE TABLE dash.DashboardArap (
    araptype NVARCHAR(1),
    partyshortname NVARCHAR(50),
    partyname NVARCHAR(75),
    doctype NVARCHAR(2),
    refdoc NVARCHAR(2),
    refno NVARCHAR(6),
    refdate DATETIME,
    docno NVARCHAR(6),
    docdate DATETIME,
    amount NUMERIC(14,2),
    netamount NUMERIC(18,2),
    gstamount NUMERIC(18,2),
    duedate DATETIME,
    aging INT,
    partyid NVARCHAR(6),
    unitname NVARCHAR(20),
    creditdays INT,
    paymenttermname NVARCHAR(75),
    SalesmenName NVARCHAR(50),
    partyregionname NVARCHAR(50),
    collectionstatusname NVARCHAR(50),
    supplierbillno NVARCHAR(20),
    supplierbilldate DATETIME,
    isauth NVARCHAR(100),
    msmeno NVARCHAR(15),
    Gstr2bdate DATETIME,
    partybranchname NVARCHAR(50),
    fcnramount NUMERIC(11,2),
    notes NVARCHAR(100),
    controlaccode NVARCHAR(6),
    partygroupname NVARCHAR(50)
);


--DROP USER DashReadUser;
-----------------
--DROP LOGIN DashReadUser;


-------------Creating  new Login
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = 'DashReadUser')
BEGIN
    CREATE LOGIN DashReadUser WITH PASSWORD = 'StrongPassword@123';
END

-----------Creating a new user in client db
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = 'DashReadUser')
BEGIN
    CREATE USER DashReadUser FOR LOGIN DashReadUser;
END

---------Grant Only SELECT Operation to user 
GRANT SELECT ON SCHEMA::dash TO DashReadUser;


-- SELECT TABLE_SCHEMA, TABLE_NAME 
-- FROM INFORMATION_SCHEMA.TABLES 
-- WHERE TABLE_SCHEMA = 'dash';

ALTER TABLE stdinstructions ADD  DoctypeZ NVARCHAR(1)

UPDATE stdinstructions SET doctypez = doctype
UPDATE stdinstructions SET doctype = doctypez

UPDATE stdinstructions SET doctype = '0'

----------Invoice
SELECT E.yearinvoiceno, I.id, I.invoiceno, I.subno AS invoicesubno,
        I.partyid, I.branchid, I.Unitcode,I1.IsSpecialHeader
        FROM EInvoiceSuccess E
        LEFT JOIN Invoice1 I1 ON E.yearinvoiceno = I1.yearinvoiceno
        LEFT JOIN Invoice I ON I1.yearinvoiceno = I.yearinvoiceno
        WHERE I1.iseinvoice = 'Y' AND I1.iscancelled = 'N'
        AND CONVERT(DATE, AckDate) IN ('21-Nov-25') AND partyid + Branchid IN (SELECT partyid+Branchid FROM contacts WHERE typeofcontact = 'M')
----------Indent
        SELECT Id, IndentNo, PartyId, BranchId,UnitCode, I.dated FROM indent I
        WHERE CONVERT(DATE, Dated) = '21-Nov-25' AND 
        IsAuth = 'Y'  AND partyid + Branchid IN (SELECT partyid+Branchid FROM contacts WHERE typeofcontact IN ('M','I'))
        ORDER BY dated DESC
----------Order
        SELECT Id, orderno, PartyId, BranchId, yearorderno, Unitcode, dated
        FROM Orders
        WHERE CONVERT(DATE, Dated) = CONVERT(DATE,GETDATE())  AND
         IsConfirmedOrder = 'Y' AND 
        EXISTS (SELECT yearorderno FROM Orders1 WHERE Orders.yearorderno = Orders1.yearorderno)
        AND partyid + Branchid IN (SELECT partyid+Branchid FROM contacts WHERE typeofcontact IN ('M','O'))
        ORDER BY dated DESC
---------Voucher Payment
        SELECT V.id, N.Yearvoucherno, V.voucherno,
        V.divisionid AS Divisioncode, V.bankcode, V.currency
        FROM NEFTPayLog N 
        LEFT JOIN Voucher V ON N.yearvoucherno = V.yearvoucherno
        WHERE CONVERT(DATE, N.dated) = CONVERT(DATE, GETDATE()) AND V.divisionid = '00'
--------Voucher Receipt
SELECT DISTINCT V.id, V.Yearvoucherno, V.voucherno,V.bankcode,
        V.divisionid AS Divisioncode, V.currency, V.dated
        FROM Voucher1 V1
        LEFT JOIN Voucher V ON V1.yearvoucherno = V.yearvoucherno
        WHERE --CONVERT(DATE, V.dated) = CONVERT(DATE, GETDATE()) AND 
        vouchertype = 'R' 
        AND V1.amount != 0
        AND refdoc IN ('SI', 'OA')
        AND divisionid = '00'
        ORDER BY dated DESC

        UPDATE indent SET dated = '21-Nov-25' WHERE  dated > '26-Jun-25'
        UPDATE Orders SET dated = '21-Nov-25' WHERE  dated > '30-Jun-25'
        UPDATE NEFTPayLog SET Dated = '21-Nov-25'
        UPDATE voucher SET Dated = '21-Nov-25' WHERE dated >  '01-Jul-25'
        
        UPDATE EInvoiceSuccess SET AckDate = '21-Nov-25' WHERE yearinvoiceno IN (
            SELECT E.yearinvoiceno
        FROM EInvoiceSuccess E
        LEFT JOIN Invoice1 I1 ON E.yearinvoiceno = I1.yearinvoiceno
        LEFT JOIN Invoice I ON I1.yearinvoiceno = I.yearinvoiceno
        WHERE I1.iseinvoice = 'Y' AND I1.iscancelled = 'N'
        AND CONVERT(DATE, AckDate) > '01-Jul-25'AND partyid + Branchid IN (SELECT partyid+Branchid FROM contacts WHERE typeofcontact = 'M')
        )

        UPDATE indent SET UnitCode = '06' WHERE yearindentno = '202526000114'
        UPDATE indent SET UnitCode = '06' WHERE yearindentno = '202526000115'
        UPDATE indent SET UnitCode = '04' WHERE yearindentno = '202526000116'


        UPDATE Orders SET UnitCode = '04' WHERE yearorderno = '202526000302'
        UPDATE Orders SET UnitCode = '06' WHERE yearorderno = '202526000303'
        UPDATE Orders SET UnitCode = '07' WHERE yearorderno = '202526000307'

        -- UPDATE contacts SET email1 = 'sharmili@erpcrystal.in', email2 = '', email3 = '', email4 = ''

    

        UPDATE invoice1 SET IsSpecialHeader = 'Y' WHERE  yearinvoiceno = '202526000389'
        UPDATE invoice SET Unitcode = '01' WHERE  yearinvoiceno = '202526000389'

          UPDATE invoice1 SET IsSpecialHeader = 'Y' WHERE  yearinvoiceno = '202526000390'
        UPDATE invoice SET Unitcode = '05' WHERE  yearinvoiceno = '202526000390'
        
        UPDATE invoice SET Unitcode = '01' WHERE  yearinvoiceno = '202526000397'

        SELECT * FROM ErpCrystalMfg..ScheduledTasks
        SELECT * FROM ErpCrystalMfg..TaskList

        UPDATE ErpCrystalMfg..ScheduledTasks SET CronExpression = '25 11 * * *' WHERE taskcode = '002'--Invoice
        UPDATE ErpCrystalMfg..ScheduledTasks SET CronExpression = '46 10 * * *' WHERE taskcode = '001'--Indent
        UPDATE ErpCrystalMfg..ScheduledTasks SET CronExpression = '46 10 * * *' WHERE taskcode = '003'--Orders

        UPDATE ErpCrystalMfg..ScheduledTasks SET CronExpression = '46 10 * * *' WHERE taskcode = '005'--voucher payment
        UPDATE ErpCrystalMfg..ScheduledTasks SET CronExpression = '46 10 * * *' WHERE taskcode = '006' --voucher receipt


SELECT * FROM EInvoiceSuccess ORDER BY AckDate DESC

UPDATE company1 SET Isactive = 'Y'



SELECT * FROM headerfooterexist WHERE headerfootercode IN ('001','002')

SELECT * FROM headerfooterexist WHERE headerfootercode IN ('007','008')
SELECT * FROM headerfooterexist WHERE headerfootercode IN ('020')

DELETE FROM headerfooterexist WHERE headerfootercode = '020'

SELECT * FROM headerfooterlist

TRUNCATE TABLE headerfooterexist

INSERT INTO HeaderFooterExist (HeaderFooterCode, FileSuffix) VALUES('001','_05_Special')
INSERT INTO HeaderFooterExist (HeaderFooterCode, FileSuffix) VALUES('001','_Special')
INSERT INTO HeaderFooterExist (HeaderFooterCode, FileSuffix) VALUES('002','_05_Special')
INSERT INTO HeaderFooterExist (HeaderFooterCode, FileSuffix) VALUES('002','_Special')