常见问答---科目余额表、明细分类账、核算项目余额表的精简版菜单怎么显示出来

栏目：eas cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

通过查询分析器执行以下脚本，重登客户端即可显示：

-- 科目余额表(精简)

if not exists (select * from t_bas_sysmenuitem where FNumber = '90NBalanceListReport')

insert into t_bas_sysmenuitem(FID, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FName_L1, FName_L2, FName_L3, FNumber, FDescription_L1, FDescription_L2, FDescription_L3, FSimpleName, FIsLeaf, FLevel, FLongNumber, FDisplayName_L1, FDisplayName_L2, FDisplayName_L3, FOrder, FImagePath, FVisible, FEnabled, FUiOprt, FOpenMethod, FShortcutCode, FIsReport, FParent, FFunction, FIndustry, FNoSuit, FMenutype, FUiClassName, FUiClassParam)

values

('5U8j0HZ7Tlai6kne7J6VExdCz6U=', '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-000000000000CCE7AED4', null, N'科目余额表(精简)', N'科目餘額表(精簡)', N'90NBalanceListReport', null, null, null, null, 1, 4, N'10FinancialAccounting!0GeneralLedger!6AccountReport!90NBalanceListReport', null, N'财务会计_总账_统计报表_科目余额表(精简)', N'財務會計_總賬_統計報表_科目餘額表(精簡)', N'255', N'imgFunction_statements', 1, 1, N'', 0, N'GLN0501', 0, 'b1ddb558-00fd-1000-e000-0ac3c0a8100dFD37DC9F', 'bc5a6ec6-00fd-1000-e000-0003c0a81268PERMITEM', 0, null, 10, 'com.kingdee.eas.fi.gl.rpt.client.GLNRptAccountBalanceUI', null);

if not exists (select * from t_pm_mainmenuitem where FNumber = '90NBalanceListReport')

insert into t_pm_mainmenuitem(FID, FName_L1, FName_L2, FName_L3, FNumber, FDescription_L1, FDescription_L2, FDescription_L3, FSimpleName, FIsLeaf, FLevel, FLongNumber, FOrder, FImagePath, FVisible, FEnabled, FUiOprt, FOpenMethod, FShortcutCode, FIsReport, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FParent, FFunction, FControlUnitID, FDisplayName_L1, FDisplayName_L2, FDisplayName_L3, FSysMenuID, FIsModified, FIndustry, FNoSuit, FMenutype, FUiClassName, FUiClassParam, fpinyin, fshortpinyin)

values

('5U8j0HZ7Tlai6kne7J6VExdCz6U=', null, N'科目余额表(精简)', N'科目餘額表(精簡)', N'90NBalanceListReport', null, null, null, null, 1, 4, N'10FinancialAccounting!0GeneralLedger!6AccountReport!90NBalanceListReport', N'255', N'imgFunction_statements', 1, 1, N'', 0, N'GLN0501', 0, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, 'b1ddb558-00fd-1000-e000-0ac3c0a8100dFD37DC9F', 'bc5a6ec6-00fd-1000-e000-0003c0a81268PERMITEM', '00000000-0000-0000-0000-000000000000CCE7AED4', null, N'财务会计_总账_统计报表_科目余额表(精简)', N'財務會計_總賬_統計報表_科目餘額表(精簡)', '5U8j0HZ7Tlai6kne7J6VExdCz6U=', 0, 0, null, 10, 'com.kingdee.eas.fi.gl.rpt.client.GLNRptAccountBalanceUI', null, null, null);

--明细分类账(精简)

if not exists (select * from t_bas_sysmenuitem where FNumber = '91NSubLedgerReport')

values

