“The Best Spreadsheet Loader on Earth!”

GLSU allows an organization to streamline its financial data entry functions. GLSU provides a flexible and intuitive spreadsheet interface for collecting and posting transactions to SAP. From simple recurring general journal entries to allocations thousands of lines long, GLSU solves many common SAP data entry problems.

Far more than a simple batch load program, GLSU uses a combination of a configurable spreadsheet interface with a custom ABAP load program. These two items work together to deliver deep functionality such as…

youtube-play Watch a demo now
  • AutomationEnter only relevant SAP data items for your specific application. Customize the order of fields. All spreadsheet customization is done through dialog boxes which let you choose and order fields from a picklist. Adding, changing or deleting fields takes seconds.
  • FlexibilityForm input, monthly close packages, complex allocations, rebates, accruals, etc. can all be automated using GLSU. Different spreadsheet templates can be created, stored on the SAP server, and distributed to your workforce quickly.
  • AccuracyGLSU can check your input data against live (or off-line) SAP master data to warn of potential errors before posting occurs.

GLSU

Challenges

Using an in-house loader

Flexibility of GLSU

  • Support for all kinds of Finance documents
  • Not limited by a 999 line limit; you can load as many lines as your version of Excel will support
  • Doesn’t stop on first error
    • Superior error detection and correction
    • Custom validations
  • The entire entry is validated at one time
  • Date and currency conversion
  • Prevention of double postings

Easy, familiar user interface

  • Do everything right in Excel
    • No need to export and then import – post directly from the spreadsheet
  • Keep existing form look and feel
    • Blank column and row support
  • Supports all standard Excel functionality

Time consuming and expensive upkeep and maintenance

  • Flexible template modification – changed your coding block? No problem -add fields to existing templates in seconds
  • World-class support
  • SAP Partner helps when you need to upgrade SAP
  • Redirect IT resources to problems not solved easily by off the shelf solutions
  • Support for 4.6c and later and multiple versions of Excel

Z Option Inc. – A solid partner

  • Free 30-day trial
  • Free start-up session
  • Easy, quick implementation with free remote assistance
  • No new hardware required
  • Superior on-line support and maintenance

If you are new to SAP, we feel your pain. Let us help.

Considerations:

Flexibility of GLSU

  • Support for all kinds of Finance documents
  • Not limited by a 999 line limit; you can load as many lines as your version of Excel will support
  • Doesn’t stop on first error
    • Superior error detection and correction
    • Custom validations
  • Dropped header – posting multiple SAP documents from a single worksheet

Difficult user interface

  • Easy familiar user interface (Excel)
  • Keep existing form look and feel
    • Blank column and row support
  • Streamline your month-end close
  • GLSU supports Post / Park / Accrue / Foreign Currency Adjustment

Large learning curve

  • Keep existing form look and feel
  • Data look-ups (F4 key)
  • Excel functionality to automate common functions
  • Create a template from existing SAP document
  • GLSU Excel function to bring SAP description into spreadsheet

Long expensive on-going projects

  • Avoid costly throwaway interfaces
    • Have a solution for your day-to-day needs
    • Streamline your month-end close

Large legacy data uploads at one time

  • Export multiple worksheets

Data integrity and Security

  • Doc attach with document number drill back from spreadsheet
  • No dual authorization sets
    • Leverage existing SAP security
  • Data lookups
  • Pick lists
  • Check file upload history

Z Option Inc. – A solid partner

  • Free 30-day trial
  • Free start-up session
  • Easy, quick implementation with free remote assistance
  • No new hardware required
  • Superior on-line support and maintenance

Post large entries – new acquisition/ division conversion to your SAP system

Flexibility of GLSU

  • Support for all kinds of Finance documents
  • Not limited by a 999 line limit; you can load as many lines as your version of Excel will support
  • Large legacy data uploads at one time
  • Export multiple worksheets
  • Doesn’t stop on first error
    • Superior error detection and correction
    • Custom validations
  • The entire entry is validated at one time
  • Date and currency conversion

