AR Apply Detail Supplemental Information

Supplemental Information

AR Apply Detail - Supplemental Information

Report Description	Formats
Important Notes / Disclaimers	Fields

Report Description:

This report shows a list of all Cash Receipts, Credit Memos and/or Returns and how they were applied. Here are some typical GP users describing how they use it:

Julia, the Accounts Receivable Clerk:

Customers call all the time asking how a particular payment was applied. When there are a lot of credits and returns it gets even more complicated. Having a report I can quickly run to see all the detail saves me from having to do a lot of drilling down and screen printing. Plus I have something very professional that I can present to the customer.

David, the Controller: Purchasing Manager

When doing reconciliations of a customer's account it would take us hours to get all the relevant information together. Now we just run a SmartList and can start analyzing the data right away.

For these reasons and more we offer the AR Apply Detail report. It currently comes in 2 formats: SmartList Builder and Crystal Reports.

Formats:

Order a Report Print
Order
Form

SmartList Builder:

Receivables Apply Detail
Go To's already set up (you can always add more of your own):
- Customer Transaction Inquiry
- Customer Inquiry
- Customer Payment Summary Inquiry
Requires SmartList Builder.

View Sample

Crystal Reports:

Includes one report based on a SQL Server stored procedure
Available for Crystal XI
Parameters:

Date Range
Customer ID Range
Document Type:

Payments
Credits
Returns
All

Requires either Crystal Reports, or a product that will allow you to run a Crystal Report from within GP. If you are interested in one, please check out our GP Reports Viewer.

View Sample

Important Notes/Disclaimers:

To install any of our reports you will need to install our GP Reports Installer, which is included at no additional charge with every report we sell. The GP Reports Installer is a small Dexterity application that only needs to be installed on one computer (does not have to be on the server) and will control all our reports and their associated SQL components.
All of our SQL code is encrypted. You will not be able to modify it without our help. You WILL be able to modify the actual report in any way you want - changing the layout, linking to additional tables, adding SmartList Go To's, etc.
As with any report, there is only so much available data to test with. While we make every attempt to test all reports with various data, your data may have something unique that we did not account for. Please let us know if you are not seeing expected results.

Fields:

Customer ID
Customer Name
Document Date
GL Posting Date*
Document Type / Number (combination, such as "Payment - Check #25486")
Document Number (such as "PYMNT00014697" or "RTN001745")
Original Trx Amount
Current Trx Amount
Total Applied Amount
Applied to Doc. Number
Applied to Doc. Type
Applied Amount
Applied to GL Posting Date*
Applied to Document Date
Discount
Writeoff

LEGEND:

* - fields are available, but not displayed by default on the report.

Site Terms of Use