# QAD Menu Program Reference Template > Source: https://netray.co/tools/qad-menu-program-reference-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable QAD menu and program reference you fill in once and export to Excel, with usage and risk columns for training, access reviews and migration planning. ## Category other-erp ## Erp QAD ## Audience - QAD administrator - Super user - Auditor - Trainer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Program **Key:** program **Type:** text **Help:** The executable name shown in the program field, for example sosomt.p. #### Description **Key:** desc **Type:** text #### Module **Key:** module **Type:** select **Options:** - Sales - Purchasing - Inventory - Production - Product Structure - Finance - Item Master - Reports - Other #### Menu path or number **Key:** menu **Type:** text **Help:** Copy from your own menu, it varies by site and version. #### Usage **Key:** freq **Type:** select **Options:** - Daily - Weekly - Monthly - Rare #### Changes data? **Key:** writes **Type:** select **Options:** - Yes - No #### Role that needs it **Key:** role **Type:** text #### Users **Key:** users **Type:** number **Rows:** **Program:** sosomt.p **Desc:** Sales order maintenance **Module:** Sales **Freq:** Daily **Writes:** Yes **Role:** Order desk **Users:** 8 **Program:** popomt.p **Desc:** Purchase order maintenance **Module:** Purchasing **Freq:** Daily **Writes:** Yes **Role:** Buyer **Users:** 5 **Program:** ppptmt.p **Desc:** Item master maintenance **Module:** Item Master **Freq:** Weekly **Writes:** Yes **Role:** Planner **Users:** 4 **Program:** bmpsmt.p **Desc:** Product structure maintenance **Module:** Product Structure **Freq:** Weekly **Writes:** Yes **Role:** Engineering **Users:** 3 **Program:** wowomt.p **Desc:** Work order maintenance **Module:** Production **Freq:** Daily **Writes:** Yes **Role:** Production planner **Users:** 6 **Program:** ppptiq.p **Desc:** Item inquiry **Module:** Item Master **Freq:** Daily **Writes:** No **Role:** Everyone **Users:** 60 **Totals:** #### Total user assignments **Key:** users **Agg:** sum **Format:** integer #### Programs listed **Key:** program **Agg:** count **Format:** integer **Notes:** The example programs are common QAD names, but program names, menu numbers and labels vary by site, version and customization. Verify every row against your own menu before relying on it. Add custom programs and mark them in the notes column of your own copy. ## Content **Intro:** Every QAD site ends up with a few people who know the program names by heart and a lot of people who do not. This worksheet turns that knowledge into a table you can export to Excel for training, access reviews and migration planning. **Sections:** #### How to use the worksheet **Body:** Start with the programs your team uses weekly. Add a row for each, copy the menu path from your own system, and note whether it changes data. Then add the role that needs it and an approximate user count. The totals show how many assignments you have. Export to Excel and share with auditors and trainers. **Bullets:** - Start with daily programs, then add weekly ones - Copy menu paths from your own system - Mark programs that change data - Record the role, not individual names #### Why a program reference matters **Body:** QAD menus are organised by function, but people search by program name, because the program name is what appears in the title bar, in tickets and in security setup. A current reference shortens onboarding, makes tickets precise, and gives auditors an artifact for who can change what. It also becomes the starting inventory when you plan an upgrade or a move to a newer architecture. #### Using it for access reviews and migration **Body:** Sort by the writes column and role. Any data-changing program with a large user count is worth a second look. During migration planning, the same table helps you decide which programs are standard, which are customized and which can be retired because nobody has used them in a year. Add a column in Excel for last-used date if you can pull it from your logs. #### Common mistakes **Body:** The most common error is copying program names from a training document that predates your version. Another is mixing standard and customized programs in one list without marking which is which. A third is listing individual users instead of roles, which makes the sheet outdated after every personnel change. Keep it role based and review it each quarter. **Cta:** If you want this reference generated from your actual QAD menu and usage logs, Netray can build a read-only extract and keep it current. **Faq:** #### Are the program names in the examples exact? **Answer:** They are common QAD program names for core functions, but you should confirm them against your own system. Names, menu numbers and labels differ by version, language and customization, so treat the examples as a starting format. #### Can I use this for a QAD security audit? **Answer:** Yes as a supporting artifact. Combine it with your actual security configuration export. The worksheet shows intent and ownership, but the system configuration is the evidence of who actually has access. #### How do I find the program name behind a screen? **Answer:** In most QAD interfaces the program name appears in the title bar or can be shown from the menu or help. Check your version documentation or ask your administrator for the exact method on your site. #### Does this export to Excel? **Answer:** Yes. Use the export controls to download the table as Excel, CSV or PDF. You can then add columns such as last used date or control owner. ## Search terms QAD menu program list, QAD program reference, QAD menu template excel, QAD sosomt popomt programs, QAD program names list, QAD access review template, QAD training cheat sheet, QAD menu number list --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json