List of Contributions

James Tobin

Contact Details

My Content

1 to 20 of 23 total

RE: Querying Foreign Exchange Rates from GEMS

Posted By James Tobin 08-13-2019 20:02
Found In Egroup: Automate \ view thread
GEMS is a specific system at EM but we need more info about what specifically you're trying to achieve.  Are you looking to get a daily dump of the new rates? ------------------------------ James Tobin ------------------------------

RE: Basis Scripts

Posted By James Tobin 08-13-2019 19:58
Found In Egroup: Automate \ view thread
Previously used Loadrunner for this but I don't see why WInshuttle wouldn't work in this case.  Massively reduced processing time.  I believe SAP have introduced ways of carrying out mass role assignment now but you may have other needs apart from role assignments ------------------------------ James ...

Simulate Log

Posted By James Tobin 08-10-2019 17:08
Found In Egroup: Automate \ view thread
After adding the Validate option to my FB01 or FB50 script the log is populating as expected against the line item.  However when I run a Simulate it is populating the same column as my Validate, but on row 2 and therefore overwrites what's in there.  Any way to get the simulate to log in the same ...

RE: SAP 750 to HANA

Posted By James Tobin 06-14-2019 11:40
Found In Egroup: Automate \ view thread
Hi Brad, I am assuming you mean ECC to S/4HANA? I'm interested to hear other points of view.  However I believe Winshuttle cannot handle Fiori recording and therefore needs to be done using the backend tcode.  In our project we have users posting manual entries in Fiori but our scripts use the legacy ...

RE: ABT1N - Intercompany Asset Transfer Script

Posted By James Tobin 06-14-2019 11:34
Found In Egroup: Automate \ view thread
I recall creating one previously but using ABT1 rather than ABT1n.  The new transaction caused a few issues in the recording. ------------------------------ James Tobin ------------------------------

RE: S4 HANA Request to Allow Access

Posted By James Tobin 04-15-2019 18:15
Found In Egroup: Automate \ view thread
This sounds like its the GUI Security setting.  If that is the case then contact your Basis or Security team as usually this is locked down especially if you're connecting via Citrix.​ ------------------------------ James Tobin ------------------------------

RE: AR Posting

Posted By James Tobin 04-08-2019 16:05
Found In Egroup: Automate \ view thread
Just to post back in case anyone comes across this issue in future.   My script included multiple screens 0300, 0301, 0302 etc however the problem was that I used the "SAP Field" in my IF statement.  Eg. If SAP FIeld RF05A-NEWBS was 01 then go to 0301.  This didn't work.  The IF statement had to point ...

AR Posting

Posted By James Tobin 03-29-2019 20:24
Found In Egroup: Automate \ view thread
I'm creating an AR posting using FB01 and it works if the posting keys are per the order it was recorded in (01, 50).  However if there are multiple lines the loop is not functioning correctly.  Has anyone got this working correctly previously? The customer line is obviously different to the revenue ...

RE: Script for transaction FV50 with the Long text

Posted By James Tobin 03-29-2019 20:21
Found In Egroup: Automate \ view thread
Hi Nupur, if you are using Studio 11 there is a long text option under the Map tab. Might be worth exploring. I believe you can then choose which text you need and assign it where required in the script James ------------------------------ James Tobin ------------------------------

RE: Negative Signs on JE Script

Posted By James Tobin 03-27-2019 10:15
Found In Egroup: Automate \ view thread
This is helpful thank you I used a similar approach in my script but the formula was in the template as opposed to Winshuttle. It's helpful for me to see the usage of the transform formula Thanks again James

RE: Negative Signs on JE Script

Posted By James Tobin 03-26-2019 11:31
Found In Egroup: Automate \ view thread
Hi Bob, I was using the *-1 formula in Excel in a separate column and pointing the script to that column. But can I achieve this using the transform formula in Studio 11.4.1 or another place? Thanks​ ------------------------------ James Tobin ------------------------------

RE: FB01 Posting

Posted By James Tobin 03-11-2019 01:17
Found In Egroup: Automate \ view thread
Appreciate you sticking with me on this! If an account has an FSG with all optional I do not see Profit Center on the main SAPMF05A 0300 screen only under more (1st screenshot). If I change the account to Profit Center mandatory then only then it appears on SAPMF05A 0300 (2nd screenshot). I'm ...

RE: FB01 Posting

Posted By James Tobin 03-07-2019 13:19
Found In Egroup: Automate \ view thread
Hi Younus, If the account has profit center mandatory then you will find that COBL-PRCTR appears in SAPMF05A as well as SAPLKACB. How would you handle it in that case? As a side note I found turning off the BDC_CURSOR fixed some issues around if the field didn't appear on screen but sometimes ...

RE: FB01 Posting

Posted By James Tobin 03-06-2019 15:49
Found In Egroup: Automate \ view thread
I tried posting to an account where all fields are optional but Profit Center is still under the More tab. In the script I cannot reference the same template field twice. One solution is to use an additional column over to the right hand side on the template with a simple formula to reference the ...

RE: FB01 Posting

Posted By James Tobin 03-05-2019 12:35
Found In Egroup: Automate \ view thread
Stephen, Younus, thank you both for your responses. We have an "all optional" FSG created so can give it a go. Where do you include the code (condition) to check the FSG for each line item? Can you send an example of the code you use? For now we made the account as Profit Center required but there ...

RE: Recording a script through FireFighter ID

Posted By James Tobin 03-01-2019 17:13
Found In Egroup: Automate \ view thread
You could try recording in one of the other modes

RE: Recording a script through FireFighter ID

Posted By James Tobin 03-01-2019 15:38
Found In Egroup: Automate \ view thread
In Options under SAP Settings there is a checkbox for "Allow runs using Virsa or Firefighter or GRC".  Try checking that. ------------------------------ James Tobin | Energy Transfer Partners, LP | ------------------------------

FB01 Posting

Posted By James Tobin 03-01-2019 11:49
Found In Egroup: Automate \ view thread
My recording uses FB01 and if Profit Center is a required field in the account then there are no issues. However if Profit Center is optional it doesn't appear on the first screen and instead will only appear if you click on More in FB01. I cannot include PRCTR in both screens using the same upload ...

RE: Negative Signs on JE Script

Posted By James Tobin 02-20-2019 09:22
Found In Egroup: Automate \ view thread
​Hi Jan, thanks for the ABS formula this is the cleanest way.  However how does the transform rule work exactly?  I tried using a formula =ABS(E) (amount is in column E) because I'm using a row identifier of D but the formula is invalid.  If I use a cell (eg. =ABS(E16)) then the formula is valid ...

Negative Signs on JE Script

Posted By James Tobin 02-15-2019 09:17
Found In Egroup: Automate \ view thread
My FB50 scripts are both cell based and column based and I'm trying to create a condition to convert a negative number to positive.  In Excel I usually use if <0 then *-1 but for some reason this doesn't work.  Any suggestions? ------------------------------ James Tobin -------------------- ...