-- Adds the missing InterestPercent field to the Profit & Loss Dashboard's field catalog
-- (REPORTID -1399900900, "/AccountReports/AccountProfitLossDashboardReport") — every other
-- waterfall measure (COGS, GrossMargin, OtherIncome, GPAndOtherIncome, OperatingExpenses, EBITDA,
-- Depreciation, EBIT, NetProfit) already has a "*Percent" sibling row; Interest was the one
-- measure missing it, even though AccountProfitLossDashboardQB/DTO now compute and expose it.
--
-- Confirmed live before writing: REPORTVSFIELDSID -1399801101 is unused. IncomeTax/NetProfit/
-- NetProfitPercent (SLNO/DISPLAYSLNO 23/24/25) are shifted up by 1 to make room for
-- InterestPercent at 23, keeping it adjacent to Interest (SLNO 22) — matching every other
-- measure/percent pair's adjacent placement in this same catalog.
--
-- Deliberately NOT added to MREPORTVIEWFIELDS (the Profit and Loss Dashboard view's own display
-- field list, REPORTVIEWID 1000000700): confirmed live that view already excludes every
-- intermediate "*Percent" field (COGSPercent, GrossMarginPercent, etc.) from its 13 display
-- fields, showing only NetProfitPercent as a final summary — InterestPercent stays consistent
-- with that established pattern, available via the API/JSON DTO but not added as a new export
-- column.

UPDATE MREPORTVSFIELDS SET SLNO = 24, DISPLAYSLNO = 24
WHERE REPORTVSFIELDSID = -1399801078 AND REPORTID = -1399900900; -- IncomeTax

UPDATE MREPORTVSFIELDS SET SLNO = 25, DISPLAYSLNO = 25
WHERE REPORTVSFIELDSID = -1399801077 AND REPORTID = -1399900900; -- NetProfit

UPDATE MREPORTVSFIELDS SET SLNO = 26, DISPLAYSLNO = 26
WHERE REPORTVSFIELDSID = -1399801076 AND REPORTID = -1399900900; -- NetProfitPercent

INSERT INTO MREPORTVSFIELDS
    (REPORTVSFIELDSID, REPORTID, SLNO, FIELDNAME, FIELDTITLE, FIELDTYPE, FIELDWIDTH,
     ISDISPLAY, ISMERGECOLUMN, ISGROUPCOLUMN, ISSUBTOTAL, ISGRANDTOTAL, CALFORMAT,
     DISPLAYSLNO, ALIGNMENT, SOURCETYPE, OBJECTFIELDTYPE, DIMENSIONFIELDID)
VALUES
    (-1399801101, -1399900900, 23, 'InterestPercent', 'Interest %', 6, NULL,
     NULL, NULL, NULL, NULL, NULL, NULL,
     23, 2, 5, 1, -1);
GO