RE-FX Accrual Engine using customer/vendor accounts

[massimo_marchetti]

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

[Former Member · Accepted solution]

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

[massimo_marchetti · Accepted solution]

Hi Kon,

thank you very much for your help.

So the requested posting schema it's not possible just using the Accrual Engine... 😞

The workaround you suggested could work, even though I would like to avoid a clearing account if technically possible, as well as additional postings in FI. If I could understand your tip, these postings should be done with a custom program, starting from the ACE documents, is it right?

I'm waiting for a developer on the project, in order to investigate if we can replace a dummy GL account set in customizing (the clearing account) with the vendor (special GL indicator) using the BAdI provided for the accrual engine, before the document is posted in FI of course.

This would be the best from our point of view; I will keep you updated after our investigation.

Thank you very much and best regards,

Massimo

[Former Member · Accepted solution]

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