Data integrity and Security

  • Doc attach with document number drill back from spreadsheet
  • No dual authorization sets
  • Leverage existing SAP security
  • Data lookups
  • Pick lists
  • Check file upload history
  • SAP doc numbers returned to the spreadsheet after posting
  • Complete audit trail intact

Easy, familiar user interface

  • Do everything right in Excel
    • No need to export and then import – post directly from the spreadsheet
  • Keep existing form look and feel
    • Blank column and row support
  • Supports all standard Excel functionality

Long expensive on-going projects

  • Avoid costly throwaway interfaces
  • Have a solution for your day-to-day needs
  • Streamline your month-end close

Z Option Inc. – A solid partner

  • Free 30-day trial
  • Free start-up session
  • Easy, quick implementation with free remote assistance
  • No new hardware required
  • Superior on-line support and maintenance

What other challenges does GLSU solve?

Some of the most common day-to-day challenges you face in your SAP environment

GLSU functionality will blow your mind

  • Classic and SAP General Ledger (NEWGL) Support
  • We support posting, parking, accrual/deferral and post foreign currency adjustments

Flexibility of GLSU

  • Support for all kinds of Finance documents
  • Not limited by a 999 line limit; you can load as many lines as your version of Excel will support
  • Large legacy data uploads at one time
  • Export multiple worksheets
  • Doesn’t stop on first error
    • Superior error detection and correction
    • Custom validations
  • The entire entry is validated at one time
  • Date and currency conversion

Data integrity and Security

  • Doc attach with document number drill back from spreadsheet
  • No dual authorization sets
    • Leverage existing SAP security
  • Data lookups
  • Pick lists
  • Check file upload history
  • SAP doc numbers returned to the spreadsheet after posting
  • Complete audit trail intact

Easy, familiar user interface

  • Do everything right in Excel
    • No need to export and then import – post directly from the spreadsheet
  • Keep existing form look and feel
    • Blank column and row support
  • Supports all standard Excel functionality

Long expensive on-going projects

  • Avoid costly throwaway interfaces
    • Have a solution for your day-to-day needs
    • Streamline your month-end close

Z Option Inc. – A solid partner

  • Free 30-day trial
  • Free start-up session
  • Easy, quick implementation with free remote assistance
  • No new hardware required
  • Superior on-line support and maintenance

Processing AP vendor invoices

  • Process multiple invoices from a single sheet with our dropped header functionality

Travel and expense forms – use your existing forms

  • Use Excel functionality to flatten your learning curve by maintaining existing form layouts

COPA – profitability analysis

  • Full COPA support
  • All of your COPA (RKE) fields are available for inclusion in your templates

Monthly data loads

  • Such as payroll entries, p-card processing, large JEs
  • GLSU allows you to post more than the 999 lines
  • Post multiple tabs at the same time

SAP TCodes That GLSU Can Reproduce

General Ledger Transactions

    F-02 - Enter G/L Account Posting
    F-05 - Post Foreign Currency Valuation
    F-65 - Preliminary Posting
    FB01 - Post FI Document
    FB01L - General Posting for Ledger Group
    FB50 - G/L Acct Posting: Single Screen Transaction
    FB50L - Enter G/L Account Document for Ledger Group
    FBB1 - Post Foreign Currency Valn
    FBCB - Balance Carryfwd for Ledger Group
    FBS1 - Enter Accrual/Deferral Doc.
    FBV1 - Park FI Document
    FV50 - Park G/L Account Items
    FV50L - Park G/L Account Document for Ledger Group 

Asset Transactions

    ABAD - Asset Retire. frm Sale w/ Customer
    ABB1 - Correction of Asset Accounts
    ABF1 - Post Document
    ABF1L - Post Document in Ledger Group
    ABZK - Acquisition from purchase w. vendor 

Vendor Transactions

    F-41 - Enter Vendor Credit Memo
    F-42 - Enter Transfer Posting
    F-43 - Enter Vendor Invoice
    F-63 - Park Vendor Invoice
    F-66 - Park Vendor Credit Memo
    F-90 - Acquisition from purchase w. vendor
    FB60 - Enter Incoming Invoices
    FB65 - Enter Incoming Credit Memos
    FV60 - Park Incoming Invoices
    FV65 - Park Incoming Invoices 

