vertcnc
IS-IT--Management
- Jun 9, 2005
- 22
I need to generate a monthly report that shows sales taxes paid based on customer. I have been experimenting with crystal reports and think I am close. The tables i am using our rm30502, rm00401,rm30201,rm30101,rm00101. I would like the report to show colum of invoices paid by cutomer name and then showing the amount of sales tax paid, frieght.
I currently are using the following fields Customer name, Check #, Invoice # GL Post date, Applied amount, Sales amount , tax amount, frieght amount.
The problem I am having is duplicate records. I would like the report to only full the records for a specified date range. It seems to be pulling all the customer records. I have played with the linking but without much luck. The report is arranged in colums as displayed below. Grouped by customer name then check #.
Customer Check # Invoice GLpostdate Amntpd slsamnt frt tax
Any help would be appreciated.
I currently are using the following fields Customer name, Check #, Invoice # GL Post date, Applied amount, Sales amount , tax amount, frieght amount.
The problem I am having is duplicate records. I would like the report to only full the records for a specified date range. It seems to be pulling all the customer records. I have played with the linking but without much luck. The report is arranged in colums as displayed below. Grouped by customer name then check #.
Customer Check # Invoice GLpostdate Amntpd slsamnt frt tax
Any help would be appreciated.