Pick List:

Excel dialog box which shows every available FI field on your SAP system, including (CO-PA) and custom fields added to the coding block.

F4 Key: Lookups

The F4 key on your keyboard can be configured to do "lookups" of master data items inside the spreadsheet. If you are currently using F4 for other uses in other Windows applications, this feature can be turned off. In that case, you can right-click on a GLSU item to get the master data lookup dialog box.

Auto-Resize columns

Each time your rebuild your GLSU spreadsheet, columns are automatically widened so that all data can be viewed easily. This feature can be turned off if required.

Auto Format

Each time you rebuild your GLSU spreadsheet, the spreadsheet is reformatted with our default color scheme for easy navigation and viewing. This feature can be turned off if required.

Automatic validation before post/export

GLSU allows you to determine if you want the spreadsheet validations to happen automatically before posting. Validations can be turned off if required.  GLSU pre-validates over 25 master data items and select attributes as well as cost accounting and financial accounting line items within SAP configuration, configured coding block checks, asset checks, SD order checks, funds mangement checks, CO relevant fields, FI relevant fields, MM relevant fields, and joint venture checks.

Check file upload history

Each spreadsheet you post with GLSU is recorded on the SAP system. GLSU can be configured to warn you if you are loading the same filename more than once. This can potentially catch double-postings and improve your FI integrity.

Export multiple worksheets

An Excel workbook can have multiple worksheets. Each of these worksheets can represent a unique GLSU SAP posting. These worksheets can be posted individually or separately with GLSU.

Skip / Blank columns

To contain user formulas, data from other applications, notes, etc.

Skip blank rows

Blank rows can be used at any point in the spreadsheet to contain sub-totals, zero dollar lines, etc.

Foreign Language

GLSU uses a stand-alone text file which includes all text used in the software. A user can quickly translate and rename this file to another language for broader user acceptance.

Dropped-Header

“Drop” any header field to the line items and create multiple documents within one worksheet based on a change of data in any header field

Post or Export:

GLSU allows either immediate posting or SM35-like batch posting to give you plenty of options to control your SAP document posting.

Post / Park / Accrue / Foreign Currency Adjustment

You can decide to post, park, or accrue each document. Accrual documents will require a reversal date and reason. Parked documents will trigger normal SAP processes like workflow once they are in the SAP system.

Choose the SAP system

You decide if the transaction is going to be posted to your production, test, or development system. GLSU can access any SAP system you can normally login to.