Automate

Hi Winshuttle team,

Am wondering if there's a template that I can upload mutiple manual accruals (ZA entries) into SAP at once?
I found the FBS1 template but not really sure how it will work?
Thanks a lot.

------------------------------
Lindsay Ouyang
------------------------------

Hi Lindsay,
It really depends on your needs.
What FBS1 does is embedding reversal date upfront. The result is manual posting with pre-defined reversal date that you chose at the time of data entry. This however doesn't mean it will be immediately or automatically reversed on the given date. You still need to do it manually. However the good thing is that you can reverse all FBS1 documents at one run. Open up transaction F.81, enter company code and run it (default run is a test run)- it will show all FBS1 documents that are available for reversal. So if you choose to do a non-test run, it will reverse them all, and the reversal date you gave at the time of posting will the the one used. This is - if it was correct, as you won't be able to do that  for example in closed period.
To sum up:
- you can mass-post with the mentioned template and give the system a reversal date
- then you mass reverse the accruals in F.81
And a side note - you can manually change the reversal date on each posted accrual using FB02.

This also means it really is for accruals that you would reverse next month and you're sure about it, as otherwise you would spend time on manual chaging of documents (unless there's a Winshuttle template for that :) ).

As an alternative to FBS1, you can simply use another logic - post standard manual entry (FB50/FB01/F-02), using a document type that is not in use for any other type of entry. In your case this might be 'ZA' if this is only for accruals. Then you can mass-reverse them in F.80 giving a specific reversal date. So the difference is basically that you give the reversal date when you actually choose to reverse the documents, not upfront like it is via FBS1.

------------------------------
Radoslaw Poziomek | BSC Continuous Improvement Specialist
Owens Illinois | *
------------------------------

Original Message:
Sent: 02-17-2020 23:12
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Winshuttle team,

Am wondering if there's a template that I can upload mutiple manual accruals (ZA entries) into SAP at once?
I found the FBS1 template but not really sure how it will work?
Thanks a lot.

------------------------------
Lindsay Ouyang
------------------------------

Thank you Radoslaw for the detailed replies, however am aiming for a template or transaction which can help to post mass accruals without mannually reverse it (automatically reverse).

------------------------------
Lindsay Ouyang | AA
John Wiley & Sons, Inc. | 0422320085
------------------------------

Original Message:
Sent: 02-18-2020 02:48
From: Radoslaw Poziomek
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Lindsay,
It really depends on your needs.
What FBS1 does is embedding reversal date upfront. The result is manual posting with pre-defined reversal date that you chose at the time of data entry. This however doesn't mean it will be immediately or automatically reversed on the given date. You still need to do it manually. However the good thing is that you can reverse all FBS1 documents at one run. Open up transaction F.81, enter company code and run it (default run is a test run)- it will show all FBS1 documents that are available for reversal. So if you choose to do a non-test run, it will reverse them all, and the reversal date you gave at the time of posting will the the one used. This is - if it was correct, as you won't be able to do that  for example in closed period.
To sum up:
- you can mass-post with the mentioned template and give the system a reversal date
- then you mass reverse the accruals in F.81
And a side note - you can manually change the reversal date on each posted accrual using FB02.

This also means it really is for accruals that you would reverse next month and you're sure about it, as otherwise you would spend time on manual chaging of documents (unless there's a Winshuttle template for that :) ).

As an alternative to FBS1, you can simply use another logic - post standard manual entry (FB50/FB01/F-02), using a document type that is not in use for any other type of entry. In your case this might be 'ZA' if this is only for accruals. Then you can mass-reverse them in F.80 giving a specific reversal date. So the difference is basically that you give the reversal date when you actually choose to reverse the documents, not upfront like it is via FBS1.

------------------------------
Radoslaw Poziomek | BSC Continuous Improvement Specialist
Owens Illinois | *

Original Message:
Sent: 02-17-2020 23:12
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Winshuttle team,

