Skip to Content
avatar image
Former Member

Automate Journal Posting in SAP (FICO)

May 04, 2017 at 10:01 AM | 137 Views | Last edit Apr 13, 2017 at 04:11 PM 2 rev.

Hi Guys,

I am looking at automating a process in SAP, but I am hoping to get the idea validated before mentioning it to the SAP team.

Process:

We have to pay a royalty for certain SKUs - it is calculated as (50% x revenue) - COS - allocated overhead. We currently download P&L data from BW after month-end to calculate the overhead allocation and the royalty charge, then create an invoice in SAP.

Idea to Automate:

The entire calculation uses master data attributes and follows simple and fixed rules. The calculation is currently performed in VBA in excel. I am wondering if we can create an ABAP code within FICO to produce this calculation. It can be run like how we calculate depreciation on Fixed Assets.

What are your thoughts? Is this a silly idea? I just feel that this calculation is so basic that it is a waste of effort to perform this manually.

FIN (Finance) | process | automate
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Sanil Bhandari
    May 04, 2017 at 11:20 AM

    Hi

    I would suggest to do this calculation in BW report and show you the invoice amount for royalty

    Than you can post the invoice in ECC. That would be easier to do, much simpler and cleaner way to do.

    Regards

    Sanil Bhandari

    Add comment
    10|10000 characters needed characters exceeded