Receipts report for Peachtree

[crystalpro]

I need to create a report listing all the receipts for a specific date range in Peachtree.

I can only get the report to work when there is one receipt during that specified date range.

Does anyone know how to show each receipt amount on the report, the invoice # it paid, the original invoice amount?

 

[IdoMillet]

Please clarify. If you want receipts for a given date range, what would you expect the report to show if there are no receipts in that date range?

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[crystalpro]

If there are no receipts for the specified date range, the report will not list anything for that sales rep.

 

[IdoMillet]

Still not clear.
In your original message you state:
---------------------------------------
I can only get the report to work when there is one receipt during that specified date range.
---------------------------------------

So, can you clarify what is the problem?

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[crystalpro]

The problem lies when there are two or more receipts for one invoice during a specific time frame.

If I run the report for 4-1-03 to 4-30-03, every thing is
fine as long there is only one receipt per invoice:
sales rep JOE-01
customer 100SMITH
invoice# 2305
invoice amount 10000.00
receipt amount 2000.00
commission 200.00

If there is more than one receipt, the receipt amount is not correct and therefore the commission is wrong, too:
sales rep JOE-01
customer 100SMITH
invoice# 2305
invoice amount 10000.00
receipt amount 1000.00
commssion 100.00
(In this case there were two receipts for the period 4-1-03 to 4-30-03, each for 1000.00. The receipt amount should have shown, 2000.00 and the commission 200.00)

 

[IdoMillet]

You need to group by
Sales_Rep, Customer, and then Invoice.

Total the received amount within Invoice.

Compute the commission on that total.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[crystalpro]

Thank you for your help, but the suggestions you gave have already been done. This issue still remains that I cannot get more than one receipt per specified date range for the report.

 

[IdoMillet]

Are you saying the second receipt doesn't even show up in the detail section?

If so, explain what tables are involved, how you are joining them, and what is your record selection formula.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com