on 03-13-2014 1:32 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.