We are currently running MIcrosoft Dynamics GP 10.0. When we do a cheque run, we'd like to see all invoices and credit memos that have been applied to this cheque to show up on the cheque stub for this vendor. This seems to work fine, until we have a credit memo for a large amount and it takes more than one invoice to cover it over multiple cheque runs.
Week 1 - Company X has a credit memo for $40, and an Invoice for $60. When we do the cheque run - Company X will have a cheque printed off for $20 and the cheque stub will show both the credit memo for $40 and the invoice for $60. This is fine, that's what we want to see.
Week 2 - Company X has a credit memo for $1500, an invoice for $100, an invoice for $200, and an invoice for $700. When we do the cheque run, no cheque will print, as there is still $500 remaining on the credit memo. That's fine as well.
Week 3 - Company X has an invoice for $600. When we do the cheque run, the cheque will be for the correct amount of $100, but on the cheque stub we will only see a credit memo for $500 and the invoice for $600. When the vendor gets the cheque, they think we are not paying the previous 3 invoices for $100, $200 and $700 dollars - and it looks like the credit memo was only for $500 instead of $1500.
This causes confusion with our vendors, and they think we are not paying all the invoices.
We've spoken to support and have been told that this is the way GP works.
In GP, I've verified that "Print Previously Applied Documents" is checked under Tools, Setup, Purchasing, Payables. And that "All Documents" is selected under "List Documents on Remittance" on this same screen.
Any ideas of how we can get all invoices since the last cheque was cut to show up on the next cheque stub??