QuickScript Frequently Asked Questions

 

What SAP authorisations do I need for QuickScript?

In general, for any WinR3 product, you need the authorisations to run any transaction that you wish to record or run/replay.

There is a comperhensive description of the additional SAP set-up required to run QuickScript in the User Guide.
Back to top

How can I make my scripts use “today” for input data, instead of a fixed date?

Very often, when a date is recorded, what you really need in your script is not a fixed date (the actual date that was recorded) but a relative date – e.g. “today” or “today + 1 week”. For example, when creating a Purchase Order you may want the delivery date to be in the future (e.g. today + 2 days), it is very unlikely that you would always want it to be the exact date you recorded.

This is very easy to do and a useful general technique to remember when working with QuickScript. Remember, you are using Excel and all of Excel's functions and formulas are available to you. All you have to do is replace the date recorded in the sheet with a formula - for example, to use “today” just use the formula:

=TEXT(TODAY(), “mm.dd.yyyy”)

Note the conversion to text, this is to ensure that QuickScript uses exactly the value you see in the cell. Note also the specification of date format, this is critical. The format must be exactly the same as the format you have specified in your SAP user profile (you can see your SAP format by running transaction SU3 and looking at the ‘Defaults' tab).
Back to top

Can I rely on SAP's parameter ID (PID) to carry forward data from one transaction to the next?

Very often, SAP ‘remembers' what it has just done and carries it forward in a parameter ID which it defaults into subsequent transactions. For example, if you create a Sales Order (VA01) then run the Change Sales Order transaction (VA02) the sales document number will be automatically carried forward from VA01 to VA02.

You can, if you wish, rely on this behaviour rather than using the Data Wizard in QuickScript. However, you must be very careful when making the recording. Continuing with the example, you must not record the input of the sales document number to the VA02 transaction, that is the recording must be made using the default value and not entering the data yourself. If you make the recording and input the data, the entry of the data will be recorded and put into the script – there will also be a column for the data in the spreadsheet. If you see the column in the spreadsheet, you must use the Data Wizard – if it is in the script as an input field, QuickScript will always use the spreadsheet as the source of data.

It is recommended, at least until you become more familiar with QuickScript, that you do not rely on parameter ID's. This will make your scripts more predictable. Back to top

Can I make the script ‘Run' faster?

QuickScript's ‘Run' speed can be increased by turning ‘Off' local data history, as follows.

Back to top

Can I share scripts?

Yes! All QuickScript spreadsheets are completely self-contained and can be used on any PC that has QuickScript installed.
Back to top