Customer Transactions

    F-21 - Enter Transfer Posting
    F-22 - Enter Customer Invoice
    F-27 - Enter Customer Credit Memo
    F-64 - Park Customer Invoice
    F-67 - Park Customer Credit Memo
    F-92 - Asset Retire. frm Sale w/ Customer
    FB70 - Enter Outgoing Invoices
    FB75 - Enter Outgoing Credit Memos
    FV70 - Enter Outgoing Invoices
    FV75 - Park Outgoing Credit Notes
    

GLSU Version History (What's new in GLSU 6.0?)

Added in GLSU version 6.0…

  • Better Template Support – Download and use templates stored in SAP without leaving Excel
  • Automated “Description Fields” creation – When you add fields to your worksheet, you can also add their descriptions
  • Pin pick list favorites – When getting drop-down help in the cell in Excel, pin your favorite results to the list
  • Better Cross-Company document handling – Now returns all cross-company document numbers back to your worksheet
  • Mapping Functionality – Interface or flat file Mapping with Default Entry Offset for single row entries
  • Post/Park Ribbon enhancements – Button texts now change depending on type of process configured in Options menu
  • Custom Pick Lists – ZZ Custom Fields and other standard SAP fields not supported by GLSU can be added by the customer
  • Better attachment handling – When multiple documents are posted, physically stores the attachment once, with links stored for all other documents
  • Automation of “Send Validation Now” function – can automatically handle updated company codes and posting keys
  • Support for 64 bit MS Office
  • Ability to Park to Ledger Groups
Check out our video walk-through of the new
GLSU 6.0 Data Import Feature!

zoption_glsu_demo

Added in GLSU version 5.0…

  • Load Document enhancement – Facilitates quick creation of a GLSU template with data from existing SAP financial documents
  • Show blocking indicators in pick lists for Cost center, Profit center, and Internal orders
  • Add pick values for Reversal reason, fields with fixed values, and select fields with SAP check tables
  • Pre-validation of accounts which are “Post automatically only” and Reconciliation accounts and excluded from pick lists
  • Option to view SAP Message Long Text information in pre-validation
  • GLSU functions available in Excel Ribbon
  • Premium-User controlled Default User Settings

Added in GLSU version 4.2…

  • Support for Windows 8 / Excel 2013
  • Support for Multi-Portal SSO (Single Sign-On)

Added in GLSU version 4.1…

  • Pre-validation enhancement for Cost Accounting and Financial Accounting line items within SAP configuration, configured coding block checks, asset checks, SD order checks, funds management checks, CO relevant fields, FI relevant fields, MM relevant fields, and joint venture checks
  • Document number drill-back from the spreadsheet to an interactive SAP screen
  • Support for Windows 7

Added in GLSU version 4.0…

  • Attach source spreadsheet documents to the BDS (Business Document Service) in SAP
  • Shows cross-company (intercompany) and split document numbers
  • Double-byte (East Asian Language) Unicode support
  • Windows installer (mainly to aid in Citrix and other non end-user involved deployments)
  • Installation Check: GLSU SAP side installation check function

Added in GLSU version 3.1…

  • Custom Validations (w/Excel drill-back)
  • Dropped-Header (Multiple Documents on a single sheet)
  • SSO Support (Single Sign-On with SAP Logon Tickets)
  • Configurable Default and Hidden Field List
  • Payment Terms Pre-Validation/Description/Pick Values (Live and Off-line)
  • Personnel Number Pre-Validation/Description/Pick Values (Live and Off-line)
  • Assets Pre-Validation/Description/Pick Values (Live and Off-line)
  • Display SAP SID/Client on worksheet
  • CO-PA Pick Values (SAP 4.7 and later with a live connection)
  • Search function on Choose Fields
  • Pick Date Values
  • Enhanced Pre-Validation Error List Handling (Insert errors worksheet)

Added in GLSU version 3.0…

  • Real-time (Live) and Off-line validation options: GLSU now offers both real-time and off-line configurable options for Pre-Validations, Master Data Lookups (Pick Lists) and Descriptions.
  • SOX Compliance: Adherence to basic SOX (Sarbanes-Oxley Act) requirements for data access.
  • Job Class: Configurable technical option to submit background jobs as “Class A”.
  • Blocking and Deletion Indicators: Shown for Vendor, Customer, and GL Accounts in Pick Lists at both the central and company level.
  • Long Text: Added support for Park Document long texts.
  • Tax Codes: Validation, Pick Values, and Description support for Tax Codes (Real-Time and Off-line).
  • Trading Partner: Validation, Pick Values, and Description support for Trading Partner (Real-Time and Off-line).
  • Post Foreign Currency Adjustment: Support for transaction FBB1.
  • Time/date stamp: Display of Time/Date stamp of off-line validation data in “Options” screen.
  • Validation Info: Status display of real-time or off-line GLSU configuration for each configured item.

Added in GLSU version 2.4…

  • Enhanced language support: GLSU will be quickly adaptable to support new languages as required by new and existing customers.
  • Enhanced validations: Additional performance enhancements have been made to the master data validation portion of GLSU.
  • Enhanced message handling: The GLSU user will have configurable choices for how SAP messages are returned to the GLSU spreadsheet.
  • Enhanced font selection: More control will be given for the fonts used in picklists, etc, to aid in foreign language handling.

Added in GLSU version 2.3…

  • Selection Criteria for Validation Data: This allows you to specify specific ranges of data for each of the master data elements GLSU can validate inside the spreadsheet.
  • Show Validation Again: This will show the previous listing of errors without doing the validation logic again. This will shorten the time it takes you to correct multiple erros in a spreadsheet before posting.
  • Check blocked and ‘marked for deletion’: these indicators are now checked at the company code and central levels.
  • Profit Center Validation: Now checking the blocking indicator.
  • Print Document History: Posting history is printable from the SAP ZGLSU ABAP screen.
  • Validation of Sales Organization: GLSU’s first PA validation.
  • Performance Improvements: Even better performance in the GLSU add-in for validation data.

Added in GLSU version 2.2…

  • Long Text Support: for document and line item long texts.
  • Configurable GLSU installation directory: (Advanced XP Support, Support for “limited” user accounts) GLSU can now be installed to any directory the user chooses. Installation can vary between every user at your organization.
  • SAP 4.7 Enterprise: is now fully supported.

GLSU Compatibility Chart (with Windows, Office/Excel, and SAP/SAPGUI)

GLSU and Microsoft Windows

  • Windows XP and Vista (32 and 64 bit) are supported
  • Windows 7 (32 and 64 bit) requires at least GLSU 4.1
  • Windows 8/8.1 requires at least GLSU 4.2
  • Windows 10 requires at least GLSU 5.0

GLSU and Microsoft Excel/Office

  • GLSU (Through GLSU 5.0) is compatible with Office 2003, 2007, 2010, 2013, and 2016 – 32-bit ONLY – 64-bit Excel REQUIRES GLSU 6.0
  • GLSU is also compatible with Office 365, provided you are using the PC-based version of Excel

GLSU and SAP

  • GLSU is compatible with SAP ECC 4.6, 4.7, 5.0, 6.0, and all EHP for 6.0, SAP NetWeaver, HANA, S/4HANA
  • GLSU is compatible with SAPGUI 7.10, 7.20, 7.30. 7.40
  • Avoid SAPGUI 7.20 patch levels 0 and 5, patch levels 6 and beyond are preferred. (Though GLSU supports 7.20, SAP does not)
  • Avoid SAPGUI 7.30 patch levels 0 and 6, patch levels 7 and beyond are preferred. (Though GLSU supports 7.30, SAP does not)
  • Avoid SAPGUI 7.40 patch levels 0, 1, and 6, patch levels 2 and beyond (except 6) are preferred.
  • You can check the expected release dates of SAPGUI patches using this link : http://service.sap.com/sap/support/notes/1053737

What’s New in GLSU 6.0?

  
  
  
Get Manuals             Read Success
Stories
      Product Compatibility
Matrix