Module Codes in ice.Menu

,

Does anyone know what the codes listed in ice.Menu.Module mean? I’m trying to produce a list of the menus only for the modules we are licenced. I’m doing this manually at the moment, but I’d love to figure out a way to cross reference this to ice.EnabledModule. Unfortunately, Data Dictionary wasn’t any help.

I’m open to better ideas if anyone has them!

Thanks for the help!

FWIW - The modules list in EAC in 10.2.300, has 168 rows. There are only 67 distinct values for Menu.Modules.

You might have a better chance of matching up the Menu.Module values with something from the Epicor sales docs

1 Like

I wish… please let us know if you ever figure it out.

BTW… “SheMunkee” is one of the best screen names I can recall seeing. Great job!

1 Like

I was having the same trouble–not having a list of what menu items are actually available to me, so I made a spreadsheet. It uses the “Module” field in the menus table to filter based on what modules are licensed.

Menus Workbook.xlsx (632.3 KB)

Notes on using it:

  • I am using 10.2.600, so the menu items could be different in your version
  • Download the menu items using a BAQ on Ice.Menu and paste into “Menu Detail” sheet (be careful to preserve the order of columns and the formulas in the last four columns)
  • Download the licensed modules using “copy all include labels” in the Company Configuration license tracker and paste into the “Modules” sheet (being careful to preserve the Module ID, which is hand-entered)
  • Sort the menu detail items based on the calculated “Hierarchy Code”
  • The grouping on “Menu Licd” was done by hand, but it wouldn’t be hard to create a macro to do it more efficiently

The “Menu Licd” sheet constructs the menu, in order, based on what modules you have licensed. It’s about 90% accurate, and for greater accuracy, you’ll have to go through menu by menu, line by line, and check it, manually showing or hiding items using the right-most column on the Menu Detail sheet. I had to hide a bunch of location-specific screens that are technically licensed but don’t apply to us here in Canada.

4 Likes

Thank you James.
I used what James had developed and mapped out the list of Licensed Modules Names to the related ModuleID value from the Ice.Menu table. I then created a User Code Type of License and set up the list below. This way I can use it in BAQs and External Audit reporting to show only the menu items licensed. Queries need to also account for the CGCCode in Ice.Menu to include/exclude country specific functionality.

CodeID IsActive CodeDesc LongDesc
AP TRUE AccountsPayable AccountsPayable
AR TRUE AccountsReceivable AccountsReceivable
BP TRUE BusinessProcessManagement BusinessProcessManagement
DA TRUE DynamicAttributes DynamicAttributes
DE TRUE Data Exchange Server Data Exchange Server
EQ TRUE EstimateQuoteManagement EstimateQuoteManagement
EQA TRUE EnhancedQualityAssurance EnhancedQualityAssurance
ES TRUE Scheduling Scheduling
GL TRUE GeneralLedger GeneralLedger
IM TRUE InventoryManagement InventoryManagement
JC TRUE Job Management Job Management
MM TRUE MaintenanceManagement MaintenanceManagement
MP TRUE MultiSitePublish MultiSitePublish
MR TRUE MaterialRequirementsPlanning MaterialRequirementsPlanning
MS TRUE MultiSiteGLJournals MultiSiteGLJournals
OM TRUE OrderManagement OrderManagement
PJ TRUE ProjectManagement ProjectManagement
PM TRUE PurchaseManagement PurchaseManagement
PS TRUE AdvancedPlanningAndScheduling AdvancedPlanningAndScheduling
QA TRUE QualityAssurance QualityAssurance
RQ TRUE SupplierRelationshipManagement SupplierRelationshipManagement
SE TRUE SingleLevelEngineering SingleLevelEngineering
SR TRUE ShippingReceiving ShippingReceiving
SU TRUE System Utilities System Utilities
SV TRUE ShopVision ShopVision
UD TRUE User Defined User Defined
XA TRUE ExecutiveDashboard ExecutiveDashboard
XS TRUE System Menu System Menu
5 Likes

ECB Epicor Collaborate

Anyone know what module ‘BM’ is? There is a single system menu item in the menu table referencing it (BMMN3090) which appears to be a duplicate of SEMN3000 (Mfg Lead Time Calculation)?

Never mind, I had a go at working it out for the codes not listed in the table above.

