Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
IHi,
Im just wondering if anyone here tried to create a table chart here that emulate or present a ledger type of table ?
Ex.
Invoice | Inv Date | Customer | Amt | OR | Payment | Running Balance |
---|---|---|---|---|---|---|
1234 | 1/10/11 | Alibaba | 10,000 | 5634 | 500 | 9,500 |
6765 | 1,500 | 8,000 | ||||
there are 2 tables ( for invoice and payment)
Hope you could share your inputs.
Thanks.
Hi,
Will you please describe, what these two tables have (fields and the sample data).
Regards,
Kaushik Solanki
basically it will have this
Invoices
-invoicenum
-invdate
-invamt
-customercode
Payment
-ornum
-ordate
-refnum (this is the inv num where in the payment should be applied - w/ possible partial payment)
-oramt (payment amount)
-customercode
then out of this tables running balance is computed...
Hi,
You can load this two tables. Which will be linked with CustomerCode field.
Then you need to create a pivot table which will have InvDate,InvoiceNum,CustomerCode,OrderDate, as dimensions and Sum(Invamt), sum(Refnum) and sum(Oramt).
Hope you understood.
Or else Semd me the sample data. with the format in which you want to data to display.
Regards,
Kaushik Solanki
sorry for late reply.. anyway i have this excel file for sample data (with 2 sheet for inv and payment) and it should be in this format when join in side by side... i have to consider also the partial payment so it also in detals payment applicaiton wherein you can alsi see the running balance
Invoice | Inv Date | Customer | Amt | OR | Payment | Running Balance |
---|---|---|---|---|---|---|
1234 | 1/10/11 | Alibaba | 10,000 | 5634 | 500 | 9,500 |
6765 | 1,500 | 8,000 | ||||
see my QVW file i tried this and so far this is what i intent to do... thanks for the idea kaushikz