Module Codes in ice.Menu

Epicor ERP 10
,
1

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!

2

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

3

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
4

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
5

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
3 Likes