Home » Developer & Programmer » Reports & Discoverer » Report column running Total reset bill number wise
Report column running Total reset bill number wise [message #666067] Wed, 11 October 2017 02:58 Go to next message
adil shakeel
Messages: 47
Registered: August 2017
Member
Hi all.

I have to develop a report in which there are six columns

1. Bill No.
2. Party
3. Item
4. Total BILL Amount.
5. Total Rcvd Amount against bill
6. Amount receivable.


This is a receivable report. In this report we receive amounts from different parties without consideration of bill numbers. Means we keep on receiving amounts from time to time from parties and then we adjust that amount against parties bills on first in first out basis.
The 5th column named with amount receivable is a formula column which shows result of (total bill amount - Total amount rcvd against bill).

The structure of report of group above with party as group.
here is the structure of report:
(Bill no) (Party) (Amount)  Item    (Amount against bill)   (Amount receivable.)
1          PETER   5000     paper    5000                   0 
1          PETER   7000     sticker  4000                   3000 
1          PETER   2000     board       0                   2000

2          SORAJ  12000     paper   10000                   2000
2          SORAJ   1000     Board       0                   1000

3          HUMA   10000     paper       0                   10000 
Actually we have 14,000 receiveable from Peter for bill # 1 and total received from him was 9000 against bill, this 9000 should be adjusted from the amount against bill number1, and out of this 9000, first full amount of paper item should be adjusted then balance should be adjusted from the next recent item and then so on.

Now just guide me how to do this in oracle reports 6i.


[EDITED by LF: fixed duplicate messages; applied [code] tags to preserve formatting]

[Updated on: Wed, 11 October 2017 03:25] by Moderator

Report message to a moderator

Re: Report column running Total reset bill number wise [message #666096 is a reply to message #666067] Fri, 13 October 2017 12:46 Go to previous messageGo to next message
adil shakeel
Messages: 47
Registered: August 2017
Member
I am waiting for reply
Re: Report column running Total reset bill number wise [message #666097 is a reply to message #666096] Fri, 13 October 2017 13:28 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You need to write a SELECT statement that joins the necessary tables and does the appropriate aggregation.
Previous Topic: RPT2XLS.put_cell for dynamic column
Next Topic: Error 500 while opening oracle Reports URL
Goto Forum:
  


Current Time: Thu Mar 28 13:41:04 CDT 2024