Supplemental Information
AP Check Edit List - Supplemental Information
| Report Description | Formats |
| Important Notes / Disclaimers | Fields |
Report Description:
The AP Check Edit List report shows all payables checks saved in batches with the details of what invoices they will apply to. Here are some typical GP users describing how they use it:
Creating a batch of checks in GP? Easy. Verifying that I have all the checks I need in my batch and getting a list of them to show my boss for approval? Not so easy. Presentation is important, so I used to put a list together in Excel before asking for approval. Now this is a breeze with the AP Check Edit List from Flexible Solutions!
When I need to approve a batch of checks, I would much rather do it ahead of time, before the checks are all printed. That way we don't have a large number of voids, which wastes time and check stock. But looking at the Edit List report from GP makes my brain hurt. I need to see a quick listing showing all the checks and how they will be applied to our vendor invoices.
For these reasons and more we offer the AP Check Edit List report. It currently comes in 2 formats: SmartList Builder and Crystal Reports.
Back to topFormats:
Order
Form
SmartList Builder:
- Includes 2 SmartLists:
- Payables Check Edit List Summary - one line per check
- Payables Check Edit List Detail - detail of the apply information for each check
- Available for GP 8.0, GP 9.0 and GP 10.0
- Go To's already set up (you can always add more of your own):
- Edit Payables Checks (all versions)
- Edit Payables Checks Batch (GP 9.0 and 10.0)
- Requires SmartList Builder.
Crystal Reports:
- Includes one report based on a SQL Server stored procedure
- Available for Crystal XI
- Parameters:
- Batch ID
- 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.
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:
- Batch ID
- Payment Number
- Checkbook ID
- Vendor ID
- Vendor Name
- Check Total
- Applied Amount (total for check)
- Unapplied Amount (total for check)
- Currency ID
- Apply to Document No.^
- Apply to Document Date^
- Apply to Doc. Due Date^
- Apply to Orig. Doc. Amount^
- Amount Applied^
- Amount Still Unapplied^
- Apply to Voucher Number*^
* - fields are available, but not displayed by default on the reports.
^ -on the detail SmartList only
Site Terms of Use