FSG

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
Rizwan.Mumtaz
Posts: 80
Joined: Sat Feb 21, 2009 11:40 am
Location: Pakistan

FSG

Post by Rizwan.Mumtaz »

If i have two columns in my colum set as follow:

Col-1 & Col-2
May-09 & Apr-09
PTD & PTD


Now i have a row set and one row is as following:


Opening Profit b/f
(having, Amount type YTD, with 0 offset)


Now result of this row is fig.of May Ytd & fig.of May Ytd

The above result is wrong

The result should be as: fig.of May Ytd & fig.of Apr Ytd

how can i do this, Please some one give the solution in this regard.
Thanks to all.
hiszaki
Posts: 482
Joined: Thu May 10, 2007 9:03 am
Location: Egypt

Post by hiszaki »

HI Rizwan

Try to make the col period PTD with offset 0 for may & offset -1 for period Apr. then run again.

Thanks
Hisham
Rizwan.Mumtaz
Posts: 80
Joined: Sat Feb 21, 2009 11:40 am
Location: Pakistan

Post by Rizwan.Mumtaz »

Hi Hisham

No it dos'nt work and it could'nt be, as i confirm it from metalink.

Thanks for ur help
sudhir
Posts: 31
Joined: Sun Sep 02, 2007 9:19 am
Location: Oman

Post by sudhir »

Hi,

If you desire YTD, then the Amount Type for your columnset definition must be YTD - Actual.
Then you could use the offset 0 and -1 for the 2 columns respectively.

See if this works
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 25 guests