Skip to Content

RE-FX Accrual Engine using customer/vendor accounts

Hi,

our customer wants to post accruals and deferrals (related to RE-FX revenues/expenses) against a customer/vendor account, not a simple GL account.

The customizing settings in RE-FX allow to specify two GL accounts, not the vendor or customer account (K* or D* as account symbols).

The requirement is for example the following posting in FI.

RE-FX contract with a rent condition (3 months frequency) paid in arrears for 300,00 EUR

1 month

RERAALCN (accrual for 1/3 of the whole quarterly rent)

   Cost  100,00 EUR

   Vendor (special GL code)  -100,00 EUR

2 month

RERAALCN (accrual for 1/3 of the whole quarterly rent)

   Cost  100,00 EUR

   Vendor (special GL code)  -100,00 EUR

3 month

RERAPP

   Cost     300,00 EUR

   Vendor -300,00 EUR

RERAALCN

Vendor (special GL code)  200,00 EUR

Cost   200,00  EUR

Is it possible such a posting schema? Should we use an enhancement (BAdI) for this?

Thank you for any help provided!

Regards,

Massimo Marchetti

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 16, 2014 at 12:32 PM

    Hi Massimo,

    You are right, using the standard system it will not allow you to use Vendor/Customer Special GL Indicator. I have just thought about it for awhile, I am thinking there is a workaround method that may work for your scenario. I just share what my thoughts to you and no guarantee it will work for you.

    Here are the steps:

    1) In your accruals setup, you will setup the Periodic Posting entries into the following

    Dr Cost

    Cr Cost Clearing Accounts

    2) Go to TCode: FBD1 (Recurring Journal) and setup the entries:

    Dr Cost Clearing Accounts

    Cr Vendor Accounts Special GL (Note: I have not tried this before but I think it will work.)

    In your scenario, the recurring will run for 2 months and then it will reverse out in the 3rd month.

    3) Run your RERAPP and RERAALCN every month.

    I am not able to tell you absolutely that it will work as I seldom configure Accrued expenses, my clients normally have problem with Deferred Income but I am really curious whether my solution will work and hopefully it will help you. I will try to test it on my end too and if there is any findings I will keep you update.

    Kon

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member MASSIMO MARCHETTI

      Hi Massimo,

      You are welcome. You can just set the correct account codes in the account determination without any customization. Use (S) for GL accounts for both Dr and Cr.

      Regards,

      Kon