Ledger balances in FI on a weekly basis

[Former Member]

Hi all,

I am referring to the new FI extractor 0FI_GL_10, used for account balance, with a time granularity of Fisc period.

I would like to get the same on a weekly basis or to be more clear, want to get posting date as an enhanced feild in this extractor, so that I can increase the granularity.

I tried checking this myself and wasnt able to do this, as in the source table(Totals table), there is no key by which we can do the append. Also date being more a granular level, I dont this, this is acheivable.

Feel free to contradict me.

So, is there any way out, using any other Fi datasource, preferably using New FI GL scenario(as we have multiple ledgers) to get the balance on a weekly basis.

Do we have anything similar to inventory model to evaluate balance/stock, so that we can make use of it?

I am somehow sure, that this is a generic requirement, to track weekly balances.

Any thoughts are appreciated.

regards,

Naveen.A

[dennis_scoville4 · Accepted solution]

The 0FI_GL_10 DataSource is the extractor for the FAGLFLEXT table in ECC. This table is the accumulation of transactions, to calculate accounts balances, and therefore wouldn't have any dates on it. There is no possible way to get more granular in this DataSource, as to dates, than it already provides.

To be able to get individual posting dates (activity), you would have to use the 0FI_GL_14 DataSource, which extracts data from the FAGLFLEXA table (line item details). This would require you, however, to calculate balances during each load if you need that along with the activity.

Edited by: Dennis Scoville on Aug 10, 2009 11:31 AM

[Former Member · Accepted solution]

Great to see your reply.

I had this thought also open but the reason, i was referring to a model similar to inventory for evaluating the balance from 0FI_GL_14 is keeping in mind any possible archiving.

If we are based on run time either during load or during query execution for balance, then archiving could really spoil the game, with missing documents.

Any thoughts on this?

regards,

Naveen.A

[dennis_scoville4 · Accepted solution]

You could create a custom DSO and load the 0FI_GL_10 data into it on a weekly basis. By adding the execution date to the key, you would, in effect, have a snapshot of the weekly balances. The trickiest thing for this would be determining the complete key for this DSO, but that would generally be the same as the key for the FAGLFLEXT table in ECC.

Since Fiscal Week isn't delivered as a standard Time Characteristic, you will have to derive that through a custom Function Module or other means.

[Former Member · Accepted solution]

That looks interesting.

But does week based on execution date, really mean balance of that week. I guess we can have predated or post dated posting(with in the open period), which in this case would be accounted for the execution week and not posting week.

Do let me know, if I am missing something?

Naveen.A

[dennis_scoville4 · Accepted solution]

You're correct. If there are any pre-dated or post-dated postings to an account, they would be execution week based and not posting week based. It would just reflect a difference in the balance week-over-week on the account. There really isn't a good way to determine if it's a pre- or post-dated transaction. This can hold true for postings in the future because you can legitmately post an accrual across several periods and then "relieve" that accrual for the open period with actuals.

There really isn't any clean way to get this data where it reflects the posting week unless you use the details (0FI_GL_14 or 0FI_GL_40) in conjunction with the 0FI_GL_10 DataSource.

[Former Member · Accepted solution]

Thanks for taking time to understand the need.

I would like to wait for a while for any other members to respond, if they have dealt with a similar scenario.

Naveen.A

[Former Member]

It seems that the only option left out is, using line item extractor for this purpose and hence implementing the same.