Module Name Module
AdvancedAllocations AA
ActualCosting ACT
AdvancedEstimatingAndPricing AEP
AdvancedMaterialManagement AM
APMICRChecks AMC
AccountsPayable AP
APPositivePay APP
AccountsReceivable AR
ARLockbox ARL
PackOutManagement AS
AdvancedUnitOfMeasure AUM
BusinessProcessManagement BP
CreditCardProcessing CD
MultiCurrencyManagement CM
CustomerRelationshipManagement CR
ContractRenewal CRL
DynamicAttributes DA
DynamicDocuments DD
Data Exchange Server DE
LocationManagement DNM
DeferredRevenue DRV
EpicorElectronicReports EC
EpicorCollaborate ECB
ExpenseManagement EM
ExternalPayrollIntegration EPI
EstimateQuoteManagement EQ
EnhancedQualityAssurance EQA
Scheduling ES
AssetManagement FA
IntegratedFieldService FS
FieldServiceManagement FSM
GeneralLedger GL
CaseManagement HD
Handheld HH
InventoryManagement IM
EpicorIoTConnector IOT
JobManagement JC
LandedCostContainerTracking LC
MaintenanceManagement MM
MultiSitePublish MP
MaterialRequirementsPlanning MR
MultiSiteGLJournals MS
OrderManagement OM
ProjectBilling PB
AdvancedConfigurator PC
PurchaseContracts PH
PaymentInstruments PI
ProjectManagement PJ
AdvancedPackageControl PKG
PurchaseManagement PM
Payroll PR
AdvancedPlanningAndScheduling PS
PettyCash PYC
QualityAssurance QA
RebatesPromotionsAndRoyalties RP
RecipeAuthoring RPA
SupplierRelationshipManagement RQ
ICESDK SDK
SingleLevelEngineering SE
EpicorCommerceConnectCustomer SI
ShippingReceiving SR
EdiDemandManagement SS
VisionEpicorFinancials SV
AvalaraSalesTaxForGenericImportProcess TCU
TimeManagement TM
RohsWeeeManagement WE
ExecutiveDashboard XA

These ones I’m not sure about:

Module Name Module
SU System Utilities
BM (?) Bill of Material Management (?)
MFS (?) (mis-keyed?) Field Service Asset Management (?)
PZ (?) CnvProgs Maintenance (?)

These modules must therefore not have codes in the Menu table. (Unless they have the same codes as those already assigned. I’ve assumed (rightly or wrongly) a one-to-one relationship between the module code and the licenced module.

EnterpriseSearchPremium
EnterpriseSocialPremium
EpicorEverywhereFramework
MultiTenant
GlobalUsers
SdkRuntime
VerticalizationCreator
Productization
DocumentManagement
EducationERPStandardAndEnterprise
EducationSLS
EducationExpress
MultiSiteManagement
ConsolidatedPayment
ConsolidatedPurchasing
AttachmentsForSharePoint
AdvancePrinting
AdvancePrintArchiving
DataManagementTool
KineticPreview
ADPPayrollIntegration
AdvancedCostManagement
AdvancedInventoryManagement
AdvancedProduction
AdvancedPurchasing
AutoLabelPrintControl
ChannelPartner
Configurator
ConsumerConfigurator
CustomerConfigurator
CustomerConnectStoreFront
CustomerManagedInventory
DealerNetworkManagement
EdiVantage80x
Engineering
EpicorCommerceConnectConsumer
EpicorCommerceConnectSupplier
ExpressShip
ExternalCRMIntegration
FSMIntegration
MESDataCollection
MobileConnectAndroid
MobileConnectiOS
MobileFieldService
MultiLevelEngineering
MultiLevelJob
MultiLevelQuote
MultipleBooks
MultipleDivision
MultipleWarehouse
MultisiteFinancials
PeriodicAverageCosting
PlanningByRevision
ReplicationServer
SlsAssessmentsAndFormsDesigner
SlsClinicalCare
SlsCommunityServices
SlsICareIntegration
SlsOnlineClaimingForResidentialManagement
SlsOutboundEdiInterface
SlsResidentialManagement
SupplierManagedInventory
Surveys
TaxConnectST
TaxConnectUT
ThirdPartyWMSIntegration
FoodBeverage
Pharma
Epicor Everywhere Framework Users
Enterprise
Education
Communication Channel: HTTP
REST Operations Support
iScala Business Object Model Version
Workflow Element: Condition
Windows Workflow Foundation Runtime
Workflow Element: Break
Workflow Element: Poster
Communication Channel: Windows Service Bus
Visual Email Builder
Epicor Service Connect Standalone
Workflow Element: REST Operation
Workflow Element: Manager
Workflow Element: Finish
Workflow Element: Choice
Workflow Element: Connector
Workflow Designer Users
Workflow Element: .NET Call
Workflow Element: Requester
Workflow Element: Workflow Foundation Integration
Workflow Element: Conversion
Communication Channel: Sonic MQ Series
Workflow Element: DB Operation
Web Services Support
Workflow Element: Splitter
WCF Integration
Workflow Element: Start
Workflow Element: Workflow Call
Web-based Task Monitor
Workflow Element: Web Method
iScala Admin Console
Unlimited Number of companies
Unicode
Multiple server support
English (UK)
Communication Channel: FTP
Communication Channel: MSMQ
Communication Channel: COM
Communication Channel: File
Communication Channel: IBM MQ Series
Communication Channel: SMTP
Multiple Installation Support
Any Database Server
Workflow Editor
Workflow Element: Task
.NET References Support
Integrated Workflow Designer
EPT for Accounts Receivable - US ACH
EPT for Accounts Payable - US ACH
Epicor Data Discovery Basic
Communication Channel: RabbitMQ
MICR Checks
TaxConnect

2 Likes

Just found out that Epicor actually has a reference in its help now. While the above is helpful, I needed official documentation.

In the help, search for Kinetic Modules Overview.

3 Likes

Excellent. Exactly what I needed. Thanks, John. Thanks, Epicor.