GLSU Ribbon Menu Features
Once activated, GLSU has its own tab in Excel with specific features in a Ribbon menu format.
1. Processing | |
|
POST / PARK This feature will first Validate the sheet(s) [depending on settings], and then Post or Park the document(s) in SAP. |
|
|
EXPORT This feature will Validate the GLSU sheet(s) [depending on settings], and Export the data to a single .ZGL file (for processing manually using SAP transaction ZGLSU). Also see section Export a Document (2-Step Posting Process). |
|
|
VALIDATE Validates the GLSU sheet(s) and displays a list of errors that need to be repaired before an Export or a Post/Park can be done. See more on Validating here. |
|
|
REVIEW VALIDATION This window brings back the list of validation errors showing the issues and the location of each. |
|
2. Tools | |
|
OPTIONS Allows for SAP system connection setup, sheet selection for processing, and a list of general options and settings. |
|
|
CHOOSE FIELDS Allows the user to select which SAP fields are on the current GLSU sheet. Used to add/remove the fields from the sheet. |
|
|
REFRESH DESCRIPTIONS Refreshes descriptions by connecting to SAP and updating all cells that contain the "=glsu_description(xx)" formula (where xx equals the cell where master data element is entered) |
|
|
IMPORT Allows for importing of delimited data directly into a GLSU sheet. Mapping of incoming file fields to GLSU fields is supported. Also see section Importing Data. |
|
3. Utilities | |
|
LOGOUT Disconnects the GLSU connection to SAP. |
|
|
INITIALIZE Creates a new GLSU sheet. This will bring up the CHOOSE FIELDS dialog so that the GLSU fields can be selected or the defaults taken. |
|
|
RESET LINKS Reads the GLSU sheet to find and fix any broken GLSU formula links such as " |
|
|
SHOW MY CONTACTS Displays the contact information all of your GLSU Premium Users. Premium users often can solve accounting questions. |
|
|
RETRIEVE VALIDATION DATA Connects to SAP to update validation preferences, and if Validation Options are set to .INI, will then retrieve the data to the .INI file. |
|
|
SHOW VALIDATION INFO Show a list of validation fields and whether the data set is LOCAL or LIVE. |
|
|
EXPORT DEFAULT LANGUAGE Exports the internal default English language strings to a file. A translator may then edit this file to localize the language. |
|
4. Help | |
|
GLSU VERSION INFO This "About" dialog shows the component version information necessary for GLSU support questions. Clicking on the “More…” button will give detailed information that is useful for support as well. If you would like to attach this information to a support ticket, click on the “Save as…” button |
|
|
GLSU MANUAL This feature will link you directly to the latest manual online for the GLSU version that is installed. |
|