Am wondering if there's a template that I can upload mutiple manual accruals (ZA entries) into SAP at once?
I found the FBS1 template but not really sure how it will work?
Thanks a lot.

------------------------------
Lindsay Ouyang
------------------------------

@Lindsay Ouyang​, there's simply no such functionality in SAP, therefore you can't get it easily.
You can ask SAP consultants to build it for you, or simply schedule F.80 transaction to run periodically.
As alternative with Winshuttle, you can use scheduling option in the program, this however requires that your computer is online, and that you have built a script for F.80 (as it's not available). You could also use BAPI, as the Stephen mentioned, but you'd need SAP programmer for that, and to be honest - it would have take them less time to create a job for auto run of F.80 than playing with BAPI for reversals.

------------------------------
Radoslaw Poziomek | BSC Continuous Improvement Specialist
Owens Illinois | *
------------------------------

Original Message:
Sent: 02-19-2020 17:52
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Thank you Radoslaw for the detailed replies, however am aiming for a template or transaction which can help to post mass accruals without mannually reverse it (automatically reverse).

------------------------------
Lindsay Ouyang | AA
John Wiley & Sons, Inc. | 0422320085

Original Message:
Sent: 02-18-2020 02:48
From: Radoslaw Poziomek
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Lindsay,
It really depends on your needs.
What FBS1 does is embedding reversal date upfront. The result is manual posting with pre-defined reversal date that you chose at the time of data entry. This however doesn't mean it will be immediately or automatically reversed on the given date. You still need to do it manually. However the good thing is that you can reverse all FBS1 documents at one run. Open up transaction F.81, enter company code and run it (default run is a test run)- it will show all FBS1 documents that are available for reversal. So if you choose to do a non-test run, it will reverse them all, and the reversal date you gave at the time of posting will the the one used. This is - if it was correct, as you won't be able to do that  for example in closed period.
To sum up:
- you can mass-post with the mentioned template and give the system a reversal date
- then you mass reverse the accruals in F.81
And a side note - you can manually change the reversal date on each posted accrual using FB02.

This also means it really is for accruals that you would reverse next month and you're sure about it, as otherwise you would spend time on manual chaging of documents (unless there's a Winshuttle template for that :) ).

As an alternative to FBS1, you can simply use another logic - post standard manual entry (FB50/FB01/F-02), using a document type that is not in use for any other type of entry. In your case this might be 'ZA' if this is only for accruals. Then you can mass-reverse them in F.80 giving a specific reversal date. So the difference is basically that you give the reversal date when you actually choose to reverse the documents, not upfront like it is via FBS1.

------------------------------
Radoslaw Poziomek | BSC Continuous Improvement Specialist
Owens Illinois | *

Original Message:
Sent: 02-17-2020 23:12
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Winshuttle team,

Am wondering if there's a template that I can upload mutiple manual accruals (ZA entries) into SAP at once?
I found the FBS1 template but not really sure how it will work?
Thanks a lot.

------------------------------
Lindsay Ouyang
------------------------------

I'm a little confused - is your issue that you have to run F.80 manually, or you cant post ZA reversing documents using Winshuttle?
​

------------------------------
Stephen Butler | Systems Analyst
RSA Insurance Group Plc
------------------------------

Original Message:
Sent: 02-19-2020 17:52
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Thank you Radoslaw for the detailed replies, however am aiming for a template or transaction which can help to post mass accruals without mannually reverse it (automatically reverse).

------------------------------
Lindsay Ouyang | AA
John Wiley & Sons, Inc. | 0422320085

Original Message:
Sent: 02-18-2020 02:48
From: Radoslaw Poziomek
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Lindsay,
It really depends on your needs.
What FBS1 does is embedding reversal date upfront. The result is manual posting with pre-defined reversal date that you chose at the time of data entry. This however doesn't mean it will be immediately or automatically reversed on the given date. You still need to do it manually. However the good thing is that you can reverse all FBS1 documents at one run. Open up transaction F.81, enter company code and run it (default run is a test run)- it will show all FBS1 documents that are available for reversal. So if you choose to do a non-test run, it will reverse them all, and the reversal date you gave at the time of posting will the the one used. This is - if it was correct, as you won't be able to do that  for example in closed period.
To sum up:
- you can mass-post with the mentioned template and give the system a reversal date
- then you mass reverse the accruals in F.81
And a side note - you can manually change the reversal date on each posted accrual using FB02.

