Report column running Total reset bill number wise [message #666067] |
Wed, 11 October 2017 02:58 |
|
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
|
|
|
|
|