List of Contributions

jan ketele

Contact Details

My Content

1 to 20 of 50+ total

RE: Winshuttle pour la comptabilisation de piéces par FB01

Posted By jan ketele 04-05-2024 08:02
Found In Egroup: Automate \ view thread
Bonjour Meryam, Pourque tout le monde puisse suivre, je continue en Anglais: I'm not familiar with this T-code, but I 'm convinced that you're always better off using Direct if you have the choice. So a quick look into BAPI's resulted in: BAPI_ACC_GL_POSTING_POST you may want to give that a try ...

RE: Winshuttle: Is it possible to create a script (MM02) that modify the Alternative UoM data based on Alternative UoM that is on Excel?

Posted By jan ketele 03-27-2024 09:20
Found In Egroup: Automate \ view thread
hi Nart, you may want to have a look at this : https://preciselyu.precisely.com/page/automate-studio-webinars when searching on the community website, you'll find a lot of examples too. enjoy, jan ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------ ...

RE: How to set a field value in a repeating Table based on the entry of another field per row

Posted By jan ketele 03-18-2024 12:14
Found In Egroup: Automate \ view thread
Hi Mirka, that's something I would do with an Excel formula in the availabililty check column on the uploadfile, the formula would look like =IF(NOT(ISERROR(FIND("Subst.",column-row))),"CH","YS"), where column-row would point at the description location in that row. hth, jan ------------------------------ ...

RE: How to link script which has different Sheet as a load sheet?

Posted By jan ketele 03-18-2024 06:45
Found In Egroup: Automate \ view thread
Hi Nart, first you save each separate script, referring to the sheet it's working on. Then, while linking those using 'chain scripts', you chose the option 'custom' on the run settings. then on the settings icon, chose ALC: All from first script': this will avoid you need to login for every single ...

RE: Fixed current date for upload?

Posted By jan ketele 03-05-2024 08:24
Found In Egroup: Automate \ view thread
Hi Nart, sorry, as a matter of fact "currentdate" does not work. It does work with the simple Excel formula TODAY(), ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: If data column is blank, make the value the same as in SAP S4?

Posted By jan ketele 03-05-2024 07:41
Found In Egroup: Automate \ view thread
Hi Nart, no, just the backslash "\" would do, if you prefer to use another character you can define that character in the Studio RUN-tab as shown in my screenshot. ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: If data column is blank, make the value the same as in SAP S4?

Posted By jan ketele 03-05-2024 01:57
Found In Egroup: Automate \ view thread
Good morning, I think you 're referring to the 'skip indicator' : to be defined in the run tab, by default it's a backslash, but one can chose another character. Works perfectly in transaction scripts but I had some issues with it when using direct. hth, Jan ------------------------------ jan ...

RE: Fixed current date for upload?

Posted By jan ketele 03-04-2024 11:35
Found In Egroup: Automate \ view thread
------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: SAP User can't see all the SAP Systems in Winshuttle Studio

Posted By jan ketele 02-20-2024 09:31
Found In Egroup: Automate \ view thread
Good afternoon Marcel, I think you 'll have to add the SAP systems you require. have a look at this: https://help.precisely.com/r/Automate-Studio/20.3/en-US/Automate-Studio-with-Connect-User-Guide/Setting-up/Add-an-SAP-system best, Jan ------------------------------ jan ketele release expert ...

RE: Excel Add-In Run Icon Grayed Out

Posted By jan ketele 01-31-2024 03:27
Found In Egroup: Automate \ view thread
good morning, there should be two acitve Winshuttle add-ins in Excell: please check: https://customer.precisely.com/s/article/Winshuttle-Excel-Add-in-is-not-appearing-360023446412?language=en_US ------------------------------ jan ketele release expert Xeikon Manufacturing NV -------- ...

RE: MM01 Warehouse Extension Script Error

Posted By jan ketele 01-12-2024 06:35
Found In Egroup: Automate \ view thread
Hi Ann, MM-transaction scripts are tricky: one always has to start by deselecting all views, then you start with only Basic Data and from within that Basic Data view one can select another view via the GoTo-menu (top row). Available MM-views are dependant of material type, plant selection etc etc, ...

RE: Automate Studio Training: How to Easily Modify Scripts

Posted By jan ketele 09-21-2023 06:59
Found In Egroup: Automate \ view thread
Hi Maria, That timing is rather late on the day for us to follow, will there be a recording we can watch later ? best, jan ------------------------------ jan ketele Xeikon Manufacturing NV ------------------------------

RE: Windows 11 don't let Studio 12.1 installed.

Posted By jan ketele 09-07-2023 08:05
Found In Egroup: Automate \ view thread
Hi Marcel, after installing Windows 11 we updated Studio to V20.3.1, as well as the WFM which was updated to AutomateFM 20.3.1 best, jan ------------------------------ jan ketele Xeikon Manufacturing NV ------------------------------

RE: SAP Material Master Creation using Winshuttle and BAPI_MATERIAL_SAVEDATA

Posted By jan ketele 09-05-2023 11:00
Found In Egroup: Automate \ view thread
hi Pamela, I've been using that BAPI for several years now. The field MARA-TRAGR does get updated correctly with it (CLIENTDATA) and the "X" in CLIENTDATAX The script does need the SALES_VIEW box ticked in the HEADDATA. best, Jan ------------------------------ jan ketele Xeikon Manufacturing ...

RE: Data entry form: automate query process

Posted By jan ketele 06-09-2023 06:29
Found In Egroup: Automate \ view thread
Hi Nick, I'm using VBA for this sort of manipulations ... getting data from different sources and gathering all data into an uploadsheet, ready for WS-uploadscripts, can easily be done with a little VBA scripting. Not only very fast but also, most importantly, errorproof. best, Jan -------- ...

RE: Create MM02 Sales Text

Posted By jan ketele 06-07-2023 06:32
Found In Egroup: Automate \ view thread
David, there you find an interesting webinar on text entering: https://preciselyu.precisely.com/studio-3-ways-to-maximize-long-text-in-sap-and-save-time-and-resources/1134493 hth, Jan ------------------------------ jan ketele Xeikon Manufacturing NV ------------------------------

RE: Compatibility SAPGUI 8.0 vs Studio 12.1

Posted By jan ketele 06-06-2023 04:06
Found In Egroup: Automate \ view thread
Hi Pedro, this may help: https://customer.precisely.com/s/article/Third-Party-Products-Support?language=en_US ------------------------------ jan ketele Xeikon Manufacturing NV ------------------------------

RE: Winshuttle with variable rows

Posted By jan ketele 05-08-2023 10:02
Found In Egroup: Automate \ view thread
Pedro, It's hard to assess what exactly you're struggling with, it would help to have more detail. In my experience it's always better to prepare upload files within excel and to let the WS scripts do their magic on the fully prepared worksheets. So that there is no need for WS to execute Excel functionalities ...

RE: Studio update needed

Posted By jan ketele 05-05-2023 07:14
Found In Egroup: Automate \ view thread
Hi Sean, I called Precisely this morning because it's getting very urgent for us. The lady on the telephone directed me to the customer site to create a ticket on their support: it's very well hidden, so here you go: go to customer.precisely.com, menu 'support': 'creat a new case',  next window: select ...

Studio update needed

Posted By jan ketele 05-04-2023 04:38
Found In Egroup: Automate \ view thread
Dear Winshuttle, We're getting a forced update in the company form Windows 10 to Windows 11. Looking at compatibilitychart of WS Studio 20.2.9, I noticed we need to  update Studio to 20.3.1 I've been searching all over your site, but can't find any update files, or a place to request this update. Can ...