|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Custom Report - Payments Reconsiliation |
| Author |
Message |
|
|
| Posted : 2006-07-07 13:25:33 |
Hi
I was asked by the controler of my company to come up with a report which reconsiles each invoice and payments applied to it. I am now in the process of designing it. i have made some progress. I will list what i already have in my plan and please write any other feedback you have on this.
I linked the Invoice Table with the Receive Payment Line Table using the RefNumber. I now need the Total Amount of the Invoice and i think i can use SubTotal and SalesTaxTotal. i would like to know if i need to use the invoice Line Table to come up with the total?
any comments on the subject would be appreciated.
thanks,
sam |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-07-07 14:28:29 |
|
|
|
|