Share
Report
5When creating a batch using Select Checks, GP10 will include any invoice with a discount date PRIOR to the Discount Date Cutoff (if that option is used). The problem we are having with this is it pulls in invoices where we are too late to get the discount, but the full invoice isn't due yet. For example, we do a check run on 05/21/09, using 05/27/09 as the Discount Cutoff Date. If we have an invoice dated 05/01/09 with terms of 2%10/Net60, it would get selected for the check run. We would not want it in the check run because we have missed the discount deadline, so there is no reason to pay it before 60 days. We have been using Edit Check Batch to remove these invoices manually.
What we want is to be able to ask for all invoices with a DUE DATE prior to a certain date, and all invoices with a DISCOUNT DATE within a specified window. (Example - 05/21/09 check run - Due Date Cutoff 05/21/09, Discount Date Cutoff 05/21/09-05/27/09). I have just created a smart list that will let us know what discounts we are eligible for in a specified window, so we will select the checks using no discount cutoff and and then I can add the invoices from the smartlist to the check run. Is there any other way to do that in the selection process?
*This post is locked for comments
All responses (
Answers (