This also means it really is for accruals that you would reverse next month and you're sure about it, as otherwise you would spend time on manual chaging of documents (unless there's a Winshuttle template for that :) ).

As an alternative to FBS1, you can simply use another logic - post standard manual entry (FB50/FB01/F-02), using a document type that is not in use for any other type of entry. In your case this might be 'ZA' if this is only for accruals. Then you can mass-reverse them in F.80 giving a specific reversal date. So the difference is basically that you give the reversal date when you actually choose to reverse the documents, not upfront like it is via FBS1.

------------------------------
Radoslaw Poziomek | BSC Continuous Improvement Specialist
Owens Illinois | *

Original Message:
Sent: 02-17-2020 23:12
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Winshuttle team,

Am wondering if there's a template that I can upload mutiple manual accruals (ZA entries) into SAP at once?
I found the FBS1 template but not really sure how it will work?
Thanks a lot.

------------------------------
Lindsay Ouyang
------------------------------

If you're really going for speed / efficiency / volume, you could use winshuttle direct with BAPI​_ACC_DOCUMENT_POST

Out of the box, it doesn't create reversing journals, so you'll need to extend it, hopefully you've got an ABAPer around....

https://blogs.sap.com/2018/03/27/enlarging-the-use-of-bapi_acc_document_post/

We've just done this, and it works perfectly for just about any document you might want to post, and is much more robust than using a transaction script

------------------------------
Stephen Butler | Systems Analyst
RSA Insurance Group Plc
------------------------------

Original Message:
Sent: 02-17-2020 23:12
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Winshuttle team,

Am wondering if there's a template that I can upload mutiple manual accruals (ZA entries) into SAP at once?
I found the FBS1 template but not really sure how it will work?
Thanks a lot.

------------------------------
Lindsay Ouyang
------------------------------

Thank you very much Stephen, this method seems very powerfull, unfortunately when reading the SAP posting  I don't really understand how this is operating as not a system specialist. But thanks all the same.

------------------------------
Lindsay Ouyang | AA
John Wiley & Sons, Inc. | 0422320085
------------------------------

Original Message:
Sent: 02-19-2020 04:39
From: Stephen Butler
Subject: Winshuttle templates and SAP tcode to book accruals

If you're really going for speed / efficiency / volume, you could use winshuttle direct with BAPI​_ACC_DOCUMENT_POST

Out of the box, it doesn't create reversing journals, so you'll need to extend it, hopefully you've got an ABAPer around....

https://blogs.sap.com/2018/03/27/enlarging-the-use-of-bapi_acc_document_post/

We've just done this, and it works perfectly for just about any document you might want to post, and is much more robust than using a transaction script

------------------------------
Stephen Butler | Systems Analyst
RSA Insurance Group Plc

Original Message:
Sent: 02-17-2020 23:12
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Winshuttle team,

Am wondering if there's a template that I can upload mutiple manual accruals (ZA entries) into SAP at once?
I found the FBS1 template but not really sure how it will work?
Thanks a lot.

------------------------------
Lindsay Ouyang
------------------------------

I have done it. It look a while to get there.

------------------------------
Phil Harrison | Business Analyst
CRODA LTD | 07767980965
------------------------------

Original Message:
Sent: 02-17-2020 23:12
From: Lindsay Ouyang
Subject: Winshuttle templates and SAP tcode to book accruals

Hi Winshuttle team,

Am wondering if there's a template that I can upload mutiple manual accruals (ZA entries) into SAP at once?
I found the FBS1 template but not really sure how it will work?
Thanks a lot.

------------------------------
Lindsay Ouyang
------------------------------