('S7lVi/aqQBGpyW26Ji+9RhdCz6U=', '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-000000000000CCE7AED4', null, N'明细分类账(精简)', N'明細分類賬(精簡)', N'91NSubLedgerReport', null, null, null, null, 1, 4, N'10FinancialAccounting!0GeneralLedger!5AccountLedgerAndReport!91NSubLedgerReport', null, N'财务会计_总账_账簿查询_明细分类账(精简)', N'財務會計_總賬_賬簿查詢_明細分類賬(精簡)', N'255', N'imgFunction_statements', 1, 1, N'', 0, N'GLN0402', 0, '044558de-79fa-4e27-ae6b-a7fe4231ee21FD37DC9F', 'bc5a6ec6-00fd-1000-e000-0001c0a81268PERMITEM', 0, null, 10, 'com.kingdee.eas.fi.gl.rpt.client.GLNRptSubLedgerUI', null);

if not exists (select * from t_pm_mainmenuitem where FNumber = '91NSubLedgerReport')

values

('S7lVi/aqQBGpyW26Ji+9RhdCz6U=', null, N'明细分类账(精简)', N'明細分類賬(精簡)', N'91NSubLedgerReport', null, null, null, null, 1, 4, N'10FinancialAccounting!0GeneralLedger!5AccountLedgerAndReport!91NSubLedgerReport', N'255', N'imgFunction_statements', 1, 1, N'', 0, N'GLN0402', 0, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '044558de-79fa-4e27-ae6b-a7fe4231ee21FD37DC9F', 'bc5a6ec6-00fd-1000-e000-0001c0a81268PERMITEM', '00000000-0000-0000-0000-000000000000CCE7AED4', null, N'财务会计_总账_账簿查询_明细分类账(精简)', N'財務會計_總賬_賬簿查詢_明細分類賬(精簡)', 'S7lVi/aqQBGpyW26Ji+9RhdCz6U=', 0, 0, null, 10, 'com.kingdee.eas.fi.gl.rpt.client.GLNRptSubLedgerUI', null, null, null);

--核算项目余额表(精简)

if not exists (select * from t_bas_sysmenuitem where FNumber = '94NRptAsstactXBalanceUI')

values

('jFJHldS1R2KX1lWowSFdnxdCz6U=', '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-000000000000CCE7AED4', null, N'核算项目余额表(精简)', N'核算項目餘額表(精簡)', N'94NRptAsstactXBalanceUI', null, null, null, null, 1, 4, N'10FinancialAccounting!0GeneralLedger!6AccountReport!94NRptAsstactXBalanceUI', null, N'财务会计_总账_统计报表_核算项目余额表(精简)', N'財務會計_總賬_統計報表_核算項目餘額表(精簡)', N'255', N'imgFunction_statements', 1, 1, N'', 0, N'GLN0505', 0, 'b1ddb558-00fd-1000-e000-0ac3c0a8100dFD37DC9F', 'd5fe72b6-0108-1000-e000-001dc0a8128ePERMITEM', 0, null, 10, 'com.kingdee.eas.fi.gl.rpt.client.GLNRptAsstActBalanceUI', null);

if not exists (select * from t_pm_mainmenuitem where FNumber = '94NRptAsstactXBalanceUI')

values

('jFJHldS1R2KX1lWowSFdnxdCz6U=', null, N'核算项目余额表(精简)', N'核算項目餘額表(精簡)', N'94NRptAsstactXBalanceUI', null, null, null, null, 1, 4, N'10FinancialAccounting!0GeneralLedger!6AccountReport!94NRptAsstactXBalanceUI', N'255', N'imgFunction_statements', 1, 1, N'', 0, N'GLN0505', 0, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2022-10-10 14:34:52'}, 'b1ddb558-00fd-1000-e000-0ac3c0a8100dFD37DC9F', 'd5fe72b6-0108-1000-e000-001dc0a8128ePERMITEM', '00000000-0000-0000-0000-000000000000CCE7AED4', null, N'财务会计_总账_统计报表_核算项目余额表(精简)', N'財務會計_總賬_統計報表_核算項目餘額表(精簡)', 'jFJHldS1R2KX1lWowSFdnxdCz6U=', 0, 0, null, 10, 'com.kingdee.eas.fi.gl.rpt.client.GLNRptAsstActBalanceUI', null, null, null);