Home » Applications » Oracle Fusion Apps & E-Business Suite » i want to prepare finacial year report
i want to prepare finacial year report [message #339134] Wed, 06 August 2008 20:27 Go to next message
radhavijay
Messages: 29
Registered: July 2008
Junior Member
hi,

i want to prepare a financial year report in po module.
my report is in the below format

product/month july08 aug08 sep08.........jun09 total

abc
quantity 10 10 10 30
amount 5 5 5 15
xyz
quantity 20 20 20 60
amount 10 10 10 30
and so on

runtime parameters are date range

nw im retriving amount n quantity group by productname
but im not getting how to place these quantity n amount values in particular month columns.

suppose if i give parameters as 01-jul-08 and 01-sep-08
if quantity n amount values are between 01-jul-08 and 31-jul-08 then those must place in july08 column and if values are between 01-aug-08 and 31-aug-08 then values must be stored in aug08 column.
hw to do this

please help me.

thanks in advance
radhavijay
Re: i want to prepare finacial year report [message #339160 is a reply to message #339134] Wed, 06 August 2008 23:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide
Format your post
Don't use IM speack
Search before posting
Post in the correct forum, what is "po module"?

Regards
Michel
Re: i want to prepare finacial year report [message #339210 is a reply to message #339160] Thu, 07 August 2008 01:37 Go to previous messageGo to next message
radhavijay
Messages: 29
Registered: July 2008
Junior Member
po means PURCHASE ORDER MODULE
Re: i want to prepare finacial year report [message #339225 is a reply to message #339210] Thu, 07 August 2008 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So maybe you should post this in one of the Applications subforum.
I move it.

Regards
Michel
Re: i want to prepare finacial year report [message #339228 is a reply to message #339225] Thu, 07 August 2008 02:11 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Michel,
I believe OP is looking for something like calendar functionality (generate months, sum data per month).
That doesn't necessarily relate to EBS/Apps, that's just the source of the data in this case.
Regards,
Sabine
[edit: forgot my regards! Wink]

[Updated on: Thu, 07 August 2008 02:12]

Report message to a moderator

Previous Topic: Cancel Requisition
Next Topic: Oracle Alerts
Goto Forum:
  


Current Time: Mon Dec 05 08:41:59 CST 2016

Total time taken to generate the page: 0.16657 seconds