we conInitialize New Worksheets

GLSU allows you to manage multiple worksheets independently in a spreadsheet. These worksheets can be configured independently of each other. These can also be posted independently.

You can also use this functionality to initialize a new spreadsheet for GLSU entry.

To set up a new worksheet in an existing spreadsheet,

1. Select Initialize.
2. In the Initialize Worksheet ? dialog, select OK.

   

3. In the GLSU Initialize window, select one of the following options:
   • Initialize: Creates a new GLSU template with no data. only blank fields you select.
   • Initialize from a stored template: Loads a previously saved GLSU template without data.
   • Initialize from SAP Document: Retrieves data from an existing SAP Financial document.

   

4. In the GLSU Options dialog , select a single worksheet, a range, or a select list of sheets. This initialize the spreadsheet but not format it/them.
5. Optionally, If you select Initialize using AI assistant, you will go through the regular initialization steps as you would with option 1, however, at the end, the following additional steps are performed.
   1. Choose a company code.

      Note: Due to context size limitations of LLM model, select only one company code.

   2. On the next screen, enter natural language instructions to retrieve the required master data for your sheet.
      • Include verbiage to include or exclude specific master data items.
      • Examples:
        • Get all accounts between 6000050000 and 6000059999.
        • Get all accounts that contain pattern 100040 and cost centers between 1000500000 and 1000599999.

      Note: The instructions should only relate to the main master data item and not other attributes like description, block indicator etc. You can query Accounts, Customers/Vendors, Cost Centers, Profit Centers, WBS elements, Internal Orders, and Materials.

   3. Select Continue. If records are found you will receive a response similar to the following:

      

   4. Optionally, enter additional text to manipulate the data even further to your desired outcome. You can, but are not required to use all of the data retrieved on the prior step. An example second request is shown below:

      

      Output on the sheet from the above instructions would yield the results (1425 records are created for this request – only a small sample is shown):

      

      Special Considerations:

      • The size of any one interaction will need to be keep at a manageable level. As a general guideline, for now, the final output should remain under 2000 records in most cases.
      • Larger sets of data can be retrieved in the first screen, as long as the final result is under the aforementioned 2000. This is not a hard limit. The actual size depends on what elements you are retrieving and how complex your output will be.
      • You can always create multiple sheets and consolidate any resulting output into a single, separate sheet. Once the output becomes unreliable, it is a good sign you are getting to much in your instructions.

      Caution: LLM models may produce inaccurate or incomplete results. Always validate data before posting live. Accuracy will improve as models evolve.

6. Optionally, If you select Initialize from a SAP Document, you will see the following:

   

   Enter an existing SAP document number, Company Code, and Fiscal Year for any posted (FB01) or parked (FBV1) select OK.

   Note: Only fields selected in the ZGLSU transaction will be populated with data. i.e. if field SGTXT (Line Item Text) has text in the SAP document but field SGTXT is NOT in the GLSU template (or has been suppressed by one of your Premium users) GLSU will ignore the values in SAP. Premium users may want to configure SAP to always ignore certain fields to streamline this process for end users based on your specific SAP configuration. This can be configured by Premium users in the Default and Hidden Field List.

   Note: The Initialize from a SAP document feature is not meant to load some FI documents. In some cases, it will not create a post-ready document because of other SAP functionality, including but not limited to substitutions, custom enhancements, derived values, etc.

7. The pick list will then display. Configure your spreadsheet. It will configure all worksheets in your spreadsheets if you have chosen to initialize more than one.
8. Select Accept. This will then format all worksheets you have selected.