Periodic posting in gl accounts.

[huzefasaifee]

Hi Experts!

The scenario is such: The client pays it’s vendors in advance, for instance a vendor sells tubes(Or cream, or anything). Now, the client will pay them for 1 year(or 10 months, or 3 months.) This expense needs to be mitigated over a large number of months.

So suppose they paid Rs. 10 lakh for 10 months of constant supply of tubes, they now have to do a 1 lakh rupee entry for the next 10 months manually at every month end into their GL accounts. For this, they use a calculator and make entries of the same.

This whole thing needs to be automated in some way without any calculation on the user end.

The reason this is being done is that there are errors and mismanagement in this calculation. Since we could imagine, the numbers are not going to be round figures and there are data entry errors in this manual work. This causes major compliance repercussions in their audits.

Is there any standard provision to do this? If not, I have devised a solution, that I as an ABAPer can envision.

Here's what I propose to do: I will make a custom table that will contain the records of entries made in the prepaid GL account. I will make an ABAP for the user to post in the GL account. This ABAP will simultaniously credit in the Prepaid account and update the table. Now, I will make another ABAP that will sheduled to run at the end of every month that will automatically debit from the Prepaid GL, and credit in the expense GL.

Please do point out if a solution is already given by SAP. Also, if there isn't, please do correct my approach if it seems wrong.

Much Thanks,

Huzefa.

[raymond_giuseppi]

Read first some documentation like Recurring Entries.

Regards,
Raymond

[huzefasaifee]

Thanks for the tip. Very helpful.