How do you get the Suggest Vendor Payment report to suggest Credit Memos when taking Payment Discounts?
I'm working in the Payment Journal and using the Suggest Vendor Payment report. I'm not able to get NAV to include Credit Memos in the suggested Payment Journal Lines, when the Suggest Vendor Payment is only returning payments where Payment Discount are taken.
Here's how to recreate the scenario: Use a vendor with 2%/10, net 30 payment terms. Post two Purchase Invoices and one Purchase Credit Memo using a Posting Date and Document Date of 1/1/16. For the two Invoices, use the 2%/10, net 30 terms, but for the Credit Memo set the due date to 1/1/16 (like, use a COD Payment Term). Make the amount $1000 for each of the Invoices and the Credit Memo. As a result you'll have three Vendor Ledger Entries with Due Date and Pmt. Discount Date values of the following:
Invoice 1: Due Date: 2/1/16, Payment Discount Date: 1/11/16
Invoice 2: Due Date: 2/1/16, Payment Discount Date: 1/11/16
Credit Memo 1: Due Date: 1/1/16, Payment Discount Date: blank
Open the Payment Journal and run the Suggest Vendor Payment report, using the following configurations: Last Payment Date = 1/11/16, Find Payment Discount = True, Posting Date = 1/5/15. There are other values required, but the above are what's needed in order to recreate the issue.
I've done a lot of testing on this and am not seeing how to get NAV to take both the discounts and credit memos in a clean reasonable process. I've identified a way that only "kind of work" by running the Suggest Vendor Payment report twice (once with a Last Payment Date +30 days in the future and one with a reasonable Last Payment Date), but this opens up some unreasonable follow-on issues, which make it impractical. I can outline these if needed.
Basically, I'm just wondering how everyone does this seemingly basic thing in the Payment Journal: suggest payments that take both payment discounts and credit memos. It seems to me like this would be desirable by a lot of users.
