Home

Z Option Inc.

1. ccccccessssssteeeeeeessseseeeeeeesesssssneeeeeeeeessgs 45 Foreign Cumency Adjustments ccsssesssseceeeesssssseeeeeeeeessssseneeeeseseesseceneeeeeeesessseeneeeeeesesssssneneeeess 46 Master Data Value LOOKUP Sesrresresentose eoe e a 47 Pinning Frequently Used ValUCS ccsscccccceessssssnseeeeeeeessssseeeeeeesesseseneeeeseeeesssssnnseeeeesessssssnneeeeess 49 Validate Before Post Expot Option ssssssssrrssssrrrssrrrrsnnrrrnnssrrnrnrnnrrrnnsnnrnnntnnnrnnntnnnnrnnnnnnnnnrnennnnt 51 Check Fle Upload HITO cerieosia a onesie neleeeeeee 52 A to Regze COUMN Sca a a a via udiiveeuiitentian 52 AULO BOMMIaE C OlO1S renna n o a a a a a a 53 ONO C OUMN S anana O Orne ataiid 53 PS Se MD EOI GO IANS essed de chess pote de A dc aided du Srauanda reek dessueun oentublt 55 IG OTS ROWS arniinnareni a a i a a onan a natn eee kaaa ee eat nate inet 58 MURPIEWOKNECE S s a a NS 59 ME SKIP SHEET EaU GC sa dee 60 Multiple Documents ON a Sngle Worksheet ssssssssssssrrrsssrrrrsserrrnrsrrrrnnnnrrrnnsnrrnnnnnnnnnnnnnennnnne 60 VI CITED TE SAPR VLEN Siaosi a eaa e a eer eetenas Oe 62 PREV aCe tioN n AA 63 Validating the SOrEAAMG RL ceecsssecccsssstseeecssseeeeeesesseeseeesssseeseeesesseesesesesseeeeesessenseeeeesssnseeeeeags 63 Page 4 SNOW Valda TON WTO sereia lat ineaiivasindbehinistanstualuhinedenteniia 64 Come cting Erorsin the SOrPeAdM Ge b ceccssscecesssseeessssseeeeessseeseeeesssseeeeeesssseeeeesessseeseeessssanes 66 REHIC V
2. Search Search Reset Show Hidden Fields Configure your spreadsheet by choosing fields in the Possible boxes and moving them to the Selected boxes Thisis explained in more detail later in the manual Use the Add gt gt and lt lt Remove buttonsto edit the fields which are in the selected boxesto the nght of the screen Click the Accept button Type your Fl entry data into the spreadsheet Header information goes at the top of your soreadsheet Detail information goesin the second section of the soreadsheet If you need fields which are not on your spreadsheet re do the steps explained above which describe how to edit the fields on your spreadsheet When you have keyed in your data you should then validate it before exporting the upload file Choose Validate H Accept Cancel wll IE bog amp Page 33 11 Once your spreadsheet is validated Post the document to SAP ADS BRE ge gypa y toaa O 12 You will be asked to log onto your SAP system to post This is explained more fully in a later section of the manual Page 34 This page intentionally left blank Page 35 ECA wr Features Page 36 Other Spreadsheet Features The following pages will discuss the functionality of the GLSU spreadsheet in greaterdetail Initialize New Worksheets GLSU allows you to manage multiple worksheets independently in a soreadsheet These worksheets can be configured i
3. ZOPTION GET PREMIUM USERS ZOPTION USER ZOPTION GLSU Function Group R3TR FUGR ZOPTION GLSU Contains ZOPTION GLSU_POST ZOPTION GLSU_GET VALIDATION ZOPTION GLSU_UVE PICK GET ZOPTION GLSU_LIVE VAL GET ZOPTION GLSU_LIVE_AUTH ZOPTION GLSU_LIVE_DESCR GET ZOPTION GLSU_LIVE CUSTVAL ZOPTION GLSU_GET AUFNR ZOPTION GLSU_INSTALL_ CHECK ZOPTION GLSU_LIVE_SUBST ZOPTION GLSU_LIVE SETING_GET ZOPTION GLSU_ LIVE COBL CHECK ZOPTION GLSU_LIVE CUSTEXTRACT ZOPTION GLSU_LIVE CUSTPICK ZOPTION GLSU_LIVE_DOCEXTRACT ZOPTION GLSU_PARK_LDGRP ZOPTION GLSU_RWBAPI_COBL ZOPTION GLSU_GET TEMPLATE LST ZOPTION GLSU_GET TEMPLATE DAT ZOPTION GLSU_UNK ATTACHMENT ZOPTION GLSU_LIVE FB00 GET ZOPTION GLSU_ VAUDATE BALACCT Message Cla ssR3TR Program R3TR Program R3TR Program R3TR Program R3TR Program R3TR Program R3TR Program R3TR MSAG ZOPTON GLSU PROG ZOPTION GLSU PROG ZOPTION GLSU_ PRINT HISTORY PROG ZOPTION GLSU SEND CONFIG PROG ZOPTION GLSU SEND CONFIG OFFL PROG ZOPTION GLSU TOP CONSTANTS PROG ZOPTION GLSU TOP TABLES PROG ZOPTION HIDDEN Business Add Ins Implementations R3TR SXCI ZOPTION GLSU PRKLDG Table R3 R TABL Table R3 R TABL Table R3 R TABL Table R3 R TABL ZOPTION CUSTMSG ZOPTION FIELD COLUMNS ZOPTION GLSU_ PARK LDGRP_COMM ZOPTION LIVEDES R3IR ENHO ZOPTION GLSU PRKLDG_ EXT R3IR ENHO ZOPTION GLSU PRKLDG_IMP Page 119 Page Table Table Table Table Table Table Table Table T
4. 05 and 30 for AC TVT Activity Additional activities as required Page 118 Authonzation Field Values Object S BDS D Forattaching documents to the BDS 01 05 and 30 for AC TVT Activity Additional activities as required BDS for LOIO CLASS or as configured KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKHK SECTION 4 TRANSPORT TO OTHER SYSTEMS KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKRKKKKRKKKKKKKKKKKKKKKK 4 1 Transport all of the above to any systems where GLY will be run KKKKKKKKKKKKKKKKKKKKKKKKKKKKEKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK SECTION 5 OPTIONAL SET PRO FILE PARAMETER KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKHK 5 1 If users require document dnil back functionality from Excel set system profile parameter sap gui user scripting equal to TRUE Supported Technical Environment Notes When configunng logical file paths it isimportant that the file paths specified are either Network File System or Windows Shares common and wntable acrossall application servers if the environment has more than one application server Since GLSU jobsare load balanced itis possible that jobs will be started on application servers other than the one the userhaslogged onto BDC Log files stored atthe application server OS level must be configured to be read by all application servers The default path suggested by SAP Is usr sap lt SID gt SYS global If this directory i
5. Se E Choose a value for Posting key Double click here to pin or unpin ae ve Reverse credit memo data value N aua Lj a Bank charges i Other receivables Oubgaing payment Payment difference Other deanng Payment dearing Specal G L debit Credit memo Reverse MYE Page 50 Pins are stored from session to session They are stored by Company Code This means that a list of pinned values stored under Company Code 2000 can be different froma list pinned under Company Code 3000 Validate Before Post Export Option Page 51 The user will probably want to validate the soreadsheet values each time before posting to SAP GLSU Options i Workbook General Attachments Transaction Type Park Document System System 202 Chent 300 lest Updated 1 20 2015 4 0L35PM Add System W Validate Before Post Expart Show Posting Messages in Popup Export Active Worksheet Only Allows f T C Process Selected Worksheets Select C Export Range of Worksheets te Formatting W Auto Resize Columns W Auto Format K Cancel Choose the Options menu item from the spreadsheet Choose the Workbook tab Select the Validate Before Post Export checkbox De select the checkbox if you do not want GLSU to go through the step of validating yourdata against its master data each time you create a ZGLflle This option works the same using the Post o
6. Pick valuesare available for many CO PA fields these are fields which start with RKE however descnptionsand validations are not available for these fields Another way to look up the SAP master data values is by using the F4 key on your keyboard Since many of our customers already use the F4 key for other functionality ZO ption has made the F4 key optional when usng GLSU To activate the F4 key to toggle the Choose a value for XXX screen see above 1 Choose the Options menu item from the spreadsheet Choose the General tab Switch the F4 Pick G LSU Values to the checked postion NOTE De selecting the F4 Pick GLSU Values option will not tum off the lookup functionality it will just not automatically assgn the F4 key to the lookup You will still be able to use the lookup functionality by nght clicking on the cell Page 49 GLU Options Workbook General Attachments This functionality was added in the event you encountera function key conflict with another software package Pinning Frequently Used Values Once a pick list ison the screen note that the first column hasthe image of a pin in the header This first column is special in that it allows the user to pin frequently used values This makes finding those often used posting keysoraccountsvery fast and easy To pin or unpin a pick value smply double click in the pin column just in front of the desired data value __
7. 17 Sheet 14 Sheet 24 Sheet 1B Sheet 2B Page 72 VAT Taxes VATtaxes are calculated by your SAP system at the time of posting VATtaxes are calculated by SAP configuration that isnot available to GLSU While GLSU cannot calculate European VAT taxes inside the soreadsmeet it can allow transaction which contain VAT taxesto be successfully posted Header Field XMWSTisthe Calculate Tax field This field can be added to your spreadmeet using the GLSU Ribbon gt Choose Fields button A usercan add the field XMWSTto their spreadsheet and populate it with an X see below Once populated the Calculate Taxfield will disengage the standard GLSU balancing functionality that prevents G LYU from posting entres where debits do not equal credits Once populated the balancing formula in the line item header willbe changed to taxcalc see below The user is given the respongbility of sending GLSU and SAP an entry which willbe properly balanced after VAT taxes are calculated and added to the posting A B C D E F G H 1 a 3 Header Document type Company Code Document Date Posting Date Currency Calculate tax Cocument Number 4 SA 3000 1 2 2015 1 2 2015 USD 5 T Cine items test cy Account Account Descr tax calc lost Center Tax code Tax Jur 8 40 46000 Other loans short term 7 g 50 4766000 Miscellaneous Expense 10 1200 U1 AB1234 10 50 476000 Office supplies 10 1201 U1 AB1234 11 50 101000 Petty Cash Freight 10 1202 U1 AB123
8. B Medium Pnonty or C Low Pnonty Max SQL Statement Size This value denotes the maximum sze of a database SQLstatement Depending upon your SAP database this value may need to be adjusted You should contact your DB administrator before you change the default value NOTE The default 64K value will not need to be adjusted in approximately 95 of G LYU installations Submit As Non Unicode With application of SAP note 723363 and or certain versions of SAP 4 7 support package SAPKH47023 and ECC 5 0 support package SAPKH50005 an option wasadded by SAP to the standard load program to submit asnon Unicode For installations which are known to be non Unicode this setting should be checked initially unless otherwise determined by ZOption support Custom Validations GLSU can be configured along with development to handle custom validation scenanos Custom validation development can be done via your intemal development resources or outsourced fora fee to ZOption development staff Any headeror detail fieldscan be validated eitheron a line by line ortotal document bass Dnil back to the Excel spreadsheet cell is supported Errorsare denoted in Excel by CV E Custom Validation Eror Only errors are supported at this time Users must select Retrieve Validation Data from the GLSU gt Utilities menu option OR Send Validation Now from the ZGLSU transaction within SAP for the new setting to take effect Custom validations are only supported
9. General attachments Sy a hen syatem 202 Chent B00 Last Updated 1 21 2015 9 25 35 AM Add System Transacton Typ Post Document W Validate Before Post Export W Check File Upload History W Show Posting Messages in Popup Export Active Worksheet Ony Of Process Selected Worksheets Export Range of Worksheets T Formatting E Aube Resme Crne M Auto Format Page 60 The SKIPSHEET feature There are actually two ways to skip sheets in GLSU You could select the individual worksheets to post park using the Multiple Worksheets feature documented above Altemately you can simply add the keyword skipsheet in cell Al on every sheet that you never want to be acted upon by the export post or park functions Sheets marked in this way will imply be skipped over The feature is great for excluding those sheets that you use for calculations VLOOKUPS and other non GLSU helper sheets Multiple Documents on a Single Worksheet GLSU hasthe capability to post multiple documents on a single worksheet This isachieved by the dropped header concept In short any number of header fields can be dropped dragged and dropped in the Add Delete Columns function to the line items Most header fieldsScan be dragged from the upper nght box to the lower nght box as shown below Select elds gt Feds in SAP Desa lt lt blank gt gt blank column e lt deso gt gt blank coumi MONAT
10. averages Show My Contacts To see who your Premium users are click on Show My Contacts Using the Z Option Ticket System ZOption usesa web based Support Ticket System which allows our users to notify us if there are questions or problems with the software that need to be resolved Features of the Ticket System are 1 Easy creation of trouble tickets Tracking of open tickets via the user dashboard 3 Automatic paging of ZOption technical support staff when new tickets are created This assuresa timely response 4 Upload of backup documents You can attach screenshots of error messages Excel soreadsheets INI files etc to the ticket to fully inform the ZOption technical support staff of the problem Automatic email notification when resolutions or additional comments are posted Search capabilities of the Ticket System database to quickly answer questions that have arisen from other ZOption customers Premium Users at yourcompany are eligible to receive Ticket System login IDs If they have not already done so each Premium user should request a ticket system login ID 1 The ZOption Ticket System isaccessble from http www zoption com 2 Select Support gt Support and Licensing System 3 Requesta Ticket System ID 4 Fill out all of the information Once your ticket system ID hasbeen confirmed you will receive an email you may login to the ticket system on the same support page by clicking Log onto Ti
11. Format checkbox Ignore Columns You may choose to have columns in your preadsheet which you do not want to post to SAP For example you may need a column forcalculations which then feed the amount columnsin your spreadsheet Non postable or blank columns may be added to your Spreadsheet which GLY will ignore when creating the uploadable ZGL file Page 54 Felis in SAF i lt lt blank gt gt blank column lt lt desa gt gt bank column MONAT Period KURSF Enchange rate WWERT Tranelatn Date KBLNR Reference BYORG Cross CC no BATAT 8 Goc Header Text AUIGLY Clearing proc YANSI Caludsate taw i Las ETT Feld Deser lt lt blank gt gt blank column lt 2desr gt gt blank column NEWUM Special G L ind NEW BK Mew 00 000 E DETK Amount in LC WriV ST Tax amount lt MiWSTS LC tax moh MWSKZ Tax code MSKRL Wio c disc A iri ra Addit Faw Seadh Search Riese To ignore columns from the GLSU menu 1 Choose menu item Choose Fields 2 Select item lt lt blank gt gt In the pick list 3 Add asmany ofthese blank columnsasare required by yourapplication 4 Acceptthe changes Page 55 Feld Felis in SAF lt cblank gt gt blank column lt lt deser gt gt blank column MONAT Period KURSF Enchange rate WWERT Tran latn Date KBLNR Reference BYORG Cross Cc no BKTXT Doc Header Text AUGLY Clearing proc TREE Caludsate taw Feki Desc lt blank gt
12. ItisOFF by default Some installations may not be able to take advantage of thisfeature due to SAP verson and or configuration 2 a i E F rkb G ED emn wOrkKDoOoE Ieceeplat Warkbook I R is Umha F Horktbaook Re ie Eli le pS EL TEE Aj J ee nie Creation dates Workbook Creation datet i Hor kode as lt Se curi Harkbook Sagur z E Workba aT E i Worki mnt ny a i ti L i i I A FF AAR 4 Choose Cancel Please keep in mind that reserved words must be enclosed in angle brackets lt gt If they are not the literal word will be substituted in the description NOTE These selections must be typed in The disolay is only to inform you of what optionsare available If the USER option is selected by the Premium user all of the options available for storing documents will be in the control of the standard user From the GLSU menu in Excel 1 Choose Options 2 Select the Attachments tab NOTE Thistab will only appear if the Premium user has selected an option other than NO If the posting timeout isreached in GLSU asset in the Premium User Functions gt Maintain Technical Options gt Job Wait Time setting BDS document attachments will NOTbe updated forthe posted worksheets SAP cannot create a link to the document because no document numbers will be recorded until the SAP job runs Page 79 From this options screen you can select which option suites your needs If the Premium user has sel
13. Lavout Connections i ike hae dal iin Copy WE Fonmulas del Ir iT Custom Sort E Lf Data X Cut E i Review ae Trust Center A Decrease Font Size E F View E Delete Cells E 7 Developer Delete Sheet Columns F Add Ine OM Delete Sheet Rows ae je Email es TEAM gt Fill Color b E F Background Removal T Filter Font IF A FontColor b Font Size lr E Format Cells Dal Format Painter Be Freeze Panes j A Increase Font Size Em Insert Cells f Insert Function L I Insert Sheet Columns New Tab t Insert Sheet Rows b Macros Customizations Reset Merge amp Center ST Ca Name Manager bu Import Export After hitting OK the standard Developertab will be visible on the Excel Ribbon est multi 2 xls Compatibility Mode Excel FILE HOME History INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIE DEVELOPER ADD INS ie E Record Macro mw b ETa Froperties ie Map Properties fede Import gg Ep 7 ba iy bZ E saii HE Use Relative References m Q View Code q Expansion Packs Visual Macros Add Ins COM Insert Design Source Basic A Macro Security Add Ins Mode Run Dialog Refresh Data Code Add Ins Controls XMIL Modify Now we need a button added to the menu To do this click on the insert icon and insert a button object Initially the button willbe named Button 1 but we will change that Page 102 AVOUT FORMULAS DATA an wa Propertie r p e A View Coc OM Insert Design d Ins Mode
14. PGLSU50 SAR x cofiles K900077 2D2 x cofiles K900077 2D2 NOTE Actual transport numbers may vary The transport for this release are asfollows ZD2K900077 G LSU MAIN PROG RAM 1 3 Add the transport to the comect import queue Use transaction SIMS Press the Truck icon or Overview gt Imports Page 115 Double click the queue for the system into which you want to import the transport usually your development box When the Import Queue is displayed select Extras gt Other Requests gt Add and enter the transport number e g ZD2K900077 Confirm that you wish to add it to the queue 1 4 Import the transport usng Request gt Import If erorsoccur try re importing the file usng more overmde flags Some enorsin importing are unavoidable If something failsto generate try importing itagain and then try manually generating the object If you get stuck call usat 1 877 653 0795 KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK SECTION 2 SETUP LOGICAL FILE NAMES KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKEKKKKKKKKKKKKRKKKKKKKKKKKKKKKK UPG RADE NOTE IF YOU ARE UPG RADING FROM A PRIOR VERSION you probably already have the logical filenames set up those have not changed in the upgrade If you are ina technical environment that has more than one application server please read the Supported Technical Environment Notes section below before starting this step for important information 2 1 Determine what path
15. SD orderchecks funds management checks CO relevant fields Fl relevant fields MM relevant fields and joint venture checks Document number dnill back from Excel to interactive SAP screen New features in GLSU verson 4 0 a a iM R Attach source spreadsheet documents to the BDS Business Document Service in SAP Shows cross company intercompany and split doc ument numbers Double byte East Asan Language Unicode support Windows installer mainly to aid in Citnx and other non end user involved deployments GLSU SAP side installation check function New features in GLSU verson 3 1 O CO ND MW PWN EBE Custom Validations with Excel dnil 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 Tems Pre Validation Descnption Pick Values Live and Off line Personnel Number Pre Validation Desc nption Pick Values Live and Off line Assets Pre Validation Descnption Pick Values Live and Off line Displays SAP SID Client on worksheet CO PA Pick Values SAP 4 7 and later with a live connection 10 Search on Choose Fields 11 Pick Date Values 12 Enhanced Pre Validation Eror List Handling Page 17 SOX Compliance GLSU meets basic data access requirements for SOX Sarbanes Oxley Act GLSU hasalwaysrestncted access for posting documents by leveraging standard SAP authonty objects The additional checks which are
16. Ume Piers Dae Account balanced Cost Center Profit Center a l 100084 500 50 113150 500 Page 13 Validate Data before Posting GLSU lets each user choose SAP master data fieldsto pre validate before posting Company Codes Posting Keys Cost Centers Profit Centers Customers Vendors Field Status Group information and many others are all selectable This feature ensures that your users data entry iscorect before posting to SAP This will reduce eror correction time and increase productivity Errors Found Di Error E C8 Account 111010 not found in Company Code 3000 E AB G L account 1110106 not defined in chart of accounts CAUS E 08 09 Document out of balance db 100 00 E Ci Account 121005 not found in Company Code 3000 E E AlO G L account 121005 s not defined in chart of accounts CAUS B10 Atleast 2 posting ines are required Check to see if a Dropped Header field often with blue column headings has unexpectedly changed Page 14 Definition of Users There are three typesof GLSU users Premium users Standard users and all otheremployeesor business partners of the customer These three types of users have different ca pa bilities with G LSU Licensed GLSU Users Posting Functionality Download GLSU Add In from the GLSU ABAP to their PC provided they have SAP access Export documents from the G LSU spreadsheet to the AGL file off line users Post the soreadsheet to SAP Templat
17. emors exist they will all show in the dialog box hown above To correct the problem 1 Select the enorin question by clicking on the appropnate line 2 Once the item is selected click on the Go To Eror button at the bottom of the screen The dialog box will then disappearand your cursor will be placed in the cell containing the enor This is especially useful for long entres Custom Validation enors if utilized are denoted with a CV E in front of the eror message indicating Custom Validation Eror You can view extended SAP message information long text for all messages EXCEPT when G LSU or CustVal is in the Source column To view the Source and othervalues select More For ease of enor processing you may also copy to the clipboard or insert a worksheet of emors from the Validation Emors dialog To do this smply nght click and then select the appropnate option Page 67 Errors Found During Validation Type Cell Error Copy Messages to Clipboard Insert an Errors WorkSheet Expand SAP Information After insertion of an emors worksheet you may use the hyperlinks In Excel 2000 or later at the left of the newly created worksheet es B C Sheet 1B k Cell Error Go To Error Sheet 1B IC8 Account 100001 not found in Company Code 3000 Go To Error Sheet 1BTAS G L account 100001 is not defined in chart of accounts CAUS 4 n Sheet 2A Sheet 1B Sheet 2B Sheet 1B Msg 01212015100038 Please note that these
18. for you Note templates are not changed on the SAP server Changes which need to be made to the structure of the template must be done insde Excel Once saved the edited spreadsheet file can be uploaded to SAP To access this functionality Page 92 1 Click the Premium User Functions button on the ABAP screen transaction ZG LSU 2 Click the Maintain Templates button 3 Click the add rename ordelete buttons see instructions below The following pages explain how to upload rename and delete the GLSU templates which are stored on your SAP server Standard users will not have access to add upload or rename spreadsheet templates Downloading templates is done from the first screen of ZGLSU Page 93 To UPLOAD a new Spreadsheet to the SAP server 1 Click the Upload Template icon 2 Locate the spreadsheet on your PC using the standard Windows dialog box shown below When found click the Open button Lookin Ji Test Workbooks O 5 1 test a xlsx 071744 test xlsx 0 1765 Template 1 xlsx Be 7135 BELNR returns O 7056 Example of offsetting entries xlsx Q BelnrBvorg 1767 xlsx H double_bug 1_multi_sheet_hangdsx Q7 importDemol xdsx Be Large Template xds Be Omni Jim 5 1 crash on attachads H PinTester xlsx ER Post test 1763 xls 4 Clickthe Check icon when finished 7 1 2014 11 25 AM 9 11 2014 1133 AM 7 10 2014 8 57 AM 19 17
19. functionality to calculate when a row should be skipped For example ifthe dollar monetary value of a calculated amount is 0 in column A of your spreadsheet you could use the formula IF D8 0 Skip Thiscould then be copied to all subsequent rows to avoid 0 currency wamingsat the time of posting Use blank rows to hold sub Totals This is especially useful for custom form development Multiple Worksheets Page 59 GLSU spreadsheets can have multiple worksheets When posting each of these worksheets will create a separate SAP document When posting you may wish to postone all ora range of these worksheets in your soreadsheet You could use thisfeature to have GLSU ignore a worksheet which contains all of your calculations feeding the posting worksheet s via formulas From the GLSU menu 1 Choose the Options menu item 2 Adjust worksheet optionsasrequired You can choose to exporta sngle worksheet by choosing option Export Active Worksheet Only Choose a range by selecting option Export Range of Worksheets and then typing in the range of worksheets in the two fields below see screenshot above 3 If you choose to exporta selection of specific sheets select Process Selected Sheets and then press the SELECT button Post Park Sheet Selection You can use multiple worksheets To book allocations across company codes Use a different worksheet for each company GLU Options Workbook
20. has been set low Any workbook over this maximum amount willnot be attached Page 80 1 Clickon the View Workbook Sze Report button View Workbook Size Report 2 The userwillbe presented with a quick summary report a Workbook Size Report 3 Clickon the Show Sheet Sze Report button 4 This report will how each sheet and itsapproximate size in bytes It can be very helpful to find those over size sheets and deal with them before posting and attaching hc Workbook Size Report Lesa 5 Clicking on the sheet name will show it asthe active sheet for your review Page 8 amp 1 GLSU R 3 Features Page 82 GLSU SAP Features Besides posting your ZG L file to SAP the GLSU ABAP program also controls many other options PC EEEE ee File Batch Job Name BDC Session Name Maximum zh as Lines per Doc ga Check eee History Delete ZGL file after upload Premium User Functions C Work GLSU close_package1 zal FIGLSU FI GLSU RE No Data Char if 940 Validation Options Send Validation Now Standard Users will not see the Premium User Functions button shown above Only Premium Users will see thisoption on the screen The following pages explain the ABAP functionality in greater detail Page 83 Setting your GLSU Validation Options The GLSU ABAP program will allow you to configure the GLSU validations to your requirements The GLSU ABAP program can be accessed by
21. isa good option to leave ON GLSU will also delete all posting history attached to your ID if needed Upload Control Check Upload History Show Upload History Clear Upload History _ Delete ZGL file after upload Print Upload History The following explains each of the fields in the Upload File History section 1 Check Upload History Leave thischeckboxon if you want GLSU to check its history to potentially detect emoneous double postings of entnes and prompt you if you want to continue If the checkbox isON and GLSU does find the file in its intemal history it will stop the posting process You will need to rename the ZGLfile or tum thischeckbox OFF to continue 2 Delete ZGL file after upload Leave this checkbox on if you want the G LSU ABAP to physically delete the Z L file from your PC after posting This will eliminate any chance of an emoneous double posting z 2 Iest Workbooks Post test multi ZGL 01 21 2015 11 32 02 100028535 eefttTest Workbooks Post test multi ZGL 01 20 2015 11 14 23 100028534 ee2ttTest Workbooks Post test multi ZGL 01 13 2015 10 50 31 100028510 ee2ttTest Workbooks Post test multi ZGL 01 13 2015 10 44 17 100028507 ee2 Test Workbooks Post test multi ZGL 01 13 2015 10 44 17 100028508 yeonos x 3 Show Upload History Clicking on this button will display the dialog box shown above It shows files which have been posted to SAP under your SAP login ID It shows file name d
22. message are only valid until changesare made to the contents of the worksheet or the worksheet name ischanged Itis also possble to pnnta list of errors from this worksheet Simply use the standard File gt Prnt functionality from within Excel If The error is an out of balance situation GLU will not know which line tem is incorect You will have to find the eror manually and correct it before posting Page 68 Retrieve Validation Data G LSU will allow you to retrieve the SAP maser data you have chosen to validate against eitherasan off line process or real time live basis To download the SAP master data into your PC INI file NOTE The system will automatically refresh your masterdata each time you log in to SAP If you make changesin SAP dunng your session it isbest to click on LOGOUT and let GLSU refresh the master data again on the next login From the GLSU menu Choose the Retneve Validation Data menu item You will only be able to retneve validation data via this method for datasets which are 5 megabytesor less For larger off line datasets you should login to SAP execute transaction Z LSU and select Send Validation Now or configure more live validations to reduce the PC footpnnt Si tll 7 8 amp A A G The appropnate SAP master data valuesand texts along with SAP fields and structures will be downloaded to your PC For most GLSU implementations you will only need to perfom this function w
23. you would like to use to store the ZOption GLSU temporary posting files These files are usually less than 2 3 megabytes in size but for sme heavy users they can approach 15 megabytes The filesare deleted assoon asthe process completes so the nomal state of this directory isto be empty During rare circumstances fillescan get hung tt is good practice to occasonally purge any files over 30 daysold You will need to setup a logical file names and logical file paths for each SAP system ID where GLSU will be run The logical fille namesare in the format ZOPNON GLSU POST xxx where xx is replaced by the system ID ZOPTION GLSU POST 21 is provided in the transport only asan example 2 2 Use transaction FILE to create the logical file paths Acknowledge the client independent waming and scroll to the bottom of the list of logical paths Select ZOPTION GLSU POST Aland pressthe Copy As button oruse menu option Edit gt Copy As This will allow you to create a new entry and hows you the current ZOPTION GLSU POST 21 asthe default name Erase the ZD1L and put in your system ID When you have it correct press enter and when asked if you want to copy dependent entnes select Copy All You now need to set the path for this new logical file path definition Select the new ZOPTION GLSU POST xx entry and pressthe second file foldericon up at the top This allows you to enterthe physcal file name for Windows NT If you are not using Windows N
24. 0 100 refdoc1 Same text on all 9 50 113150 100 refdoc1 10 40 121005 100 refdoc2 11 50 121010 100 refdoc2 12 40 131000 100 refdoc3 13 50 133000 100 refdoc3 14 15 v Sheet1 4 f gt All 3 documents will contain the same Document Header Text When using dropped header functionality the balance cell in GLSU will no longer display balanced Since there are multiple documents on one sheet this functionality isnot feasible in the context of dropped headers However pre validation will still be performed to ensure each individual document balances If an out of balance situation occurs a pre validation message will be issued If you double click the eror GLSU will highlight the range of amounts on the worksheet in which the out of balance condition occurs Page 62 Multiple SAP Systems Many SAP users work in an environment where there are multiple productive environments of SAP or development testing environments G LSU gives you the ability to download masterdata from as many of these environments asrequired Each time you download data froma different SAP client a new and unique file of masterdata isdownloaded to your PC These files must be refreshed individually Choose the Options menu item from GLSU Options the spreadsheet Workbook General Attachments Choose the appropnate environment from the dropdown box This listing is System Sys 800 automatically updated each time Last Updated _System zD2 Cli
25. 2014 10 34 7 15 2014 10 08 AM 12 12 2014 944 AM 6 9 2014 3 05 PM 7 30 2014 1 26 PM 7 15 2014 1 26 PM 12 18 2014 324 PM 12 2 2014 2 27 PM 10 16 2014 4 18 PM Microsoft Exe Microsoft Exc Microsoft Esc Microsoft Exc Microsoft Exc Microsoft Exo Microsoft Exc Page 94 To RENAME a Spreadsheet Template which isalready stored on your SAP server perform the following steps Ww NF NOTE This functionality is only available to Premium Users Click the Premium User Functions button from transaction Z LSU Click the Maintain Templates button Highlight the appropnate soreadsheet you wish to edit and then click the Rename icon at the bottom of the screen hown on the previous page bb Type in the new name of the template in the dialog box which then displays When finished click on the Check icon wv To DELETE a Spreadsheet Template which is already stored on your SAP server perfom the following steps wW N R Note this functionality is only available to Premium Users Click the Premium User Functions button from transaction Z LSU Click the Maintain Templates button Highlight the appropriate spreadsheet you wish to edit and then click the Delete icon at the bottom of the screen shown on the previous page Click Yes in the following dialog box Importing Data into a GLSU Template Page 95 GLSU hasa utility to allow data to be imported from a file directly
26. 4 12 50 473000 refresh required 10 1203 U1 AB1234 Page 73 Document and Line Item Long Texts GLSU allows you to input document and line item long texts on each document These text fields are not the same thing asthe document header text BKIXT or the line item texts SG TXT Long Texts allow you to input multiple line formatted texts Long Texts for Park Documents are also supported e Header Long Text field names begin with BELEG e Line Item Long Text field na mes begin with DOC_ITEM These are in the headerand detail sections respectively of the possible fields listing in the Select Fields dialog box shown below NOTE You will see a listing foreach of the Headerand Line Item Long Texts fieldsthat you have configured on your system You will need to ask your SAP Administrator which isthe appropnate field to populate e Configure Header Line Texts using transaction OBI8 e Configure additional Line Item Texts using transaction OBT10 After you have made your configuration changes you will need to either go to SAP transaction ZG LSU and do Send Validation Now or from Excel select Utilities gt Retneve Validation Data in order to be able to access the updated text fields from the GLSU spreadsheet Select Fields Fields in SAP Fields on Spreadsheet Descr j Descr Clearing text IT Document type Doc complete Company Code Doc currency G BLDAT Document Date Header Ledger Group i BUDAT Posting Date Fields Manda
27. 5 B7E L2D003 1 662 13 1 Use the BROWSE button to find data fileson your hard dnve or network 2 My data has headers If yourdata hasheaderson record 1 check this box If no headersare available you can continue but it makes mapping more diffic ult 3 Selecta Data delimiter This will let you see if the delimiter isthe nght one forthe file and gives the user visual confirmation that the data will import propery 4 Enter the number of records to show in the preview window This value is also used to constrain the numberof preview recordson the mapping screen 5 The preview area will how the data recordsasthey willappear in the data mapping screen 6 Click MAP FIELDS to open up the data mapping screen hown on next page Page 96 The Data Mapping Screen Primary Map Sheetl Primary Map SAP Fisted GLSU Fisid Description Colt Map to Fie or Value Example data HEWES Posing bey EVE Acoount WRETR Arc SETT Text ROSTL et C f La ca PRCTR Prot Cen er SOG231 b85 DEC PMT SNN Ly ba oa 63 1229 4 007 87 0 4 007 87 WI S0G231 6eS MUNCY MF 6510100000 416510395 1 Primary Map Thisarea isfordata file record fields to GLSU template fields 2 Offset Map Thisarea worksthe same asthe Primary Map except that it is mapped so that an offset entry willbe produced 3 Checkbox Use offset map Tum ON OFF the Offset Map feature Many mappings will not use this feature
28. A new unlock code will be issued which will allow more unique usersto upload entnes 2 Remove existing Users intemally registered asStandard usersso that new userscan be registered automatically by GLSU or manually by a Premium User Remember that there isa difference between Standard Usersand Un Registered Users Standard Users are allowed by GLSU to upload entnes Un Registered Userscan use all the GLSU functionality EXCEPT posting This will allow employees at your company to download the GLSU add in and download the master data To maintain the Standard User 1 Click the Premium User Functions button in the G LSU ZGLSU transaction 2 Click the Maintain Standard Users button The following screen will display Username Created On Last Used TESTUSER 08 30 2024 04 27 2034 Page 26 3 To have GLSU automatically register users enable the Auto register users checkbox 4 To manually add new users click the New icon at the bottom of the screen 5 Enterthe username and click the Check icon 6 To manually delete users click the Delete icon 7 Once yourchangesare complete click the Check icon to save yourchanges Page 27 Step 4 Uploading new Add ins Premium Only G LSU works with two sets of programming code The ABAP code transaction Z LSU on SAP controls the functionality of posting and user maintenance The Visual Basic for Appli
29. Accrue sy subrc 0 Page 104 Premium Only Default and Hidden Field List Asa Premium user you can configure the possble SAP fields which will be disolayed and defaulted in Excel This promotes ease of use and lack of confusion for fields which your company may never use or use infrequently To configure the list of default and hidden fields perfom the following 1 Start transaction ZGLSU 2 Select Validation Options 3 Choose option Select Hidden and Default Fields at the bottom of the screen you may have to scroll down 4 Check the appropnate options for fields you wish to Default and fields you wish to suppress from display NOTE Suppression doesnot cause the field to be unusable in GLSU it smply doesnot dilay the field in the possible fields list asthe default Select Hidden and Default Fields i w L SS E Z E E E R E E E Hidden and Default fields since they are relatively static require a Send Validation Now operation in order to be updated the next time a spreadsheet is initialized These settings willbe applied each time a GLSU spreadsheet is initialized The settings are not applied when editing an existing worksheet Page 105 Premium Only Maintain Technical Options From the LYU transaction in SAP logged in asa registered Premium user 1 Select Premium User Functions 2 Select Maintain Technical Options C YES user is forced to attach the wo
30. E Vall GTO MID a Ue xcissai vnc te tevtaniceuvinn A NAARAAN 68 Adding Master Data TEMES enere AONNE E ANAKE 69 NEFCOMDany ansat HO Sresi eaen 71 MPT OS vie saiee ca ist eas iiss re eee eae ated eos need a ee eee eer ee eee 72 Documentand LINE Item Long TOXUS ccccccesssssssseeeeesessssseeeeeeeeesssesneeeeseeeesssssenseeeeesessssssnneeeeess 73 Double Byte East ASIAN LanguagesS s esssssssseerrrrrsserrrrrrrssserrnrrrnrssrnrnrnnnrsnnrrnrnnnrsnenrrrnnnrenennne 75 Document Atac nmMments BD S airia ocuudustparemataneedertueetaaewis 71 OLU SPP CSS aaah assesses anes eek ees eet 82 Setting your GLSU Validation OPTtlONS 0 eee cccccssssseecessssneeeeesssseeeeesssseeeeeessseeeseesssaeesessssneeees 83 PID CESSING EPOE FES reirse a ein ae teaver teat ater uate 85 Maximum Of Document LINE ITCIMNS ce eessssssseeeeesessssseeeeeeeeessssneeeeeeesesssssnseeeeeeeesssssnneeeeess 86 Upload FIGS ISON sce a a e a 87 Pead MECT TEMP la le Snekers e a a a e a n 89 Impormng Data Into sa GLU Template cuicsnctereencitaseent nine anes 95 Mapping Ne DSUs Sa ahd chee pan oc aCe ic epee eee oars Da ieee ae we Pesiime Ge atte du Sceueanda rotten ie nueue dentate 97 IMPONA DANA nesne EE 98 mporn Data AdVanc 60 mirren a a EA 99 Embedding Custom GLSU Buttons into a Template sssssssssnssrrrssnrrnrnnrrrrnenrnrnnsnernnnrserrnne 101 G LSU SAP Side Installation Check Technical Project Team Utility sssssesesssnnsnesnnnenssennnns 103 Premiu
31. ERG ri nie tTO FL kar Bar i r oP Bol a it i Tpi j rr rt g iat E EFLFE FFR GR D Text check boxes Master data ar 2 kf check boxes n You can also select ranges of master data to be sent to the INI file This will allow you to exclude ranges of masterdata that you do not nomally use For instance if you do not use all the company codes which have been configured for your organization you can limit the range of company codesto a specific range or list of individual values This will work for each of the master data elements that GLSU validates In short if you do not use the data do not send itto the INI file This will improve the processing performance of GLSU Page 85 Processing Export Files G LSU remembers all the settings you used the last time you posted a document through GLSU Every time you run Z LSU the filename batch log name etc will be auto populated with the values from your last posting You smply edit these valuesasnecessary then run the program PC CEEE e File C Work GLSU close_packagel zq Batch Job Name FIGLSU BDC Session Name FI GLSU RE Maximum e Lines per Doc 540 E PPE Counter to Ref Doc PC Spreadsheet Output File If you need to search your hard drive you can click the file dialog button then use the Standard Windows dialog box to locate the ZGLfile PC ene ae File sktop Excel Dev GLSU v5 2 Test Workbooks Post test multi z
32. Main 334 335 Seoul 301106 GaNa 131 9876 5432 151 010 Seoul DongJak gu SangDo Search Search Reset Select Cancel Page Document Attachments BDS G LSU supports the attaching of the spreadsheet file to the posted documents in the SAP BDS Business Document Service for supplemental documentation and audit purposes Regular postings parking accrual deferral and posting foreign currency transaction typesare all allowed with the document attachment feature There are several ways this functionality can be configured Important Note Any Premium or Standard user must select the Send Validation Now option from the LSU transaction for these settings to take effect From a Premium user perspective you can set the options so certain optionsare always enforced or can be determined by the end user From the LSU menu logged in asa GLSU Premium user in SAP 1 Choose Premium User Functions 2 Choose Maintain Technical Options Attaching Documents Max Attachment Size 4 009 K Attach to intercompany documents w Use link for subsequent attachments w YES user is forced to attach the workbook NO the user is not allowed to attach the workbook PROMPT the user about attaching the workbook USER let the user dadde about attachments Description Excel Liptoad from GLSU Description for attachments Press F1 for help If you choose YES the spreadsheet will always be a
33. NR Document Number AUGLV Field Descr lt lt blank gt gt blank column NEWBS Posting key lt lt descr gt gt blank column NEWKO Account NEWUM Special G L ind WRBTR Amount NEWBK New co code SGTXT Text DMBTR Amount in LC KOSTL Cost Center WMWST Tax amount PRCTR Profit Center MVWSTS LC tax MVWSKZ Tax code W o c disc Show Hidden Fields From the GLSU menu l 2 3 4 Click on menu item Choose Fields from the GLSU Ribbon The pick list is organized into Headerand Detail fields The pick list is also organized into possble and selected fields Select fields use graphical buttonsordrag and drop and re order them graphical buttons only asdesired Click the Accept button when satisfied Page 39 You can search for specific technical field namesand field descriptions by entenng your search string into the search boxand then press Search Both the possible headerand detail fields are searched Reset will retum all possible fields to the list If your Premium user has configured hidden fields you will not see these fieldsasa default This is meant to reduce clutter or remove fields which are rarely or never used However these fields are still available simply by checking the Show Hidden Fields checkbox If your Premium user has configured default fields these fields will automatically appear in the selected fields although they can be removed if desired Re Order Columns Once you have chosen t
34. Period KURSF Exchange rabe VWiWERT Transat Date HNR Reference BYORG Cross Cc ino SET AT Joc Header Text Cleanng proc mea eae tar eno blank column blank cohen Spedal G L ind Mew Co cocks Amaut it LE Tax amount LC CAN lax code W cadere Arid ta Show Hidden Fields Relds on Soreadsheet Pied Tees HART Dooment tpe BURRS Company Code ADAT Decument Date BUDAT Posting Date WAERS Currency PELNA Document Humber Pete Heg NEWES Posting key EWE Accounl WERETR Amount Page 61 Each time a dropped header field changes a new document will be posted It isimportant to note that any header field which changes will tnggera new document whether it is just one dropped header field or every dropped header field Ifa dropped header field is left blank it will inhent the lastnon blank value 3 documents will be created one for each unique entry ix GLSU Doc xisx Excel 7 x HOME History INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER ADD INS GLSU SIGN It p aa meee peee TE z ae We Retrieve Validation Data S lt E 7 x 4 EA 3 Show Validation Info O Post Export Validate Review Options Choose Refresh Import Logout Initialize Reset Show GLSU Validation Fields Descriptions Links Contad Export Default Language Version Info Processing Tools Utilities v H l a 4 1 19 2015 1 19 2015 USD 5 7 Account Amount Reference Doc Header Text 8 40 11101
35. Run Diale 5 Form Controls o E v EB Aa fab Activex Controls p OEY M Ea bel amp o a bisit Place your button where you prefer it Sze it if needed If the button doesn t have an edit border around it then asmply right click on the button to tum on edit mode In edit mode for the button look for selection Edit Text in the right click menu Name the first button VAUDATE Now all that isneeded isto tie the button to a macro While in edit mode select Assign Macro Forthe Macro Name enter GLSUValidate and press OK Test the button by clicking on it The action should be exactly asthough you had clicked on the GLSU Validate menu item Create a custom Pos button using the same procedure Simply add a new button asbefore and nght click on it to get the edit mode and the edit menu Edit the text to say POST Again in edit mode edit the macro to read GLSUPost You re ready to go You can go into edit mode nght click on any button asneeded to change the text the macro name orto resize or move the button into place Page 103 GLSU SAP Side Installation Check Technical Project Team Utility To aid in the diagnoss of installation configuration and secunty role issues GLSU comes equipped with an installation check utility This utility can be run by all licensed GLSU users both Premium and standard It can be used to help intemal BASIS personnel or ZO ption support staff Snce the utility runs fo
36. Start by clicking on INIMNAUZ FLE ng 3S n FJ op Ho 2 Clickon OK to bnng up a lit of templates Initialize Inawlize from a stored template C Indisite from a SAP Document _ 3 Selecta template by clicking on it Page 90 Global Template List Posabs Fae 4 The GLSU system will pop up a file explorer Use this to place the template file wherever you like on your system You can change the name atthis time to something that suits your workflow Save As G gt Computer Windows C GLSU Work Organize New folder a Music t Pictures H Videos JA Crew Reynolds JE Computer amp Windows C di temp do SRECYCLE BIN dell go Documents and Settings Date modified Mo tems match your search Filename Post testods Save as type xus Files taxds Authors Enc Jellison Tags Add a tag Hide Folders Cancel 5 The end result willbe a fully formed template possibly partially filled in by your Premium user with required field data 6 Make whatever modifications you need to add lines change dates etc and postor park the document asusual The template issimply meantasa starting point to maintain some consistancy from document to document _ Download a spreadsheet template Page 91 The altemate way to select and download templates is by using the ZGLSU transaction Pest E se 057 1372014 Fost
37. T please Page 116 use the New Entnes button and enter your correct operating system in the Syntax Group field along with the correct physical path for this system ID If you want to set up more than one system id go back to the main Change View Logical File Paths Overview screen and press the top file foldericon Do the Copy Asand repeat the instruc tions in section 2 2 When you are finished creating the logical file paths press the SAVE button or choose menu option Table View gt Save Itwillask fora transport number create a new one so you can easily track the logical file names 2 3 Use transaction FILE to create logical file names Now that all the logical file pathshave been defined and their physical paths defined we need to assign logical file names that use those paths While still in transaction FILE click on the 3rd file folder icon Scroll to the bottom of the list and again we will select the entry called ZOPTION_GLSU POST Aland pressthe Copy As button or use the menu option Edit gt Copy As This will pop up a screen requesting the logical file information The only thing that needsto be changed isthe logical file and logical path replacing ZD1 with your desired system id in both fields NOTE If you want to also change the physcal file name you may edit the Physical file field The text lt PARAM_1 gt is replaced by the system with Usemame limestamp so for ohn Smith whose USERID is J SMITH run
38. This option isvalid if you are performing the off line method of retneving descriptions If you are retneving descnptionsin a real time method this configuration option hasno relevance From the LSU Transaction in SAP select Validation Options Page 0 eG Ka aie Z Option GLSU Send configu Ses ses ss es sd E 2 Make sure you re download your INI file after making your text selections 3 Inserta blank column into your spreadsheet where you want the master data text to appear Foran explanation of how to add a blank column see the section on Ignonng Columns 4 Optional Type ina column description into your blank column header 5 Inthe blank column type the formula glsu_description xx where xx equals the cell where the ma ser data element is entered In this example the E column is being referenced Page 71 Using descriptions with a live setting in GLSU If you are using live descriptions for certain fields in GLSU you may need to perfom a Refresh Desc nptions after utilizing Account Account Descr the GLSU description function 110002 refresh required 110005 refresh required If this isthe case the text refresh required will appear in 110005 refresh required each cell Upon selecting the refresh descriptions options in G LSU all of descriptions will be updated from SAP Inter Company Transactions Intercompany trans
39. Version 6 0 Financials Spreadsheet Uploader ZOption 417 Oakbend Suite 200 Lewisville Texas 75067 www zoption com 877 653 7215 972 315 8800 fax 972 315 8804 Page 2 This page intentionally left blank Page 3 Table of Contents MOGUC fo a Braessters as ars se ges ts st teen ge ree SS ee ee ee eee ee eee eee ee ee es ee ee 7 HOW DOCS GSU WV OTE ein ctivinsirs bene tessuvinndeadsnndtantvunsealnavanieairiaslanatandenitdvaieavived envatedbuventnatdawestecncind 10 CUSTOMIZE YOUR prcad NECS vaca ciciaca cen siaasn an a aed 11 CUSTOMIZE DY Dep Ge IN ss cene he eceicetvsnaitet ceraiatvesaitisl sone eiviaeid ene ais eerie 12 Validate Data before POSLING ccccssccccceecssssssseeeeeeesssssnneeeeeesessssseneeeeeesessssnneeeeeesesassnneeeeeesessags 13 DETINONOT USEIS sanun aa ia aiaiai 14 Whats Newin GEU 2 ccisccssesasvnacrtnag seseasiunuciiaqsduatuiuesavuaagduasan A 15 WX Gre aa so aia ese eee et er E 17 Ge nhing SIGHS seca retten tactician 20 Getting Started for Premium USMS cccccccccccceessssssssssnseeeeeeeeeeeeeeesssssesssseeeaaaeeseeeeeeeeesessssseseegs 21 Step 1 Maintaining the GLSU LICENSE Premium Only cesessssseeeeessssssseeeeeeeesssssseeeeeess 22 Step 2 Maintaining Premium Users Premium ONMY c ccccccsssssecessssseeeessssseeeeeessseeseeeessseneeess 23 Step 3 Maintaining Standard Users Premium ONMy ccccccccsssssecesssssseeeessssseeeeeesssseeeeesss
40. able Table Table Transaction Transaction Table Type TABL TABL TABL TABL TABL TABL TABL TABL TABL TABL TABL R3TR R3TR R3TR ZOPTION UVERET ZOPTION LV_IN ZOPTION LV_OUT ZOPTION MSG_ LOG TX ZOPTION PIC KUST ZOPTION VAL ZOPTION ZBAPIRETURN1 ZOPTION ZBSEG ZOPTION ZDATA ZOPTION ZOG ZOPTION GLSU_VAUDATE TRAN TRAN TTYP View Maintenance View Maintenance Data Data Data View Maintenance Package R3TR Package R3TR Package R3TR DEVC DEVC DEVC ZOPTION GLSU ZG LSU ZOPTION T_BBSEG R3IR VDAT V_FILENACI R3IR VDAT V FILEPATH R3IR VDAT V PATH ZOPTION COMMON ZOPTION GLSU ZG 11
41. able teat unicode 05 13 2014 Pestable TAESTE E 05 1 gt Choose Cancel h Saven p Windows C a kalale Name Date modified Type a i atemp 1 16 2015 233446 PM File foldes E SRECYCLE BIN 2 21 201411 55 AM file folder dell 4 2 2014 9 28 AM File folder A Document and Settings TAA 12706 AM File folder hp HLI 4 13 AM File folder ine 2 71 2014 4 16 AM File folder bt Office 2010 Developer Resources 12716 2014 37 AM File folder F PerfLogs 71342009 10 20 PM File folder di Program Files 1721 2015 9 03 AM File folder A Program Files x86 S S 2014 440 PM File folder ProgramData S 3 2014 443 PM File foldes Recovery 1 2011 10 12 AM File folder F SWSETUFP A212014 11 55 AM File folder Lalle alel nahin TEA a e Sevesstype Ewel Templates txt Bo Cancel 1 Click the Download a spreadsheet template button from the ABAP program ZGLSU Highlight the approprate template and click the Choose button 3 Us the tandard Windowsdialog boxto choos a file name and directory on your PC to store the file Click the Save button when finished Premium Users will be able to maintain the Spreadsheet Templates that are stored on your SAP system Premium Users will be able to upload new templates from their PC to SAP Premium Users will also be able to rename the templates which are stored on the SAP server If you do not have access to this functionality you will need to be set up asa Premium User or have yourCompany s Premium User do this
42. ace Enter only relevant SAP data items for your specific application Customize the orderof fields All rea dsheet customization isdone through dialog boxes which let you choose and order fields from a pick list Adding changing ordeleting fields takes seconds 2 Build data entry applications Form input monthly close packages complex allocations rebates accruals etc can all be automated using GLSU Different prea dsheet templates can be created stored on the SAP server and distnbuted to your workforce quickly 3 Pre verification of data BEFORE posting GLSU can check your input data against SAP master data to wam of potential emors before posting occurs About your User Guide This guide will help you leam how to use GLSU by ZOption It will also serve asa reference as you attempt more sophisticated techniques The first chapter descnbesthe high level concepts about how GLSU works The second and third chapters explain the detailed functionality of the GLSU soreadsheet and the SAP portionsof the product respectively This guide assumes you are already familiar with basic Windows and Microsoft Excel concepts menus dialogs mouse operations such asclicking and dragging This guide also assumes you are familiar with basic SAP concepts posting parking batch sessions etc If you need more information on these subjects please referto the appropnate Microsoft manuals or your SAP documentation or administrator For more informa
43. actions are posted using G LSU in the same way they are done through the on line screens The user will populate field NEWBK the New Company Code field in GLSU if they want the specific line item to go to a different company code than the one listed in the headerof the transaction IMPORTANT You cannot populate the NEWBK field in the first line of a GLSU spreadsheet The first line of the spreadsheet must be booked to the company code shown in the headerof the spreadsheet This isa requirement of the SAP interface used by GLSU and cannot be changed GLSU will use the contents if any of the NEWBK field when determining if an account or other master data item is relevant to that company code G LSU will use the clearing configuration already set up for yourcompany The intercompany cleanng process must be properly configured forGLSU to work conrectly Populating the NEWBK field will affect all subsequent line items Example You are attempting to posta 5 line document You use company code 1000 in the headerand want the 4th and 5t lines to go to company code 2000 The spreadsheet should be populated as Shown below Both lines shown in yellow will be booked to company code 2000 B C D E F 3 3 Header 4 A 3000 1 2 2015 1 2 2015 USD 5 T Cine tems krat Account Account Descr balanced New co code o 40 46000 Other loans short term 40 9 50 4766000 Miscellaneous Expense 10 10 50 4 6000 Office supplies 10 11 12 13 14 15 16
44. ate time and SAP document numbers 4 Clear Upload History Clicking on this button will delete ALL history from SAP about what files have been loaded under your ID 5 The Print Upload History option will disolay an SAP pnnter fnendly verson of the listing see below Page 88 el al IH CQA Z Option GLSU Print History GLSU Upload History Report System ZD2 Client 800 Us Filename Date i 2 Test Workbooks Post test multi ZGL 01 21 2015 11 32 02 10002853 2 2 Iest Workbooks Post test multi ZGL 01 20 2015 11 14 23 10002853 2 TIest Workbooks Fost test multi ZGL 01 20 2015 11 05 27 2 TIest Workbooks Post test multi zZGL 01 20 2015 11 04 35 ee 2 TIest Workbooks Post test multi ZGL 01 20 2015 11 04 13 Page 89 Spreadsheet Templates Spreadsheet Templates can be stored on your SAP server This functionality allows the efficient distribution of templates to your SAP users It also allows for your users to geta quick head start when using GLSU forthe first time Standard Users can download the templates Premium Users can Download Upload Rename and Delete the templates which you have stored The following pages explain the Premium User functionality in greater detail DOWNLOADING a template from SAP to your PC isan easy process There are two ways to do this You can download the template from the SAP ZGLSU transaction or from the front end Let slook at the GLSU front end method first 1
45. but it ishere when needed 4 Save and Exit Save the map foruse later Mapsare saved in the workbook by sheet so that they willbe available when the workbook isopened again later 5 Save and Import Save the map to the workbook AND proceed to import the data into the GLSU template Don t wony If the data isnot mapped nght you can come backand modify the map then reload the data again 6 Preview The data preview pane showsone record ata time vertically to assst in field mapping 7 Preview Navigation The NEXT and PREV buttons step through the preview record set Note that the mapped data changeson the left asthe preview record changeson the nght Page 97 Mapping the Data To map the data coming from the record to the GLSU template fields simply click and drag the data set from the Example Data window to the left and drop iton the Primary Map in this example Drag overone data field ata time until you have completed the data mapping Use the PREV and NEXTbuttonsto step through the records The data in each window will change showing just how the data map is working Note that the import mapping will only step through the records that were previewed on the pror screen If more records are needed to visualize all of the different typesof records that will be imported save and exit this screen change the PREVIEW value from 10 to something higher and then re enter the data map Use the Clear Single Link button to undo a mapping
46. cations code controls the functionality of the spreadsheet This Visual Basc code is stored in an Excel add in Typically the ABAP and the Visual Basic Add in are upgraded together However there may be times when Z Option releases new Visual Basic Add in separately from the ABAP New spreadsheet functionality could then be acquired without re transporting a new version of the GLSU ABAP code ZOption will provide application in the form of a SetupGLSU exe file to your Premium User s Once the VB code hasbeen received it will need to be uploaded to your SAP server NOTE You MUST perform this upload step for each SAP system client combination if you wish to deploy the PC components from SAP The functionality to upload new VB Add in isunder the Premium User Functions screen Click the Upload Add in button then browse to the location of the SetupG LSU exe file on your computer Select Open and then confim the upload Your Premium User s should then test the new VB code Once satisfied they should notify the G LSU users to download the new Add in Lookin j GLSU 2 Name Datemodified__ Tye setupGLSU exe 1 20 201510 11 AM Application a Excel Add In Installer z You are now finished with all of the Premium User only steps Please proceed to the next section Getting Started for Standard Users to continue the setup process Page 28 Getting Started for Standard Users T
47. cket System Page 113 Export a Document 2 Step Posting Process You may choose to post yourdocument to SAP using a batch posting method The batch posting method exports an uploadable file onto your PC Many times this will be used to troubleshoot an issue and may be requested by ZOption Support From the GLSU menu 1 Choose menu item Export Select Copy Filename to Clipboard Login to SAP via the SAP GUI if you are not already logged in Execute transaction ZGLSU Paste Ctri V the filename from Step 2 into the PC Spreadsheet Output File field Press the green Execute F8 button A MW PW N NOTE The file issaved under the same name asyour spreadsheet with a L extenson See Processing Export Files for more detailed information with screen shots about manually processing the files in SAP Custom Pick Lists For custom fields like ZZnnnnnn ex ZZCHAN Distnbution Channel there isnomally no pick list available However one can be created with a little help from an ABAP programmer All of the ZZnnnnn fields are candidates for custom field pick lists 6 BSEG NEWBK NEWBS NEWKO LECHAN OS Line items LODES se ty balance t Dist channel o 40 100000 J 50 100000 21 Have your ABAP resource look at the examples available in SAP function LOPTION GLSU_LIVE_CUSTPICK There isan example forretuming a custom ZZCHAN pick list that they can use as is orus asa template to build custom pick lis
48. cription field addssome automation to this process 9 From here on out if you add more line items you will need to copy the glsu_descnption function down to each line entered in orderto see the descnption NOTE Even though the Choose Fields selection list shows the column type as lt lt descr gt gt what is really going on is that GLSU isadding a lt lt blank gt gt column and automatically filling it with the glsu_descnption formula Don t get confused if subsequent vists to the Choose Fields screen show lt lt blank gt gt forthe descnption field This is correct Page 58 Ignore Rows You may also need to have rows in your spreadsheet which do not post line items in your document These rows could be sub totals or other items which are used for integnty checks of the document before posting Header Document type C Code ate ing Date Currency SA 3000 122015 VW2 2015 USD balanced Text 40 100000 80 50 100000 10 50 100000 10 50 100000 10 110 Sum 50 100000 10 50 100000 10 50 100000 10 50 100000 10 50 100000 10 1 Inthe first column of the spreadsheet type the words IG NORE COMMENT or SKIP Note for customers using a default language other than English These values will be in the native language you have installed and translated G LSU will then ignore these rows when creating the ZGL file 3 All other rows with data are posted nomally You can often use native Excel
49. document numbers will be recorded until the SAP job runs uD im Format Meaning 2015 1 2 2015 USD rae justified balanced Notes Centered e_ ett will be centered in the editor This line will Paragraph left aligned be the second line since there is a semi colon This d term 10 line will not be centered Continuous Text 40 Extended Line A Raw Line Line Feed Display Notes 300001 Line Feed and Extended Line x Fh us Line Feed and Raw Line A Fa L Row Tet R Command Line E a ee er ee ee ee E TAE This Teer vill b psmnt rsj in th editor iv Comment Line z Tiis Line will be tie Semmi Line simm There is a semi oolce i L Lisy PELL got be oeepered Page 75 Double Byte East Asian Languages G LSU supports the use of double byte character sets If you intend to use GLSU with one or more double byte characters sets you will need to make a couple of changes detailed below You will need the Unicode RFC Libranes on the desktop in the SAP GUI This can be found in the Development Tools section during the SAP GUI installation procedure for 6 40 and eanier For SAP GUI 7 10 or later this is automatic If you are unsure what you have installed please contact the department responsible for SAP GUI deployment First open your SAP GUI settingsand open the Code Page settings Under Upload Download Encoding you will need to select Unicode UTF 16LE and select OK Repeat this step foreach do
50. dsornot These radio button selections affect the entire GLSU installation for your SAP system and affect every user Standard Users will not have the capability to change these selections These radio buttonsalso have no relevance when a master data item is selected to be Live 4 Premium Only Off line INI or Real time Live These radio buttons will tell G LSU the source for pre validations pick values and descnptions If you choose off line all pre validations pick valuesand descnption values will come from the off line file that is sent to your workstation If you choose Live all pre validations pick valuesand descnptions will come from SAP in real time The more Live validations you configure the smallerthe PC footpnnt 5 Company Codes to Validate Choosng a range of company codes will limit all master data values to these rangesof companies when the validation isset to the INI setting this is not valid for real time validations If there are company codesat your organization which you never use orpost entnesto then omit them from your selection here Those values will not be saved on your PC s validation file 6 Sort Fields Radio Button This radio button controlsthe sort order of the pick list in the GLSU spreadsheet 7 Save Changes You must click on the Save Changes button for GLSU to store your selections Page 84 EP Ga Po om a af vr FF a Aa a ee me a eee oe ee ae E Coron Gii E T maoa Cor T
51. e Page 86 Maximum of Document Line Items If you are posting ta accounts which use taxes you may want to limit your maximum input to 150 lines SAP books multiple FI lines for accounts using Taxes You can have GLSU limit the numberof lines which are posted ona given entry You may want to do this because your entnesare longer than 999 lines SAP s intemal limit or because you are posting documents with taxes which book more FI line items than are entered by the accountant 1 Maximum Input Lines per Doc This parameter controls how many lines each SAP document will have When this limit is reached GLSU will start a new document until the lines are fully posted Append Counter to Ref Doc You have the option to auto increment each document if more than one document is posted This sequential counter is placed in the last digit of the reference doc field Balancing Account Info Clicking on the Balancing Account Info button will display the following dialog Enterthe appropnate posting values for yourbalancing account and save Page 87 Upload File History The second section of the ABAP lets you view the files you have previously loaded using G LSU GLSU Can prompt you if you are attempting to load the same file name in consecutive attempts GLSU can also delete the upload file after processing if thisoption is chosen to prevent the same file from being loaded multiple times eroneougy This
52. e Soreadsheet Control Functionality Customize GLSU spreadsheets P Download spreadsheet templates from SAP to their PC one Gada they have SAP access Manage Manage GLSUtemplatesstoredonSAP on SAP Help Support ZOption telephone ticket system support Yes No No Page 15 What s New in GLSU ZOption iscommitted to aggressive ongoing development of GLSU and its other software packages New features in GLSU verson 6 0 o NOU PWN FP 10 11 12 13 14 Park Documents to Non Leading Ledgers Sup port for 64 bit MS Office installations Download templates from GLSU directly asan initialization option Copy existing posted documents asan initialization option Select individual sheets for export validation and post park actions The menu ribbon will now read Post or Park depending which transaction is selected The local validation data isautomatically updated on the first login Import data from delimited files directly into a GLSU template This includes the ability to create offsetting entres automatically ifthe data is available on the incoming records Custom pick list support is available for custom fields ABAP function module coding is required Working examples are provided Automatically add a descnption field to a template foran existing field Document attachment sze can now be controlled by a Premium user The worksheet sze Is viewable in GLSU along with a breakdown
53. e activated but not mapped and a REF2 with constants and or calculations would be supplied Perhapsall of the columns in the offset row are always the same and only Amount value changes from record to record In that case use the above approach but map the Amount column in the Offset Map You can load a fixed length file as follows 1 Use File Open fixed width mode to open and slice the file into columns as desired 2 5ave the resulting workbook as a Tab delimited txt or Comma Separated Variable csw file 3 Use the standard import method for delimited files to pull the data into your GLSU template Page 101 Embedding Custom GLSU Buttons into a Template It is useful at timesto be able to build a template and add yourown buttons for VALIDATE and POST GLSU allows you to do this quite easly so that your most used menu actionsare embedded in the template The first step in thisprocessisto get accessto the Developer Tab 1 Go to File gt Options 2 Clickon Customize Ribbon 3 On the nght hand sde check the boxnext to Developer Excel Options j al r Customize the Ribbon Formulas ae Lhoose commands from Customize the Ribbon sia Popular Commands Main Tabs A anguag ii All Chart Typ Gii Mam ates n Borders b E Sf Home Advance Calculate Now amp F History Custom Center E F Insert Fa Conditional Formatting hs F Pane
54. e appropnate system via the SAP GUI A non used SAP GUI session ora newly created session oran existing document display session will be used by GLSU Click on a hyper linked document number to view it in SAP Document Num er ross CC no 2000 0100000061 7100028408300015 3000 0100028408 2000 0100000062 3000 0100026409 0100028409300015 Technical notes Two piecesof functionality must be enabled for this feature of GLSU 1 SAP GUI scripting must be on in the SAP GUI foreach desktop To enable this functionality from the SAP GUI menu select Customize Local Layout gt Options Select the Scnpting tab and then select the Enable Scnpting checkbox You will need to clos all SAP GUI sessions before the setting will take effect 2 Your technical SAP team will need to configure SAP system profile parameter sapgui user scripting to TRUE Posting or Parking Documents SAP financial transactionscan be processed in different ways SAP users sometimes choose to Park documents instead of immediately posting them GLSU allows you to park your documents if you choose These parked documents can then be released and posted latervia the standard SAP process Page 44 System System ZD2 Cent 800 Last Updated 1 20 2015 10 53 07 AM Add System Transaction Type Park Document f Validate Before Post Export Check Fie Upload History Export Active Worksheet Only C Export Range of Worksheets to Iv Auto R
55. e entry into SAP This may require many hours of unproductive data entry time by your processing departments or IT organization Maybe you are already usng a simple batch input loader but wih you had the flexibility to handle numerous requirements from different departments in your organization Maybe you wish that you could do batch input with fewer enors in a more timely manner GLSU by ZOption allowsan organization to streamline its financial data entry functions G LSU providesa flexible and intuitive soreadsheet interface forcollecting and posting transactions to SAP From smple recumng general joumal entres to allocations thousands of lines long GLSU solves many common SAP data entry problems Post directly to SAP without leaving Excel a i NON ommend p BRR ae i 153 3 o on ey Go amp r yy cand a Jt of dite T LLL gt Menu Edi Favonmtes Extras System Help ei J40 DHM anaa OF Og SAP Easy Access SS amp Aotermenn WHA w a Gheresteroie Brssionuses B FJ Favorites SAP menu Office O Cross Application Components t 2 Collaboration Projects 2 Logistics 2 Accounting O Human Resources t O Information Systems Tools Page 9 What is GLSU Far more than a simple batch load program GLSU usesa combination of configurable soreadsheet interface with a custom ABAP load program These two items work together to deliver deep functionality such as 1 Configurable work sp
56. e imported data to the end of your GLSU template It is useful when you have two or more files that are formatted exactly the same but contain different sets of data e g one file per week percompany code etc Import ALL records The system will import as many recordsas the file contains Import only a subset of records Enter the numberof records to load This is useful when testing your map all the way to actually importing a small subset of the recordsin the file Once everything looks good use the Import ALLrecords and Clear my line items and import the data settingstogether to clearthe template and import all of the data records Make sure you have the sheet active that you want to import data into The name of the sheet will show in the caption of the Map Fields screen Page 99 Importing Data Advanced With the introduction of the IMPORT feature two new keywordshave been created REF1 and REF2 These reference rows in the GLSU template work with the IMPORT feature to build moderate to highly complex data imports Here isan example of what one lookslike a GLSU template Line Items 1 A that Account balanced Text Cost Center Profit Center REF1 40 REF2 50 100000 The REF1 line istied to the Primary Map and REF2 istied to the Offset Map Let s take REF1 for example Normally when a Primary Import map iscreated you map what you like and may or may not leave some column blank If there isno REF1 row the mis
57. ecessary to insta Il the G LSU transport onto your development system Instructions for usng the GLSU Ticket System are also explained in the Technical Installation section at the end of the manual Once the GLSU transport has been installed the logical file path hasbeen configured and necessary authonzation profiles have been edited then it is time to move to the next section Getting Started for Premium Users Page 21 Getting Started for Premium Users Premium usersat your ste will be resoongble for maintaining the specific users who will be using GLSU After the GLSU software hasbeen propery installed on your SAP system use transaction Z LSU to start the G LSU program Premium user functions are accessed by clicking on the Premium User Functions button y Maintain Premium Users Maintain Standard Users To get started the Premium User s need to do the following tasks in order presented These steps are explained in detail on the next few pages 1 Maintain the GLSU license This step tells yourcopy of GLSU how many seats have been purchased by yourcompany 2 Maintain the Premium Users You willneed to name atleast one Premium user before anyone can post using GLSU 3 Maintain the Standard Users You can either have GLSU auto register the standard usersor you can name them manually Page 22 Step 1 Maintaining the GLSU License Premium Only The first step in getting GLSU running isto setup main
58. ected forced options the option would be displayed here and the other options would be disabled GLSU Options Workbook General Attachments The GLSU Premium user can set rules beset dan oe Attachments with split documents When a GLSU document splits based on the Maximum input lines per Doc as SAP System ID D2 configured in transaction ZG LYU G LY will attach the spreadsheet to all of the split Client 8 documents m Always attach the active workbook to the Attachments with inter company SAP Financial document l documents i When a GLSU document isan inter f GLSU will prompt the user each time a Company document denoted by NEWBK in document is posted your template GLSU will attach the Workbooks will NEVER be attached spreadsheet to the headerdocument t hen a Pe E pa ONLY A logical link exists in SAP under the intercompany document number Excel Upload from GLSU Excel GLSU functionality when inside the Business Document Navigator If you wish to perform additional functions with it rather than Just usng the Excel functionality within the Business Document Navigator ZOption always recommends extracting the source document from the BDS If GLSU descnptions orother GLSU functions contain a NAME select Reset Links to repopulate the cells View Workbook Size Report An additional feature isavailable to allow the userto see the workbook sze on disk This is especially useful when the Max Attachment Size
59. ed by other groups vendors for Payables customers for Receivables etc GLSU lets you tailor the spreadsheet for the needs of these individual departments These customized spreadsheets can then be stored centrally on your SAP server as Templates Central storage of these templates enables Consistency By having your processing personnel download these centrally stored Templates you Can ensure that your data isbeing entered in a consistent fashion Ease of distribution Central storage of the templates also facilitates the enterpnse wide distribution of these templates Everyone that hasaccessto SAP can download the templates NOTE G LSU Templates may also be distributed as Excel XLS files via other methodssuch as email FIP etc Department 1 Department 2 Account Customer Terms Amount Account Vendor Amount 3 Fields 4 Fields ALE O HOMI of OUT FORMULAS DATA REVIEW WIE DEVELOPER ADD INS SU HERA A a a Fo ae ee a i fee een EHEH re sa iii o Retrieve Validation Data T FE 1 i ra g ES a ee a ae Sj Show Validation Info Export Walda Review Option Choose Refresh import logovi Initialize Keset Show My ia GLSU Validation held Desoiption Lins Contacts Export Default Language Vernon inio Pr ng T AT li a gt G24 js B C D E F G l Header Document Type Company Code Document Date Posting Date Currency Doc HeaderText Document Number i SA 3000 Usp L
60. ed to log in Itis at this point where G LSU will determine which transactionsare allowed and which are not Premium users are exempt from these settings Enable Field Selection and Template Creation for Std Users This option controls whether or not standard usersof GLSU can accessthe Choose Fields menu item It might be used in conjunction with the GLSU template download feature to get all users of GLSU in an organization using the same consstent templates without the ability to edit their fields Premium users are exempt from this setting NOTE Only Premium Users will be allowed to maintain these technical options Z Option recommends that you consult either Z Option and or your BASIS administrator before changing any of these settings from their default values Page 108 Premium Only Create Off Line Validation File Since GLSU offerstwo methodsto validate Off Line and Real Time it may be a requirement to create a validation file foran extemal useror business partner Vendor etc independent of the site wide configuration configured by the Premium User Forexample in yourGLSU configuration you might have selected all fields which are available for Live validations This configuration creates the minimal footprint on the PC workstation This isan optimal configuration for an in house user with direct access to SAP However many customers use GLSU to create spreadsheets which can be used off line Snce the pre validation pick lis
61. eneess 25 Step 4 Uploading New Add ins Premium ONy cccccessscceessssseeeessssseeeeeessseeeeeessseeeeeessseneeess 27 Getting Started for Standard USMS ccccccccccccccssssssssssssnseeeeeeeeeeeeeeeessesssssessseaeesseeseeeeeeeesssssseseas 28 Standard Users Step 1 Set your GLSU Validation ChoOiC S ssssssesrressseeerrrrrrssrernrrnnrssserrrenne 28 Standard Users Step 2 Download Install the GLSU Add iN cccecessssssteeeeesessessneeeeeess 29 Standard Users Step 3 Create your first G LSU preadSheet cceeesscceceeessssssseeeeeeesssssseeeeeess 30 hi glam el g re obi g t ial Le 0 eee Bs a a a eo EP RS 36 Initialize New WOrkSNG eS ccccccccceecssssssseeeeeeeessssseeeeeeeesesssseneeeeeeesessseeuseeeseesessssnneeeenesessssssanseeeess 36 Add Delete COLUMNS sensein a a S 38 R amp T er Co UMN Skace a a a a a 39 BOSE UO UES I arrese auii a a a a a uaa ecetia tec teeest 40 Logging on with SSO Single Sgn On with SAP logon tickets esssssssssssseerrrrrsseerrrrrrreseern 41 Displaying Posted Document Numbers amp Mesa geS ssssssssssssrrrrssrrrrnrserrrnrssrrrrnrnrrnrnnenrrnnnnne 41 Document Number D ll Ba C K eesssesseseeeeeeessssseeeeeeeesessseeeeeeeeeeeessseneeeeseesessssenneeseeesesssssneeeeeess 43 Posting or Parking DOC UIMENES iosicavisssscistiecistvincdiaresiwiadivachutascinanavandpudedenan Avapiguseeennmaarisanonaabine 43 Accrual Deferral Booking Reversing DOCUMENNG
62. ent 8 tra A Z LSU is run on the client in question To have more than one choice e a available in the preadsheet Options menu you must run the Zs LSU A Veda leire Pactiequort 2 transaction in more than one SAP client Example To have both production and testing environment lw Show Posting Messages in Popup information you must run the ZS LSU transaction on both the productive and testing boxes This then downloads two unique files containing master data to your PC i Check File Upload History In order to help distinguish between workbooks for different SAP systems you may use the SAP system and client formula to display this information on the worksheet Simply add the formula glsu_sysid to any cell If you change systems in the Options of GLSU the system and client will change automatically NOTE It may be necessary to add a skip row to avoid a pre validation emor when adding this formula The SAP system choice does not take effect until the ABAP Is run on the appropriate SAP chent LSU stores each unique cllent s data in a separate INI file on your PC Page 63 Pre Validations GLSU givesthe user the ability to pre validate many of the values being keyed aswell asother key configuration components such asblocked indicators posting rules and many other conditions and constraints to ensure they are correct before they are posted to SAP If errors exist in data during posting time will be wasted in try
63. esize Columns Auto Format From the GLSU menu 1 Choose the Options menu item 2 Choose the Workbook tab 3 Choose the appropnate transaction type from the dropdown box If your requirement isto park to a non leading ledger you may add field LDG RP Ledger Group to the header of yourGLSU template and populate it with the appropnate ledger group value Page 45 Accrual Deferral Booking Reversing Documents On SAP systems 4 6x and newer GLSU will allow you to book accrual deferral documents as well as nomal postings and parked documents This is equivalent to transaction FBS1 in SAP You will need to tell G LSU explicitly that you want to book an accrual document as follows 1 Choose the Options menu item 2 Choose the Workbook Tab 3 Choose the Accrual Deferal option in the Transaction Type drop down box GLSU Options x Workbook General Attachments System System ZD2 Chent 800 Last Updated 1 20 2015 2 04 44 PM Transaction Type crua Defer Post Document Validate Before P Park Document _ Check Fie Upload Post Fo Show Posting Messages in Popup Export Active Worksheet Only Process Selected Worksheets Select C Export Range of Worksheets Ea Formatting Auto Resize Columns V Auto Format You will also have to add two new header fieldsto your spreadsheet These fields are only allowed with accrual deferral preadsheets Populating these fields i
64. ess for end users based on your specific SAP configuration Thiscan be configured by Premium users in the Default and Hidden Field List Note 2 The Load Document feature isnot meant to load parked documents and some other Fl 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 derved values etc 6 The pick list will then display Configure your spreadsheet It will configure all worksheets in your soreadsheets if you have chosen to initialize more than one 7 Click the Accept button This will then format all worksheets you have selected Page 38 Add Delete Columns GLSU allows complete control over which fields are available to the user Any field which isavailable in your Fl configuration may also be posted to via GLSU As yourcompany sconfiguration changes GLSU automatically updates the Possible Fields listing so that you always have access to the relevant SAP fields Use the anow buttons to move fields or you can also drag and drop the desired fields Select Fields Fields on Spreadsheet Field Descr Field Descr lt lt blank gt gt blank column BLART Document Type lt lt descr gt gt blank column BUKRS Company Code MONAT Period BLDAT Document Date KURSF Exchange rate 7 BUDAT Posting Date Translatn Date WAERS Currency XBLNR Reference BKTXT Doc Header Text BVORG Cross CC no BEL
65. fora single data element Use the Clear Pimary Map to clearout ALLof the mappingsfor the Pimary Map There are smilar buttons available undemeath the Offset Map Primary Map Sheet1 Primary Map Example Data Prev nea SAP Ftd GLSU Feld Desorption Colt Map to etd or Value Example data a cone Col Header Example data 5 Fi J1 USO B NET AMT 4 017 57 J B TEXT DEC PY MT MULUS KOSTL Cost Gerber i CT ETR 4L5510735 31 PACTR F 24 PROFIT CTR 3 52531 565 CEC PYHT Doggi lt 1 14 2014 i 553 i2201 Gear Single Link Cear Primary Map 4 007 87 Offest Map udan O OOOO Ol a SAP Fed GLSU Fad Description Cot Map to Fald or Value Example data 007 87 Lig rex 06231 66 gt MUNCY MF Tb 6500A 416510795 Page 98 Importing Data Please select from the following options 0 Import the data appending it to the existing line items Please select from the following options Import ALL records f Import only a subset of records Srecordsjsiosd a eel There are several import options available on the Import Data screen l Be 2 saN eaa Press button Import and Exit to start the import The process barand record counter will how the import progress Clear my line items and import the data This removes ALL of the data from your G LSU template before importing the data Import the data appending it to the existing line items This setting appends th
66. gt blank column lt lt desr gt gt bank column NEVWUM Speca G L ind NEW BK Mew 00 0008 DETK Amount in LC WriV ST Tax amount MiVSTS Le tax MAVSK Tax code MSERL Wio c disc iri ra Aridi oe Las ETT Ls In Use blank columns to store Excel formulas for calculations You can use the blank columns for the metrics used in allocations Description Columns Blank column are great for adding in yourown notesand fomulas but there isa pecial pupose blank column that you can use to automatically add descriptions to existing columns Let s use Posting Key asan example A Posting Key is just another number in the soreadsheet Wouldn t it be nice to have a descniption next to it forclanty and fordouble checking your selection Page 56 An added lt lt descr gt gt field isalso known asa Description Column Descnption Columns work best when the data to be descnbed isalready entered Forourexample we will use a GLSU template that has8 line items already entered Note that description fields are available for Headerfieldsas well To create a Descnption Column do the following From the GLSU menu 1 2 Choose menu item Choose fields Select item lt lt descr gt gt under either Headerorltemsand move it overto the right You may drag it over if you prefer Field Deso a Field Descr lt lt blank gt gt blank column NEWBK New co code NEWEBS Posting key NEWUM Special G L ind NEWKO Account DMETR A
67. he appropnate fields for posting you can order these fields in whatever order makes sense for yourapplication by using the spinner arowson the nght hand sde Select Fields x Feads in SAP Feds on Spreadsheet Feil Descr Feij Descr lt lt Dank gt gt Denk okr g BLART Document Type lt lt descr gt gt bank column 4 BUKRS Company Code MONAT Penrod BLOAT Document Date KURSF Exchange rate BUDAT Posting Date VWiWERT Tranctatn Date VARERS Currency XBLNR 86 Reference lt BKTXT Doc Hesjer Text BORG CrogsOC no BELNR Document Number AUGLY Cipariig perce ABST 8 lt Caicuilate tax DOKI Document wie Header Feki Feij Descr Fei Desci ccbank gt bank column HEWES Posting key lt lt ca mie bank couri HEWERO Account NEWUM Special G L ind WRETR Amount heal Eeki NEWER New Oo code gt I SGTAT Text DMETR Amount im LC KOSTL Cost Cerite Viet Tax amount PRCTR Profit Center PMVwSTS LC tax PT SK Tax Oboe SEAL Wid cder PVA Addit tax z Search Seanch Reset Show Hidden Fields Accept Cancel From the GLSU menu Choose menu item Choose Fields In the Selected Fields column choose the field you want to move Use the up and down anow buttonson the nght sde of the screen to change their order Headerand Detail fields work separately Click the Accept button when finished i a a E a Page 40 Post a Document GLSU gives you two waysto update your SAP sy
68. he first step to get GLSU on your PC isto download the GLSU Add in from the GLSU ABAP program GLSU spreadsheet functionality is provided by an Excel add in This add in contains the programming which makes GLSU work on your PC To get started you will need to 1 Set your GLSU validation choices 2 Download install the GLSU add in 3 Create your first soreadsheets This section will walk you through the initial stepsto post your first GLSU spreadsheets The following section Other Spreadsheet Features will detail the remaining G LYU functionality Standard Users Step 1 Set your GLSU Validation Choices The GLSU ABAP program will allow you to configure the GLSU validations to your requirements For most installations the UVE validation settings will make the most sense This setting causes G LSU to use live data to validate your workbook GLSU comes pre configured with this setting However should you wish to view or change these settings please see section Setting Your GLSU Validations Options For those itemsthat are not marked as UVE and are pulled to the front end for validations there is a choice that can be made between manually updating thisfile using the Retneve Validation Data menu item and automatic The Automatic setting isON by default Thisfeature will refresh the validation data automatically on the first login Thisiscontrolled by a setting on the General tab of the Options dialog GLSU Options Lang
69. hen you have added a new document type or legal entity Company code G LSU will allow you to insert SAP master data texts into your spreadsheets for presentation or documentation purposes You will put the GLSU descnptions into a blank column of your spreadsheet see the Ignoring Columns section Master data textscan be added in either the detailorheadersections Page 69 Adding Master Data Texts In the example below Column D isa blank column Column D contains an Excel formula glsu_description xx The xx in the formula isa reference to another cell in the ssreadsheet that containsa GLSU masterdata element in thiscase the account value in Column D The formula in Column D will retum the Account master description forthe account shown in cell D9 The cell isshown in yellow for emphass only H 9 gt A s D9 i A z C n D E 1 3 Header Document type Company Code Document Date Posting Date 4 SA 3000 1 2 2015 1 2 2015 5 T Cine items atest Gy Account Account Descr balanced a 40 Cafe Cts 20 9 50 10 10 50 10 11 The glsu_description xx fomula will work forany ma ser data element that GLSU pre validates including GLAccounts Vendors Cost Centers Profit Centers etc except Field Status Groups Specific stepsto include master data texts in your spreadsheets 1 Make sure your GLSU INI file contains the master data texts by choosing the Text checkbox forallthe appropnate fieldsin the ZGLSU transaction
70. ill fillin those blanksasthe recordsare imported There are a few neat tnicksthat the REF rowscan be used for How about coloring the background of the REFI row light green The effect would be that the import data would load and produce a green bar paper effect REFI and REF2 lines like this Line Items LLA it Account balanced Text Cost Center Profit Center REF1 40 REF 50 100000 would produce this look in the imported sheet It could help when trying to determine which imported recordsare from the Primary Map and which recordsare from the Offset Map Line Items iLa Account balanced Text Cost Center Profit Center REF1 40 REF2 50 100000 40 6510100090 4 017 87 DEC PYMT 416510395 50 100000 4 017 87 DEC PYMT 416510395 40 6510100090 4 017 87 JANPYMT 416510395 50 100000 4 017 87 JANPYMT 416510395 Note that the REF1 and REF2 rowscan be hidden once they are set up and tested What about calculations Yes calculationscan be used aswell It ispossble to derive data for say the Profit Center column based on Account and anything else on the imported sheet A VLOOKUP could be used on Account to lookup the associated Profit Center forexample Note also that if only the Primary Map isfilled in and the Offset Map is inactive then only a REF1 row will be needed Having a REF2 row will have no effect If the goal isto have the REF2 row fill in all of the columns for every record loaded then the Offset Map would b
71. ing to correct these enor GLSU lets the user choose the fieldsto validate against in SAP The SAP components of GLSU then download these valuesto the PC either in an off line or real time method depending upon your configuration of GLSU Pre Validation of data and SAP configuration isa large part of GLSU functionality NOTE As of GLSU 4 1 in addition to the validations seen from LSU gt Validation Options pre validations for GG BO Cost Accounting and Financial Account Line item validations with sster transactionsOKC7 and OB28 respectively are now checked In addition all configured coding block checks asdefined in table TRWPR usually including the following are also Included PAI exit for customer fields in coding block asset checks SD order checks funds management checks CO relevant fields Fl relevant fields MM relevant fields and joint venture checks These pre validations in G LSU will dnill back to the enor line or row in Excel Technical Configuration Note OKC7 and OB28 checks willbe performed when activation level isset to eithera L ora 2 The fields which are validated are chosen in the ABAP program See the section in the next chapter to leam how to choose which fields to validate against By default in a new GLSU installation all pre validationsare performed and performed UVE unless otherwise configured Validating the Spreadsheet After SAP masterdata valueshave been downloaded to your PC via the ABAP progra
72. into a template The data must be delimited with a comma pipe tab or other delimiter that can be specified The import system is great for pulling data exported from Excel SAP or another system directly into G LSU The import is fastand can be a great time saver Further if the data is available on the record an offsetting entry can be built This isall done in a user fnendly data preview and mapping environment To get started click on the IMPORTicon on the menu Ci Users Crew M My data hes headers Data dolmiters t pram e Comma C Tab EE USD NOY 5 NUUS USO H S ALS E USD NO gt NUSO USD AY ALS Egg USD NOY S amp S ALE WSO A S AL E USD AY S amp S ALG WSO HAV WNLKE LED HIW NUKE USD ACY S amp S KUKE E1 i Eil Ji Ei E1 4i Ei Ji i amp eebBeeseeE SE CUR TERMS PMS CO CODE PKH PKI DOC HEADER TEXT 505231889 SOGi31 873 SOS21 873 06231 673 MOLI 1 E75 SOG SOG231 878 S529 1 878 06251 8786 DEC PYMT 50004062 JAN PYMT Soon4082 DEC PYMT S100555 LAN PYMT 50006554 DEC PYMT 50004067 JAN PYMT MOGE CLT PYMT 0000ga RO PMT S02 DEC PrMiT S000063 VENDOR INVDATEINVe GROSS 1 14 2014 iJia aois 1 14 2014 1 14 2014 1 14 2014 1 14 2004 1 14 2014 1 14 2014 1 14 2014 1 14 2014 BEF 122013 4 007 5 BOON 4007 83 873 112013 780 38 873 122013 700 8 B7301 700 g75 122013 1 320 l B7E AiMiS 1 320 14 S7E 102013 1 682 1 Ore 112009 1 682 1
73. ke sure you have read understood and agreed to the End User License Agreement signed by yourmanagement SAP Requirements SAP System version 4 7 Enterprise or later All GLSU installations are Unicode compliant Transport install package from ZOption User autho nzations for transactions FBO1 FBV1 FBS1 FBB1 as needed and othersaslisted in Section 3 of the Technical Installation at end of this manual Minimum PC Requirements Windows Vista 7 8 8 1 or 10 32 or 64 bit OS Microsoft Excel 2007 2010 or 2013 32 or 64 bit SAP GUI Currently supported verson from SAP Hardware asrequired by Windows OS version GLSU supports double byte character sets East Asan Languages GLSU supports the use of SSO via SAP SNC Secure Network Communication If SNC is propery installed on the desktop no additional setup stepsare required in GLSU GLSU supports the use of portal and multi portal login via a custom Java servlet solution For more information please contact Z Option Support PC Application must be installed as an Administrator Manual Version This is GLSU Manual verson 6 0a Page 6 This page intentionally left blank Page 7 A ion Shak Q k tens howl _ Ry r i 2 Page 8 Introduction Have you ever wished foran easier way to get financial data into your SAP system Chancesare your Organization uses many homegrown applications and or spreadsheets to pre process your data befor
74. l provide additional GLSU functionality The functionality isaccessed by new items in the Excel Ribbon These menu optionsare explained in detail later in the manual Add Ins Add ins available Analysis ToolPak Analysis ToolPak VBA Euro Currency Tools Fubbonx Visual Designer Solver Add in Cancel kal Z Option Glsu Browse Fj Z Option Gisu Fubbon Automation Because GLSU is not written with Excel macros there is no nsk of having virus problems l T OPPN DEA when installing the GLSU Z Option GLSU General Ledger Spreadsheet Uploader code via the add in V5 2 150114 All Z Option add ins are digitally signed for your protection Page 11 Customize Your Spreadsheets Each column in the GLSU spreadsheet represents an SAP data element for posting There are columns for each headerand detail field which could be populated GLSU allows you to customize which SAP data elementsare available on your spreadsheet Each useror department can use GLSU in a way that is intuitive forthem Adding changing ordeleting fieldson the soreadsheet even PA charactenstics isconfigurable and doesnot require re coding of the spreadsheet or the ABAP load program Example Accountants may not care to validate against customersand the Receivables department may not care about Vendor master data Page 12 Customize by Department Each of yourdepartments may have a set of fields which are unique to them but are rarely us
75. logging into your portal you may open your GLSU workbook and attempt to connect to SAP Upon logon attempt you will not see the standard logon dialog asisdocumented in the previous section Instead you will see the logon dialog seen to the left You must select the SAP system you wish to logon to and enter the client You will not be required to perfomm this step on subsequent GLSU operations unless you attempt to process another workbook which is assgned to another SAP system you exit out of Excel or explicitly log out of SAP from Excel 4 7 Option SAP System Selection Enter the 54P Client 1 g0 External Internal External Internal External Internal External Internal External Internal External Internal External Internal External Internal System Selection Alternate System Selection G elect Cancel Displaying Posted Document Numbers amp Messages G LSU will retum posted SAP document numbers to the spreadsheet in a popup You can also have the document numbers retumed to a special cell in the spreadsheet From the GLSU menu 1 Choose menu item Choose Fields 2 Selectfield BELNR Document Number 3 Select Accept Upon a successful posting all document numbers posted will be displayed in this cell when it is available in the worksheet Page 42 If documents are posted all of the document numbers will be displayed in thisfield with their cormesponding company code
76. lps work insde SAP To see the lists of master data values 1 Put your Excel cursoron a field 2 Rick click your mouse from that field 3 Pick Pick GLSU Values 4 Onthe Choos a value for dialog choose the appropnate master data value Posting key Account maT GLSU Values or Press F4 while in the cell Bl i Right click on the cell and select Pick Paste Speciala Pick GLSU Valuese Choose a vale for Account Acct Block Description 101000 Petty Cash Freight 10212100 Depreciation of equities Designated Trading IAS Any of the columnsin the Choose a value dialog box may be sorted by clicking on the column header Subsequent clickson the header row will sort the fields in ascending or descending order 100000 100009 1001000 10045000 10045001 10045002 101000 102000 102009 Petty Cash local currency Petty Cash customer pymt in local currency Land Equities Designated Trading Bonds Designated Trading IAS Treasury Stock TAS Petty Cash Freight Petty Cash German DM Petty Cash customer pymt in German DM Page 48 NOTE lf you choose a field that you do not have configured for pick values then the Choose a value dialog will not appear For all date fields a calendar will be disolayed to choose an appropnate date GLSU handles date formatting differences between Excel and SAP aslong asExcel recognizes the cellasa date GLSU Date Selection January 2015
77. m the GLSU spreadsheet can use these valuesto tell you if you have keyed in eroneous data before posting The validation can be performed either off line against an INI that resides on your PC or real time against live SAP data ora combination of both methods To perfom a validation 1 Choose Validate 2 Ifthe document doesnot have master data enors you will see the No Enors Found dialog box NOTE If you DO have erors you fix the errors with the procedure described on the following section Page 64 GLSU Validation ii No Errors Found To perfom a validation 3 Choose Validate 4 Ifthe document doesnot have master data enors you will see the No Errors Found dialog box NOTE If you DO have enors you fix the erors with the procedure described on the following section To correct multiple errors 1 Choose Show Validation Again 2 This will show you the previous listing of emors which were discovered without the overhead of reprocessing the validations This will horten the length of time it takes to corect multiple emorsona spreadsheet Show Validation Info Since validation pick values and descnptionscan be perfomed either off line against an INI that resdeson your PC orreal time against live SAP data ora combination of both methods GLSU provides information about the current configuration of these options If you are a Standard user of GLSU you will not be able to change these setting
78. m Only Default and Hidden Field Ust wo cccccsssssssssssssseeeeeeeeeeeeeessessssesssssseaeenees 104 Premium Only Maintain Technical OptonS ssssssssssserrrssssrrrsserrrnrserrrnrennrrrnnnerrrnnsnrrnnnnsernnne 105 Premium Only Create Off Line Validation Fil s sssssssssresessseeeeeennnrrrnrnrrrnsnneeennnnnnrnnnnnnnnennnne 108 Premium Only Default User SQttingS sessserrnessseeerrrrrssserrrrnnrsssernnrnnrssserrnrnnnnsnrernnnnnnsneennnnnne 109 ee OMI Si OCI Osroena 112 Getting Help from your Premium USCIS 2 0 eecccccccesssseeeeessseeeeeeessseeeeceessseeseesessseeseeeessseaeeeeesssgaes 112 Using the ZO ption Tc Ket yeman a 112 Export a Document 2 Step Posting Process ccccccccccccesssssssssssnsseeeeeeeeeeeeeeeesssssssssseensseeees 113 USE 10 PIG SES sirri A A cnt distnii talsiiats 113 TEchnicah Nsigllalon ccc KAS aA RA AAs 114 Trademarks SAP isthe registered trademark of SAP SE Microsoft Excel isthe registered trademark of Microsoft Corporation All other trademarks are the property of their respective owners Copynght 1999 2015 ZOption Incorporated No part of this User Guide may be reproduced in any fom orby any means without the pror wntten pemission of ZOption Inc Notice Page 5 This User Guide as well asthe software described in it is fumished under license and may only be used or copied in accordance with the terms of such license Before using this software or reading this user guide ma
79. mount in LC WRETR Amount When you push ordrag a lt lt descr gt gt field over you willbe shown a Format Descnption Field pick list This list is meant for selecting by double clicking the existing GLSU template field that you would like descnbed Format Descnption Field Describe whieh fread Descr Account Header Contents Posing hey Derr Fed Value gisu_desciption OK Cancel You can add asmany description fieldSas you need and drag them wherever you need them while still in the Choose Fields screen Pressing AC C EPT will close the Choose Fields screen and insert the lt lt descr gt gt fields that you have created Page 57 6 Note that the Descnption Column is populated with the requested information For those descriptions that come up as refresh required this meansthat the master data is missing these values To resolve this find and click menu item Refresh Descriptions Posting key Posting key Descr Account balanced 40 Debit entry 100000 5 50 Credit entry 100000 2 40 Debit entry 100000 3 50 Credit entry 100000 4 40 Debit entry 100000 5 50 Credit entry 100000 6 40 Debit entry 100000 7 50 Credit entry 100000 6 7 Note how allof the rows that have data Posting key in ourexample are given a description 8 Clickona description cell to see the underlying glsu_description function While this function could have been added manually the lt lt descr gt gt des
80. n a normal posting spreadsheet will result in a posting enor 4 Field SIODT Reversal Date Field Page 46 5 STGRD Reversal Reason Foreign Currency Adjustments On SAP systems 4 6x and newer GLSU will allow you to book Foreign Currency Adjustments documents as well asnommal postingsand parked documents This is equivalent to transaction FBB1 in SAP You will need to tell GLSU explicitly that you want to booka Foreign Currency Adjustment document by 1 Choose the Options menu item Choose the Workbook Tab 3 Choose the Post Foreign Currency option in the Transaction Type drop down box 4 When choosing fields for your template add any additional amount fields such as DMBIR Local Currency and or DMBE2 Local Currency 2 and or DMBE3 Local Currency 3 Transaction Type Workbook General l Attachments l System System 7D Client 800 Last Updated 1 20 2015 2 04 44 PM Add System Post Document Validate Before P Park Document Accrual Deferral Check File UploadiiEN ase elkellircrint Show Posting Messages in Popup Export Active Worksheet Only Process Selected Worksheets Select Export Range of Worksheets to Formatting e Auto Resize Columns e Auto Format Page 47 Master Data Value Lookups GLSU allows you to look up certain ma er data elements inside the spreadsheet This functionality works simila dy to the way search he
81. ndependently of each other They may also be posted independently You will also use this functionality to initialize a new spreadsheet for G LYU entry To setup a new workheet in an existing soreadsheet 1 Choose Initialize Initialize Worksheet Are you sure The existing worksheet will be overwritten 2 Inthe message boxInitialize Worksheet Choose OK 3 You can choos from 1 of 2 options The first will create a new GLSU template with no data only blank fields you select The second option allows you to retneve data from an existing SAP Financial document GLSU Initialize Initialize from a stored template Initialize from a SAP Document x a Page 37 4 Inthe GLSU Options dialog box choose a single worksheet a range ora select list of sheets This will initialize the soreadsheet but not format it them 5 OPTIONAL If you chose Initialize from a SAP Document you will see the following Load Document om Document Company ox cancel Enter an existing SAP document number Company Code and Fiscal Yearand select OK Note 1 Only fields selected in GLSU will be populated with data i e if field SG TXT Line Item Text hastext in the SAP document but field SG TXT is NOT in the GLSU template orhasbeen suppressed by one of your Premium users GLSU will ignore the values in SAP Premium users may want to configure SAP to alwaysignore certain fields to streamline this proc
82. ning the program at 8 38 in the moming would have a filename like ZOP_GLSU J SMITHO83079 in the path you defined in step 2 2 Repeat 2 3 asnecessary forall your system ids When you have finished creating the logical file names press the SAVE button or choose the menu item Table View gt Save Asan altemative configuration method you can choos to create one logical filename definition as ZOPTION GLSU POSTand transport it throughout your landscape It isimportant to note you must use extreme care when utilizing thismethod Use appropnate vanablesas this path will be used in all systems including production unless you choose to maintain the entnes separately in each system In the case of a mixed logical filename configuration one that containsboth a ZOPTION GLSU POST SD entry and a ZPTION GLSU POSTentry the SD entry willbe used if one isavailable and then the entry without a SID 2 4 Record the transport number as this will have to be transported to all systems where GLSU will be run Page 117 KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKEKKKKKKKKKKK SEC TION 3 SETUP USER AUTHORIZATIONS KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK UPG RADE NOTE IF YOU ARE UPG RADING FROM A PRIOR VERSION most of the pror authorizations will still work the only addition isRFC accessif you want your usersto be able to post their documents directly from the Excel soreadsheet via RFC connection 3 1 The following isa li
83. now in place ensure that data ata company code level Cannot be viewed in the off line validation file off line and live pick list or off line and live description functionality unless the user has specific authonty to view the data For specific detailson what authonty objectsare checked please see Section 3 of the Technical Installation section Page 18 This page intentionally left blank Page 19 Page 20 Getting Started This getting started section is broken into three sections 1 Technical Installation This isdone by yourcompany s BASIS team and isthe first step in the process Technical installation instructions are detailed in the last section of this manual 2 Unlock the GLSU Licenses This step isthe second in the installation process Ittakesplace after GLSU hasbeen installed on yourdevelopment platform License Unlock procedures are done by yourcompany s Premium User s This isthe point where you will configure GLSU with the Premium and Standard Users 3 Posting your first spreadsheet After GLSU hasbeen technically installed and unlocked you will want to post your first smple preadsheet This section will explain the steps required to do this by introducing you to the basicsof GLSU s functionality The following section will explain GLSU s capabilities in much greater detail Step 1 Technical Installation Proceed to the last section of this manual This section contains the sequential steps n
84. of individual sheet gzes Allow Premium userto globally control accessto transactionsand the Choose Fields menu option forall users Pick lists now support pinning favonte values so that they stay on top forease of access Crosscompany document numbers are now retumed in the BVORG field Cross CC no and are linked to the crosscompany document New features in GLSU verson 5 0 l Load Document enhancement Facilitates quick creation of a GLSU template with data from existing SAP financial documents Show blocking indicatorsin pick lists for Cost center Profit center and Intemal 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 exclude from F4 pick lists Option to view SAP Message Long Text information in pre validation GLSU functions available in an Excel Ribbon Premium user controlled Default User Settings New features in GLSU verson 4 2 Page 16 l 2 Sup port for Windows 8 Exc el 2013 Sup port for Multi Portal SSO Single Sign On New features in GLSU verson 4 1 1 2 Pre validation enhancement for Cost Accounting and Financial Account line items within GG BO Sister configuration transactions OKC 7 and O B28 respectively configured coding block checks usually including PAI exit for customer fields in coding block asset checks
85. r Export routine Each time you either directly post the spreadsheet or export the ZG L file the validation routine will be executed Page 52 Check File Upload History GLSU helps prevent posting the a file twice by allowing you to check the SAP system pnorto posting so you Can make sure you haven t previousy uploaded the same file It does this check based on the filename of your spreadsheet GLSU Options 1 Choose the Options menu item from the Workbook General Attachments spreadsheet 2 Ifthe Check File Upload History checkbox is System Systemizp2iGient 800 _ ticked and a file with this same filename hasbeen Lest Updated 1 21 2015 9 25 35 AM previously uploaded under your username you will Add System receive a message boxsimilarto the one below Transaction Type Post Document Validate Before PostExport MagT ype i Check File Upload History 7 4 FF show Posting ee This fle was previously uploaded a oo est Vorkbooks Post test mult 2GL 2015012011 14 23 1028534 Export Active Worksheet Only s dTest Workbooks Post test mul 2GL 2015012011 05 27 100028533 oof Test Workbooks Post test mut Z6 2015012011 04 35 100025532 dTest Workbooks Post test muti ZGL 2015012011 04 13 100028531 C Export Range of Worksheets 2 Test Workbooks Post test multi ZGL 2015012010 57 31 100028530 oo est Vilorkbooks Post test mult 2G 2015012010 56 12 100028529 2 est Workbooks Post tes
86. ra particular SAP user ID when diagnosing issues the utility should always be run underthe SAP user ID in question To run the GLSU installation check go to transaction Z LSU in SAP and then type check in the SAP command box The GLSU installation checker checks these items Transport import of GLSU data transports 2 Open wnite transfer close and contents of temporary work filleson local and remote SAP application servers Generation status of SAP standard load programs Authonzations for posting parking accruing batch session management file system access immediate job submisson and the vanous RFC requirements needed to connect from Excel If an SAP authontty object is checked the authonty object and the arguments will be shown A sy subrc O indicates the check was successful forthe SAP userID under which the check wasrun Any number other than 0 indicates that the check failed and may require attention S_BICH_ADA BIGADAIN sy subre 6 5s BDC_MONI BDOCGROUPID FI sy subrc 0 S_BOC_MONT BDOCGROUPIO sy subrc 0 Ss RFC ZOPTION GLSU sy subre 6 5S RFC Z0FTION COMAMON sy subrc 6 5_RFC RFC1 sy subrc 0 gt RFL SRFC Sy subre 6 S RFC SUSO sy subrc 0 S_RFC SYST sy subrc 0 S_RFC SYST sy subrc 0 S RFC RFCH sy subrc 6 0010 F_BUKF_BUK Post Accrue sy subrc 0 0011 F_BUKF_BUK Post Accrue sy subrc 0 1666 F_BUKF _BUK Post Accrue sy subrc 0 2000 F_BUKF_BUK Post Accrue sy subrc 0 3000 F_BUKF_BUK Post
87. rkbook NO the user is not allowed to attach the workbook O PROMPT the user about attaching the workbook USER let the user decide about attachments Description Excel sl ai from GLSU Job Wait Time sec Allows you to synchronize GLSU with the parameters you have set forbatch processing at yourcompany After the specified number of seconds GLSU will retum a message to the user saying that they need to try their posting again later NOTE When job wait timesare reached neither long texts nor BDS document attachments can be saved because no document numbers will be recorded until the SAP job runs Doc Retention days Thisoption will control the amount of time that GLSU remembers files that are uploaded by each user GLY will forget filenames loaded by users when they become older than the numberof daysspecified Page 106 Disable Load Balancing When selected this option will force the background job to run on the application server that the user islogged into When not selected the default setting the background job isrun in an available batch work processlike any other job Maximum Rows Returned for Live Pick Lists The value entered here specifies the maximum number of records that will be retneved to avoid long runtimes for real time live pick values The default value is 1000 entres Job Class Thisoption specifies which job classGLSU background jobs will be submitted as The possble entnesare Class A High Prony
88. s thisisdone bya Premium user at yourcompany but you will be able to see how each of the validated items is configured To see the configuration of the off line versus real time elements perfom the following 1 Select Show Validation Info 2 Ifthe validation info is stored locally on your PC you will see Stored on PC along with the number of entnes 3 If the validation info is retneved ina real time fashion from SAP you will see Live from SAP 4 Fornon static entnesorentnes Vahdaton Info Sy Stem i 208 Cheni 800 Source Prout Types Stored on PE Company Codes Stored on PC Accounts Live from SAP Asset Live from SAP Cost Elements Live from SAP Feld Status Groups Live from SAP Live from SAP si 153 83 24 47 Page 65 which have a large number of records you may want to consder switching to live for better performance For static entnes you can reduce SAP application serverload by configuration the elements to be stored on the PC INI Page 66 Correcting Errors in the Spreadsheet If the validation performed in the previous section finds an enor a dialog box will disolay which shows the errors found The picture below shows an enor involving an incorect GLaccount Errors Found During Validation Type Cell Error E C8 Account 100001 not found in Company Code 3000 E A8 G L account 100001 is not defined in chart of accounts CAUS Go To Error More If multiple
89. s first Document number 1000 2200003760 2000 2200000211 3000 2200000029 In addition to displaying the document numbers GLSU can also display all of the posting messages from SAP From the GLSU menu 1 Choose menu item Choose Fields 2 Select field ZWO PMSG S 3 Select Accept Posting Messages Posting takes place in previous fiscal year Document 2200003766 was posted in company code 1000 Intercompany documents will not be populated in this field as only messages which are displayed in the SAP session are Shown here Since SAP doesnot show crosscompany documents in this log neither doesGLSU Both of these special fields can be dropped usng GLSU dropped header functionality When the fields are dropped the document numbers and posting messages will be populated in their respective positions for each new dropped header document that is created Page 43 Document Number Drill Back GLSU is delivered with the capability if the document number field BELNR is present on the sheet and populated with an SAP document number to dnill oack to the document in an interactive SAP GUI sesson The document number and in the case of intercompany entnesthe comesponding company code will be disolayed in the document number field asan Excel hyperlink You can simply click the link of the document you wish to view and you willbe taken to an SAP document overview screen FBO3 You must already be logged into SAP in th
90. s folder or click Change to install to a different folder Ga Install GLSU to G C Program Files x86 Z Option GLSU lt Back Cancel Page 30 Standard Users Step 3 Create your first GLSU spreadsheet Once the GLSU Add in hasbeen downloaded to yourPC and activated you may now begin using GLSU To proceed you may either Initialize a new soreadsheet ordownload an existing template from the SAP server This section explains how to set up a spreadsheet from scratch The next section explains how to download a template which hasbeen created and customized by yourcompany s Premium users To Initialize a new spreadsheet perfom the following steps 1 Download and activate the GLSU Add in See the previous section for detailed instructions 2 Choose GLSU from the Excel Ribbon if not already selected 3 Choose Initialize T Lil a H i E j Ta 4 Inthe Initialize Worksheet dialog box choos OK Initialize Worksheet Are you sure The existing worksheet will be overwritten 5 On the next dialog box select Initialize NOTE There are instructions for the Initialize from a SAP Document option later in this manual Page 31 GLSU Options System Last Updated 1 20 2015 10 11 32 AM Add System Transaction Type Post Document M Validate Before Post Export Check File Upload History M Show Posting Messages in Popup Export Active Worksheet Only Proce
91. serata time In order to set these values one Premium user will change their valuesto the appropnate valuesand then amply select the Save Defaults for All Users pushbutton NOTE All existing G LSU user settings which DO NOT ALREADY HAVE A VALUE SAVED FOR THAT FIELD will be overwntten with the Premium userssettingsand values All newly registered GLSU users settings registered afterthe Premium user performs this action will also be created with these default settings If a mistake ismade the Premium usercan reset to factory default settings by selecting the Reset for All Users pushbutton This will remove ALL settings which were created by this feature AND custom settings which were created by end users Please be cautious when using the Reset for All Users function This functionality doesNOT create settings for SAP IDs which are not registered GLSU users Balancing Account Info a2 check H X Page 110 This page intentionally left blank Page 111 Trouble Shooting Page 112 Troubleshooting Getting Help from your Premium Users Standard Users should raise all first level support issues with their Premium Users per the Software License Agreement signed by your principals If there isan issue which requires additional support the Premium user may alwaysopen a support ticket but all resolutions and communication must be performed through a Premium user This helps ZOption keep your maintenance costs below industry
92. sng values will importasblankas expected However what if the requirement is that the posting key is 40 for every row Looking atthe example above notice that REF1 hasa posting key of 40 This is constant As long as the Posting Key column isnot mapped the value 40 will be used for every primary record Some imports may only have a 1 1 correlation between the number of recordsin the file and the number of records being imported However if an Offset Map iscreated we have a 1 2 conrelation between the number of records being imported and the number of recordsactually imported The Primary Map will always import data but the Offest Map will import data only if itistumed on in the mapping screen Let stake a look atthe mapping screen forthe example above Notice how the map displays the incoming data with a REF1 row in place Primary Map SAP Field GLSU Field Description Col Map to Feld or Value Example data NEWBS Posting key REFI default NEWER Aocoumnt 18 G L ACCT 6510100090 WRETR Amount NET AMT 4 017 87 SGTAT T t TEXT DEC PYMT KOSTL Cost Center 5 CST CTR 416510395 PRCTR Profit Center PROFIT CTR Notice how the REF1 value bleeds through to the Primary Map This means that for every row that is imported the value of account will be 40 Itsa constant Page 100 The same is true forthe Offset Map and the REF2 row In this case the Offset Map would have blanks unmapped columns for both Posting Key and Account The REF2 row w
93. snot common to all application servers the financial document number may not be retnevable by the GLSU application snce the document number is retrieved from these files SAP Upgrade Notes If you are upgrading your SAP system from any 4 0x 4 5x 4 6x or 4 7x verson to any of these versons you do not need a separate transport fom ZOption Although there are sgnificant differencesin the SAP repository components for these SAP versons ALL of the objects necessary to run in each of these environments are delivered with the one codebase Therefore an upgrade of the ZOption software isnot necessary unless you desire new Z Option functionality in a later release of GLSU Transport object list for G LSU Object Directory UMU ADIR R3TRSOTR ZOPTION GLSU Table Definition UMU TABD ZOPTON GLSU TEMPLATE DATA Table Definition UMU TABD ZOPTON GLSU TEMPLATE UST Class ABAP Objects R3TR CLAS ZOPTION CL IM_G LSU PRKLDG Domain R3TIR DOMA ZOPTION CHAR250 Domain R3TR Data Element R3TR Data Element R3TR Data Element R3TR Data Element R3TR Data Element R3TR Data Element R3TR Data Element R3TR Data Element R3TR Enhancement Implementation Enhancement Implementation Function Group ZOPTION PING DO MA ZOPTION CHAR8000 DTEL ZOPTION MAXROWS DTEL ZOPTION ROWNUMBER DTEL ZO PTO N SHEETNUM BER DTEL ZO PTO N SPUTNUM BER DTEL ZOPTION VAL250 DTEL ZOPTION VALKEY DTEL ZOPTION VALLINE DTEL ZOPTION VALMSG R3IR FUGR ZOPTION COMMON Contains
94. ss Selected Worksheets Select Export Range of Worksheets to Formatting lv Auto Resize Columns v Auto Format If you are installing GLSU for the first time the System will say No Systems Found In this case you should click the Add System button then log in to yourdesired SAP system so GLSU can retneve vital information about that SAP system and subsequently you will be able to post to it You can perfom this function multiple times for multiple SAP system client combinations you may wish to use Page 32 6 Hit OK and the pick list will be displayed 10 Select Fields Fields in SAP Field lt lt blank gt gt lt lt descr gt gt MONAT KURSF WWERT XBLNR BVORG AUGLV XMWST DOCID Descr blank column blank column Period Exchange rate Translatn Date Reference Cross CC no Clearing proc Calculate tax Document type Field Descr lt lt blank gt gt blank column lt lt descr gt gt blank column NEWUM Special G L ind NEWBK New co code DMBTR Amount in LC WMWST Tax amount MWSTS LC tax MWSKZ Tax code XSKRL L FWzuz Addt tax W o c disc v Fields on Spreadsheet Field Descr BLART Document Type BUKRS Company Code BLDAT Document Date BUDAT Posting Date WAERS Currency BKTXT Doc Header Text BELNR Document Number Field Descr NEWBS Posting key NEWKO Account WRBTR Amount SGTXT Text KOSTL Cost Center PRCTR Profit Center
95. st of authonty objects which are needed to use the GLSU solution Authonzation Field Values Object S TCODE Transaction code FBO1 for document posting SM 35 for document processing log viewing ZG LSU forthe main GLSU program FBSL for Accrual FBV 1 FBVO and FBVB for Park Document FBB1 for Post Foreign Currency Adjustment FV50L for Park to Ledger Group S BICH JOB JobAction RELE J obGroup S BDC MONI Batch input monitoring activity DELE Session name Fl G LSU Activity 16 Name of RFC to be protected ZOPTION GLSU ZOPTION COMMON RFC 1 SRFC SUSO SYST RFC H BDS BAPI forattaching documents 0002 for document dnilback Type of RFC object to be protected FUGR S PATH Full Authonzation S DATASET Activity Full Authonzation Delete authonty isneeded to cleanup temporary intermediate files Filename Path asconfigured in Section 2 Program ZO PTO N RFBIBLO Company Code All required Activity 01 for Posting and Accrual 03 to download master data in the INI or real time pick lists and description functionality This is also the activity which wasadded to adhere S RFC F_BKPF_BUK to SOX requirements fordata access 77 for Park Document S GUI For uploading downloading files 60 and 61 for ACIVT Activity S BDS DS Forattaching documents to the BDS BKPF and AC CTG DOC MT for Cla ssNa me BO Bravo Oscar for Classlype 01
96. stem eithervia a direct posting orbya batch upload process From the GLSU menu 1 Z 3 Choose menu item Post On the SAP Logon screen choose the appropnate SAP system and select OK On the SAP Logon at SAP screen enter your SAP user ID and password for this SAP system and click OK Aftera short pause the GLSU system will retum a dialog box with the document number if the posting was successful and any relevant wamingsand enor messages User Data Client 800 a Cancel User USERNAME A B Co D F G Pa i a La 3 Header Document type Company Code Document Date Posting Date Curren Document Number E SA 3000 1 2 2015 1 2 2015 USD 100028534 5 7 Une heme LAMELO Account balanced Text a 40 100000 110 9 50 100000 10 10 50 100000 10 11 50 100000 10 12 50 100000 10 13 50 100000 10 14 50 100000 10 15 50 100000 10 16 50 100000 10 17 50 100000 10 18 50 100000 10 19 50 100000 10 G LSU will prompt you to log into your SAP system the first time you connect forthe day or ession Subsequent postings to SAP will not require that you re log into SAP To log out of a GLSU SAP connection choose Logout Page 41 Logging on with SSO Single Sign On with SAP logon tickets If you plan to use SSO with GLSU there is little which is different from a site which doesnot use SSO First you should login to your SAP Portal as you would nomally do before attempting to use GLSU After successfully
97. t System at www zoption com see previous section After you are logged in select Generate License Unlock Codes gt Generate GLSU unlock codes gt Generate GLSU Premium User Unlock Codes 5 Enter the SAP User ID of the Premium user you are registenng into the webste and click Generate GLSU Premium 6 In SAP paste the Premium user unlock code into the field for the unlock code and enter the SAP user ID you are unlocking Click the Check icon The userisadded asa GLSU Premium user 7 Repeat steps4 6 asnecessary forall Premium Users You will need to repeat this procedures for each of the Premium Users on your SAP system You will need to key ina unique Premium User Unlock Code for each one Page 25 Step 3 Maintaining Standard Users Premium Only You can register your Standard usersin GLSU in 2 different ways 1 Automatic registration GLSU will know how many licensed usersare available at your ste It will keep track of the different users who have UPLOADED entnes using GLSU When the license limit isreached no new usernameswill be allowed to upload entnes until one of the two procedures below is perfomed to free up more seats 2 Manual registration If you want specific people to upload entres using GLSU you should manually add their login na mes to the GLSU registered user list There are two waysto get more Standard Usersaccessto upload GLSU entnes 1 Purchase more Standard seats from ZOption
98. t multi Zol 2015012010 56 12 100028528 Process Saected Worksheets Select Formatting W Auto Resize Columns 7 W Auto Format 3 You will need to rename and save your file and post again Auto Resize Columns GLSU hasa feature that re sizes the soreadsheet column widths each time you adjust the spreadsheet usng the Choose Fields pick list Thisfeature wasadded oo that fields of various widths are always presented properly on the spreadsheet This feature may be ovemdden at the usersoption Example If you have custom formatted your spreadsheet so that it representsa form you would probably want to tum this feature off From the GLSU menu 1 Choose the Options menu item from the spreadsheet 2 Choose the Workbook tab 3 De select the Auto Resize Columns checkbox Page 53 Auto Format Colors GLSU will automatically format the colorsand appearance of the spreadsheet each time the Choose Fields pick list is activated However the user may be using GLSU to emulate a specific form fordata entry and may not desire to have the spreadsheet reformatted each time a change ismade to the columns The reformatting setting can be disabled at the usersoption Tum this feature off if you prefer not to use the gray blue white and green color scheme of the standard ZOption templates 1 Choose Options 2 Choose the Workbook tab 3 De select the Auto
99. tain the GLSU license Execute transaction ZG LSU in SAP Once in the GLSU transaction type PREM in the SAP command boxand press Enter Clicking on the Maintain License button from the Premium User Function screen displays the dialog box shown in the image below NOTE Depending on if any license data already exists I e system copies you may not need to enter the PREM function the license dialog may display automatically Maintain Templates Upload Addin Maintain Premium Users Maintain Standard Users E4VVGUGC3 Maintain License Maintain Technical Options Create Offline Validation File The Maintain License screen shows the number of Premium and Standard users which have been licensed and how many have been used at yourcompany To change these numbers of licensed users either the first time you use GLSU orif you add seatslater you will need a License Unlock Code The License Unlock Code is supplied by ZOption 1 Open an Intemet Web Browser and go to the ZOption webste at hitp www zoption com Click the link for Support amp Licensing 2 If you have not already done so each Premium user should request a ticket system login ID by navigating the web page menu to Support gt Support amp Licensng gt Don t have an ID yet Request a Ticket System ID Click the link to the form Fill out all of the information 3 Once yourticket system ID hasbeen confined you will receive an email yo
100. te WAFERS Currency Correspondence BETXT Doc Header Text 2 Note BELNR Document Number Payment advice infor MONAT Period Posting Messages KURSF Exchani Descr Field Descr Personnel Mo i NEWBS Posting key ZUONR Assignment NEWEKO Account ZTERM Payt terms WRBETR Amount PROJK WBS Element slaTXT Text TXICD Tax Jur KOSTL Cost Center RKE WWSBU Strategic Bus Unit DOC_ITEMO001 Line Item Notes DOC_ITEMZIW1 Line Item Correspond DOC_ITEMZIW2 Line Item Details Search Search Reset Show Hidden Fields Accept Cancel Page 4 A note on formatting long texts 1 The semi colon isused asa newline character If you wish to starta new line you may either type the semi colon characterorchoose Alt Enter from your keyboard The semi colon character will NOTbe displayed in the long text 2 Use the tide characteron either sde of a formatting option The formatting characters available on your system may vary from those shown below See Example NOTE The total length of long text lines may not exceed 72 characters this isan SAP hard limit which Cannot be changed by GLSU Long texts are also limited to non split documents only but are available for multi sheet and dropped header If the posting timeout isreached in GLSU asset by the Premium User Functions gt Maintain Technical Options gt Job Wait Time setting long texts will NOT be updated for the posted worksheets SAP Cannot create a link to the document because no
101. tion about ZOption and other ZOption products see our Web site on the intemet at www zoption com WORK SMART BE A CHAMPION Page 10 How Does GLSU Work GLSU isa spreadsheet uploader tool that runsin a two or three step process Ithasboth ABAP and a Visual Basc Add in which work together to provide a complete solution GLSU can post data to your SAP system in two ways 1 Direct Posting 2 Batch Direct Posting allows you to enter SAP data without ever leaving the spreadsheet Excel dialog boxestell you ifthe posting was successful and retum the SAP document number and other SAP messages upon a successful post At the highest level the GLSU batch posting functionality worksin a two step process 1 Userinputs data into the soreadsheet This isthe posting data which will then be posted to SAP These entnescan be aslong asyou require You are not limited by any SAP limitations on document posting sze and you can post multiple worksheets ata time 2 Post the export file to SAP Using the GLSU custom transaction Zs LSU the user will then post the data to SAP using a smple procedure Installing GLSU the first time isa Smple processand is explained in detail in the next chapter Getting Sta rted Installing G LSU involves activating the GLSU add in in Excel The GLSU spreadsheet functionality is provided by an Excel Add in This add in is wntten using Microsoft Visual Basic for Applications Once activated the Add in wil
102. ts and descriptions are major features which would be lost if the extemal user was given a local validation file INI we provide the Create Offline Validation File function available to only Premium users d Upload Addin Maintain Premium Users Maintain Standard Users l o al ei Off Line Validation File In order to create an off line validation file perform the following steps Pw SY 3 98 08 DAR 25H5 he Z Option GLSU Create Off Line Validation File Log in to SAP Execute transaction ZGLSU Select Premium User Functions Select Create Offline Validation File Enter or select the offline validation file you want to create NOTE Be certain not to overwnte your personal local file Enter your selection cntena Leave a in all fields you do NOT want to be downloaded to the off line validation file A blank in the selection cntena will select all values or you Can limit the selection based on specific critena Execute the program Leave in all fields you don t want to select Page 109 Premium Only Default User Settings Premium Users can set default values for all Balancing Account Info values Maximum Input Lines per Document and No Data Character This is extremely useful for large implementations where the number of GLSU users may be in the hundredsor thousands of usersand you do not want the end usersto have to set these values manually one u
103. ts as needed Page 114 Technical Installation There are 4 main steps that must be completed for ZO ption GLSU to run on your productive SAP system plusan optional 5th step Install the transport and import it into SAP Set up the logical filenames for your system Set up user authonzation Transport all of the above to any systems where GLSU will be run Optional Set profile parameter Mew E Each steps is detailed below UPG RADE NOTE IF YOU ARE UPG RADING FROM A PRIOR VERSION you probably have already set up the logical filenamesand authonzation Those stepscan be skipped for upgrades KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK SECTION 1 INSTALL AND IMPORT THE ZOPTION G LSU TRANSPO RT KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKHK 1 1 Copy the all the files from the CD root directory or aP file into usr sap trans or its equivalent on your SAP machine 1 2 Run the included ZO PUNSAR BAT file if you are on a Windows NT operating system This will expand the compressed file Z PGLSU50 SAR If you are not on Windows NT run the sapcar commands manually e g sapcar xvf ZOPGLSU51a SAR NOTE This verson is Unicode compliant Even if your SAP system is not Unicode you should still install this version The code iscompatible and it willsave you an upgrade step if you should ever convert your SAP system to Unicode Example e usr sa p trans gt zopunsar sa pcar xf ZO
104. ttached to all SAP document numbers If you choose NO the spreadsheet will neverbe attached to the SAP document If you choose PROMPT the user will be prompted whether or not to attach documents NOTE The user will not able to set optionsin this setting They will alwaysbe prompted what action to take If you choose USR the optionson the end user desktop will be enabled and the user will be able to set their own optionsaccordingly You can also configure what descnption will be used in the BDS forthe attached documents This can be a combination of hardcoded text elements and parameters from both the workbook and the SAP system Fora listing of the available parameters put your mouse cursor on the descnption field and select F1 The next screen willbe shown Max Attachment Size Allows the Premium user to set the maximum attachment sze for standard users This allows very large workbooks from being attached in orderto manage the load on the SAP database Attach to intercompany documents GLSU can attach the workbook to all intercompany documentsthat are created The default is OFF This feature can be tumed on so that the workbook Page 78 isattached to the headercompany documents AND any intercompany documents that are produced Use link for subsequent attachments GLSU can attach a workbook to the first document produced and then attach a link to that workbook on any subsequent documents This saves space in the SAP database
105. typing transaction Zs LSU in the box atthe top of your SAP GUI Master data may be downloaded to your PC each time you run the ABAP on an ad hoc bassorin a real time live fashion You may individually select or de select certain SAP master data itemsas you require Forexample if you never post to customersor profit centers de select those items and your validation update process will execute faster when in offline mode Validation File Options Refresh Validation with Upload Send Validation Now Validation Options Select the button that says Validation Options in the LYU transaction The following explains each of the fields in the Validation Options dialog box 1 Master data checkboxes Activate these checkboxes if you wish to download these master data valuesto your PC 2 Text checkboxes Activates these checkboxes to download the text values labels forthe associated master data value These default to the OFF position By tuming these on you can see a search help dialog box in the Excel spreadsheet See next page 3 Premium Only Suppressed Required Optional radio buttons If you are a Premium level user you will have the option to make selected validation fields either Suppressed Required or Optional This is milar to the way SAP Field Status Groups works By Suppressing or Requinng individual fields users will not have the option to make their own choices about whether they validate for these fiel
106. u may log in to the ticket system on the same support page by clicking Log onto Ticket System Select your company from the drop down list and enter your user ID and password you created in step 2 NOTE UserIDSand passwords ARE cas sensttive 4 After you are logged in select Generate License Unlock Codes gt Generate GLSU unlock codes gt Get GLSU License unlock codes 5 Enter the Registration Code from the SAP Maintain License screen and press Generate GLSU License Page 23 6 Paste the License Unlock Code from the webste into the License Unlock Code Field in SAP and press enter Your usercount is updated and the license is unlocked g License Updated Step 2 Maintaining Premium Users Premium Only Premium users must be individually named on your system To set up the Premium users for your site Restart the ZG LYU transaction NZGLSU in the SAP command box Once in the ZGLSU transaction type PREM in the SAP command boxand press Enter From the Premium User Function screen click on the Maintain Premium Users button The following dialog box will display TLLISONE 09 10 2014 01 19 2015 REYNOLDSC 05 30 2014 01 21 2015 HOFFITJ 05 30 2014 01 207 2015 vD Tx 1 Clickthe New icon atthe bottom ofthe page Page 24 2 To adda Premium User you willneed a Premium User Unlock Code You will need to type in the Premium User s SAP user ID into the Usemame field Login to the ZOption Ticke
107. uage Font Aral lf F4 Pick GLSU Values if Auto update validation file each session Page 29 Standard Users Step 2 Download Install the GLSU add in If your desktop admin group hasalready installed the GLSU add in orif you are installing from a network location you can ignore this page of instructions and gmply run the SetupGLSU exe installer To download and install the GLSU add in on each PC l Au PF WN Pa Ensure that the G LSU ABAP program hasbeen transported and propery installed on your SAP system Sta rt SAP You must have an SAP logon to download the GLSU Add in Execute the GLSU transaction Z LYU Make sure you have set your validation optionsasdescribed in the previous chapter From the GLSU transaction choose the Download Add in button A standard Windows dialog box willappearand ask where the installer should be downloaded You can change this if desired but ZO ption recommends that you do not Click Save Click Yes to confirm the download of the installer Click Next On the destination folder install step ZOption highly recommends installing to the default installation path Click Next and then Finish 10 Click ok through the add in installer steps until the installation is complete Sta rt Microsoft Excel and note the new GLSU menu in the nbbon Download GLSU Add In JE GLSU InstallShield Wizard Destination Folder Click Next to install to thi
108. uble byte SAP system you will use with GLSU NOTE If you cannot change these settings you may need to speak with your desktop administrator group orthe group who handles the deployment and maintenance of the SAP GUI Second if GLSU is already installed open Excel and perfom the following steps From the GLSU menu 1 Choose Options 2 Choose General tab 3 Tum Unicode File Handling to On 4 Select OK After you have performed the stepsnecessary to enable support for double byte character sets you can ensure GLSU is able to display these sets by performing a Pick Values on any supported field Pick a company code which you know contains double byte character sets You will see a disolay similar to below In this example both Korean and English texts are displayed simultaneously GLU Options Workbook General Attachments Tahoma RF F4 Pick GLSU Values Unicode File Handling C Off On Page 76 Choose a value for Account Cust Block Name Address 301061 Seti EBS 1 1234 Main Street 463 455 Seoul 301062 SCH Eas 2 1235 Main Street 344 462 Seoul 301063 Se CHAS 3 1236 Main Street 463 822 Seoul 301064 HHA 4 11 30 555 Main 203 102 Seoul 301065 Sr Oo IHI 1 1 990 555 Main 123 223 Seoul 301066 HZ9 240 2 102 1 555 Main 334 334 Seoul 301067 Z9 AHO 3 10 11 555 Main 345 111 Seoul 301068 FZS OHD 4 10 11 555 Main 556 345 Seoul 301069 Tim Curtin 1 43 555
109. with a live connection i e not supported in the off line mode Full development documentation is provided in the ZOPTION GLSU UVE CUSIVAL function module Transaction SE37 available on your SAP system after GLSU hasbeen installed Perform SAP Substitutions Reserved for future use Perform SAP Validations Activate GLSU pre validations for Financial Accounting line item validations and Cost Accounting line item validations These are the same SAP validations as configured in OB28 and OKC7 respectively NEVER Delete BDC Sessions When this option is checked GLSU will never delete the sessons contained in transaction SM35 whether they are successful or not Use Header Company w split Activating this option will place the header company of the workbook as the header company on EVERY SAP split document which iscreated when the number of lines exceeds the Maximum Input Lines per Doc value With the option de selected the last New co code Technical Field NEWBK value set willbe placed on each respective slit document Attaching Documents See section Document Attachments BDS Page 107 Transaction Control This section allows the Premium userto control globally which transactionscan be used by all GLSU users The checked options will be the only onesavailable in the Options screen Note thatona clean installation GLSU will not immediately know these settings However asson as a GLSU user attempts to post or park they are requir

Z Option Inc.

Contents

Download Pdf Manuals

Related Search

Related Contents